Jpgraph小应用

 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

 <html xmlns="http://www.w3.org/1999/xhtml">

 <head>

 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

 <title>成绩查询</title>

 </head>

 <body>

 <?php

     include('conn.php');

     $sql = 'select distinct(km) from tb_grade';

     $r = mysql_query($sql);

 ?>

 <form action="lx3do.php" method="post">

     请选择要查询成绩的科目：

     <select name="sel">

       <?php

               while($row = mysql_fetch_array($r)){

                 echo '<option value="'.$row['km'].'">';

                 echo $row['km'];

                 echo '</option>';

             }

       ?>

     </select>

     <input type="submit" value="查询" name="sub"/>

 </form>

 </body>

 </html>

<?php

header ( "Content-type: text/html; charset=UTF-8" );

require_once 'Jpgraph/jpgraph.php';

require_once 'Jpgraph/jpgraph_bar.php';

include('conn.php');

$sel =$_POST['sel'];

$sql = "select * from tb_grade where km='$sel'";

$r = mysql_query($sql);

while ($row=mysql_fetch_array($r)) {

    $data[] = $row['xh'];

    $datas[] = $row['cj'];

}

$graph = new Graph(600, 600);

$graph->SetScale("textlin",0,100);

$graph->SetShadow();    

$graph->img->SetMargin(60, 10, 60, 80);

$barplot = new BarPlot($datas);    

$graph->Add($barplot);

$barplot->value->Show();

$graph->title->Set(iconv("utf-8","gb2312","数学成绩"));

$graph->xaxis->title->Set(iconv("utf-8","gb2312","学号"));

$graph->xaxis->SetTickLabels($data);

$graph->yaxis->title->Set(iconv("utf-8","gb2312",'成绩（百分比）'));

$graph->title->SetFont(FF_SIMSUN, FS_BOLD);

$graph->xaxis->title->SetFont(FF_SIMSUN,FS_BOLD);

$graph->yaxis->title->SetFont(FF_SIMSUN,FS_BOLD);

$graph->Stroke();

?>

 <?php

     header("content-type:text/html;charset=utf-8");

     $conn = mysql_connect("localhost","root","") or die("连接服务器失败");

     mysql_select_db("db_test8");

     mysql_query("set names utf8");

 ?>

巴特西

Jpgraph小应用

最新文章

热门文章