session_start();
$conn = mysqli_connect("localhost", "ODBC", "", "spynews_db");
if(mysqli_connect_errno()){
echo "Unable to connect" .mysqli_connect_error();
exit();
}else{
if(isset($_POST["submit"])){
//echo $_POST["submit"];
$password = "";
$charset = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789";
for($i = 0; $i < 8; $i++){
$random_int = mt_rand();
$password .= $charset[$random_int % strlen($charset)];
}
//echo $password, "\n";
$sql = 'INSERT INTO users VALUES (?,?,?,?,?,?)';
$stmt = mysqli_stmt_init($conn);
if(mysqli_stmt_prepare($stmt,$sql)){
mysqli_stmt_bind_param($stmt,'ssssss',$user_email,$user_name,$user_surname,$user_date_of_birth,$user_gender,$password);
$user_name =$_POST["name"];
$user_surname =$_POST["surname"];
$user_gender =$_POST["gender"];
$user_date_of_birth =$_POST["dateofbirth"];
$user_email =$_POST["email"];
$to = $_POST["email"];
$from = "From:[email protected]";
if(!isset($_POST["email"]) || $_POST["email"] == null){
echo "Please enter a valid email address";
}else{
$result = mail($to, $_POST['name'],
$password,$from);
if(!$result){
echo "Error sending message";
}else{
echo "message sent";
}
}
mysqli_stmt_execute($stmt);
$stmt->close();
echo"User Registered";
$conn->close();
}else{
echo "Failed to Register";
}
}
}
?>
| Name: | |
| Surname: | |
| Gender: | Male Female |
| D.O.B: | |
| Email: | |
Dipankar BiswasPosted Aug 9, 2016, 6:45 AM