<?php
$db_host = 'localhost'; // Server Name
$db_user = 'root'; // Username
$db_pass = ''; // Password
$db_name = 'contacts'; // Database Name

$conn = mysqli_connect($db_host, $db_user, $db_pass, $db_name);
if (!$conn) {
	die ('Failed to connect to MySQL: ' . mysqli_connect_error());
}

// Attempt insert query execution
$sql = "INSERT INTO contacts
	(Users_First_Name, Users_Second_Name, Users_Gender, Forename,
	Surname, Mobile, Home_Phone, EMail, Home_Address, Groupe)
	VALUES ('".mysql_escape_string($_POST['Users_First_Name']) ."',
			'".mysql_escape_string($_POST['Users_Second_Name']) ."',
			'".mysql_escape_string($_POST['Users_Gender']) ."',
			'".mysql_escape_string($_POST['Forename']) ."',
			'".mysql_escape_string($_POST['Surname']) ."',
			'".mysql_escape_string($_POST['Mobile']) ."',
			'".mysql_escape_string($_POST['Home_Phone']) ."',
			'".mysql_escape_string($_POST['EMail']) ."',
			'".mysql_escape_string($_POST['Home_Address']) ."',
			'".mysql_escape_string($_POST['Groupe']) ."')";


if(mysqli_query($conn, $sql)){
  echo "Records inserted successfully.";
	} else{
  echo "ERROR: Could not able to execute $sql. " . mysqli_error($conn);
}

if (!$query) {
	die ('SQL Error: ' . mysqli_error($conn));
}
?>