<?php /*note: When a doctor get referred it needs to get inserted in doctor stub table with a doctorSerialID and 'temp' in Doctor_unregistered table when doctor registering before checking hospital doctor, check whther this mobile number present in hospital_refer_in_doctor_stub if present update entry then update doc id hospital_refer_in_doc_stub where mobile number and also update doctor_unregistered as fals in doctor stub table, and then go for hospital_refer_out_doc_stub end of note */ session_start(); if (!isset($_SESSION['hospital_id_SESSION'])) { header("Location: hospital_login.php"); die; } include 'db_conn.php'; include 'Email_sender.php'; //include 'logger.php'; //$logger=new Logger(); $email_sender = new EMAIL_SENDER(); $hospital_name = ""; $hospital_id = $_POST['hospital_id']; $mobile = $_POST['mobile']; $name = $_POST['name']; $email = $_POST['email']; $doctor_title = $_POST['doctor_title']; $link = "https://play.google.com/store/apps/details?id=com.hospitalcheck.referralio&hl=en"; //$logger->write("INFO :","before count result_query_referin".$count_queryin); //query to check if already referredin $query_get_referin = "select * from hospital_refer_in_doctor_stub where refer_by_hos_id='{$hospital_id}' and refer_in_doc_mobile='{$mobile}'"; $result_query_referin = mysql_query($query_get_referin); $count_queryin = mysql_num_rows($result_query_referin); if ($count_queryin > 0) {
<?php session_start(); if (!isset($_SESSION['hospital_id_SESSION'])) { header("Location: hospital_login.php"); die; } $hospital_id = $_SESSION['hospital_id_SESSION']; $hospital_name = $_SESSION['hospital_name_SESSION']; include 'db_conn.php'; include 'logger.php'; include 'GCM.php'; include 'Email_sender.php'; $logger = new Logger(); $gcm = new GCM(); $email_sender = new EMAIL_SENDER(); $logger->write("INFO :", "PHP Scritp Name =>" . $_SERVER['REQUEST_URI']); $logger->write("INFO :", "Type of Request =>" . $_SERVER['REQUEST_METHOD']); $doctor_name = ""; $doc_mob_number = ""; $doc_email = ""; $doc_title = ""; $doc_ref_id_name = ""; $doc_ref_mobile_number = ""; $doc_ref_email = ""; $doc_ref_title = ""; $gcm_id = ""; $logger->write("INFO :", "before post"); $pat_name = $_POST['pat_name']; $pat_mobile = $_POST['pat_mobile']; $pat_age = $_POST['pat_age'];
<?php session_start(); if (!isset($_SESSION['hospital_id_SESSION'])) { header("Location: hospital_login.php"); die; } $hospital_id = $_SESSION['hospital_id_SESSION']; $hospital_name = $_SESSION['hospital_name_SESSION']; include 'db_conn.php'; include 'Email_sender.php'; include 'logger.php'; include 'GCM.php'; $logger = new Logger(); $gcm = new GCM(); $email_sender = new EMAIL_SENDER(); $logger->write("INFO :", "PHP Scritp Name =>" . $_SERVER['REQUEST_URI']); $logger->write("INFO :", "Type of Request =>" . $_SERVER['REQUEST_METHOD']); $logger->write("INFO :", "before post"); $pat_id = $_POST['pat_id']; $status = $_POST['status']; $logger->write("INFO :", "received post"); /*for sending SMS to refering doctor regarding the patient */ $query_pat_referring = "select tmp.*,sd.Doctor_mobile_number as Ref_mob_number,sd.Doctor_Title as Ref_Title,sd.Doctor_name as Ref_name,sd.Doctor_email as Ref_email from doctor_stub sd inner join (SELECT ps.patient_thread_id,ps.Patient_Name ,ps.reg_by_doc,ps.doc_ref_id,ds.Doctor_Title as Reg_Title,ds.Doctor_name as Reg_name,ds.Doctor_mobile_number as Reg_mobnumber,ds.Doctor_email as Reg_email FROM `patient_stub` ps inner join doctor_stub ds on ps.reg_by_doc=ds.Doctor_serial_id where ps.patient_thread_id= '{$pat_id}')as tmp on tmp.doc_ref_id=sd.Doctor_serial_id"; $logger->write("INFO for query:", $query_pat_referring); $res_pat_referring = mysql_query($query_pat_referring); $row_pat_referring = mysql_fetch_assoc($res_pat_referring); $reg_mob_number = $row_pat_referring['Reg_mobnumber']; $reg_title = $row_pat_referring['Reg_Title']; $reg_name = $row_pat_referring['Reg_name']; $reg_email = $row_pat_referring['Reg_email'];
<?php session_start(); if (!isset($_SESSION['hospital_id_SESSION'])) { header("Location: hospital_login.php"); die; } $hospital_id = $_SESSION['hospital_id_SESSION']; $hospital_name = $_SESSION['hospital_name_SESSION']; include 'db_conn.php'; include 'logger.php'; include 'Email_sender.php'; $logger = new Logger(); $email_sender = new EMAIL_SENDER(); $logger->write("INFO :", "PHP Scritp Name =>" . $_SERVER['REQUEST_URI']); $logger->write("INFO :", "Type of Request =>" . $_SERVER['REQUEST_METHOD']); $img_path = "/profile_doc_images/"; $Doctor_name = mysql_real_escape_string($_POST['Doctor_name']); $Doctor_dob = $_POST['Doctor_dob']; $Doctor_email = mysql_real_escape_string($_POST['Doctor_email']); $Doctor_specialization = mysql_real_escape_string($_POST['Doctor_specialization']); $Doctor_qualification = mysql_real_escape_string($_POST['Doctor_qualification']); $Doctor_HospitalName = mysql_real_escape_string($_POST['Doctor_HospitalName']); $Doctor_mobile_number = $_POST['Doctor_mobile_number']; $Doctor_password = mysql_real_escape_string($_POST['Doctor_password']); $Doctor_photograph = $_POST['Doctor_photograph']; $Doctor_yxp = mysql_real_escape_string($_POST['Doctor_yxp']); $Doctor_Country = mysql_real_escape_string($_POST['Doctor_Country']); $Doctor_State = mysql_real_escape_string($_POST['Doctor_State']); $Doctor_City = mysql_real_escape_string($_POST['Doctor_City']); $Doctor_Address = mysql_real_escape_string($_POST['Doctor_Address']);