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
| <?php
include ("c:\wamp\www\jpgraph-1.22\src\jpgraph.php");
include ("c:\wamp\www\jpgraph-1.22\src\jpgraph_bar.php");
define('MYSQL_HOST', 'localhost');
define('MYSQL_USER', 'root');
define('MYSQL_PASS', 'pwd');
define('MYSQL_DATABASE', 'projet');
$tableauAnnees = array();
$tableauNombreVentes = array();
// **********************************************
// Extraction des données dans la base de données
// *************************************************
$sql = mysql_query("SELECT NAME,
COUNT(IDACT) AS NBR_ACT
FROM `activity`
GROUP BY NAME (`activity`);
");
$mysqlCnx = @mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASS) or die('Pb de connexion mysql');
@mysql_select_db(MYSQL_DATABASE) or die('Pb de sélection de la base');
$mysqlQuery = @mysql_query($sql, $mysqlCnx) or die('Pb de requête');
while ($row = mysql_fetch_array($mysqlQuery, MYSQL_ASSOC)) {
$tableauAnnees[] = $row['NAME'];
$tableauNombreVentes[] = $row['NBR_ACT'];
}
// etc |
