connect_error == true ) {
die("Connection failed: " . $conn->connect_error);
print_r("Connection was NOT successful \n");
}else {
print_r("******Connection was Successful******** \n");
}
$INSERT = "INSERT INTO tbl_client(str_fname, str_lname, str_idNum, str_dob, str_gender, str_type, str_status )values (?, ?, ?, ?, ?, ?, ?)";
$stmt=$conn->prepare($INSERT);
$stmt->bind_param("sssssss" , $str_fname, $str_lname, $str_idNum, $str_dob, $str_gender, $str_type, $str_status);// 2 strings and 1 interger
$stmt->execute();
echo " New record(s) inserted successfully
";
echo "S.A Identity Number : $str_idNum";
echo "
Client Account Type : $str_type";
echo "
Is Account Active ? : $str_status";
echo "
First Name : $str_fname";
echo "
Last Name : $str_lname";
echo "
Date Of Birth : $str_dob";
echo "
Gender : $str_gender";
}
header("refresh:5;url=formClient.html");
$stmt->close();
$conn->close();
?>