дано:
таблица news (id,title,date,meta_d,meta_k,author,description,text) и два файла: news.php и view_news.php (первый показывает список событий и второй показывает событие)
помогите в первом организовать постраничную навигацию.
news.php
PHP:
скопировать код в буфер обмена
<?PHP include ("blocks/bd.php"); $result = mysql_query ("SELECT title, meta_d, meta_k, text FROM settings WHERE page='news'",$db); ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta name="description" content="<?PHP echo $myrow['meta_d']; ?> "> <meta name="keywords" content="<?PHP echo $myrow['meta_k']; ?> "> <meta http-equiv="Content-Type" content="text/html; charset=windows-1251"> <title><?PHP echo $myrow['title']; ?> </title> <link href="style.css" rel="stylesheet" type="text/css"> <style type="text/css"> <!-- .style1 {color: #0000FF} --> </style> </head> <body> <table width="960" border="0" align="center" cellpadding="0" cellspacing="0" class="main_border"> <? include("header.php"); ?> <tr> <td><table width="960" border="0" bgcolor="#FFFFFF"> <tr> <? include("nav.php")?> <td valign="top"> <p><?PHP echo $myrow['text']; ?></p> <?PHP $result = mysql_query("SELECT id,title,date,description,author FROM news ORDER BY date DESC",$db); do { printf (" <table align='center' class='news'> <tr> <td class='news_title'> <p class = 'news_name'><a href='view_news.php?id=%s'>%s</a></p> <p class = 'news_adds'>Дата добавления: %s</p> <p class = 'news_adds'>Автор: %s</p></td> </tr> <tr> <td>%s</td> </tr> </table><br><br>",$myrow ["id"], $myrow ["title"], $myrow ["date"], $myrow ["author"], $myrow ["description"]); } ?> <p> </p> </td> </tr> </table></td> </tr> <?include("footer.php");?> </table> </body> </html>
view_news.php
PHP:
скопировать код в буфер обмена
<?PHP include ("bd.php"); if (isset ($_GET['id'])) {$id = $_GET['id'];} $result = mysql_query ("SELECT * FROM news WHERE id='$id'",$db); ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta name="description" content="<?PHP echo $myrow['meta_d']; ?> "> <meta name="keywords" content="<?PHP echo $myrow['meta_k']; ?> "> <meta http-equiv="Content-Type" content="text/html; charset=windows-1251"> <title><?PHP echo $myrow['title']; ?> </title> <link href="style.css" rel="stylesheet" type="text/css"> <style type="text/css"> </style> </head> <body> <table width="960" border="0" align="center" cellpadding="0" cellspacing="0" class="main_border"> <? include("header.php"); ?> <tr> <td><table width="960" border="0" bgcolor="#FFFFFF"> <tr> <? include("nav.php")?> <td valign="top"> <p class = "view_title"><?PHP echo $myrow['title']; ?></p> <p class = "view_date">Дата добавления: <?PHP echo $myrow['date']; ?></p> <p class = "view_date">Автор: <?PHP echo $myrow['author']; ?></p> <p><?PHP echo $myrow['text']; ?></p> <p> </p> </td> </tr> </table></td> </tr> <? include("footer.php");?> </table> </body> </html>
|