$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>