File manager - Edit - /home/autoph/public_html/connect/api/v1/users/users.php
Back
<?php date_default_timezone_set('Asia/Manila'); header('Content-Type: application/json'); $sqlUser = 'autoph_arnel'; $sqlDatabase = 'autoph_connect'; $sqlPass = 'Hke@2001'; $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(). '.'); $key = $_REQUEST['key']; if($key == '5463358374534'){ $username = $_REQUEST['username']; $username = mysql_real_escape_string($username); $password = $_REQUEST['password']; $md5_password = md5($password); $user_generic_query = user_generic_query(); $fields = " SELECT u.*, c.comp_id as company_id, c.comp_name as company, c.comp_code as company_code, d.deal_id as dealer_id, d.deal_name as dealer, d.deal_code as dealer_code "; $query = $user_generic_query." AND (u.u_name = '%s' OR u.employee_id = '%s') AND u.u_password = '%s' "; $query_formatted = sprintf($query,$fields,$username,$username,$md5_password); // echo $query_formatted;exit; $sql_obj = mysql_query($query_formatted, $conn); $sql_arr = array(); while($sql__arr = mysql_fetch_assoc($sql_obj)) { $sql_arr = $sql__arr; } if(count($sql_arr) > 0){ $sql_arr['api_status'] = 1; }else{ $sql_arr['api_status'] = 0; } echo json_encode($sql_arr); }else if($key == '54633343444223'){ $asa_id = $_REQUEST['id']; $user_generic_query = user_generic_query(); $fields = " SELECT u.*, c.comp_id as company_id, c.comp_name as company, c.comp_code as company_code, d.deal_id as dealer_id, d.deal_name as dealer, d.deal_code as dealer_code "; $query = $user_generic_query." AND u.u_id = '%s' "; $query_formatted = sprintf($query,$fields,$asa_id); // echo $query_formatted;exit; $sql_obj = mysql_query($query_formatted, $conn); $sql_arr = array(); while($sql__arr = mysql_fetch_assoc($sql_obj)) { $sql_arr = $sql__arr; } if(count($sql_arr) > 0){ $sql_arr['api_status'] = 1; }else{ $sql_arr['api_status'] = 0; } echo json_encode($sql_arr); } function user_generic_query(){ return " %s FROM `vts_users` u LEFT OUTER JOIN vts_dealerships d ON u.dealer = d.deal_id LEFT OUTER JOIN vts_company c ON d.comp_id = c.comp_id WHERE 1 "; } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings