TMG6470/graphTest2.php at master · leftger/TMG6470 · GitHub

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
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
<?php


//$candidate=$_GET['user'];
//$candidate="Romney";
$candidate= $_POST['vehicle'];
if ($candidate==NULL) $candidate= array("Romney","Gingrich","Paul","Santorum");
include("phpgraphlib.php");

$graph=new PHPGraphLib(950,650);

$link = mysql_connect('sql.mit.edu', 'grosas', 'snett')
   or die('Could not connect: ' . mysql_error());

mysql_select_db('grosas+candidates_2012') or die('Could not select database');
$dataArray=array();
//print_r($candidate);
//echo "<br />" . $candidate[2] . "<br />";
//for($i=0;$i<count($candidate); $i++) {
foreach ($candidate as $value) {
$sql="SELECT Date,SUM(Amount) FROM $value GROUP BY Date";

$result = mysql_query($sql) or die('Query failed: ' . mysql_error());
$sum = 0;
if ($result) {
  while ($row = mysql_fetch_assoc($result)) {
      $salesgroup=$row["SUM(Amount)"];
      $dates=$row["Date"];
 $sum=$salesgroup+$sum;
      $data[$dates]=$sum;
  }
}
$dataArray[]=$data;
//$graph->addData($data);
}
//print_r($data);
if(count($dataArray)==4){
$graph->addData($dataArray[0], $dataArray[1], $dataArray[2], $dataArray[3]);}
if(count($dataArray)==1){
$graph->addData($dataArray);}
if(count($dataArray)==2){
$graph->addData($dataArray[0], $dataArray[1]);}
if(count($dataArray)==3){
$graph->addData($dataArray[0], $dataArray[1], $dataArray[2]);}
//$data3 = array(43, 23, 34, 23, 53, 32, 43, 41);
//print_r($dataArray);
//print_r($data1);
//print_r($data2);
//$graph->addData($data1,$data2,$data3,$data4);
$graph->setTitle("Campaign Finance Contributions Up To Sept. 30, 2011 in Dollars");
$graph->setTitleLocation('left');
$graph->setBars(false);
$graph->setLine(true);
$graph->setLineColor("green","red","blue","purple");
//$graph->setDataPoints(true);
//$graph->setGradient('red', 'maroon');
//$graph->setDataPointColor('maroon');
//$graph->setDataValues(true);
//$graph->setDataValueColor('maroon');
//$graph->setGoalLine(.0025);
//$graph->setGoalLineColor('red');
$graph->setXValues(false);
if(count($candidate)==4){
$graph->setLegendTitle($candidate[0], $candidate[1], $candidate[2], $candidate[3]);}
if(count($candidate)==1){
$graph->setLegendTitle($candidate);}
if(count($candidate)==2){
$graph->setLegendTitle($candidate[0], $candidate[1]);}
if(count($candidate)==3){
$graph->setLegendTitle($candidate[0], $candidate[1], $candidate[2]);}
$graph->setLegend(true);
$graph->createGraph();
//}*/
/*$graph->setTitle('CPU Cycles x1000');
$graph->setTitleLocation('left');
$graph->setLegend(true);
$graph->setLegendTitle('Module-1', 'Module-2', 'Module-3');
$graph->setGradient('green', 'olive');
$graph->createGraph();*/
//else  echo "Please try again and submit the last name of a major presidential candidate but not the current incumbent.";
/*$graph2->addData($data2);
$graph2->setTitle("Campaign Finance Contributions Up To Sept. 30, 2011 in Dollars");
$graph2->setTitleLocation('left');
$graph2->setBars(false);
$graph2->setLine(true);
$graph2->setLineColor("red");
$graph2->setLegendTitle($candidate[1]);
$graph2->setLegend(true);
$graph2->createGraph();*/
//echo "<meta http-equiv=\"Refresh\" content=0;url\"graphTest.html\">";
?>