File manager - Edit - /home/autoph/public_html/connect/home/ML_GetDetails.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(). '.'); $chkList = $_REQUEST['chkList']; // Expects select = * or select = RegID $did_something = 0; if($chkList==1) { $MyCustomerID = addslashes($_REQUEST['MyCustomerID']); $customerType = addslashes($_REQUEST['customerType']); $custInfo_arr =array(); $sql = "SELECT * FROM vts_customers WHERE c_id= '$MyCustomerID'"; $sqlResult = mysql_query($sql, $conn) or die("Couldn't perform query $sql (".__LINE__."): " . mysql_error() . '.'); if(mysql_num_rows($sqlResult) == 1) { $sqlRecord['status'] = $status; $sqlRecord['statusCode'] = 'Success'; $json = json_encode([$sqlRecord]); } $did_something += 1; } else { $sqlRecord['status'] = 'Error'; $sqlRecord['statusCode'] = $MyCustID; $sqlRecord['custType'] = $customerType; $json = json_encode([$sqlRecord]); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings