01.<div id="content-wrapper">
02.
03. <div class="container-fluid">
04.
05. <!
06.
07.
08. <!
09. <div class="row">
10.
11.
12. </div>
13.
14. <!
15. <div class="card mb-3">
16. <div class="card-header">
17. <i class="fas fa-table"></i>
18. ข้อมูลลูกค้า</div>
19. <div class="card-body">
20. <div class="table-responsive">
21. <table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
22. <thead>
23. <tr>
24. <th>ORDERID</th>
25. <th>ชื่อ</th>
26. <th>นามสกุล</th>
27. <th>โทรศัพท์</th>
28. <th>email</th>
29. <th>ที่อยู่</th>
30. <th>สินค้า</th>
31. <th>จำนวน</th>
32. <th>ราคา</th>
33. <th>ราคารวม</th>
34. <th>สถานะ</th>
35. <th>วันเวลา</th>
36. <th>สถานะจัดส่ง</th>
37. <th>การจัดการ</th>
38. </tr>
39. </thead>
40. <tbody>
41. <?php
42. include "../connect.inc.php";
43. $sql = "SELECT DISTINCT * FROM cart Left JOIN info ON cart.username=info.owner Inner join product ON
44. cart.id_product=product.id inner join checkout on cart.cart_id= checkout.cart_id ";
45. $q = mysql_query($sql);
46. $i = 1;
47. while($r = mysql_fetch_array($q)) {
48.
49.
50.
51. ?>
52. <tr>
53. <?php $c = $r["quality"] * $r["price"] ; ?>
54.
55. <td> <?php echo $r["order_id"] ?> </td>
56. <td> <?php echo $r["firstname"]; ?> </td>
57. <td> <?php echo $r["lastname"]; ?> </td>
58. <td> <?php echo $r["phone"]; ?> </td>
59. <td> <?php echo $r["email"]; ?> </td>
60. <td> <?php echo $r["address1"]; ?> <?php echo $r["state"]; ?> <?php echo $r["zipcode"]; ?> </td>
61. <td> <?php echo $r["name"]; ?> </td>
62. <td> <?php echo $r["quality"]; ?> </td>
63. <td> <?php echo $r["price"]; ?> </td>
64. <td> <?php echo $c ; ?> </td>
65. <td> <?php echo $r["status"]; ?> </td>
66. <td> <?php echo $r["date_time"]; ?> </td>
67. <td> <?php echo $r["ship_status"]; ?> </td>
68.
69. <td> <a href="delete_customer_order.php?id=<?php echo $r["cart_id"]; ?>"> <i class="fa fa-trash"></i></a>
70. <a href="update_ship.php?id=<?php echo $r["cart_id"]; ?>"> <i class="fa fa-car"></i></a>
71. <a href="update_ship1.php?id=<?php echo $r["cart_id"]; ?>"> <i class="fa fa-times"></i></a> </td>
72.
73. </tr>
74. <?php
75. $i++;
76. } ?>
77. </tbody>
78. </table>
79. </div>
80. </div>
81.
82. </div>
83.
84. </div>
