01.<html>
02.<head>
03.<title>Dr.Boo</title>
04.</head>
05.<body>
06.<?php
07. ini_set('display_errors', 1);
08. error_reporting(~0);
09.
10.
11. $serverName = "localhost";
12. $userName = "root";
13. $userPassword = "root";
14. $dbName = "datacheck";
15.
16. $conn = mysqli_connect($serverName,$userName,$userPassword,$dbName);
17. $nature = $_POST['nature'];
18.if ($nature != 'สภาพเรียบร้อย') {
19. $nature = 'ชำรุดเสียหาย';
20.}
21. $sql = "INSERT INTO tb_check (id_no, ch_date, ch_name, ch_inv, ch_po, ch_av, pro_id, pro_name, ch_mr, pro_no, ch_lot, mfg_date, exp_date, nature)
22. VALUES('".$_POST["id_no"]."','".$_POST["ch_date"]."','".$_POST["ch_name"]."','".$_POST["ch_inv"]."','".$_POST["ch_po"]."','".$_POST["ch_av"]."'
23. ,'".$_POST["pro_id"]."','".$_POST["pro_name"]."','".$_POST["ch_mr"]."','".$_POST["pro_no"]."','".$_POST["ch_lot"]."','".$_POST["mfg_date"]."'
24. ,'".$_POST["exp_date"]."','".$_POST["$nature"]."')";
25.
26. $query = mysqli_query($conn,$sql);
27.
28. if($query) {
29. echo "Success";
30. }
31.Else
32. {
33. echo "Not";
34. }
35. mysqli_close($conn);
36.?>
37.</body>
38.</html>
