format("Y/m/d");
$tTime =Explode(":", date('H:i:s'));
$svtTime = $tTime[0].":".$tTime[1].":".$tTime[1];
if(isset($_POST['done'])){
$svEditSector = mysql_escape_string($_POST['svEditSector']);
$svEditBusinessName = mysql_escape_string($_POST['svEditBusinessName']);
$svEditRegion = mysql_escape_string($_POST['svEditRegion']);
$svEditMunicipality = mysql_escape_string($_POST['svEditMunicipality']);
$svEditCity = mysql_escape_string($_POST['svEditCity']);
$svEditBrgy = mysql_escape_string($_POST['svEditBrgy']);
$loadCustData = mysql_escape_string($_POST['loadCustData']);
$loadCDFName = mysql_escape_string($_POST['loadCDFName']);
$loadCDLName = mysql_escape_string($_POST['loadCDLName']);
$loadCDMName = mysql_escape_string($_POST['loadCDMName']);
$loadCDGender = mysql_escape_string($_POST['loadCDGender']);
$loadCDBirthDate = mysql_escape_string($_POST['loadCDBirthDate']);
$loadCDMobile = mysql_escape_string($_POST['loadCDMobile']);
$loadCDEmail = mysql_escape_string($_POST['loadCDEmail']);
$loadCDHomeAddress = mysql_escape_string($_POST['loadCDHomeAddress']);
$loadCDFBAccnt = mysql_escape_string($_POST['loadCDFBAccnt']);
$loadCDTWAccnt = mysql_escape_string($_POST['loadCDTWAccnt']);
$loadCDIGAccnt = mysql_escape_string($_POST['loadCDIGAccnt']);
//$sDealID = mysql_escape_string($_POST['sDealID']);
//$svDate = $tDate;
//$svTrimDate = date_format(date_create_from_format('Y-m-d', $svBday), 'Y/m/d');
//$svTime = $tTime;
//$svUserID = mysql_escape_string($_POST['svUserID']);
// $myAge = date_diff(date_create($svTrimDate), date_create('now'))->y;
echo "Set ID". $loadCustData. "Today
";
//echo $myAge. "Age
";
//echo $svtTime. "Time
";
//echo $svTrimDate. "bday
";
//insert
$getCompID = mysql_result(mysql_query("SELECT `bid` FROM `businesses_names` WHERE `business_name` LIKE '%$svEditBusinessName%'"),0);
//$getSecID = mysql_result(mysql_query("SELECT `sid` FROM `db_sectors` WHERE `sectors_name` LIKE '%$svEditSector%'"),0);
mysql_query("UPDATE `vts_customers` SET `cust_business_id`='$svEditBusinessName',`sector_id`='$svEditSector',`cust_region`='$svEditRegion',`cust_municipality`='$svEditMunicipality',`cust_city`='$svEditCity',`brgy_name`='$svEditBrgy', `cust_middle_name`='{$loadCDMName}', `cust_fname`='{$loadCDFName}',`cust_lname`='{$loadCDLName}',`cust_bday`='{$loadCDBirthDate}',`cust_gender`='{$loadCDGender}',`cust_mobile`='{$loadCDMobile}',`cust_email`='{$loadCDEmail}',`cust_home_add`='{$loadCDHomeAddress}',`cust_fb`='{$loadCDFBAccnt}',`cust_tweet`='{$loadCDTWAccnt}',`cust_InstaG`='{$loadCDIGAccnt}' WHERE `c_id`='{$loadCustData}'");
}
//display from database
if(isset($_POST['display'])){
$svLname = mysql_escape_string($_POST['svLname']);
$svFname = mysql_escape_string($_POST['svFname']);
echo "";
echo $svFname." ". $svLname. " has been added to your database.";
echo "
";
}
?>