<?php
include 'conn.php';
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Bookstore</title>
<link rel="stylesheet" href="css/bootstrap.min.css">
</head>
<body>
<!-- contact section -->
<section id="contact" class="py-5 bg-warning mt-3">
<div class="container">
<!-- title contact -->
<!-- title -->
<div class="row">
<div class="col text-center ">
<h1 class="display-4 text-uppercase mb-0 ">
<strong>User Upadte </strong>
</h1>
<div class="title-underline bg-danger"></div>
<!-- <p class="mt-2 text-capitalize text-muted">Lorem ipsum dolor sit amet.</p> -->
</div>
</div>
<!-- end of title -->
<div class="row justify-content-center">
<div class="col-md-6 my-3">
<div class="card card-body bg-secondary">
<!-- title -->
<div class="card-title text-center text-white">
<h1 class="text-capitalize"></h1>
<!-- <p>Message Us</p> -->
</div>
<!-- end of title -->
<form action="" method="POST" >
<!-- simple form -->
<?php
$id = $_GET['id'];
$sql = "SELECT *FROM users WHERE id = '$id' ";
$result = mysqli_query($conn ,$sql);
if(mysqli_num_rows($result)>0) {
while ($user = mysqli_fetch_assoc($result)){ ?>
<div class="form-group mt-3">
<input type="text" class="form-control" name="u_name" value="<?php echo $user['uname'] ;?> ">
</div>
<div class="form-group mt-3">
<input type="text" class="form-control" name="u_email" value="<?php echo $user['uemail'] ;?>">
</div>
<div class="form-group mt-3">
<input type="text" class="form-control" name="u_no" value="<?php echo $user['uno'] ;?> ">
</div>
<!-- email -->
<!-- <div class="form-group mt-3">
<input type="password" class="form-control " name="u_pass" placeholder="password">
</div> -->
<!-- append -->
<button type="submit" value="Update" name="update" class="btn btn-outline-dark btn-block text-uppercase">submit</button>
<?php }
} else{
echo '0 result';
}
?>
</form>
</div>
</div>
<script src="js/jquery.min.js"></script>
<script src="js/bootstrap.min.js"></script>
<?php
if(isset($_POST['update'])) {
$u_name = $_POST['u_name'];
$u_email = $_POST['u_email'];
$u_no = $_POST['u_no'];
$sql = "UPDATE users SET uname='$u_name',uemail='$u_email',uno='$u_no' WHERE id='$id'";
if (mysqli_query($conn,$sql)) {
echo "<script type = \"text/javascript\">
alert(\"Updated Succesfully \");
window.location = (\"dash.php\")
</script>";
}else{
echo "error updating record:",mysqli_error($conn);
}
}
?>
</body>
</html>
0 Comments