<?php

class Autocomplete extends Mgc {
    public function fetch() {

        if(!$this->managers->access('suppliers')) {
            return false;
        }
        $result = array();
        $search = mb_strtolower($this->request->get('filter_name'));

        $selects = $this->db->query("SELECT `name`, `url` FROM __categories WHERE LOWER(name) LIKE '%$search%'");
        foreach ($selects as $select) {
            $result[] = [
                'name' => $select['name'],
                'url'  => '/catalog/' . $select['url']
            ];
        }

        return $result;
    }
}

$ajax = new Autocomplete();
header("Content-type: application/json; charset=utf-8");
header("Cache-Control: must-revalidate");
header("Pragma: no-cache");
header("Expires: -1");
$json = json_encode($ajax->fetch());
print $json;