Insert Record in Database using PHP

Prev Tutorial Next Tutorial

How to Insert Record in Database using PHP

For insert data in database using PHP first we create Html form page and get data from user, now connect database and run insert command.


Html page

<form action="insert-data.php" method="post" id="nameform">
First Name: <input type="text" name="fname"></br>
Last Name: <input type="text" name="lname"></br>
<button type="submit" form="nameform" value="submit">Submit</button>
<button type="reset" value="Reset">Reset</button>


Connect to database

$servername = "localhost";
$username = "username";
$password = "password";

// Create connection
$conn = mysqli_connect($servername, $username, $password);

// Check connection
if (!$conn)
  die("Connection failed: " . mysqli_connect_error());
echo "Connected successfully";




Example to Insert Record in Database using PHP

include 'db-connect.php';

$f_name = $_POST["fname"];
$l_name = $_POST["fname"];

$sql = "insert into user(f_name, l_name)
      VALUES('$f_name', '$l_name'";

$result = mysql_query($sql);
header("Location: add-record-successfully");
else {
echo mysql_error();


Prev Tutorial Next Tutorial

Yahoo Advertisements

Buy 3 Year Old Domain,, @$200

Buy This Ad Space @$50 per Month, Ad Size 600X200 Contact on:

Download Projects

Adsense Advertisements
Free Classified Site – Bedpage

Yahoo Ads Advertisements