Insert Data Into MySQL Using MySQLi and PDO
After a database and a table have been created, we can start adding data in them.
Here are some syntax rules to follow:
- The SQL query must be quoted in PHP
- String values inside the SQL query must be quoted
- Numeric values must not be quoted
- The word NULL must not be quoted
The INSERT INTO statement is used to add new records to a MySQL table:
VALUES (value1, value2, value3,…)
To learn more about SQL, please visit our SQL tutorial.
In the previous chapter we created an empty table named “MyGuests” with five columns: “id”, “firstname”, “lastname”, “email” and “reg_date”. Now, let us fill the table with data.
Note: If a column is AUTO_INCREMENT (like the “id” column) or TIMESTAMP (like the “reg_date” column), it is no need to be specified in the SQL query; MySQL will automatically add the value.
The following examples add a new record to the “MyGuests” table: