Файл: notice.php
Строк: 40
<?
require_once('core/index.php');
require_once('core/func.php');
avt();
$title='Уведомления';
require_once('design/head.php');
$count=$db->query("SELECT id FROM `notice` WHERE `id_user`='".$user['id']."'")->rowCount();
$stmt = $db->prepare("UPDATE `notice` SET `read` = ? WHERE `id_user` = ?");
$stmt -> execute(array('0', $user['id']));
require 'core/pagination.php';
$pagination = new Pagination;
$pagination->sett($count, 10, true);
$res = $db->query("SELECT * FROM `notice` WHERE `id_user`='".$user['id']."' ORDER BY `time` DESC " . $pagination->limit());
echo '<div class="h1">';
if($count==0){echo 'Уведомлений нет.';}
$num=1;
foreach($res as $post){
$ank = $db->query("SELECT * FROM `users` WHERE `id`='".$post['id_user']."'")->fetch();
echo vremya($post['time']).'<br/>'.bb(filter($post['text'])).($num!=$count?'<br/><br/>':null);
++$num;
}echo '</div>';
echo "<div class='pg'>";
echo $pagination->get();
echo "</div>";
echo '<div class="h1"><img src="/design/ico/png/delete.png"> <a href=?delete>Очистить журнал</a></div>';
if(isset($_GET['delete'])){
$db->exec("DELETE FROM `notice` WHERE `id_user`='".$user['id']."'");
$_SESSION['msg']='Журнал очищен';
header('Location:?');
}
require_once('design/foot.php');
?>