0 ) { echo "

WARNING!!! Possible duplicate entry. ".$fname." ".$lname." . Please check your entry and try again. Thank you!



"; }else { //$attendingphysician=$_POST['attendingphysician']; $sql="INSERT INTO `patient_list` (`patient_id`, `patient_fname`, `patient_mname`, `patient_lname`, `patient_bday`, `patient_age`, `patient_sex`, `patient_status`,`phic_number`,`assigned_doctor`,`patient_occupation`, `patient_taddress`, `patient_paddress`, `patient_mobile`,`patient_line`,`patient_ername`,`patient_eraddress`,`patient_ermobile`,`patient_erline`,`patient_datefirstdiagnose`,`patient_datefirstdialysis`,`patient_placedialysis`,`patient_pd`,`patient_pdreason`,`patient_renal`,`patient_como1`,`patient_como2`,`patient_como3`,`patient_como4`,`patient_como5`,`patient_como6`,`patient_dateencoded`,`patient_timeencoded`,`patient_encodedby`,`status`,`isActive`,`branch_code`,`phic_member`,`hepa_class`,`hepa_type`,`entry_type`,`dialyzer`,`tx_package`,`access`,`epo`,`tx_frequency`,`region`,`reg_city`,`patient_package_code`) VALUES('','$fname','$mname','$lname','$bday','$age','$sex','$status','$phicNumber','$doctor','$occupation','$taddress','$paddress','$mobile','$landline','$emergencycontat','$emergencyaddress','$emergencymobile','$emergencylandline','$datediagnosed','$datefirstdialysis','$placeofdialysis','$onPD','$HDReasons','$renaldiagnosis','$comordities1','$comordities2','$comordities3','$comordities4','$comordities5','$comordities6','$toDate','$currentTime','$logged_user','Out','1','$comCode','$tmember','$hpActive','$hpType','$referral','$myDialyzerCode','$myPackageCode','$access','$myEpoCode','$frequency','$region','$regCity','$packageID')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); }else{ echo "

New Record has been added successfully. Thank you!



"; } } } $checkAccess = $user_data['add_new_patient']; if($checkAccess == '0'){ secalert(); }else{ ?>
"; echo ""; echo ""; }else{ ?>
"; $q=mysql_query("SELECT * FROM `patient_list` WHERE `isActive`='1' AND `branch_code`='$comCode' AND `patient_lname` LIKE '%$searchtext%'"); $row=mysql_fetch_array($q); $total=mysql_num_rows($q); $dis=10; $total_page=ceil($total/$dis); $page_cur=(isset($_GET['page']))?$_GET['page']:1; $k=($page_cur-1)*$dis; $page_cur = mysql_real_escape_string($page_cur); $qq=mysql_query("SELECT * FROM `patient_list` WHERE `isActive`='1' AND `branch_code`='$comCode' AND `patient_lname` LIKE '%$searchtext%' ORDER by `patient_lname` ASC"); echo ""; echo ""; while($row = mysql_fetch_array($qq)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo ""; echo "
Record I.D First Name Last Name Assigned Doctor Referral Gender Address Date Registered - -
" . $row['patient_id'] . "" . $row['patient_fname'] . "" . $row['patient_lname'] . ""; $docID = $row['assigned_doctor']; $docFname = mysql_result(mysql_query("SELECT `doc_fname` FROM `doctors_profile` WHERE `doc_id`='$docID'"),0); $docLname = mysql_result(mysql_query("SELECT `doc_lname` FROM `doctors_profile` WHERE `doc_id`='$docID'"),0); echo $docFname ." ".$docLname; echo "" . $row['entry_type'] . "" . $row['patient_sex'] . "" . $row['patient_taddress'] . "" . $row['patient_dateencoded'] . "UpdateExpired
"; echo "
Patient's Information:
Last Name:
 First Name:
 Middle Name:
 Age:
 Sex:
 Status:
Occupation:
 Landline Number:
 Mobile Number:
 Birthdate:            Access:                   Frequency:
Present Address:
 PhilHealth Number:
 PhilHealth Member:
Permanent Address
 Referral:
 Assigned Doctor:

Nearest Relative (to notify in case of emergency):
Contact Person: (Full Name)
 Contact Number:
Complete Address:
 Mobile Number:

Date first diagnosed with kidney disease (mm-dd-yyyy)
Date of first dialysis (mm-dd-yyyy)
Place where first dialysis done		 Hepatitis (HP) Hepatitis (Type)
Date Diagnosed:
 Date of First Dialysis:
 Place Diagnosed:
 Hepatitis Info:
 Hepatitis Type:

Previously on PD?
If yes, what was the reason for shifting to HD?
Renal Diagnoses:
Dialyzer: EPO: Package:

Co-morbidities:
1. 2.
3. 4.
5. 6.