File manager - Edit - /home/autoph/public_html/weCare/Covid19/ContactTracing/Autohub/ahg_saveContactTracingForm_employee.php
Back
<?php include 'core/init.php'; date_default_timezone_set('Asia/Singapore'); $toDate = date_create() ->format("m/d/Y"); $myCurTime=$currentTime; //if submit/ save to databasevar if(isset($_POST['done'])){ $myLoc = mysql_escape_string($_POST['myLoc']); $closeContact ="NA";//mysql_escape_string($_POST['closeContact']); $liveSameHome ="NA";//mysql_escape_string($_POST['liveSameHome']); $lastDateOfContact ="NA"; mysql_escape_string($_POST['lastDateOfContact']); $travel ="NA"; mysql_escape_string($_POST['travel']); $travelLocation ="NA"; mysql_escape_string($_POST['travelLocation']); $travelDate ="NA"; mysql_escape_string($_POST['travelDate']); $symptoms = mysql_escape_string($_POST['symptoms']); $symptomsDate = mysql_escape_string($_POST['symptomsDate']); $visitedPlaces = "NA";mysql_escape_string($_POST['visitedPlaces']); $visitedOtherPlaces = "NA";mysql_escape_string($_POST['visitedOtherPlaces']); $Activities ="NA"; mysql_escape_string($_POST['Activities']); $hospitalPurpose = "NA";mysql_escape_string($_POST['hospitalPurpose']); $highRiskActivity = "NA";mysql_escape_string($_POST['highRiskActivity']); $hospital ="NA";mysql_escape_string($_POST['hospital']); $noLiveInsideYes ="NA"; mysql_escape_string($_POST['noLiveInsideYes']); $brgy = "NA";mysql_escape_string($_POST['brgy']); $town = "NA";mysql_escape_string($_POST['town']); $province ="NA"; mysql_escape_string($_POST['province']); $city ="NA"; mysql_escape_string($_POST['distance']); $distance = "NA";mysql_escape_string($_POST['city']); $dealership = "NA";mysql_escape_string($_POST['dealership']); $empLastName = mysql_escape_string($_POST['empLastName']); $empFirstName = mysql_escape_string($_POST['empFirstName']); $empPosition = "NA";mysql_escape_string($_POST['empPosition']); $empDept = mysql_escape_string($_POST['empDept']); $workSched = "NA";mysql_escape_string($_POST['workSched']); $myTemp = mysql_escape_string($_POST['myTemp']); //$toDate = mysql_escape_string($_POST['toDate']); mysql_query("INSERT INTO ahg_employees (closeContact, liveSameHome, lastDateOfContact, travel, travelLocation, travelDate, symptoms, symptomsDate, visitedPlaces, otherPlaces, Activities, otherACtivities, hospital, noLiveInsideYes, brgy, town, province, city, distance, dealership, empLastName, empFirstName, empPosition, empDept, workSched, myTemp, toDate, vLocation, hospitalPurpose) VALUES('{$closeContact}','{$liveSameHome}','{$lastDateOfContact}','{$travel}','{$travelLocation}','{$travelDate}','{$symptoms}','{$symptomsDate}','{$visitedPlaces}','{$visitedOtherPlaces}','{$ACtivities}','{$highRiskActivity}','{$hospital}','{$noLiveInsideYes}','{$brgy}','{$town}','{$province}','{$city}','{$distance}','{$dealership}','{$empLastName}','{$empFirstName}','{$empPosition}','{$empDept}','{$workSched}','{$myTemp}','{$toDate}','{$myLoc}','{$hospitalPurpose}')"); exit(); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings