execQuery($query); $num = $dbObj->_numrows; //$total = $dbObj->_numrows; ?>

หน้าหลัก » แผนภูมิแสดงวุฒิการศึกษาของบุคลากรทุกสายงาน ‹ ย้อนกลับ "; $strQ = " SELECT * FROM degree_tb"; $res = $dbObj->execQuery($strQ); $c = mysql_num_rows($res); while( $rs0 = $dbObj->fetchArray($res) ) { $dc = $rs0['Degree_code']; if ($dc != 4 ){ $sql = " SELECT COUNT(Degree_code) AS num FROM personal_tb WHERE StatusId='1' AND Degree_code='$dc' and ( Person_type='1' Or Person_type='2' Or Person_type='3' Or Person_type='4' Or Person_type='5') "; $result = $dbObj->execQuery($sql); $rs = $dbObj->fetchArray($result); $sql1 = " SELECT COUNT(Teacher_code) AS num5 FROM personal_tb WHERE StatusId='1' and (Degree_code='1' Or Degree_code='2' Or Degree_code='3' ) and ( Person_type='1' Or Person_type='2' Or Person_type='3' Or Person_type='4' Or Person_type='5') "; $result1 = $dbObj->execQuery($sql1); $rs1 = $dbObj->fetchArray($result1); echo $num5 ; $per = ( $rs['num'] * 100 ) / $rs1['num5']; $p = number_format($per,2,'.','.'); $strXML .= ""; } } //Finally, close element $strXML .= ""; //Create the chart - Pie 3D Chart with data from strXML echo renderChart("charts/Column3D.swf", "", $strXML, "",550, 375, false, false); ?>   execQuery($sql); $no = 1+($display-1)*$limit; while( $rss13 = $dbObj->fetchArray($result19) ) { $bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF"; ?> No รายการ ปริญญาตรี ปริญญาโท ปริญญาเอก จำนวน execQuery($sql); $rs11 = $dbObj->fetchArray($result11); $dbObj->freeresult($result11); echo $rs11['num']; ?> execQuery($sql); $rs12 = $dbObj->fetchArray($result12); $dbObj->freeresult($result12); echo $rs12['num']; ?> execQuery($sql); $rs13 = $dbObj->fetchArray($result13); echo $rs13['num']; ?>   สรุป execQuery($sql); $rs1 = $dbObj->fetchArray($result1); $dbObj->freeresult($result7); echo $rs1['num5']; ?> execQuery($sql); $rs1 = $dbObj->fetchArray($result1); $dbObj->freeresult($result7); echo $rs1['num5']; ?> execQuery($sql); $rs1 = $dbObj->fetchArray($result1); $dbObj->freeresult($result7); echo $rs1['num5']; ?> execQuery($sql); $rs1 = $dbObj->fetchArray($result1); $dbObj->freeresult($result7); echo $rs1['num5']; ?>   อัตราส่วน execQuery($sql); $rs2 = $dbObj->fetchArray($result2); $per2= ( $rs2['sum'] * 100 ) / $rs1['num5'] ; echo number_format($per2,2,'.','.'); ?> execQuery($sql); $rs2 = $dbObj->fetchArray($result2); $per2= ( $rs2['sum'] * 100 ) / $rs1['num5'] ; echo number_format($per2,2,'.','.'); ?> execQuery($sql); $rs2 = $dbObj->fetchArray($result2); $per2= ( $rs2['sum'] * 100 ) / $rs1['num5'] ; echo number_format($per2,2,'.','.'); ?> 100%

freeresult($result); /** Close the Database */ $dbObj->disconn(); /** Unset Class */ unset($dbObj); ?>