$title = "";
$author = "";
$datefirst = "";
$datelast = "";
if (!empty($_POST['title'])) {
$title = $_POST['title'];
}
if (!empty($_POST['author'])) {
$author = $_POST['author'];
}
if (!empty($_POST['datefirst'])) {
$datefirst = $_POST['datefirst'];
}
if (!empty($_POST['datelast'])) {
$datelast = $_POST['datelast'];
}
$numpage = 1;
// TODO: постраничный вывод отфильтрованных результатов
$articles = news_filter($link, $title, $author, $datefirst, $datelast);
include "../views/adminnews.php";
}
}
}
}
}
}
} else {
$numpage = get_num_pages($link);
$articles = news_all($link, $page);
include "../views/adminnews.php";
}
<?php
require 'opendb.php';
$per_page = 50;
function get_num_pages($per_page)
{
$query = "SELECT COUNT(*) FROM new_commits ORDER BY id DESC";
$result = mysql_query($query);
$result_array = mysql_fetch_array($result);
$num_messages = $result_array[0];
return round($num_messages / $per_page);
}
$num_pages = get_num_pages($per_page);
$page = 0;
if (is_numeric($_GET['page'])) {
$page = $_GET['page'];
}
// Get commits
$query = "SELECT * FROM new_commits ORDER BY date DESC LIMIT " . $page * $per_page . ", " . $per_page;
$result = mysql_query($query);
$prev_page = $page - 1;
$next_page = $page + 1;
if ($prev_page < 0) {
$prev_page = false;
}
if ($next_page > $num_pages) {
$next_page = false;
}
?>
<!DOCTYPE html>
<html>
