File size: 1.59Kb
<?php
acms_header('Мировые новости - поиск');
is_active_module('PRIVATE_RNEWS');
require_once (ROOT.'/modules/rnews/plugins/config.php');
if (post('search')){
session('rnews_search', tabs(post('search')));
}
$search = esc(session('rnews_search'));
require_once (ROOT.'/modules/rnews/plugins/search.php');
$column = db::get_column("SELECT COUNT(*) FROM `RNEWS` WHERE (`NAME` LIKE ? OR `OPIS` LIKE ? OR `CATEGORY` LIKE ? OR `LINK` LIKE ? OR `TYPE` LIKE ? OR `TYPE_RU` LIKE ?)", ['%'.$search.'%', '%'.$search.'%', '%'.$search.'%', '%'.$search.'%', '%'.$search.'%', '%'.$search.'%']);
$spage = spage($column, PAGE_SETTINGS);
$page = page($spage);
$limit = PAGE_SETTINGS * $page - PAGE_SETTINGS;
if ($column == 0){
html::empty('Ничего не найдено', 'search');
}else{
?>
<div class='list-body'>
<div class='list-menu'>
<b><?=lg('Результаты поиска')?> <span class='count'><?=$column?></span></b>
</div>
<?
}
$data = db::get_string_all("SELECT * FROM `RNEWS` WHERE (`NAME` LIKE ? OR `OPIS` LIKE ? OR `CATEGORY` LIKE ? OR `LINK` LIKE ? OR `TYPE` LIKE ? OR `TYPE_RU` LIKE ?) ORDER BY `TIME` DESC LIMIT ".$limit.", ".PAGE_SETTINGS, ['%'.$search.'%', '%'.$search.'%', '%'.$search.'%', '%'.$search.'%', '%'.$search.'%', '%'.$search.'%']);
while ($list = $data->fetch()) {
require (ROOT.'/modules/rnews/plugins/list.php');
echo $rnews_list;
}
if ($column > 0){
?></div><?
}
get_page('/m/rnews/search/?', $spage, $page, 'list');
forward('/m/rnews/', 'К новостям');
back('/', 'На главную');
acms_footer();