In previous posts we have learned about creating a connection to a MySQL database with procedural and object oriented way, we also learn how to run a query with mysqli. This article demonstrates how to perform different CRUD operations with MySQLi procedural functions.
CRUD represents the four basic operations of the database.
C : C stands for Create (INSERT), which defines creating or inserting new data into the database.
R : R stands for Read (SELECT), which defines reading or retrieving records from database.
U : U stands for Update (UPDATE), update selected records of database.
D : D stands for Delete (DELETE), delete or remove the selected records from database.
For performing above operations first we have to create a connection to MySQL database and have to create a table to perform the above operations on it.