-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathcustomer-update.php
131 lines (95 loc) · 3.42 KB
/
customer-update.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
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
<?php
include_once 'includes/db_connect.php';
include_once 'includes/functions.php';
sec_session_start();
?>
<!DOCTYPE html>
<html>
<head>
<link rel="stylesheet" href="styles/main.css" />
<style>
#catagory-table {
margin-left: 40px;
}
</style>
</head>
<body>
<header id="dashboard-header">
<h1>Marvel Camera Shop</h1>
</header>
<?php if (login_check($mysqli) == true) : ?>
<?php include('admin-nav.php'); ?>
<nav id="dashboard-auth">
<ul>
<li><a href=""> Welcome <?php echo htmlentities($_SESSION['username']); ?>! </a></li>
<li style="float: right;"><a href="includes/logout.php"> Log Out</a></li>
</ul>
</nav>
<section id="dashboard-main">
<h2>Update Product</h2>
<?php
if (empty($successMessage)) {
} else {
echo $successMessage;
}
?>
<?php
if (isset($_GET['id'])) {
$name = $email = $phone = $address = "";
$id = $_GET['id'];
$sql = "SELECT * FROM customer where id = $id";
$result = $mysqli->query($sql);
if ($result->num_rows > 0) {
//var_dump($row)
while($row = mysqli_fetch_array($result))
{
$name = $row['name'];
$email = $row['email'];
$phone = $row['phone'];
$address = $row['address'];
}
}
else {
echo "No result found";
}
}
?>
<?php
if (isset($_POST['submit'])) {
$id = $_POST['id'];
$name = $_POST['name'];
$email = $_POST['email'];
$phone = $_POST['phone'];
$address = $_POST['address'];
$sql = "UPDATE customer SET name = '$name', email = '$email' , phone = '$phone' , address ='$address' WHERE id = $id";
if ($mysqli->query($sql) === TRUE) {
echo "User Has Been updated";
header('Location: ./customer-list.php');
exit();
}
else {
echo "error";
}
}
?>
<p>
<span class="error">* required field.</span></p>
<form method="post" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?>">
Name: <input type="text" name="name" value="<?php echo $name;?>"><br>
Email: <input type="text" name="email" value="<?php echo $email;?>"><br>
Phone: <input type="text" name="phone" value="<?php echo $phone;?>"><br>
Address <textarea name="address" rows="5" cols="20" ><?php echo $address;?> </textarea>
<input type="hidden" name="id" value="<?php echo $id;?>" /> <br>
<input type="submit" name="submit" value="Update">
</form>
</section>
<footer>
Copyright © sopnopriyo.com
</footer>
<?php else : ?>
<p>
<span class="error">You are not authorized to access this page.</span> Please <a href="login.php">login</a>.
</p>
<?php endif; ?>
</body>
</html>