<?php

if (isset ($_POST['submit'])) {
$dbservername = "localhost";
$dbusername = "root";
$dbpassword = "";
$dbname = "test_db";

$name = ($_POST['name']);
$gender = ($_POST['gender']);
$username = ($_POST['username']);
$email = ($_POST['email']);
$password = ($_POST['password']);


$conn = mysqli_connect($dbservername, $dbusername, $dbpassword, $dbname);
$query = "INSERT INTO `users` (`name`, `gender`, `username`, `email`, `password`) VALUES ('$name', '$gender', '$username, '$email', '$password')";

$result = mysqli_query($conn, $query);

if($result)
{
echo 'Data Inserted';
}else{
echo 'Data Not Inserted';
}
mysqli_free_result($result);
mysqli_close($conn);
}
?>