[Plugin] Http/s REST, blueprintable JSON query and Parse API manager [VaRest]

[knack]

yesterday i have a bad day with other php errors too, 3 hours without doing a simple task for get the mysql data and creating a array with the right format. Sometimes its better go to sleep and try next day hehe, i wake up and in five minutes …

i post here that simple code, perhaps can be useful for someone without too much php knowledge.

<?php
/*

*/
error_reporting(E_ALL);

require(‘…/config/config.inc.php’); //common config vars
require(‘…/db/db.mysql.php’); // db_query -> mysqli_db_query… and the others
require(‘…/include/common.inc.php’); // connect to db && session && other common things

$json = file_get_contents(‘php://input’);
$json_phpvar = json_decode($json);

if (isset($json_phpvar) && ($json_phpvar->{‘request’} == “categories”)) {

$result_array = array();
$query = db_query("SELECT * FROM categories");
while ($row = db_fetch($query)) {
    	$result_array'categories']] = $row;
}
echo json_encode($result_array, JSON_UNESCAPED_SLASHES);
exit(0);

}

?>

I sent from UE4 a “request”:“categories” in POST/JSON format. categories its a simple table with catid and catname values