1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 2 <html xmlns="http://www.w3.org/1999/xhtml"> 3 <head> 4 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> 5 <title>成绩查询</title> 6 </head> 7 8 <body> 9 <?php 10 include('conn.php'); 11 $sql = 'select distinct(km) from tb_grade'; 12 $r = mysql_query($sql); 13 14 ?> 15 <form action="lx3do.php" method="post"> 16 请选择要查询成绩的科目： 17 <select name="sel"> 18 <?php 19 while($row = mysql_fetch_array($r)){ 20 echo '<option value="'.$row['km'].'">'; 21 echo $row['km']; 22 echo '</option>'; 23 } 24 ?> 25 26 </select> 27 <input type="submit" value="查询" name="sub"/> 28 </form> 29 </body> 30 </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(); ?>
1 <?php 2 header("content-type:text/html;charset=utf-8"); 3 $conn = mysql_connect("localhost","root","") or die("连接服务器失败"); 4 mysql_select_db("db_test8"); 5 mysql_query("set names utf8"); 6 ?>