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 : /proc/self/root/var/www/html/tien-dien/code/pages/ |
<?php
$s = array();
$param_search = '';
$where = ' AND status=0 ';
if(isset($CORE->input['s'])){
$s = $CORE->input['s'];
foreach ($s as $key=>$val){
if($val!='') {
$param_search .= 's['.$key.']='.trim($val).'&';
if($key=='menus_id'){
$where .= " AND id IN (SELECT pages_id FROM tb_menus_pages WHERE menus_id='".$val."' ) ";
}
if($key=='status'){
$where .= " AND status='".$val."' ";
}
if($key=='keyword'){
$where .= " AND (title LIKE '%".$val."%' OR etitle LIKE '%".$val."%') ";
}
}
}
}
$where .= " AND id IN (SELECT pages_id FROM tb_menus_pages WHERE menus_id='".$menu_id."' ) ";
$pageNum = isset($_GET['pageNum']) ? intval($_GET['pageNum']) : 1;
$pageSize = 18;
$from = (($pageNum * $pageSize) - $pageSize);
$t = $DB->fetch_row($DB->query("SELECT count(*) as total FROM tb_pages WHERE 1 ".$where));
$total = $t['total'];
$totalPage = ceil($total / $pageSize);
$query = $DB->query("SELECT * FROM tb_pages WHERE 1 ".$where." ORDER BY `pos` ASC, `noibat` DESC, status ASC LIMIT $from, $pageSize");
$list = $list_san_pham = '';
while ($row = $DB->fetch_row($query)){
$ftitle_page = $row['ftitle'];
$list .= '
<div class="col-xxl-4 col-xl-4 col-lg-4 col-md-6">
<article class="blog mb-30">
<div class="blog__thumb">
<a href="/'.$menu_ftitle.'/'.$ftitle_page.'/"><img src="'.$row['path_img'].'" alt="'.$row['title'].'"></a>
</div>
<div class="blog__content">
<div class="blog-text">
<h3 class="blog__content__title">
<a href="/'.$menu_ftitle.'/'.$ftitle_page.'/">'.$row['title'].'</a>
</h3>
<p>'.$row['intro'].'</p>
<div class="read-more">
<a href="/'.$menu_ftitle.'/'.$ftitle_page.'/">Chi tiết <i class="fal fa-long-arrow-right"></i></a>
</div>
</div>
</div>
</article>
</div>
';
$list_san_pham .= '<div class="col-xxl-4 col-xl-4 col-lg-4 col-md-8 mb-30">
<div class="features">
<div class="features__thumb">
<a href="/'.$menu_ftitle.'/'.$ftitle_page.'/"><img src="'.$row['path_img'].'" alt="'.$row['title'].'"></a>
</div>
<div class="features__content">
<h3 class="features__content-title"> <a href="/'.$menu_ftitle.'/'.$ftitle_page.'/">'.$row['title'].'</a> </h3>
<a href="/'.$menu_ftitle.'/'.$ftitle_page.'/">Chi tiết <i class="fal fa-long-arrow-right"></i></a>
</div>
</div>
</div>';
}
$nav = '';
if(!empty($list)) {
$nav = $print->Pagination($totalPage, $pageNum, 'pages', '?act=pages&menu_ftitle=' . $menu_ftitle . '&' . $param_search);
}
?>