Inserting-data-using-php/mysql

Inserting data into database using php/MySql

In last tutorial we have seen about how to make database connection using php. now in this tutorial we are going to discuss about how to insert user input fields into database using php/mysql.
In this tutorial three values are inserted into database these are,
UserName, Password and Email.
here i used insert query for inserting data into database.
the table name as Registration. the below link shows How to create database and tables in php
The mysqli_real_escape_string is used to avoid special characters in a string for providing security.
include ("connection.php"); function which is used to call database connection.

Previous           Next

Insert.php

---

<?php
/* Database connection */
$link = mysqli_connect("localhost", "demo1", "demo123", "demo");
// Check connection
if($link === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
}
// Escape user inputs for security
$user_name = mysqli_real_escape_string($link, $_POST['User_Name']);
$password = mysqli_real_escape_string($link, $_POST['Password']);
$email = mysqli_real_escape_string($link, $_POST['Email']);
// attempt insert query execution
$sql = "INSERT INTO Registration (User_Name, Password, Email) VALUES ('$user_name', '$password', '$email')";
if(mysqli_query($link, $sql)){
echo "Registration successfully.";
} else{
echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
// close connection
mysqli_close($link);
?>