In this post, you will be learning how to edit and update data using oops in php, where we edit data from database in html form and updated the data into database using oops concept in php mysql.
edit.php
<?php
include 'dbcon.php';
$id = $_GET['id'];
class query extends database{
function getData($id){
$q = "SELECT * FROM student WHERE id=$id";
$result = $this->connect()->query($q);
if($result->num_rows > 0){
while($row = $result->fetch_assoc()){
$name = $row['name'];
$email = $row['email'];
$phone = $row['phone']; ?>
<div class="container mt-4">
<div class="row">
<div class="col-md-12">
<?php
if(isset($_SESSION['message']))
{
echo "<h5>".$_SESSION['message']."</h5>";
unset($_SESSION['message']);
}
?>
<div class="card">
<div class="card-header">
<h4>Student Add</h4>
</div>
<div class="card-body">
<form action="update.php" method="POST">
<div class="mb-3">
<label for="">Full Name</label>
<input type="text" name="name" required class="form-control" value="<?php echo $name; ?>" />
<input type="hidden" name="id" value="<?php echo $id; ?>">
</div>
<div class="mb-3">
<label for="">Email ID</label>
<input type="text" name="email" required class="form-control" value="<?php echo $email; ?>" />
</div>
<div class="mb-3">
<label for="">Phone</label>
<input type="text" name="phone" required class="form-control" value="<?php echo $phone; ?>" />
</div>
<div class="mb-3">
<button type="submit" name="save_student" class="btn btn-primary">Update Student</button>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
<?php
}
}
}
}
$obj = new query;
$obj->getData($id);
?>
update.php
<?php
include 'dbcon.php';
$name = $_POST['name'];
$email = $_POST['email'];
$phone = $_POST['phone'];
$id = $_POST['id'];
class query extends database{
function update($name, $email, $phone, $id){
$q = "UPDATE student SET name='$name', email='$email', phone='$phone' WHERE id='$id'";
$result = $this->connect()->query($q);
if($result)
{
$_SESSION['message'] = "Student Updated Successfully";
header("Location: students.php");
exit(0);
}
else
{
$_SESSION['message'] = "Not Inserted";
header("Location: students.php");
exit(0);
}
}
}
$obj = new query;
$obj->update($name, $email, $phone, $id);
?>
