1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
| <?php
error_reporting(E_ALL);
ini_set('display_errors', 1);
include("include/variables.inc.php");
$liendb = mysql_connect($bddserver, $bddlogin, $bddpassword);
mysql_select_db ($bdd);
mysql_set_charset( 'utf8' );
//include('include/var.inc.php');
$pays = ( PHP_OS == "Windows" ) ? 'fra' : 'fr_FR';
setlocale ( LC_TIME, $pays ) ;
//$id = $_POST['id'];
$result = mysql_query("SELECT
Personnes.IDPersonne,
Personnes.Nom_Personne,
Personnes.Prenom_Personne,
Concert.IDconcert,
Concert.titreconcert,
Concert.lieu,
DATE_FORMAT ( Concert.dateconcert, '%d/%m/%Y' ) AS datecon,
Prix.Prix,
SUM(Prix.Prix) AS prixbillets,
COUNT(Prix.Prix) AS nbillets
FROM Tab_NumPlace
INNER JOIN Personnes ON Tab_NumPlace.IDPersonne = Personnes.IDPersonne
INNER JOIN Instruments ON Personnes.IDInstruments = Instruments.IDInstruments
INNER JOIN Concert ON Tab_NumPlace.IDconcert = Concert.IDconcert
INNER JOIN Zones ON Tab_NumPlace.IDZone = Zones.IDZone
INNER JOIN Prix ON Zones.IDPrix = Prix.IDPrix
WHERE Concert.IDconcert = 1
GROUP BY IDconcert, IDPersonne, IDPrix
ORDER BY IDConcert, IDPersonne, IDPrix");
while ($row = mysql_fetch_assoc($result)) {
$data[$row['IDconcert']][$row['IDPersonne']][] = $row;
@$data_prix[$row['IDconcert']][$row['IDPersonne']] += $row['prixbillets'];
if (!isset($data_personne[$row['IDPersonne']])) { $data_personne[$row['IDPersonne']] = $row['Nom_Personne'] . ' ' . $row['Prenom_Personne']; }
if (!isset($data_concert[$row['IDconcert']])) { $data_concert[$row['IDconcert']] = $row['titreconcert'] . ' ' . $row['lieu']; }
}
foreach ($data as $IDconcert=>$data_personnes) {
foreach ($data_personnes as $IDPersonne=>$data_billets) {
echo $data_concert[$IDconcert] . ' : ' . $data_personne[$IDPersonne] . ' : ' . $data_prix[$IDconcert][$IDPersonne] . '€ <br/>';
foreach ($data_billets as $billets) {
echo $billets['nbillets'] . ' à ' . $billets['Prix'] . '€ = ' . $billets['prixbillets'] . '€ <br/>';
}
}
}?> |
