Server : Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.4.20 System : Linux st2.domain.com 3.10.0-1127.10.1.el7.x86_64 #1 SMP Wed Jun 3 14:28:03 UTC 2020 x86_64 User : apache ( 48) PHP Version : 7.4.20 Disable Function : NONE Directory : /var/www/html/api-truyentranh/includes/get/ |
<?php
$key_cache_menu = md5("SELECT * FROM tb_menus ORDER BY `menus_pos` ASC");
if($memcache->get($key_cache_menu)){
$categories = $memcache->get('arr_'.$key_cache_menu);
}else {
$query = $DB->query("SELECT * FROM tb_menus ORDER BY `menus_pos` ASC");
while ($row = $DB->fetch_row($query)) {
$row['menus_name'] = html_entity_decode($row['menus_name']);
$categories[] = $row;
}
$memcache->set('arr_'.$key_cache_menu, $categories, MEMCACHE_COMPRESSED, 86400);
}
// Prepare JSON structure
$result = array();
$result['status'] = true;
$result['status_note'] = "Success";
// Process categories for JSON output
$main_menu = array();
foreach ($categories as $row) {
if ($row['menus_parentid'] == 0) {
/*$menu_item = array(
'id' => $row['menus_id'],
'name' => $row['menus_name'],
'fname' => $row['menus_fname'],
'type' => $row['menus_type'],
'url' => $row['menus_url'],
'position' => $row['menus_pos'],
'sub_items' => array()
);*/
// If this is a parent menu, find its children
if ($row['menus_fname'] == 'genres') {
foreach ($categories as $sub_item) {
if ($sub_item['menus_parentid'] == $row['menus_id']) {
$menu_item[] = array(
'id' => $sub_item['menus_id'],
'name' => $sub_item['menus_name'],
'fname' => $sub_item['menus_fname']
);
}
}
}
//$main_menu[] = $menu_item;
}
}
$result['data'] = $menu_item;
echo jsonutf($result);
?>