How to Edit & Update data into database using pdo in php
Edit & Update data into database using PDO in PHP
In this post, you will be learning about how to edit data and update data into database using pdo in php.
So guys, first we will first fetch data into textbox, edit the data and submit the form for update using pdo in php.
We will be using Bootstrap v5 to design the user interface.
Step 1: Create database connection.
<?php
$servername = "localhost";
$username = "root";
$password = "";
$database = "phptutorials";
try {
$conn = new PDO("mysql:host=$servername;dbname=$database", $username, $password);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // set the PDO error mode to exception
// echo "Connected Successfully";
} catch(PDOException $e) {
echo "Connection Failed" .$e->getMessage();
}
?>
Step 2: Add the edit button in your html table where you have fetch data:
We are fetching the data of "id" using Object method in PDO PHP as given below:
<td>
<a href="student-edit.php?id=<?= $row->id; ?>" class="btn btn-primary">Edit</a>
</td>
Step 3: Create a file named "student-edit.php" and paste the below code:
We will retrieve data with the help of parameter which we created as id with send value on edit button
<?php
session_start();
include('dbcon.php');
?>
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet" >
<title>Edit & Update data into database using PHP PDO</title>
</head>
<body>
<div class="container">
<div class="row">
<div class="col-md-8 mt-4">
<div class="card">
<div class="card-header">
<h3>Edit & Update data into database using PDO in PHP
<a href="index.php" class="btn btn-danger float-end">BACK</a>
</h3>
</div>
<div class="card-body">
<?php
if(isset($_GET['id']))
{
$student_id = $_GET['id'];
$query = "SELECT * FROM students WHERE id=:stud_id LIMIT 1";
$statement = $conn->prepare($query);
$data = [':stud_id' => $student_id];
$statement->execute($data);
$result = $statement->fetch(PDO::FETCH_OBJ); //PDO::FETCH_ASSOC
}
?>
<form action="code.php" method="POST">
<input type="hidden" name="student_id" value="<?=$result->id?>" />
<div class="mb-3">
<label>Full Name</label>
<input type="text" name="fullname" value="<?= $result->fullname; ?>" class="form-control" />
</div>
<div class="mb-3">
<label>Email</label>
<input type="text" name="email" value="<?= $result->email; ?>" class="form-control" />
</div>
<div class="mb-3">
<label>Phone</label>
<input type="text" name="phone" value="<?= $result->phone; ?>" class="form-control" />
</div>
<div class="mb-3">
<label>Course</label>
<input type="text" name="course" value="<?= $result->course; ?>" class="form-control" />
</div>
<div class="mb-3">
<button type="submit" name="update_student_btn" class="btn btn-primary">Update Student</button>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Step 4: Create a code.php file and paste the below code:
<?php
session_start();
include('dbcon.php');
if(isset($_POST['update_student_btn']))
{
$student_id = $_POST['student_id'];
$fullname = $_POST['fullname'];
$email = $_POST['email'];
$phone = $_POST['phone'];
$course = $_POST['course'];
try {
$query = "UPDATE students SET fullname=:fullname, email=:email, phone=:phone, course=:course WHERE id=:stud_id LIMIT 1";
$statement = $conn->prepare($query);
$data = [
':fullname' => $fullname,
':email' => $email,
':phone' => $phone,
':course' => $course,
':stud_id' => $student_id
];
$query_execute = $statement->execute($data);
if($query_execute)
{
$_SESSION['message'] = "Updated Successfully";
header('Location: index.php');
exit(0);
}
else
{
$_SESSION['message'] = "Not Updated";
header('Location: index.php');
exit(0);
}
} catch (PDOException $e) {
echo $e->getMessage();
}
}
?>
Thank you.