File manager - Edit - /home/autoph/public_html/connect/api/v1/read_positions.php
Back
<?php date_default_timezone_set('Asia/Manila'); header('Content-Type: application/json'); $server_method = isset($_SERVER["REQUEST_METHOD"]) ? $_SERVER["REQUEST_METHOD"] : false; if($server_method !== 'GET'){ //exit; } if(!isset($_REQUEST['key']) || $_REQUEST['key'] == ''){ exit; } $key = $_REQUEST['key']; if($key != 'a00b710a823711ecb30d00ff70631b9a'){ exit; } $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(). '.'); $query = "SELECT * FROM `db_positions` WHERE status = 1 ORDER BY `position_rank` ASC"; $sql_obj = mysql_query($query, $conn); $sql_arr = array(); while($sql__arr = mysql_fetch_assoc($sql_obj)) { $sql_arr = array_merge($sql_arr,array(array( 'id'=>$sql__arr['pid'], 'name'=>$sql__arr['position_title'], 'rank'=>$sql__arr['position_rank'], ))); } echo json_encode($sql_arr); ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings