<?php
include ("../jpgraph.php");
include ("../jpgraph_line.php");
include("../../../config.inc.php") ;
mysql_connect( $host,$username,$password) or die ("?????????????????? Mysql ?????? ");
mysql_query("SET CHARACTER SET tis620");
mysql_select_db($db) or die("????????????????????"); /* ??????????????????????? */
$sql="SELECT ILI,Influenza FROM ili_visited,influenza where ili_visited.week=Influenza.week";
$db_query=mysql_db_query(ois,$sql);
$num_rows=mysql_num_rows($db_query);
$a=0;
while($a < $num_rows)
{
$result = mysql_fetch_array($db_query);
$ILI[] = $result[ILI];
$Influenza[] = $result[Influenza];
foreach($ILI as $val) '<br>';
foreach($Influenza as $val1) '<br>';
$a++;
}
/*for($i=0;$i<$num_rows;$i++){
$ILI1[i];
$Influenza1[i];
}*/
// Create the graph and specify the scale for both Y-axis
$graph = new Graph(400,200,"auto");
$graph->SetScale("textlin");
$graph->SetY2Scale("lin");
$graph->SetShadow();
// Adjust the margin
$graph->img->SetMargin(40,140,20,40);
// Create the two linear plot
$lineplot=new LinePlot($val);
$lineplot2=new LinePlot($val1);
// Add the plot to the graph
$graph->Add($lineplot);
$graph->AddY2($lineplot2);
$lineplot2->SetColor("orange");
$lineplot2->SetWeight(2);
// Adjust the axis color
$graph->y2axis->SetColor("orange");
$graph->yaxis->SetColor("blue");
$graph->title->Set("Example 6");
$graph->xaxis->title->Set("X-title");
$graph->yaxis->title->Set("Y-title");
$graph->title->SetFont(FF_FONT1,FS_BOLD);
$graph->yaxis->title->SetFont(FF_FONT1,FS_BOLD);
$graph->xaxis->title->SetFont(FF_FONT1,FS_BOLD);
// Set the colors for the plots
$lineplot->SetColor("blue");
$lineplot->SetWeight(2);
$lineplot2->SetColor("orange");
$lineplot2->SetWeight(2);
// Set the legends for the plots
$lineplot->SetLegend("ILI");
$lineplot2->SetLegend("Influenza");
// Adjust the legend position
$graph->legend->Pos(0.05,0.5,"right","center");
// Display the graph
$graph->Stroke();
?>