File manager - Edit - /home/autoph/public_html/connect/LoadUserInfo.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']; // Expect LoginName, LoginPassword //========================================================= if($ApiKey == 10241977091101){ $userID= $_REQUEST['user_id']; // Expect LoginName, LoginPassword* $uFname = strtoupper(mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$userID'"),0)); $uLname = strtoupper(mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$userID'"),0)); $uPosition = mysql_result(mysql_query("SELECT `u_position` FROM `vts_users` WHERE `u_id`='$userID'"),0); $uMobile = mysql_result(mysql_query("SELECT `usr_mobile` FROM `vts_users` WHERE `u_id`='$userID'"),0); $uLandLine = mysql_result(mysql_query("SELECT `mobileTwo` FROM `vts_users` WHERE `u_id`='$userID'"),0); $empID= mysql_result(mysql_query("SELECT `u_name` FROM `vts_users` WHERE `u_id`='$userID'"),0); $uEmail = mysql_result(mysql_query("SELECT `email` FROM `vts_users` WHERE `u_id`='$userID'"),0); $fullName = strtoupper($uFname) . " ". strtoupper($uLname); $uMobileNo = $uMobile ." | ". $uLandLine; $json = json_encode(["FullName" => "$fullName","Position" => "$uPosition","MobileNo" => "$uMobileNo","Email" => "$uEmail","FName" => "$uFname","LName" => "$uLname","MobileOnly" => "$uMobile","LandLineOnly" => "$uLandLine","empID" => "$empID","transDate" => "$toDate"]); } 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