01.<?php require_once('Connections/myconnect.php'); ?>
02.<?php
03.if (!function_exists("GetSQLValueString")) {
04.function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
05.{
06. if (PHP_VERSION < 6) {
07. $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
08. }
09.
10. $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
11.
12. switch ($theType) {
13. case "text":
14. $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
15. break;
16. case "long":
17. case "int":
18. $theValue = ($theValue != "") ? intval($theValue) : "NULL";
19. break;
20. case "double":
21. $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
22. break;
23. case "date":
24. $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
25. break;
26. case "defined":
27. $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
28. break;
29. }
30. return $theValue;
31.}
32.}
33.
34.mysql_select_db($database_myconnect, $myconnect);
35.$query_showindex = "SELECT * FROM tbl_product ORDER BY p_id ASC";
36.$showindex = mysql_query($query_showindex, $myconnect) or die(mysql_error());
37.$row_showindex = mysql_fetch_assoc($showindex);
38.$totalRows_showindex = mysql_num_rows($showindex);
39.$bmiid = "-1";
40.if (isset($_GET['BMI_id'])) {
41. $bmiid = $_GET['BMI_id'];}
42.?>
45.<head>
46.<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
47.<title>Untitled Document</title>
48.</head>
49.
50.<body>
51.<form id="form1" name="form1" method="post" action="food_insert.php">
52.<table border="1" align="center" cellpadding="20">
53. <tr>
54. <center><td>p_id</td>
55. <td>ชื่ออาหาร</td>
56. <td>รายละเอียด</td>
57. <td>แคลอรี่</td>
58. <td>รูปภาพ</td>
59. <td>วันเวลา</td>
60. <td>ลบข้อมูล</td>
61. <td>แก้ไข</td></center>
62. </tr>
63. <?php $x = 1; do { ?>
64. <tr>
65. <td><?php echo $row_showindex['p_id']; ?>
66.
67. <input type="checkbox" value = "<?php echo $p_id; ?>" name="check<?php echo $x; ?>" id="idmenu" />
68. <input name="p_id<?php echo $x; ?>" type="hidden" value="<?php echo $row_showindex['p_id']; ?>" />
69. <input name="bmi_id<?php echo $x; ?>" type="hidden" value="<?php echo $bmiid; ?>" />
70. <input name="p_name<?php echo $x; ?>" type="hidden" value="<?php echo $row_showindex['p_name']; ?> " />
71. </td>
72. <td><?php echo $row_showindex['p_name']; ?></td>
73. <td><?php echo $row_showindex['p_detail']; ?></td>
74. <td><?php echo $row_showindex['p_price']; ?></td>
75. <td><img src="img/<?php echo $row_showindex['p_img']; ?>" width="100" /></td>
76. <td><?php echo $row_showindex['p_save']; ?></td>
77. <td><div align="center"><a href="delete.php?p_id=<?php echo $row_showindex['p_id']; ?>">ลบ</a></div></td>
78. <td><a href="edit1.php?p_id=<?php echo $row_showindex['p_id']; ?>">แก้ไข</a></td>
79. </tr>
80. <?php $x++; } while ($row_showindex = mysql_fetch_assoc($showindex)); ?>
81.
82.
83.</table>
84.<center>
85.<input name="x" type="hidden" value="<?php echo $x-1 ?>" />
86.<input name="" type="submit" /></center>
87. </form>
88.<center>
89. <a href="add_product.php">เพิ่มอาหาร</a>
90.</center>
91.</body>
92.</html>
93.<?php
94.mysql_free_result($showindex);
95.?>
