<?php

header('Content-Type: application/json; charset=utf-8');
header("Access-Control-Allow-Origin: *");

ini_set('display_errors','on');
error_reporting (E_ALL);


function getParam($name)
{
    if(isset($_GET[$name]))
    {
        return trim(urldecode($_GET[$name]));
    }
    else if(isset($_POST[$name]))
    {
        return trim(urldecode($_POST[$name]));
    }

    return NULL;
}

$q       = getParam("query");
$dev_id  = getParam("id");
$dev_key = getParam("key");
if($q == NULL || $dev_id == NULL || $dev_key == NULL)
{
    header('HTTP/1.1 400 Bad Request');
    die(json_encode(array("error" => "Bad Request, query, id or key is empty")));
}

$q = trim(urldecode($q));
$link = mysqli_connect("app.comet-server.ru", $dev_id, $dev_key, "CometQL_v1");


if ( !$link )
{
    header('HTTP/1.1 403 Bad Request');
    die(json_encode(array("error" => "Невозможно подключение к CometQL")));
}

$result = mysqli_query (  $link, $q );
if(mysqli_errno($link) != 0)
{
    header('HTTP/1.1 400 Bad Request');
    die(json_encode(array("error" => mysqli_errno($link), "text" => mysqli_error($link), "see" => "https://comet-server.ru/wiki/doku.php/comet:cometql:error")));
}

$data = array();
while ($row = mysqli_fetch_assoc($result))
{
    $data[] = $row;
}

header('HTTP/1.1 200 OK');
die(json_encode(array("data" => $data)));