$altPhoneNumber = $_POST['altPhoneNumber'];
$speciality = $_POST['speciality'];
$license = $_POST['licenseNumber'];
$address = $_POST['address'];
require_once __DIR__ . '/db_config.php';
$con = mysqli_connect(DB_SERVER, DB_USER, DB_PASSWORD, DB_DATABASE) or die("Error Connecting Database " . mysqli_connect_error($con));
//Check If email exists
$query = "SELECT * from User_Credntials WHERE Email='{$email}'";
$result = mysqli_query($con, $query);
if (!empty($result)) {
if (mysqli_num_rows($result) > 0) {
$response["isRegistered"] = 0;
$response["message"] = "Email already registered!";
echo json_encode($response);
} else {
$tempPwd = randomPasswordGenerator();
$insertQuery = "INSERT INTO User_Credntials(`User_Name`, `Email`, `Temp_Password`, `Password`, `do_change_password`,`Type`) VALUES ('{$name}','{$email}','{$tempPwd}', 'NULL', b'1',b'1')";
mysqli_query($con, $insertQuery) or die("Error in Query" . mysqli_error($con));
$userId = mysqli_insert_id($con);
$date = date_create();
date_timestamp_set($date, time());
$insertQueryForHospital = "INSERT INTO hospital(`user_id`, `hospital_name`, `hospital_license`, `phone_number`, `alternative_phonenumber`, `hospital_address`,`speciality`, `last_updatedon`,`last_update`) VALUES ('{$userId}','{$name}','{$license}','{$phoneNumber}','{$altPhoneNumber}','{$address}','{$speciality}','" . date_format($date, 'Y-m-d H:i:s') . "','admin')";
mysqli_query($con, $insertQueryForHospital) or die("Error in Query" . mysqli_error($con));
$to = $email;
$subject = "Blood Donor Finder!";
$message = "Thanks for registering with us! Please find below password to continue using the android app and keep donating the blood. \n\t\t\t\tPassWord :"******"\n\t\t\t\tPlease change your password on first logon!\n\t\t\t\t\n\n\n This is a system generated mail. Reply to this email are not answered!";
$header = "From:no-reply@blooddonor.com \r\n";
$retval = mail($to, $subject, $message, $header);
if (mysqli_insert_id($con) > 0 && $retval) {
$response["isRegistered"] = 1;
$response["message"] = "Registration Successful. Please Check you email for credentials!";
<?php
$response = array();
if (isset($_GET['email'])) {
$username = $_GET['email'];
$tempPassWord = randomPasswordGenerator();
$query = "Update User_Credntials Set Temp_Password='******',do_change_password=1 where Email='{$username}'";
require_once __DIR__ . '/db_config.php';
$con = mysqli_connect(DB_SERVER, DB_USER, DB_PASSWORD, DB_DATABASE) or die("Error Connecting Database " . mysqli_connect_error($con));
$result = mysqli_query($con, $query);
if (!empty($result)) {
if (mysqli_affected_rows($con) > 0) {
$to = $username;
$subject = "Password Reset";
$message = "Your password has been reset! Please find below password to continue using Vitality and keep donating the blood.\n\n \n\t\t\t\tPassWord :"******"\n\t\t\t\tPlease Change your password next login!\n\t\t\t\t\n\n\n This is a automated message. Replying to this email will not answered!";
$header = "From: no-reply@blooddonor.com \r\n";
$retval = mail($to, $subject, $message, $header);
if ($retval) {
$response["isEmailSent"] = 1;
$response["message"] = "Your password has been reset! Please check your email and change your password";
echo json_encode($response);
} else {
$response["isEmailSent"] = 0;
$response["message"] = "Error Resetting password! Contact Tech Support!";
echo json_encode($response);
}
} else {
$response["isEmailSent"] = 0;
$response["message"] = "Error Resetting password! Email Not Registered!";
echo json_encode($response);
}