MySQL Query statement "INSERT INTO" is used to insert new records in a table.
Insert Data Into a Database table
Syntax:
INSERT INTO table_name (column, column1, column2, column3, ...)
VALUES (value, value1, value2, value3 ...)
Example:
<?php
// Database connection establishment
$con=mysqli_connect("example.com","alex","qwerty","db_name");
// Check connection
if (mysqli_connect_errno($con)) {
echo "MySQL database connection failed: " . mysqli_connect_error();
}
// Insert
mysqli_query($con,"INSERT INTO contact (name,email,message)
VALUES (Alex, 'alex@example.com', 'Sample message')")
?>
Insert Data Into a Database using HTML form
The HTML Form:
<html>
<body>
<form action="submit.php" method="post">
<table>
<tr>
<td>FirstName:</td>
<td><input type="text" name="name" id="name" ></td>
</tr>
<tr>
<td>Email:</td>
<td><input type="text" name="email" id="email" ></td>
</tr>
<tr>
<td>Message:</td>
<td><textarea name="message" cols="40" rows="5" id="message"></textarea></td>
</tr>
<tr>
<td><input name="submitBtn" type="submit" id="submitBtn"
value="Submit"></td>
</tr>
</table>
</form>
</body>
</html>
In the above example, when a user clicks the submit button, form data will be sent to "submit.php".
"Submit.php" file connects to a database, and PHP $ _POST variable receives the value from the form.
Then, mysqli_query() function executes INSERT INTO statement, and a new record will be added to the "contact" table.
submit.php Page:
<?php
// Database connection establishment
$con=mysqli_connect("example.com","alex","qwerty","db_name");
// Check connection
if (mysqli_connect_errno($con)) {
echo "MySQL database connection failed: " . mysqli_connect_error();
}
//CHECKING SUBMIT BUTTON PRESS or NOT.
if(isset($_POST["submitBtn"]) && $_POST["submitBtn"]!=""){
$name=$_POST["name"];
$email=$_POST["email"];
$message=$_POST["message"];
//INSERT QUERY
if(mysqli_query("INSERT INTO contact (name, email, message)
VALUES ($name,$email,$message)")){
echo "Record inserted successfully";
}}
?>