php-mysqlInserting data to MySQL using PHP

Inserting data to MySQL using PHP is a common task for web developers. It can be done using the mysqli_query() function. The following example code inserts a new record into a table called users:

$sql = "INSERT INTO users (name, email) VALUES ('John Doe', '[email protected]')";
mysqli_query($conn, $sql);

The code above will insert a new record with the name John Doe and email [email protected] into the users table.

The code consists of two parts:

1. The SQL query: $sql = "INSERT INTO users (name, email) VALUES ('John Doe', '[email protected]')";
   • This part of the code defines the SQL query that will be used to insert the data.
2. The mysqli_query() function: mysqli_query($conn, $sql);
   • This part of the code executes the SQL query and inserts the data into the database.

Helpful links

• PHP MySQL Insert
• MySQL INSERT Statement

Edit this code on GitHub