format("Y/m/d");
$tTime =Explode(":", date('H:i:s'));
$svtTime = $tTime[0].":".$tTime[1].":".$tTime[1];
if(isset($_POST['done'])){
$svSector = mysql_escape_string($_POST['svSector']);
$svMname = mysql_escape_string($_POST['svMname']);
$svSalesAgent = mysql_escape_string($_POST['svSalesAgent']);
$svTweeter = mysql_escape_string($_POST['svTweeter']);
$svInstaGram = mysql_escape_string($_POST['svInstaGram']);
$svBrgy = mysql_escape_string($_POST['svBrgy']);
$svRegion = mysql_escape_string($_POST['svRegion']);
$svCompany = mysql_escape_string($_POST['svCompany']);
$svViber = mysql_escape_string($_POST['svViber']);
$svFB = mysql_escape_string($_POST['svFB']);
$svsMobile = mysql_escape_string($_POST['svsMobile']);
$svEmail = mysql_escape_string($_POST['svEmail']);
$svMunicipality = mysql_escape_string($_POST['svMunicipality']);
$svHomeAddress = mysql_escape_string($_POST['svHomeAddress']);
$svCity = mysql_escape_string($_POST['svCity']);
$svBday = mysql_escape_string($_POST['svBday']);
$svGender = mysql_escape_string($_POST['svGender']);
$svLname = mysql_escape_string($_POST['svLname']);
$svFname = mysql_escape_string($_POST['svFname']);
$sCompID = mysql_escape_string($_POST['sCompID']);
$sDealID = mysql_escape_string($_POST['sDealID']);
$svWebsiteLink = mysql_escape_string($_POST['svWebsiteLink']);
$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 $svDate. "Today
";
echo $myAge. "Age
";
echo $svtTime. "Time
";
echo $svTrimDate. "bday
";
//insert
mysql_query("INSERT INTO vts_customers (cust_fname, cust_lname, cust_bday,cust_gender, cust_mobile,cust_email, cust_home_add, cust_city, cust_municipality, cust_fb, cust_viber, cust_comp_id, cust_deal_id, cust_date_added, cust_time_added, cust_add_by, age, cust_business_id,cust_region, brgy_name,cust_middle_name,website_link,sector_id, data_assigned_to)
VALUES('{$svFname}','{$svLname}','{$svTrimDate}','{$svGender}','{$svsMobile}','{$svEmail}','{$svHomeAddress}','{$svCity}','{$svMunicipality}','{$svFB}','{$svViber}','{$sCompID}','{$sDealID}','{$svDate}','{$svtTime}','{$svUserID}','{$myAge}','{$svCompany}','{$svRegion}', '{$svBrgy}','{$svMname}','{$svWebsiteLink}','{$svSector}','{$svSalesAgent}')");
exit();
}
//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 "
";
}
?>