01.<?php
02.
03. if(isset($_POST['Typebk'])
04. && isset($_POST['datebk'])
05. && isset($_POST['Numberbk'])
06. && isset($_POST['Yearbk'])
07. && isset($_POST['Sudbk'])
08. && isset($_POST['NameFrom'])
09. && isset($_POST['NameTo'])
10. && isset($_POST['posFrom'])
11. && isset($_POST['idmemFrom'])
12. && isset($_POST['posTo'])
13. && isset($_POST['idmemTo'])
14. && isset($_POST['phonefrom'])
15. && isset($_POST['phoneto'])
16. && isset($_POST['nameby'])
17. && isset($_POST['nameEdit'])
18. && isset($_POST['dateEdit'])
19.
20. ){
21.
22. require_once 'connects/connect.php';
23.
24.
25. $Typebk = $_POST['Typebk'];
26. $datebk = $_POST['datebk'];
27. $Numberbk = $_POST['Numberbk'];
28. $Yearbk = $_POST['Yearbk'];
29. $Sudbk = $_POST['Sudbk'];
30. $NameFrom = $_POST['NameFrom'];
31. $NameTo = $_POST['NameTo'];
32. $posFrom = $_POST['posFrom'];
33. $idmemFrom= $_POST['idmemFrom'];
34. $posTo = $_POST['posTo'];
35. $idmemTo = $_POST['idmemTo'];
36. $phonefrom = $_POST['phonefrom'];
37. $phoneto = $_POST['phoneto'];
38. $nameby = $_POST['nameby'];
39. $nameEdit = $_POST['nameEdit'];
40. $dateEdit = $_POST['dateEdit'];
41.
42.$stmt = $conn->prepare("UPDATE bookout_2565 SET Typebk=:Typebk, datebk=:datebk, Numberbk=:Numberbk, Yearbk=:Yearbk, Sudbk=:Sudbk, NameFrom=:NameFrom, NameTo=:NameTo, posFrom=:posFrom, idmemFrom=:idmemFrom, posTo=:posTo, idmemTo=:idmemTo, phonefrom=:phonefrom, phoneto=:phoneto, nameby=:nameby, nameEdit=:nameEdit, dateEdit=:dateEdit WHERE bookID=:bookID");
43.
44.
45.$stmt->bindParam(':Typebk', $Typebk , PDO::PARAM_STR);
46.$stmt->bindParam(':datebk', $datebk , PDO::PARAM_STR);
47.$stmt->bindParam(':Numberbk', $Numberbk , PDO::PARAM_STR);
48.$stmt->bindParam(':Yearbk', $Yearbk , PDO::PARAM_STR);
49.$stmt->bindParam(':Sudbk', $Sudbk , PDO::PARAM_STR);
50.$stmt->bindParam(':NameFrom', $NameFrom , PDO::PARAM_STR);
51.$stmt->bindParam(':NameTo', $NameTo , PDO::PARAM_STR);
52.$stmt->bindParam(':posFrom', $posFrom , PDO::PARAM_STR);
53.$stmt->bindParam(':idmemFrom', $idmemFrom , PDO::PARAM_STR);
54.$stmt->bindParam(':posTo', $posTo , PDO::PARAM_STR);
55.$stmt->bindParam(':idmemTo', $idmemTo , PDO::PARAM_STR);
56.$stmt->bindParam(':phonefrom', $phonefrom , PDO::PARAM_STR);
57.$stmt->bindParam(':phoneto', $phoneto , PDO::PARAM_STR);
58.$stmt->bindParam(':nameby', $nameby , PDO::PARAM_STR);
59.$stmt->bindParam(':nameEdit', $nameEdit , PDO::PARAM_STR);
60.$stmt->bindParam(':dateEdit', $dateEdit , PDO::PARAM_STR);
61.$stmt->execute();
62.
63.
64. echo '
68.
69. if($stmt->rowCount() > 0){
70. echo '<script>
71. setTimeout(function() {
72. swal({
73. title: "แก้ไขข้อมูลสำเร็จ",
74. type: "success"
75. }, function() {
76. window.location = "afrom.php";
77. });
78. }, 1000);
79. </script>';
80. }else{
81. echo '<script>
82. setTimeout(function() {
83. swal({
84. title: "เกิดข้อผิดพลาด",
85. type: "error"
86. }, function() {
87. window.location = "afrom.php";
88. });
89. }, 1000);
90. </script>';
91. }
92.$conn = null;
93.}
94.?>
Quote:
