PHP Delete and Update Data in MySQL

3
790

PHP Delete and Update Data in MySQL

This tutorial about PHP Delete and Update Data in MySQL is a continuation of our MySQL Tutorial for Beginners in 7 Days. In this tutorial, you will learn how to Delete and Update MySQL data using PHP with MySQLi and PDO.

MySQL Delete Data

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):

Example using MySQLi(Procedural):

Example using PDO:

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):

Example using MySQLi(Procedural):

Example using PDO:

 

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.

3 COMMENTS

  1. Please help doing my project. How to code time in button then record to access, my project is about tine in time out attendance. Can you help me? God bless.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.