-
Notifications
You must be signed in to change notification settings - Fork 0
/
view_customer.php
85 lines (69 loc) · 2.62 KB
/
view_customer.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
<!-- File : view_customer.php
Deskripsi : menampilkan data customers -->
<?php
session_start(); //inisialisasi session
if (!isset($_SESSION['username'])) {
header('Location: login.php');
}
?>
<!DOCTYPE HTML>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- Latest compiled and minified CSS -->
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.1/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-F3w7mX95PdgyTmZZMECAngseQB83DfGTowi0iMjiWaeVhAn4FJkqJByhZMI3AhiU" crossorigin="anonymous">
<title>Form</title>
</head>
<body>
<div class="container">
<br>
<div class="card">
<div class="card-header">Customers Data
<a class="btn btn-danger" style="float: right;" href="logout.php">Logout</a>
</div>
<div class="card-body">
<br>
<a class="btn btn-primary" href="add_customer.php">+ Add Customer Data</a><br /><br />
<table class="table table-striped">
<tr>
<th>No</th>
<th>Name</th>
<th>Address</th>
<th>City</th>
<th>Action</th>
</tr>
<?php
require_once('./db_login.php'); // Include our login information
$query = "SELECT customerid AS ID, name AS Nama, address AS Alamat, city AS Kota FROM customers ORDER BY customerid ";
$result = $db->query($query); // Execute the query
if (!$result) {
die ("Could not query the database: <br />". $db->error ."<br>Query: ".$query);
}
// Fetch and display the results
$i = 1;
while ($row = $result->fetch_object()) {
echo '<tr>';
echo ' <td>' . $row->ID . '</td>';
echo ' <td>' . $row->Nama . '</td> ';
echo ' <td>' . $row->Alamat . '</td> ';
echo ' <td>' . $row->Kota . '</td>';
echo ' <td>
<a class="btn btn-warning btn-sm" href="edit_customer.php?id=' . $row->ID . '">Edit</a>
<a class="btn btn-danger btn-sm" href="delete_customer.php?id=' . $row->ID . '">Delete</a>
</td>';
echo '</tr>';
$i++;
}
echo '</table>';
echo '<br />';
echo 'Total Rows = ' . $result->num_rows;
$result->free();
$db->close();
?>
</table>
</div>
</div>
</div>
</body>
</html>