01. <?php
02.$objConnect = mysql_connect("localhost","root","asu@2558") or die("Error Connect to Database");
03.$objDB = mysql_select_db("asu_project");
04.mysql_query("SET character_set_results=utf8");
05.mysql_query("SET character_set_client=utf8");
06.mysql_query("SET character_set_connection=utf8");
07.
08.
09.
10.if($_GET["Action"] == "Save")
11.{
12. for($i=1;$i<=$_POST["hdnLine"];$i++)
13. {
14. $strSQL = "UPDATE item SET ";
15. $strSQL .="item_id = '".$_POST["item_id$i"]."' ";
16. $strSQL .=",item_no = '".$_POST["item_no$i"]."' ";
17. $strSQL .=",item_name = '".$_POST["item_name$i"]."' ";
18. $strSQL .=",quarter_id = '".$_POST["quarter_id$i"]."' ";
19. $strSQL .=",item_people = '".$_POST["item_people$i"]."' ";
20. $strSQL .=",item_use = '".$_POST["item_use$i"]."' ";
21. $strSQL .=",item_persent = '".$_POST["item_persent$i"]."' ";
22. $strSQL .=",item_utility = '".$_POST["item_utility$i"]."' ";
23. $strSQL .=",integration_id = '".$_POST["integration_id$i"]."' ";
24. $strSQL .=",item_detail = '".$_POST["item_detail$i"]."' ";
25. $strSQL .="WHERE item_id = '".$_POST["item_id$i"]."' ";
26.
27. $objQuery = mysql_query($strSQL) or die(mysql_error());
28.
29. }
30.
31.
32.}
33.
34.$strSQL = "SELECT * FROM item ORDER BY item_id ASC";
35.
36.$objQuery = mysql_query($strSQL) or die (mysql_error());
37.if(@implode("",$_FILES["filUpload"]['name'])!=""){
38. $arr_filupload_name = array();
39. for($i=0;$i<count($_FILES["filUpload"]['name']);$i++){
40. $filupload_name = $_FILES["filUpload"]['name'][$i];
41. $filupload_data = $_FILES["filUpload"]['tmp_name'][$i];
42.
43. if(is_uploaded_file($filupload_data) && move_uploaded_file($filupload_data,"myfile/".$filupload_name)){
44. @unlink("myfile/".$_POST["hdnOldFile"][$i]);
45. array_push($arr_filupload_name,$filupload_name);
46. }else{
47. array_push($arr_filupload_name,$_POST["hdnOldFile"][$i]);
48. }
49. }
50.
51. $strSQL = "UPDATE item ";
52. $strSQL .=" SET filUpload = '".$arr_filupload_name[0][$i]."',
53. filUpload1 ='".$arr_filupload_name[1]."',
54. filUpload2 = '".$arr_filupload_name[2]."',
55. filUpload3 = '".$arr_filupload_name[3]."',
56. filUpload4 ='".$arr_filupload_name[4]."'
57. WHERE item_id = '".$_GET["item_id"]."' ";
58. $objQuery = mysql_query($strSQL) or die(mysql_error());}
59.?>
