03.<head>
04.<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
05.<title>Untitled Document</title>
06.</head>
07.
08.<body>
09.<form id="form1" name="form1" method="post" action="save_status_order.php">
10. <p>รายการ Order ลูกค้า</p>
11. <p> <?
12.
13. $host="localhost";
14. $username="root";
15. $pass_word="510740";
16. $db="dbproject";
17. $Conn = mysql_connect( $host,$username,$pass_word) or die ("ติดต่อฐานข้อมูลไม่ได้");
18. mysql_query("SET NAMES utf8",$Conn);
19. mysql_select_db($db) or die("เลือกฐานข้อมูลไม่ได้");
20.
21. if($_REQUEST['OrderID'] != "")
22. {
23. $del_id = $_REQUEST['OrderID'];
24. $sql_del = "delete from orderss where OrderID = '$OrderID';";
25. mysql_query($sql_del) or die(mysql_error());
26. echo "ข้อมูล ID $del_id เรียบร้อยแล้ว";
27.}
28. ?>
29. </p>
30. <table width="712" border="1">
31. <tr>
32. <td width="56">รหัส</td>
33. <td width="56">ชื่อ</td>
34. <td width="133">ที่อยู่</td>
35. <td width="99">สินค้า</td>
36. <td width="37">สถานะ</td>
37. <td width="99">เปลี่ยนสถานะ</td>
38. </tr>
39. <?
40. $sql_show = "select * from orderss,product,status";
41. $result_show = mysql_query($sql_show) or die(mysql_error());
42. while($row_show = mysql_fetch_array($result_show))
43. {
44. ?>
45.
46. <tr>
47. <td><?=$row_show['OrderID'] ?></td>
48. <td><?=$row_show['Name'] ?></td>
49. <td><?=$row_show['Address'] ?></td>
50. <td><?=$row_show['pro_name'] ?></td>
51. <td><?=$row_show['status_name'] ?></td>
52. <td><select name="menustatus" id="menustatus">
53. <?php echo "status_name"; ?>
54. </select></td>
55. </tr>
56. <?
57. }
58. ?>
59. </table>
60. <p><?php echo "<a href=admin_page.php>กลับสู่หน้าจัดการ</a>";?>
61.
62. <label>
63. <input type="submit" name="button" id="button" value="save" />
64.
65. </label>
66. </p>
67.</form>
68.<p> </p>
69.<p> </p>
70.</body>
71.</html>
