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.

index.html

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>
</form>

connect-db.php

Connect to database

<?php
$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";

mysqli_close($conn);  

?>

insert-data.php

Example to Insert Record in Database using PHP

<?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);
if($result)
{
header("Location: add-record-successfully");
}
else {
echo mysql_error();
}

$connection->close();
?>

Prev Tutorial Next Tutorial

Yahoo Advertisements

Buy 3 Year Old Domain, Tutorialday.com, SeosmoTools.com @$200

Buy This Ad Space @$50 per Month, Ad Size 600X200 Contact on: hitesh.xc@gmail.com

Download Projects

Adsense Advertisements
Free Classified Site – Bedpage

Yahoo Ads Advertisements