File manager - Edit - /home/autoph/public_html/connect\inhouseAddNotes.php
Back
<?php date_default_timezone_set('Asia/Manila'); header('Content-Type: application/json'); $sqlUser = 'autoph_arnel'; $sqlDatabase = 'autoph_connect'; $sqlPass = 'Hke@2001'; $toDate = date_create() ->format("Y-m-d"); $conn = mysql_connect($sqlHost, $sqlUser, $sqlPass) or die ("Couldn't connct to MySQL server on $sqlHost: ". mysql_error(). '.'); $db = mysql_select_db($sqlDatabase, $conn) or die ("Couldn't select database $sqlDatabase: ". mysql_error(). '.'); $uReg = $_REQUEST['APIkey']; //====================================================================== //========================================================= if($uReg == 10241024102410241024102410241024){ $regiID= addslashes($_REQUEST['regEmpID']); $regFName= addslashes($_REQUEST['FName']); $regLName= addslashes($_REQUEST['LName']); $fullName =$regFName . " ".$regLName; $regMobile= addslashes($_REQUEST['Mobile']); $regEmail= addslashes($_REQUEST['Email']); $regNotes= addslashes($_REQUEST['Notes']); $oFName= mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$regiID'"),0); $oLName= mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$regiID'"),0); $oFLName = $oLName . " ". $oFName; $chkIfMobileExist = mysql_result(mysql_query("SELECT COUNT(1) FROM `asa_InHouseLeads` WHERE `Mobile`='$regMobile'"),0); if($chkIfMobileExist > 0){ $tranStatus ='Record Already Exist.'; $buttonSave ='True'; $buttonAdd ='False'; }else{ $sql = "INSERT INTO asa_InHouseLeads (id,FName, LName, Mobile, Email,notes, ower_id,fullname,date_in,owner_fullname) VALUES('', '$regFName','$regLName','$regMobile','$regEmail','$regNotes','$regiID','$fullName','$toDate','$oFLName')"; $sqlQuery = mysql_query($sql, $conn) or die("Couldn't perform query $sql (".__LINE__."): " . mysql_error() . '.'); $tranStatus ='Record saved'; $buttonSave ='False'; $buttonAdd ='True'; } $json = json_encode(['Status'=>$tranStatus,'Save'=>$buttonSave,'AddNew'=>$buttonAdd,'visible'=>'True']); echo $json; } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings