<?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-->