forked from codespeakerdotcom/mysqlicrud
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathedit.php
67 lines (58 loc) · 2.13 KB
/
edit.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
<?php
require_once 'connect.php';
require_once 'header.php';
?>
<div class="container">
<?php
if(isset($_POST['update'])){
if( empty($_POST['firstname']) || empty($_POST['lastname']) ||
empty($_POST['address']) || empty($_POST['contact']) )
{
echo "Please fillout all required fields";
}else{
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$address = $_POST['address'];
$contact = $_POST['contact'];
$sql = "UPDATE users SET firstname='{$firstname}', lastname = '{$lastname}',
address = '{$address}', contact = '{$contact}'
WHERE user_id=" . $_POST['userid'];
if( $con->query($sql) === TRUE){
echo "<div class='alert alert-success'>Successfully updated user</div>";
}else{
echo "<div class='alert alert-danger'>Error: There was an error while updating user info</div>";
}
}
}
$id = isset($_GET['id']) ? (int) $_GET['id'] : 0;
$sql = "SELECT * FROM users WHERE user_id={$id}";
$result = $con->query($sql);
if($result->num_rows < 1){
header('Location: index.php');
exit;
}
$row = $result->fetch_assoc();
?>
<div class="row">
<div class="col-md-6 col-md-offset-3">
<div class="box">
<h3><i class="glyphicon glyphicon-plus"></i> MODIFY User</h3>
<form action="" method="POST">
<input type="hidden" value="<?php echo $row['user_id']; ?>" name="userid">
<label for="firstname">Firstname</label>
<input type="text" id="firstname" name="firstname" value="<?php echo $row['firstname']; ?>" class="form-control"><br>
<label for="lastname">Lastname</label>
<input type="text" name="lastname" id="lastname" value="<?php echo $row['lastname']; ?>" class="form-control"><br>
<label for="address">Address</label>
<textarea rows="4" name="address" class="form-control"><?php echo $row['address']; ?></textarea><br>
<label for="contact">Contact</label>
<input type="text" name="contact" id="contact" value="<?php echo $row['contact']; ?>" class="form-control"><br>
<br>
<input type="submit" name="update" class="btn btn-success" value="Update">
</form>
</div>
</div>
</div>
</div>
<?php
require_once 'footer.php';