<?php

include '../MyPDO.php' ;
include '../App.php' ;
include '../config.php';

if (!isset($_REQUEST['api_key']) || !isset($_REQUEST['key'])) {
    die("Err") ;
}

$api_key  = $_REQUEST['api_key'] ;
$key  = $_REQUEST['key'] ;

if ($api_key != App::$API_KEY) {
    die("ERR") ;
}

$conn = MyPDO::getInstance() ;
$query = " SELECT * FROM block_list WHERE code LIKE '%$key%' ORDER BY status " ;
$stmt  = $conn ->prepare($query) ;

$stmt  ->execute() ;

$jsonArray = array() ;
while ($res = $stmt ->fetch(PDO::FETCH_ASSOC)) {
    $tmp = array() ; 
    $tmp['id']    = $res['id']    ;
    $tmp['user_id'] = $res['user_id'] ;
    $tmp['blocked_at'] = $res['blocked_at'] ;
    
    array_push($jsonArray, $tmp) ;
}

echo json_encode($jsonArray, JSON_UNESCAPED_UNICODE) ;