Insert Record in Database using PHP

Google Advertisements

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

Download Projects

Adsense Advertisements
Free Classified Site – Bedpage

Yahoo Ads Advertisements