01.<?php
02.$HOST_NAME = "localhost";
03.$DB_NAME = "test";
04.$CHAR_SET = "charset=utf8";
05.$USERNAME = "root";
06.$PASSWORD = "";
07.$connect = new PDO('mysql:host='.$HOST_NAME.';dbname='.$DB_NAME.';'.$CHAR_SET,$USERNAME,$PASSWORD);
08.$id = $_GET['order_items_id'];
09.$sql = 'SELECT * FROM tbl_order_items WHERE id=:order_items_id';
10.$statement = $connect->prepare($sql);
11.$statement->execute([':order_items_id' => $id ]);
12.$edit = $statement->fetch(PDO::FETCH_OBJ);
13.if (isset ($_POST['item_name']) && isset($_POST['item_price']) ) {
14. $name = $_POST['item_name'];
15. $price = $_POST['item_price'];
16. $sql = 'UPDATE tbl_order_items SET name=:item_name, price=:item_price WHERE id=:order_items_id';
17. $statement = $connection->prepare($sql);
18. if ($statement->execute([':item_name' => $name, ':item_price' => $email, ':order_items_id' => $id])) {
19. header("Location: /");
20. }
21.}
22. ?>
23.<div class="container">
24. <div class="card mt-5">
25. <div class="card-header">
26. <h2>Update person</h2>
27. </div>
28. <div class="card-body">
29. <?php if(!empty($message)): ?>
30. <div class="alert alert-success">
31. <?= $message; ?>
32. </div>
33. <?php endif; ?>
34. <form method="post">
35. <div class="form-group">
36. <label for="name">Name</label>
37. <input value="<?= $edit->item_name; ?>" type="text" name="item_name" id="item_name" class="form-control">
38. </div>
39. <div class="form-group">
40. <label for="email">Email</label>
41. <input type="email" value="<?= $edit->item_price; ?>" name="item_price" id="item_price" class="form-control">
42. </div>
43. <div class="form-group">
44. <button type="submit" class="btn btn-info">Update person</button>
45. </div>
46. </form>
47. </div>
48. </div>
49.</div>
