<?
$objConnect = mysql_connect("localhost","root","klw3322") or die(mysql_error());

$objDB = mysql_select_db("klw");
mysql_query("SET character_set_results=tis620");//ตั้งค่าการดึงข้อมูลออกมาให้เป็น tis620
mysql_query("SET character_set_client=tis620");//ตั้งค่าการส่งข้อมุลลงฐานข้อมูลออกมาให้ เป็น tis620
mysql_query("SET character_set_connection=tis620");//ตั้งค่าการติดต่อฐานข้อมูลให้เป็น ti

$strSQL = "SELECT DISTINCT code FROM transcripts  JOIN klw ON transcripts.IDstudent=klw.Username JOIN teacher ON teacher.teachcode=transcripts.teach where code = '$_GET[id]' and teach='$_GET[teach]' and xyy='$_GET[xyy]'";



$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
while($objResult = mysql_fetch_array($objQuery))
$name=$objResult["code"];


?>
<?
$crsql="SELECT count( grad ) FROM `transcripts`  WHERE grad  LIKE '%0%' and code = '$_GET[id]' and teach='$_GET[teach]' and xyy='$_GET[xyy]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$slipnum_0=$dcrd[0];

$crsql="SELECT count( grad ) FROM `transcripts`  WHERE grad  =1 and code = '$_GET[id]' and teach='$_GET[teach]' and xyy='$_GET[xyy]'";
	$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
	$dcrd = mysql_fetch_array($slr);
	$slipnum_1=$dcrd[0];

$crsql="SELECT count( grad ) FROM `transcripts`  WHERE grad  =1.5 and code = '$_GET[id]' and teach='$_GET[teach]' and xyy='$_GET[xyy]'";
	$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
	$dcrd = mysql_fetch_array($slr);
	$slipnum_15=$dcrd[0];

	$crsql="SELECT count( grad ) FROM `transcripts`  WHERE grad  =2 and code = '$_GET[id]' and teach='$_GET[teach]' and xyy='$_GET[xyy]'";
	$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
	$dcrd = mysql_fetch_array($slr);
	$slipnum_2=$dcrd[0];

	$crsql="SELECT count( grad ) FROM `transcripts`  WHERE grad =2.5 and code = '$_GET[id]' and teach='$_GET[teach]' and xyy='$_GET[xyy]'";
	$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
	$dcrd = mysql_fetch_array($slr);
	$slipnum_25=$dcrd[0];

	$crsql="SELECT count( grad ) FROM `transcripts`  WHERE grad =3 and code = '$_GET[id]' and teach='$_GET[teach]' and xyy='$_GET[xyy]'";
	$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
	$dcrd = mysql_fetch_array($slr);
	$slipnum_3=$dcrd[0];

	$crsql="SELECT count( grad ) FROM `transcripts`  WHERE grad =3.5 and code = '$_GET[id]' and teach='$_GET[teach]' and xyy='$_GET[xyy]'";
	$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
	$dcrd = mysql_fetch_array($slr);
	$slipnum_35=$dcrd[0];

	$crsql="SELECT count( grad ) FROM `transcripts` WHERE grad  =4 and code = '$_GET[id]' and teach='$_GET[teach]' and xyy='$_GET[xyy]'";
	$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
	$dcrd = mysql_fetch_array($slr);
	$slipnum_4=$dcrd[0];


	$crsql="SELECT count( grad ) FROM `transcripts`  WHERE total  LIKE '%-1%' and code = '$_GET[id]' and teach='$_GET[teach]' and xyy='$_GET[xyy]'";
	$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
	$dcrd = mysql_fetch_array($slr);
	$slipnum_i=$dcrd[0];


?>
<?
include "libchart/classes/libchart.php";
?>
<?
header("Content-type: image/png");
	
	$chart = new VerticalBarChart(800,300);
	
	$dataSet = new XYDataSet();
	$dataSet->addPoint(new Point("GRADE 0", $slipnum_0));
	$dataSet->addPoint(new Point("GRADE 1", $slipnum_1));
	$dataSet->addPoint(new Point("GRADE 1.5", $slipnum_15));
	$dataSet->addPoint(new Point("GRADE 2", $slipnum_2));
	$dataSet->addPoint(new Point("GRADE 2.5", $slipnum_25));
	$dataSet->addPoint(new Point("GRADE 3", $slipnum_3));
	$dataSet->addPoint(new Point("GRADE 3.5", $slipnum_35));
	$dataSet->addPoint(new Point("GRADE 4", $slipnum_4));
	$dataSet->addPoint(new Point("GRADE I", $slipnum_i));
	$chart->setDataSet($dataSet);
	
	$chart->setTitle("$_GET[id]");
	$chart->render();
?>