01. $SEQ = null;
02.
03. if(isset($_POST["Asset_ID"]))
04. {
05. $SEQ = $_POST["Asset_ID"];
06. }
07. ?>
08.<?php
09. ini_set('display_errors', 1);
10. error_reporting(~0);
11. error_reporting(0);
12. $serverName = "";
13. $userName = "root";
14. $userPassword = "";
15. $dbName = "";
16.
17. $conn = mysqli_connect($serverName,$userName,$userPassword,$dbName);
18. mysqli_set_charset($conn, "utf8");
19.
20. $User_name = $_REQUEST["User_name"];
21. $Branch_ID = $_REQUEST["Branch_ID"];
22. $Department_ID = $_REQUEST["Department_ID"];
23. $Telephone = $_REQUEST["Telephone"];
24. $Date_sent = $_REQUEST["Date_sent"];
25. $SEQ = $SEQ["Asset_ID"];
26. $Asset_re_detail = $_REQUEST["Asset_re_detail"];
27.
28.
29.echo $sql = "INSERT INTO user_repair(User_name, Branch_ID, Department_ID, Telephone, Date_sent, Asset_ID, Asset_re_detail, Date_finish)
30. VALUES('$User_name', '$Branch_ID', '$Department_ID', '$Telephone', '$Date_sent', '$SEQ', '$Asset_re_detail', '0000-00-00')";
31.
32. $result = mysqli_query($conn, $sql) or die (" ข้อมูลผิดพลาด Error in query: $sql " . mysqli_error());
