01.<?
02. include ("connect.php");
03. $ID_ProType = $_POST[txtID_ProType];
04. $Name_ProType = $_POST[txtName_ProType];
05. $OldID_ProType = $_GET[OldID_ProType];
06.
07. if(trim($_POST["txtID_ProType"]) == "")
08. {
09. echo "<script language='JavaScript' type='text/javascript'>alert('กรุณากรอกรหัสปรพเภทสินค้า')</script>";
10. echo "<script>window.location='javascript:history.go(-1)'</script>";
11. }else if(trim($_POST["txtName_ProType"]) == ""){
12. echo "<script language='JavaScript' type='text/javascript'>alert('กรุณากรอกประเภทสินค้า')</script>";
13. echo "<script>window.location='javascript:history.go(-1)'</script>";
14. }else{
15. $strSQL = "SELECT * FROM producttype WHERE ID_ProType = '".$ID_ProType."' ";
16. $objQuery = mysql_query($strSQL);
17. $objResult = mysql_fetch_array($objQuery);
18. }
19.
20. if(!empty($objResult))
21. {
22. echo "<script language='JavaScript' type='text/javascript'>alert('รหัสประเภทสินค้านี้มีแล้ว กรุณากรอกใหม่')</script>";
23. echo "<script>window.location='javascript:history.go(-1)'</script>";
24. }else{
25. $sql = "update producttype set ID_ProType='".$ID_ProType."', Name_ProType='".$Name_ProType."' WHERE ID_ProType = '".$ID_ProType."' ";
26. $objQuery = mysql_query($sql);
27. if($objQuery)
28. {
29. echo "<script language='JavaScript' type='text/javascript'>alert('แก้ไขข้อมูลได้แล้ว')</script>";
30. echo "<script type='text/javascript'>window.location='ShowDataProductType.php'</script>";
31. }else{
32. echo "<script language='JavaScript' type='text/javascript'>alert('ไม่สามารถแก้ไขข้อมูลได้')</script>";
33. echo "<script>window.location='javascript:history.go(-1)'</script>";
34. }
35. }
36. mysql_close();
37.?>
Quote:
