File manager - Edit - /home/autoph/public_html/connect/ML_getCustomerProspectUpdate.php
Back
<?php date_default_timezone_set('Asia/Manila'); header('Content-Type: application/json'); //API.GEONAMES.ORG FOR THE API GEOLOCATION SERVICE // /mysql_connect('localhost','autoph_portal','mis1541ng') or die ($connect_error); $sqlUser = 'autoph_arnel'; $sqlDatabase = 'autoph_connect'; $sqlPass = 'Hke@2001'; $registrations_table = 'vts_users'; $checkins_table = 'login_history'; $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(). '.'); $update= addslashes($_REQUEST['update']); if($update == 1) { $MyCustID = addslashes($_REQUEST['MyCustID']); $MyCustType = addslashes($_REQUEST['MyCustType']); $myProspectID = addslashes($_REQUEST['myProspectID']); $return_arr = Array(); if($MyCustType==='No'){ $sql = "SELECT * FROM vts_customers WHERE c_id = $MyCustomerID ORDER BY u_lname ASC LIMIT 1"; }else{ $sql = "SELECT * FROM businesses_names WHERE bid = $MyCustomerID ORDER BY business_name ASC LIMIT 1"; } $sqlTable = mysql_query($sql, $conn); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { $return_arr[]=$sqlRecord; } $json = json_encode($return_arr); $did_something += 1; } if($did_something === 0) { $msg = did_nothing_message; $json = json_encode(["status" => "$MyCustomerID", "statusCode" => "$customerType"]); } echo $json; ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings