File: C:/xampp/htdocs/PBN/PSAinstrument/lineGraph.php
<?php
$host="127.0.0.1";
$user="root";
$pass="fredsql";
$db="tvicheck-st";
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
mysql_query("SET NAMES 'utf8'");
//$link = mssql_connect("MACBOOK7", "sa", "fred5697");
mysql_select_db($db) or die ("Unable to select database!");
// generate and execute query
$query = "SELECT * from fogra123 where PO='$po' order by id";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
// if records present
$i=0;
// iterate iii through resultset
// print title with links to edit and delete scripts
$k100ar = array();
$k40ar = array();
$c100ar = array();
$c40ar = array();
$m100ar = array();
$m40ar = array();
$y100ar = array();
$y40ar = array();
while($row = mysql_fetch_object($result))
{
$i=$i+1;
$k100=$row->k100;
echo $i."-".$k100."__";
array_push($k100ar, $k100);
$k40=$row->k40;
echo $i."-".$k40."__";
array_push($k40ar, $k40);
$c100=$row->c100;
echo $i."-".$c100."__";
array_push($c100ar, $c100);
$c40=$row->c40;
echo $i."-".$c40."__";
array_push($c40ar, $c40);
$m100=$row->m100;
echo $i."-".$c100."__";
array_push($m100ar, $m100);
$m40=$row->m40;
echo $i."-".$c40."__";
array_push($m40ar, $m40);
$y100=$row->y100;
echo $i."-".$y100."__";
array_push($y100ar, $y100);
$y40=$row->y40;
echo $i."-".$y40."__";
array_push($y40ar, $y40);
}
$max=$i;
echo "max=".$max;
print_r ($k100ar);
print_r ($k40ar);
print_r ($c100ar);
print_r ($c40ar);
print_r ($m100ar);
print_r ($m40ar);
print_r ($y100ar);
print_r ($y40ar);
?>
<!-- graph code begins here-->
<script type="text/javascript" src="wz_jsgraphics.js"></script>
<script type="text/javascript" src="line.js">
<!-- Line Graph script-By Balamurugan S http://www.sbmkpm.com/ //-->
<!-- Script featured/ available at Dynamic Drive code: http://www.dynamicdrive.com //-->
</script>
<div id="lineCanvas" style="overflow: auto; position:relative;height:300px;width:800px;"></div>
<script type="text/javascript">
var mx = <?php echo json_encode($max); ?>;
day = new Array(<?php echo implode(',', $k100ar); ?>);
for(var i=0;i<day.length;i++){
<!--document.write("<b>dot["+i+"] is </b>=>"+day[i]+"<br>"); //-->
}
var g = new line_graph();
for ($j=1 ; $j <= mx ; $j += 1) {
g.add($j, (day[$j-1]*100));
}
g.render("lineCanvas", "Line Graph K");
</script>
<script type="text/javascript" src="line2.js">
<!-- Line Graph script-By Balamurugan S http://www.sbmkpm.com/ //-->
<!-- Script featured/ available at Dynamic Drive code: http://www.dynamicdrive.com //-->
</script>
<div id="lineCanvask40" style="overflow: auto; position:relative;height:300px;width:800px;"></div>
<script type="text/javascript">
var mx = <?php echo json_encode($max); ?>;
dk40 = new Array(<?php echo implode(',', $k40ar); ?>);
var g = new line_graph();
for ($j=1 ; $j <= mx ; $j += 1) {
g.add($j, (dk40[$j-1]*100));
}
g.render("lineCanvask40", "Line Graph K40");
</script>
<script type="text/javascript" src="lineC.js">
<!-- Line Graph script-By Balamurugan S http://www.sbmkpm.com/ //-->
<!-- Script featured/ available at Dynamic Drive code: http://www.dynamicdrive.com //-->
</script>
<div id="lineCanvasC" style="overflow: auto; position:relative;height:300px;width:800px;"></div>
<script type="text/javascript">
var mx = <?php echo json_encode($max); ?>;
dc100 = new Array(<?php echo implode(',', $c100ar); ?>);
var g = new line_graph();
for ($j=1 ; $j <= mx ; $j += 1) {
g.add($j, (dc100[$j-1]*100));
}
g.render("lineCanvasC", "Line Graph C");
</script>
<script type="text/javascript" src="lineC40.js">
<!-- Line Graph script-By Balamurugan S http://www.sbmkpm.com/ //-->
<!-- Script featured/ available at Dynamic Drive code: http://www.dynamicdrive.com //-->
</script>
<div id="lineCanvasc40" style="overflow: auto; position:relative;height:300px;width:800px;"></div>
<script type="text/javascript">
var mx = <?php echo json_encode($max); ?>;
dc40 = new Array(<?php echo implode(',', $c40ar); ?>);
var g = new line_graph();
for ($j=1 ; $j <= mx ; $j += 1) {
g.add($j, (dc40[$j-1]*100));
}
g.render("lineCanvasc40", "Line Graph C40");
</script>
<script type="text/javascript" src="lineM.js">
<!-- Line Graph script-By Balamurugan S http://www.sbmkpm.com/ //-->
<!-- Script featured/ available at Dynamic Drive code: http://www.dynamicdrive.com //-->
</script>
<div id="lineCanvasM" style="overflow: auto; position:relative;height:300px;width:800px;"></div>
<script type="text/javascript">
var mx = <?php echo json_encode($max); ?>;
dm100 = new Array(<?php echo implode(',', $m100ar); ?>);
var g = new line_graph();
for ($j=1 ; $j <= mx ; $j += 1) {
g.add($j, (dm100[$j-1]*100));
}
g.render("lineCanvasM", "Line Graph M");
</script>
<script type="text/javascript" src="lineM40.js">
<!-- Line Graph script-By Balamurugan S http://www.sbmkpm.com/ //-->
<!-- Script featured/ available at Dynamic Drive code: http://www.dynamicdrive.com //-->
</script>
<div id="lineCanvasM40" style="overflow: auto; position:relative;height:300px;width:800px;"></div>
<script type="text/javascript">
var mx = <?php echo json_encode($max); ?>;
dm40 = new Array(<?php echo implode(',', $m40ar); ?>);
var g = new line_graph();
for ($j=1 ; $j <= mx ; $j += 1) {
g.add($j, (dm40[$j-1]*100));
}
g.render("lineCanvasM40", "Line Graph M40");
</script>
<script type="text/javascript" src="lineY.js">
<!-- Line Graph script-By Balamurugan S http://www.sbmkpm.com/ //-->
<!-- Script featured/ available at Dynamic Drive code: http://www.dynamicdrive.com //-->
</script>
<div id="lineCanvasY" style="overflow: auto; position:relative;height:300px;width:800px;"></div>
<script type="text/javascript">
var mx = <?php echo json_encode($max); ?>;
dy100 = new Array(<?php echo implode(',', $y100ar); ?>);
var g = new line_graph();
for ($j=1 ; $j <= mx ; $j += 1) {
g.add($j, (dy100[$j-1]*100));
}
g.render("lineCanvasY", "Line Graph Y");
</script>
<script type="text/javascript" src="lineY40.js">
<!-- Line Graph script-By Balamurugan S http://www.sbmkpm.com/ //-->
<!-- Script featured/ available at Dynamic Drive code: http://www.dynamicdrive.com //-->
</script>
<div id="lineCanvasY40" style="overflow: auto; position:relative;height:300px;width:800px;"></div>
<script type="text/javascript">
var mx = <?php echo json_encode($max); ?>;
dy40 = new Array(<?php echo implode(',', $y40ar); ?>);
var g = new line_graph();
for ($j=1 ; $j <= mx ; $j += 1) {
g.add($j, (dy40[$j-1]*100));
}
g.render("lineCanvasY40", "Line Graph Y40");
</script>
<!-- graph code ends here-->