Untitled

<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="UTF-8">
	<title>Document</title>
</head>
<body>
	<form name="add" action="add.php" method="post">
		<input type="text" name="fname"><br/>
		<input type="text" name="sname"><br/>
		<input type="text" name="email"><br/>
		<input type="text" name="cat"><br/>
		<input type="Submit" value="Add Record"/>
	</form>

</body>
</html>


<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "contactsDB";

$fname = $_POST['fname'];
$sname = $_POST['sname'];
$email = $_POST['email'];
$cat = $_POST['cat'];

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "Insert into contactsTbl(fname, sname, email, cat) values('$fname', '$sname', '$email', '$cat')";
echo $sql;
$result = $conn->query($sql);

$conn->close();
?>
<a href="all.php">All Records</a>
<a href="work.php">Work Records</a>
<a href="personal.php">Personal Records</a>
<a href="add.html">Add New</a>