/** * Storing new user * returns user details */ public function storePatient($name, $email, $password, $address, $telephone) { require_once 'DB_Functions.php'; $dbFunctions = new DB_Functions(); $resultP = mysqli_query($this->mysqli, "INSERT INTO per_all_people_f(name, email, person_type, telephone ) VALUES('{$name}', '{$email}', 'P' , '{$telephone}');"); // check for successful store if ($resultP) { // get user details $personId = mysqli_insert_id($this->mysqli); // last inserted id $uuid = uniqid('', true); $hash = $dbFunctions->hashSSHA($password); $encrypted_password = $hash["encrypted"]; // encrypted password $salt = $hash["salt"]; // salt $resultU = mysqli_query($this->mysqli, "INSERT INTO users(unique_id, name, email, person_id, encrypted_password, salt, created_at) VALUES('{$uuid}', '{$name}', '{$email}', '{$personId}', '{$encrypted_password}', '{$salt}', NOW())"); $resultPatient = mysqli_query($this->mysqli, "INSERT INTO patient(person_id) VALUES('{$personId}')"); $patientId = mysqli_insert_id($this->mysqli); // last inserted id $patientIdUpdate = mysqli_query($this->mysqli, "update per_all_people_f set patient_id = {$patientId} where person_id = {$personId}"); $resultAddress = mysqli_query($this->mysqli, "INSERT INTO address(house_no,person_id) VALUES('{$address}','{$personId}')"); $result = mysqli_query($this->mysqli, "SELECT * FROM per_all_people_f WHERE person_id = {$personId}"); if ($resultU && $resultPatient && $resultAddress && $patientIdUpdate) { return mysqli_fetch_array($result); } else { return FALSE; } } else { return false; } }
$response["error"] = 2; $response["error_msg"] = "User does not exist"; echo json_encode($response); } } else { if ($tag == "sync_db") { $uid = $_POST['uid']; $points = $db->getPointsByUid($uid); $response["success"] = 1; $response["points"] = $points; echo json_encode($response); } else { if ($tag == 'chgpass') { $email = $_POST['email']; $newpassword = $_POST['newpas']; $hash = $db->hashSSHA($newpassword); $encrypted_password = $hash["encrypted"]; // encrypted password $salt = $hash["salt"]; $subject = "Change Password Notification"; $message = "Hello Piggy Rewards Customer,\n\nYour Password has been sucessfully changed.\n\nRegards,\\Piggy Rewards Team."; $from = "*****@*****.**"; $headers = "From: svetvaz@gmail.com"; if ($db->isUserExisted($email)) { $user = $db->forgotPassword($email, $encrypted_password, $salt); if ($user) { $response["success"] = 1; mail($email, $subject, $message, $headers); echo json_encode($response); } else { $response["error"] = 1;