File manager - Edit - /home/autoph/public_html/connect/home/sub_add_new_customer.php
Back
<?php include 'core/database/connect.php'; //$connect_error = 'Sorry, we\'re experiencing connection problem. Please try again later... Thank you!'; //mysql_connect('localhost','root','aee1024') or die ($connect_error); //mysql_select_db('db_vts') or die($connect_error); //error_reporting(1); $tDate = date_create() ->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<br>"; echo $myAge. "Age<br>"; echo $svtTime. "Time<br>"; echo $svTrimDate. "bday<br>"; //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 "<p style='background:yellow;float:left;width:60%;border:1px solid #f9df04;padding:10px;font-family:San-Serif;font-size:14px;color:blue;margin:0px;top:0px'>"; echo $svFname." ". $svLname. " has been added to your database."; echo "</p>"; } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings