Insert Record in Database using PHP

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

<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

<?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

<?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();
?>