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"); $inTime = date('H:i:s'); $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){ $prosStatus= addslashes($_REQUEST['pros_status']); $userID= addslashes($_REQUEST['userID']); $sFname = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$userID'"),0); $sLname = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$userID'"),0); $senderFName = $sFname . " ". $sLname; $regNotes= addslashes($_REQUEST['Notes']); $prospectID= addslashes($_REQUEST['prospectID']); $prFName = mysql_result(mysql_query("SELECT `fullname` FROM `asa_InHouseLeads` WHERE `id`='$prospectID'"),0); $sql = "INSERT INTO asa_InHouseLeadsUpdates (id,prospect_id, sender_id, notes, date,time,prospect_fullname,sender_fullname,pros_status) VALUES('','$prospectID','$userID','$regNotes','$toDate','$inTime','$prFName','$senderFName','$prosStatus')"; $sqlQuery = mysql_query($sql, $conn) or die("Couldn't perform query $sql (".__LINE__."): " . mysql_error() . '.'); if($prosStatus == 'Closed'){ mysql_query("UPDATE `asa_InHouseLeads` SET `pros_status`='$prosStatus',`status`='1' WHERE `id`='$prospectID'"); }else{ mysql_query("UPDATE `asa_InHouseLeads` SET `pros_status`='$prosStatus',`status`='0' WHERE `id`='$prospectID'"); } $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