PHP Delete and Update Data in MySQL

PHP Delete and Update Data in MySQL

MySQL Delete Data is used In Deleting data using MySQL the DELETE Statement is used.

Syntax:

DELETE FROM tablename
WHERE specificcolumn = correspondingvalue

MySQL Delete Data

Take Note! Using the DELETE command you must not forget to include the WHERE clause because the Where clause is used to specify record you want to delete.

Without having the WHERE clause, all records in the table will be deleted.

Here the following examples in Deleting record from “tblpeople”.

Example using MySQLi(Object-Oriented):

die("Connection failed: " . $conn->connect_error);
}

// sql to delete record from table
$sql = "DELETE FROM tblpeople WHERE ID=9";

if ($conn->query($sql) === TRUE) {
echo "Record Delete successfully";
} else {
echo "Error: " . $sql . "
" . $conn->error;
}

$conn->close();
?>

Example using MySQLi(Procedural):

$username = "root";
$password = "";
$database = "mysqltutorial";

// Create connection
$conn = mysqli_connect($server, $username, $password, $database);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}

// sql to Delete record from table
$sql = "DELETE FROM tblpeople WHERE ID=9";

if (mysqli_query($conn, $sql)) {

echo "Record Delete successfully";
} else {
echo "Error: " . $sql . "
" . mysqli_error($conn);
}

mysqli_close($conn);
?>

Example using PDO:

$sql = "DELETE FROM tblpeople WHERE ID=8";

$conn->exec($sql);
echo "Record Delete successfully";
}
catch(PDOException $e)
{

echo $sql . "
" . $e->getMessage();
}

$conn = null;
?>

MySQL Update Data

To update the existing data in the MySQL database you need to used the UPDATE statement.

Syntax:

UPDATE tablename
SET column1=val1, column2=val2, column3=val3
WHERE column=value; 

Take Note! 

Using the UPDATE command you must not forget to include the WHERE clause, because the Where clause is used to specify record you want to modify.

Without having the WHERE clause, all records in the table will be modified. Example in Updating Data using MySQLi(Object-Oriented), MySQLi(Procedural) and PDO. 

Example using MySQLi(Object-Oriented):

die("Connection failed: " . $conn->connect_error);
}

// sql to UPDATE record from table
$sql = "UPDATE `tblpeople` SET `LNAME` = 'Villan',`FNAME` = 'Joven',`ADDRESS` = 'Bacolod' WHERE `tblpeople`.`ID` =5;";

if ($conn->query($sql) === TRUE) {
echo "Record UPDATED successfully";
} else {
echo "Error: " . $sql . "
" . $conn->error;
}

$conn->close();
?>

Example using MySQLi(Procedural):

$username = "root";
$password = "";
$database = "mysqltutorial";

// Create connection
$conn = mysqli_connect($server, $username, $password, $database);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}

// sql to UPDATE record from table
$sql = "UPDATE `tblpeople` SET `LNAME` = 'Villan',`FNAME` = 'Joven',`ADDRESS` = 'Bacolod' WHERE `tblpeople`.`ID` =5;";

if (mysqli_query($conn, $sql)) {

echo "Record UPDATED successfully";
} else {
echo "Error: " . $sql . "
" . mysqli_error($conn);
}

mysqli_close($conn);
?>

Example using PDO:

$sql = "UPDATE `tblpeople` SET `LNAME` = 'Villan',`FNAME` = 'Joven',`ADDRESS` = 'Bacolod' WHERE `tblpeople`.`ID` =5;"; 
$conn->exec($sql); 
echo 
"Record UPDATED successfully";
 } catch(PDOException $e) { 
echo $sql . " " . $e->getMessage();
 } 
$conn = null; 
?>

Summary

In summary, we have discussed here how to update and delete MySQL data using PHP with MySQLi and PDO. 

After you finish this article, you may go back to the first tutorial and review from the beginning and you be able to realize that you are ready to create whole PHP Projects.

Note: If you have questions or suggestions about MySQL tutorial with PHP, please leave a comment below.

Technology stack and requirements

To run this PHP project, you need these tools on your development machine:

• XAMPP or WAMP server. Bundles Apache, MySQL, and PHP so you can run PHP on Windows without individual installs. Free from apachefriends.org.
• PHP 8.0 or higher. Included with XAMPP. Older versions (5.x, 7.x) may work but modern PHP features improve security and performance.
• MySQL or MariaDB. Comes with XAMPP. phpMyAdmin manages the database through a browser UI.
• VS Code or PhpStorm. Free code editor with PHP syntax highlighting, IntelliSense, and debugging support.
• Web browser. Chrome, Firefox, or Edge for testing the running app.

Installing the source code

1. Download the archive. Get the ZIP file from the download link on this page and extract it.
2. Move to htdocs. Place the extracted folder inside C:\xampp\htdocs\ so Apache can serve it.
3. Import the database. Open http://localhost/phpmyadmin, click Import, and select the .sql file included in the archive.
4. Update database credentials. Open the config.php or connection.php file and set the correct database name, username, and password (default XAMPP: root / empty password).
5. Run the project. Start Apache + MySQL in XAMPP, then visit http://localhost/your-project-folder/ in a browser.

Using this project for your BSIT capstone

This PHP project maps cleanly to standard BSIT capstone documentation. Suggested chapter alignment:

• Chapter 1 (Introduction). Discuss the problem the system solves in real-world context. Cite Philippine business or academic use cases where a manual process could be replaced.
• Chapter 2 (Review of Related Literature). Compare this system’s features against 5-10 similar published projects. Cite journals like IJERT or IEEE Access for academic-standard sources.
• Chapter 3 (Methodology). Include Use Case Diagram, Data Flow Diagram, Entity Relationship Diagram, and Activity Diagram covering all major workflows.
• Chapter 4 (Results and Discussion). Screenshot each module of the running system with a caption explaining what data it processes and which user role interacts with it.
• Chapter 5 (Conclusion and Recommendations). Identify features that could be added in a Version 2, such as mobile app, REST API export, or AI-powered analytics.

Modules typical of PHP Delete and Update Data in MySQL

• Master data. CRUD forms for the primary entities with search and filter.
• Transaction processing. Data entry forms for day-to-day operations the system automates.
• Reports. Formatted printable output summarizing activity per day, user, or category.
• User management. Login with role-based permissions (Admin, Encoder, Viewer).
• Backup and restore. Export database to a .sql file and restore when needed.

Common enhancements for capstone review

• Modernize the UI. Add Bootstrap 5 or Tailwind CSS for a polished appearance.
• Add printable receipts. Use TCPDF or FPDF to generate PDF reports.
• Multi-user concurrency. Ensure database handles simultaneous writes without lost-update errors.
• Rewrite in Laravel. Migrate to Laravel for maintainability and modern development patterns.

Related Aricles

• How To Delete Data In The Database Using PHP
• Delete Data In PHP MySQL Without Refreshing Page
• Delete Data In Phpmysql With Javascript Confirmation
• Simple Insert Data Database PHP
• Update Data Into Database Using PHP
• Simple Edit Data Using PHP MySQL Responsive Page

Joken E. Villanueva

Founder & Lead Developer at PIES IT Solution

Founder of PIES Information Technology Solutions, a software company building production-grade applications for institutions across the Philippines. Over 8 years of hands-on full-stack development experience, currently leading the development of ClinicAI, an AI-powered clinic management platform.

Expertise: PHP · MySQL · JavaScript · AI Integration · SaaS Architecture · VB.NET · Database Design · Capstone Documentation · Java
 · View all posts by Joken E. Villanueva →