File manager - Edit - /home/autoph/public_html/connect/InhouseLeadsMyReferrals.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(). '.'); $APIkey = $_REQUEST['APIkey']; //====================================================================== //========================================================= if($APIkey == 10241024102410241024102410241024001){ $userID= addslashes($_REQUEST['userID']); $return_arr = Array(); $sql = "SELECT * FROM `asa_InHouseLeads` WHERE `ower_id`= '$userID' AND `deleted`=0 ORDER BY `LName` ASC"; $sqlTable = mysql_query($sql, $conn); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { $return_arr[]=$sqlRecord; $count = $count + 1; } if($count ==0){ $CounterNotes = "There is no active prospect found."; }else{ if($count > 1){ $CounterNotes = $count." Records found."; }else{ $CounterNotes = $count." Record found."; } } $json = json_encode([$return_arr,"CounterNotes" => "$CounterNotes"]); echo $json; } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings