<?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);

?>