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/luckymerchan/code/pages/ |
<?php
$where = '';
$slug = $CORE->input['slug'] ?? '';
if($slug!=''){
$where .= " AND b.ftitle='$slug' ";
}
$r_menu2 =
$DB->fetch_row($DB->query("SELECT * FROM tb_menus WHERE menus_fname='$code'"));
$r_total =
$DB->fetch_row(
$DB->query(
"SELECT count(*) as total FROM tb_menus_pages a
INNER JOIN tb_pages b
ON a.pages_id=b.id
WHERE a.menus_fname='$code' "));
$q_page = $DB->query("SELECT a.*,b.* FROM tb_menus_pages a
INNER JOIN tb_pages b
ON a.pages_id=b.id
WHERE a.menus_fname='$code'
ORDER BY b.noibat DESC, b.time DESC
");
$txt_list_title = $title = $body = '';
$i = 1;
while($r_page = $DB->fetch_row($q_page)){
if($i==1){
if(empty($slug)) {
$slug = $r_page['ftitle'];
}
$title = $r_page['title'];
$body = $r_page['body'];
}
$active='';
if($r_page['ftitle']==$slug){
$active='active';
}
$txt_list_title .= '<a href="/'.$code.'/'.$r_page['ftitle'].'/" class="list-group-item list-group-item-action '.$active.'">
<div class="d-flex w-100 justify-content-between">
<h5 class="mb-1">'.$r_page['title'].'</h5>
<small>'.date('d-m-Y',$r_page['time']).'</small>
</div>
</a>';
$i++;
}
if(!empty($slug)){
$r_detail = $DB->fetch_row($DB->query("
SELECT a.*,b.* FROM tb_menus_pages a
INNER JOIN tb_pages b
ON a.pages_id=b.id
WHERE a.menus_fname='$code' ".$where."
ORDER BY b.noibat DESC, b.time DESC
"));
if($r_detail) {
$title = $r_detail['title'];
$body = $r_detail['body'];
}else{
header('Location: /index.php');
}
}
$CORE->title_page = $r_menu2['menus_name'].' - '.$title;
?>