01.<?php
02.$objConnect = mysql_connect("localhost","...","...") or die("Error Connect to Database");
03.$objDB = mysql_select_db("ro1");
04.mysql_query("SET NAMES UTF8");
05.$strSQL = "SELECT * FROM staff_ro1";
06.$objQuery = mysql_query($strSQL) or die(mysql_error());
07.while ($objResult = mysql_fetch_assoc($objQuery)){
08.
09. $a = $objResult ["Department_code"];
10. if (strcmp($objResult ["employment_type"] ,"ประจำ") == 0){
11. $check_RO[$a]["RO"]+=1;
12. }else if ($objResult ["employment_type"] == "สัญญาจ้าง"){
13. $check_RO[$a]["TRO"]+=1;
14. }else if($objResult ["employment_type"] == "พนักงานรายวัน"){
15. $check_RO[$a]["PT"]+=1;
16.
17. }
18. }
19. for ($i=1; $i<=57; $i++)
20.{
21. echo "<tr>";
22. echo "<td>".$check_RO[$i]["RO"]."</td>";
23. echo "<td>".$check_RO[$i]["TRO"]."</td>";
24. echo "<td>".$check_RO[$i]["PT"]."</td>";
25. echo "</tr>";
26.}
27.
28.include ("connect.php");
29.$strSQL = "UPDATE data_ro1 SET ";
30.$strSQL .="P_RO = '".$_POST["RO"]."' ";
31.$strSQL .=",P_TRO= '".$_POST["TRO"]."' ";
32.$strSQL .=",P_PT= '".$_POST["PT"]."' ";
33.$objQuery = mysql_query($strSQL);
34.if($objQuery)
35.{
36. echo "Save Done.";
37.}
38.else
39.{
40. echo "Error Save [".$strSQL."]";
41.}
42.
43.?>
