Странициране на новини

R

ReD_z0n3

Registered
PHP: 
<?php
//настройки за база данни
$dbhost = "#";
$dbuser = "#";
$dbpass = "#";
$dbname = "#";
$conn = mysql_connect($dbhost, $dbuser, $dbpass)or die(mysql_error());
mysql_select_db($dbname, $conn)or die(mysql_error());
mysql_query("SET NAMES utf8");

$select = mysql_query("SELECT * FROM news ORDER BY id DESC")or die(mysql_error());
$num = mysql_num_rows($select);
for ($i=0;$i<$num;$i++) {
$name = mysql_result($select, $i, "name");
$news = mysql_result($select, $i, "news");
echo '<table width="300" height="10" border="0">';
echo '<tr><td><font color="red"><b>Проект name:</font></b>'.$name.'</b></td>
<tr><td><font color="red"><b>Проект:</b></font>'.$news.'</b></td></tr>
<br /><hr>';
}

mysql_close();
?>

Това е кода някой може ли да ми го направи така , че след определен брой добавени новини да ги страницира [ 1 , 2 , 3 , 4 и т.н ] Благодаря предварително :)
 
Така това е кода за страницирането .

PHP: 
<?php
define('IN_VALID', true);
$dbhost = "localhost";
$dbuser = "user";
$dbpass = "pass";
$dbname = "db";
$conn = mysql_connect($dbhost, $dbuser, $dbpass)or die(mysql_error());
mysql_select_db($dbname, $conn)or die(mysql_error());
mysql_query("SET NAMES utf8");
//$ns - номер страница
//$br - брой страница
//$one - първа
//$sl - следваща
//$pl - последна
//$pr - предишна
$br = 10;
$pageNum = 1;
if(isset($_GET['page'])) {
$pageNum = $_GET['page'];
}
$redove = ($pageNum - 1) * $br;
$result = mysql_query("SELECT * FROM `chatbox` ORDER BY id DESC LIMIT $redove, $br")or die(mysql_error());
while($row = mysql_fetch_array($result)) {
$id = $row['id'];
$nick = $row['nick'];
$message = $row['message'];
echo '<b><font color="#00b2ee">' . $nick . '  :</font></b> <font color="#00b2ee">' . $message . '   -   </font> <a href="admin_chat_delete.php?id=' . $id . '; ?>">Изтрий</a>';
}
$query = mysql_query("SELECT COUNT(id) AS numrows FROM chatbox") or die(mysql_error());
$row = mysql_fetch_array($query, MYSQL_ASSOC);
$numrows = $row['numrows'];
$maxPage = ceil($numrows/$br);
$ns = '<font color="#00b2ee">Страници:</font> ';
for($page = 1; $page <= $maxPage; $page++) {
if ($page == $pageNum) {
$ns .= " $page ";
}
else {
$ns .= "<a class=\"typ1\" href=\"?a=ranking&page=$page\">  $page</a> ";
}}
if ($pageNum > 1) {
$page = $pageNum - 1;
$pr = " <a href=\"?a=ranking&page=$page\"></a> ";
$one = " <a href=\"?a=ranking&page=1\"></a> ";
}
else {
$pr = ' ';
$one = ' ';
}
if ($pageNum < $maxPage) {
$page = $pageNum + 1;
$sl = (" <a href=\"?a=ranking&page=$page\"></a> ");
$pl = (" <a href=\"?a=ranking&page=$maxPage\"></a> ");
}
else {
$sl = '';
$pl = '';
}
echo $one . $pr . $ns . $sl . $pl;
?>

Къде точно трябва да сложа моя код , за да бачка ?!
 
PHP: 
<?php
//настройки за база данни
$dbhost = "#";
$dbuser = "#";
$dbpass = "#";
$dbname = "#";
$conn = mysql_connect($dbhost, $dbuser, $dbpass)or die(mysql_error());
mysql_select_db($dbname, $conn)or die(mysql_error());
mysql_query("SET NAMES utf8");
//$ns - номер страница
//$br - брой страница
//$one - първа
//$sl - следваща
//$pl - последна
//$pr - предишна
$br = 10;
$pageNum = 1;
if(isset($_GET['page'])) {
	$pageNum = $_GET['page'];
}
$redove = ($pageNum - 1) * $br;
$result = mysql_query("SELECT * FROM news ORDER BY id DESC LIMIT $redove, $br")or die(mysql_error());
while($row = mysql_fetch_array($result)){
	$name = $row['name'];
	$news = $row['news'];
	echo '<table width="300" height="10" border="0">
<tr><td><font color="red"><b>Проект name:</font></b>'.$name.'</b></td>
<tr><td><font color="red"><b>Проект:</b></font>'.$news.'</b></td></tr>
<br /><hr>';
}
$query = mysql_query("SELECT COUNT(id) AS numrows FROM news") or die(mysql_error());
$row = mysql_fetch_array($query, MYSQL_ASSOC);
$numrows = $row['numrows'];
$maxPage = ceil($numrows/$br);
$ns = '<font color="#00b2ee">Страници:</font> ';
for($page = 1; $page <= $maxPage; $page++){
	if($page == $pageNum){
		$ns .= " $page ";
	}else{
		$ns .= "<a class=\"typ1\" href=\"?a=ranking&page=$page\">  $page</a> ";
	}
}
if($pageNum > 1){
	$page = $pageNum - 1;
	$pr = " <a href=\"?a=ranking&page=$page\"></a> ";
	$one = " <a href=\"?a=ranking&page=1\"></a> ";
}else{
	$pr = ' ';
	$one = ' ';
}
if($pageNum < $maxPage){
	$page = $pageNum + 1;
	$sl = (" <a href=\"?a=ranking&page=$page\"></a> ");
	$pl = (" <a href=\"?a=ranking&page=$maxPage\"></a> ");
}else{
	$sl = '';
	$pl = '';
}
echo $one . $pr . $ns . $sl . $pl;

mysql_close();
?>

Ето така трябва да стане :?:
 
Код: 
<?php
include "config.php";
?>
<?php
if (isset($_GET['page']))
{
if (is_numeric($_GET['page']))
{
if ($_GET['page'] == 0)
{
$page = 1;
}
else
{
$page = $_GET['page'];
}
}
else
{
$page = 1;
}
}
else
{
$page = 1;
}
$po = "7";
$a = mysql_query("SELECT * FROM news ORDER BY id DESC") or die(mysql_error());
$b = mysql_num_rows($a);
$news = $b;
$ot = ($page * $po)-$po;
$do = $page * $po;
$stranici = ceil($news / $po);
?>
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе