public function insertDocDetails($arr) { $authObj = new UserLoginDetails($this->db); $today = date("Y-m-d H:i:s"); $arrDoc = array("first_name" => isset($arr['f_name']) ? $arr['f_name'] : "", "last_name" => isset($arr['l_name']) ? $arr['l_name'] : "", "mobile" => isset($arr['mobile_num']) ? $arr['mobile_num'] : "", "email" => isset($arr['doc_email']) ? $arr['doc_email'] : "", "address" => isset($arr['address']) ? $arr['address'] : "", "pincode" => isset($arr['pincode']) ? $arr['pincode'] : 0, "location" => isset($arr['location']) ? $arr['location'] : "", "phone" => 0, "text_msg" => isset($arr['wel_msg']) ? $arr['wel_msg'] : "", "per_patient_amt" => isset($arr['per_patient_amt']) ? $arr['per_patient_amt'] : "50", "registration_date" => $today, "group_id" => "1"); $arrLogin = array("u_mobile" => isset($arr['mobile_num']) ? $arr['mobile_num'] : "", "u_name" => isset($arr['user_name']) ? $arr['user_name'] : "", "u_password" => isset($arr['u_pass']) ? $arr['u_pass'] : "", "group_id" => "1"); $authObj->insertUserLogInDetails($arrLogin); $insert = $this->db->query("INSERT INTO doc_details(first_name,last_name,mobile,email,address,pincode,location,phone,text_msg,per_patient_amt,registration_date,group_id) VALUES(:first_name,:last_name,:mobile,:email,:address,:pincode,:location,:phone,:text_msg,:per_patient_amt,:registration_date,:group_id)", $arrDoc); return $insert; }
public function insertUserDetails($input_arr) { $authObj = new UserLoginDetails($this->db); $arrLogin = array("u_mobile" => $input_arr['mobile_num'], "u_name" => isset($input_arr['user_name']) ? $input_arr['user_name'] : "", "u_password" => $input_arr['mobile_num'], "group_id" => "2"); $authObj->insertUserLogInDetails($arrLogin); $today = date("Y-m-d H:i:s"); $arr = array("salutation" => "Mr.", "first_name" => "", "last_name" => "", "mobile" => $input_arr['mobile_num'], "refer_by_doc" => $input_arr['docId'], "email" => "*****@*****.**", "address" => "", "pincode" => 0, "location" => "", "phone" => 0, "registration_date" => $today, "group_id" => "2"); $insert = $this->db->query("INSERT INTO user_details(salutation,first_name,last_name,mobile,refer_by_doc,email,address,pincode,location,phone,registration_date,group_id) VALUES(:salutation,:first_name,:last_name,:mobile,:refer_by_doc,:email,:address,:pincode,:location,:phone,:registration_date,:group_id)", $arr); return $insert; }
function AuthUser($inputArr) { try { global $db; //validate on server side //$u_mobile = $inputArr['mobile_num']; //$u_password = $inputArr['u_pass']; //print_r($inputArr); $authObj = new UserLoginDetails($db); $result = $authObj->validateUserDetails($inputArr); //print_r($result); if (is_array($result) && sizeof($result) > 0) { $arr = array('status' => $result[0]['group_id']); } else { $arr = array('status' => 0); } return $arr; } catch (Exception $e) { echo 'Caught exception: ', $e->getMessage(), "\n"; } }