PHP Delete and Update Data in MySQL

0
439

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.

Previous articleMySQL Select Statement
Next articleLogin User and User Registration in PHP
Hello Itsourcecoders, welcome to itsourcecode.com. I'm Joken Villanueva, MIT a passionate Blogger, Programmer and a Hobbyist. I started Itsourcecode because I wanted to give back and Share all the learnings and knowledge I've learned in my career and I believe through this website I would be able to help and assist those newbie programmers in enhancing their skills from different programming languages. So let us all help each other by sharing our ideas!

Leave a Reply

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