execQuery($query0); //$rs = $dbObj->fetchArray($result); $total = $dbObj->_numrows; /** Config Table for This Page */ $myTable = "projectstdplan_tb"; $myTablePK = "Budget_Year"; $myTable2 = "project_type_tb"; $myTable2PK = "ProjectId"; /* $queryUsr = " SELECT * FROM user_tb WHERE Username='$Username' "; $resultUsr = $dbObj->execQuery($queryUsr); $rss = $dbObj->fetchArray($resultUsr); */ //=== $query = " SELECT * FROM $myTable GROUP BY $myTablePK "; $result = $dbObj->execQuery($query); $num = $dbObj->_numrows; //$total = $dbObj->_numrows; ?>

หน้าหลัก » แผนภูมิแสดงประเภทของบุคลากร   ‹ ย้อนกลับ "; $strQ = " SELECT * FROM teacher_type_tb Where Flag ='Y' "; $res = $dbObj->execQuery($strQ); $c = mysql_num_rows($res); while( $rs0 = $dbObj->fetchArray($res) ) { $dc = $rs0['Ttype_code']; if ($dc !=0 ){ $sql = " SELECT COUNT(Teacher_code) AS num FROM personal_tb pt, teacher_type_tb tt WHERE pt.Teacher_type=$dc and pt.Teacher_type=tt.Ttype_code and tt.Flag='Y' and pt.StatusId='1' "; $result = $dbObj->execQuery($sql); $rs = $dbObj->fetchArray($result); $sql2 = " SELECT COUNT(Teacher_code) AS sum FROM personal_tb pt, teacher_type_tb tt WHERE pt.Teacher_type=tt.Ttype_code and tt.Flag='Y' and pt.StatusId='1' "; $result2 = $dbObj->execQuery($sql2); $rs2 = $dbObj->fetchArray($result2); $per = ( $rs['num'] * 100 ) / $rs2['sum']; $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, "",600, 375, false, false); ?>   execQuery($sql); $no = 1+($display-1)*$limit; while( $rss4 = $dbObj->fetchArray($result8) ) { $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); $dbObj->freeresult($result13); echo $rs13['num']; ?>   สรุป execQuery($sql); $rs1 = $dbObj->fetchArray($result1); echo $rs1['num5']; ?> execQuery($sql); $rs1 = $dbObj->fetchArray($result1); echo $rs1['num5']; ?> execQuery($sql); $rs1 = $dbObj->fetchArray($result1); echo $rs1['num5']; ?> execQuery($sql); $rs1 = $dbObj->fetchArray($result1); echo $rs1['num5']; ?>

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