Edit Data to mysql
Below is the edit.php code
<?php
$conn =new mysqli('localhost', 'root', '' , 'suman');
if (isset($_POST['submit'])) {
$sql = $conn->prepare("UPDATE student SET name=? , email=? WHERE id=?");
$name = $_POST['name'];
$email= $_POST['email'];
$sql->bind_param("ssi", $name, $email,$_GET["id"]);
if($sql->execute()) {
$msg_succ = "Edited Successfully";
} else {
$msg_error = "Problem in Editing Record";
}
}
$sql = $conn->prepare("SELECT * FROM student WHERE id=?");
$sql->bind_param("i",$_GET["id"]);
$sql->execute();
$result = $sql->get_result();
if ($result->num_rows > 0) {
$row = $result->fetch_assoc();
}
$conn->close();
?>
<html>
<head>
<title>Edit Student</title>
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">
</head>
<body>
<?php if(!empty($msg_succ)) { ?>
<div class="alert alert-success" role="alert"><?php echo $msg_succ; ?></div>
<?php } if(!empty($msg_error)) { ?>
<div class="alert alert-danger" role="alert"><?php echo $msg_error; ?></div>
<?php } ?>
<div class="container">
<div class="row" >
<div class="col-sm-6">
<form name="frmUser" method="post" action="">
<div class="form-group">
<label for="name">Name</label>
<input type="text" class="form-control" id="name" name="name" value="<?php echo $row['name']?>" placeholder="Enter name">
</div>
<div class="form-group">
<label for="exampleInputPassword1">Email</label>
<input type="email" class="form-control" value="<?php echo $row['email']?>" id="email" name="email" placeholder="Enter Email">
</div>
<button type="submit" name="submit" class="btn btn-primary">Submit</button>
</form>
</div>
</div>
</div>
</body>
</html>