File manager

File manager - Edit - /home/autoph/public_html/connect/LOAD_SALES_PERSON.php

Back
<?php date_default_timezone_set('Asia/Manila'); header('Content-Type: application/json'); header('Access-Control-Allow-Origin: *'); //MODFIED 04/29/25 reported by database //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'; $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(). '.'); $regPost = $_REQUEST['apiKey']; $searchParam = $_REQUEST['search']; if(isset($_REQUEST['offset']) && isset($_REQUEST['limit']) && $_REQUEST['offset'] <> '' && $_REQUEST['limit'] <> '' ){ $offset = $_REQUEST['offset']; $limit = $_REQUEST['limit']; $offset_limit = " LIMIT ". $offset.",".$limit; }else{ $offset_limit = "LIMIT 20"; } if(isset($_REQUEST['position']) && $_REQUEST['position'] <> ''){ $position = " AND u_position = '".$_REQUEST['position']."' "; }else{ $position = ""; } if(isset($_REQUEST['uid']) && $_REQUEST['uid'] <> ''){ $user_id = " AND u_id = '".$_REQUEST['uid']."' "; $exclude_deactivated = ""; }else{ $user_id = ""; $exclude_deactivated = " AND u_status = 1 AND deleted = 0 "; } if(isset($_REQUEST['ids'])){ $asa_ids_filter_arr = json_decode($_REQUEST['ids'],true); $asa_ids_filter = " AND u_id IN (".implode(",",$asa_ids_filter_arr).") "; }else{ $asa_ids_filter= ""; } $fields = " `u_id`,`employee_id`,`u_name`,`u_fname`,`u_mname`,`u_lname`,`email`,`usr_mobile`,u_position,CONCAT(`u_fname`,' ',`u_lname`) as fullname "; $total_count = " COUNT(1) as total_count "; $sql = "SELECT %s FROM `vts_users` WHERE ( CONCAT(`employee_id`,' ',`u_name`,' ',`usr_mobile`,' ', CONCAT(`u_fname`,' ',`u_mname`,' ',`u_lname`),' ', CONCAT(`u_fname`,' ',`u_lname`) ) LIKE '%%$searchParam%%' OR `email` = '$searchParam') $position $user_id %s %s ORDER BY u_fname ASC "; if($regPost == '3892635489643867'){ $return_arr['rows'] = Array(); $return_arr['total'] = 0; //echo sprintf($sql,$fields)." $offset_limit";exit; $sqlTable = mysql_query(sprintf($sql,$fields,$asa_ids_filter,$exclude_deactivated)." $offset_limit", $conn); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { $return_arr['rows'] = array_merge( $return_arr['rows'], array( array('u_id'=>$sqlRecord['u_id'], 'employee_id'=>$sqlRecord['employee_id'], 'u_name'=>$sqlRecord['u_name'], 'u_fname'=>$sqlRecord['u_fname'], 'u_mname'=>$sqlRecord['u_mname'], 'u_lname'=>$sqlRecord['u_lname'], 'email'=>$sqlRecord['email'], 'usr_mobile'=>$sqlRecord['usr_mobile'], 'u_position'=>$sqlRecord['u_position'], 'fullname'=>$sqlRecord['fullname'] ))); } //echo sprintf($sql,$total_count);exit; $sqlTable = mysql_query(sprintf($sql,$total_count,$asa_ids_filter), $conn); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { $return_arr['total'] = $sqlRecord['total_count']; } $json = json_encode($return_arr); $did_something += 1; } else if($regPost == '7594712920757225'){ $return_arr = Array(); $sqlTable = mysql_query(sprintf($sql,$fields,'',$exclude_deactivated)." $offset_limit", $conn); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { //$return_arr[]=$sqlRecord; $return_arr[] = ['id'=>$sqlRecord['u_id'], 'text'=>$sqlRecord['u_fname'] .' '. $sqlRecord['u_lname']]; } $json = json_encode($return_arr); $did_something += 1; } if($did_something === 0) { $msg = did_nothing_message; $json = json_encode(["status" => "$msg", "statusCode" => '0']); } echo $json; ?>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings