Проблем с код за странициране

  • Автор Автор asdd
  • Начална дата Начална дата
A

asdd

Registered
Някой може ли да ми помогне да вкарам странициране на този код:

Код: 
<?
include "conf.php";
$sql = mysql_query("SELECT * FROM `1` ORDER BY `id` DESC") or die(mysql_error());
while ($row = mysql_fetch_array($sql)) {
if ($admin==$_SERVER['REMOTE_ADDR']) { $delete = " <a href=del.php?id=$row[id]>-изтрий-</a>"; }

echo " <table class=\"chats\" width=\"98%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"><tr>
  <td width=\"50%\" align=left class=forumlink><strong>".$row[nick]."</strong></td>
  <td width=\"50%\" align=right class=\"genmed\"><strong>".date("H:i:s",$row['time'])."<br>".date("d.m.y",$row['time'])."</strong></td></tr>";
$message = $row[message];
$message = str_replace(":biggrin:","<img border=0 src=smiles/icon_biggrin.gif>","$message");
$message = str_replace(":confused:","<img border=0 src=smiles/icon_confused.gif>","$message");
$message = str_replace(":cool:","<img border=0 src=smiles/icon_cool.gif>","$message");
$message = str_replace(":cry:","<img border=0 src=smiles/icon_cry.gif>","$message");
$message = str_replace(":eek:","<img border=0 src=smiles/icon_eek.gif>","$message");
$message = str_replace(":evil:","<img border=0 src=smiles/icon_evil.gif>","$message");
$message = str_replace(":exclaim:","<img border=0 src=smiles/icon_exclaim.gif>","$message");
$message = str_replace(":idea:","<img border=0 src=smiles/smiles/icon_idea.gif>","$message");
$message = str_replace(":lol:","<img border=0 src=smiles/icon_lol.gif>","$message");
$message = str_replace(":mad:","<img border=0 src=smiles/icon_mad.gif>","$message");
$message = str_replace(":mrgreen:","<img border=0 src=smiles/icon_mrgreen.gif>","$message");
$message = str_replace(":neutral:","<img border=0 src=smiles/icon_neutral.gif>","$message");
$message = str_replace(":question:","<img border=0 src=smiles/icon_question.gif>","$message");
$message = str_replace(":redface:","<img border=0 src=smiles/icon_redface.gif>","$message");
$message = str_replace(":rolleyes:","<img border=0 src=smiles/icon_rolleyes.gif>","$message");
$message = str_replace(":sad:","<img border=0 src=smiles/icon_sad.gif>","$message");
$message = str_replace(":smile:","<img border=0 src=smiles/icon_smile.gif>","$message");
$message = str_replace(":wink:","<img border=0 src=smiles/icon_wink.gif>","$message");
$message = str_replace(":twisted:","<img border=0 src=smiles/icon_twisted.gif>","$message");
$message = str_replace(":razz:","<img border=0 src=smiles/icon_razz.gif>","$message");
$message = str_replace(":surprised:","<img border=0 src=smiles/icon_surprised.gif>","$message");
$message = str_replace(":arrow:","<img border=0 src=smiles/icon_arrow.gif>","$message");

echo " <tr><td colspan=\"2\" class=\"genmed\">".$message."".$delete."</td></tr>
 </table><hr width=99%>";
}
?>
</tr>
<br/>
 
Код: 
<?php
include "conf.php";
$broinastranica = 10;//колко броя да изкарва на страница
$pageNum = 1;
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
$redove = ($pageNum - 1) * $broinastranica;
$sql = mysql_query("SELECT * FROM `1` ORDER BY `id` DESC LIMIT $redove, $broinastranica") or die(mysql_error());
$result = mysql_query($sql);
while ($row = mysql_fetch_array($sql)) {
if ($admin==$_SERVER['REMOTE_ADDR']) { $delete = " <a href=del.php?id=$row[id]>-изтрий-</a>"; }

echo " <table class=\"chats\" width=\"98%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"><tr>
  <td width=\"50%\" align=left class=forumlink><strong>".$row[nick]."</strong></td>
  <td width=\"50%\" align=right class=\"genmed\"><strong>".date("H:i:s",$row['time'])."<br>".date("d.m.y",$row['time'])."</strong></td></tr>";
$message = $row[message];
$message = str_replace(":biggrin:","<img border=0 src=smiles/icon_biggrin.gif>","$message");
$message = str_replace(":confused:","<img border=0 src=smiles/icon_confused.gif>","$message");
$message = str_replace(":cool:","<img border=0 src=smiles/icon_cool.gif>","$message");
$message = str_replace(":cry:","<img border=0 src=smiles/icon_cry.gif>","$message");
$message = str_replace(":eek:","<img border=0 src=smiles/icon_eek.gif>","$message");
$message = str_replace(":evil:","<img border=0 src=smiles/icon_evil.gif>","$message");
$message = str_replace(":exclaim:","<img border=0 src=smiles/icon_exclaim.gif>","$message");
$message = str_replace(":idea:","<img border=0 src=smiles/smiles/icon_idea.gif>","$message");
$message = str_replace(":lol:","<img border=0 src=smiles/icon_lol.gif>","$message");
$message = str_replace(":mad:","<img border=0 src=smiles/icon_mad.gif>","$message");
$message = str_replace(":mrgreen:","<img border=0 src=smiles/icon_mrgreen.gif>","$message");
$message = str_replace(":neutral:","<img border=0 src=smiles/icon_neutral.gif>","$message");
$message = str_replace(":question:","<img border=0 src=smiles/icon_question.gif>","$message");
$message = str_replace(":redface:","<img border=0 src=smiles/icon_redface.gif>","$message");
$message = str_replace(":rolleyes:","<img border=0 src=smiles/icon_rolleyes.gif>","$message");
$message = str_replace(":sad:","<img border=0 src=smiles/icon_sad.gif>","$message");
$message = str_replace(":smile:","<img border=0 src=smiles/icon_smile.gif>","$message");
$message = str_replace(":wink:","<img border=0 src=smiles/icon_wink.gif>","$message");
$message = str_replace(":twisted:","<img border=0 src=smiles/icon_twisted.gif>","$message");
$message = str_replace(":razz:","<img border=0 src=smiles/icon_razz.gif>","$message");
$message = str_replace(":surprised:","<img border=0 src=smiles/icon_surprised.gif>","$message");
$message = str_replace(":arrow:","<img border=0 src=smiles/icon_arrow.gif>","$message");

echo " <tr><td colspan=\"2\" class=\"genmed\">".$message."".$delete."</td></tr>
 </table><hr width=99%>";
}
$query = "SELECT COUNT(id) AS broi FROM plugins";
$result = mysql_query($query);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['broi'];
$maxPage = ceil($numrows/$broinastranica);
$self = $_SERVER['PHP_SELF'];
$nomeranastranici = '';
for($page = 1; $page <= $maxPage; $page++)
{
if ($page == $pageNum)
{
$nomeranastranici .= " $page ";
}
else
{
$nomeranastranici .= " <a href=\"$self?page=$page\">$page</a> ";
}
}
if ($pageNum > 1)
{
$page = $pageNum - 1;
$predishna = " <a href=\"$self?page=$page\"> [<<<<<] </a> ";
$parva = " <a href=\"$self?page=1\">[първа]</a> ";
}
else
{
$predishna = ' ';
$parva = ' ';
}
if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$sledvashta = " <a href=\"$self?page=$page\"> [>>>>>] </a> ";
$posledna = " <a href=\"$self?page=$maxPage\">[последна]</a> ";
}
else
{
$sledvashta = ' ';
$posledna = ' ';
}
echo "<br><br>".$parva . $predishna . $nomeranastranici . $sledvashta . $posledna;
?>
</tr>
<br/>
 
Изкарва грешка:


Код: 
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\xampp\xampp\htdocs\chat\chat.php on line 90

а на ред 90 е:


Код: 
$row = mysql_fetch_array($result, MYSQL_ASSOC);
 
Код: 
 <?php
include "conf.php";
$broinastranica = 10;//колко броя да изкарва на страница
$pageNum = 1;
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
$redove = ($pageNum - 1) * $broinastranica;
$sql = mysql_query("SELECT * FROM `1` ORDER BY `id` DESC LIMIT $redove, $broinastranica") or die(mysql_error());
$result = mysql_query($sql);
while ($row = mysql_fetch_array($sql)) {
if ($admin==$_SERVER['REMOTE_ADDR']) { $delete = " <a href=del.php?id=$row[id]>-изтрий-</a>"; }

echo " <table class=\"chats\" width=\"98%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"><tr>
  <td width=\"50%\" align=left class=forumlink><strong>".$row[nick]."</strong></td>
  <td width=\"50%\" align=right class=\"genmed\"><strong>".date("H:i:s",$row['time'])."<br>".date("d.m.y",$row['time'])."</strong></td></tr>";
$message = $row[message];
$message = str_replace(":biggrin:","<img border=0 src=smiles/icon_biggrin.gif>","$message");
$message = str_replace(":confused:","<img border=0 src=smiles/icon_confused.gif>","$message");
$message = str_replace(":cool:","<img border=0 src=smiles/icon_cool.gif>","$message");
$message = str_replace(":cry:","<img border=0 src=smiles/icon_cry.gif>","$message");
$message = str_replace(":eek:","<img border=0 src=smiles/icon_eek.gif>","$message");
$message = str_replace(":evil:","<img border=0 src=smiles/icon_evil.gif>","$message");
$message = str_replace(":exclaim:","<img border=0 src=smiles/icon_exclaim.gif>","$message");
$message = str_replace(":idea:","<img border=0 src=smiles/smiles/icon_idea.gif>","$message");
$message = str_replace(":lol:","<img border=0 src=smiles/icon_lol.gif>","$message");
$message = str_replace(":mad:","<img border=0 src=smiles/icon_mad.gif>","$message");
$message = str_replace(":mrgreen:","<img border=0 src=smiles/icon_mrgreen.gif>","$message");
$message = str_replace(":neutral:","<img border=0 src=smiles/icon_neutral.gif>","$message");
$message = str_replace(":question:","<img border=0 src=smiles/icon_question.gif>","$message");
$message = str_replace(":redface:","<img border=0 src=smiles/icon_redface.gif>","$message");
$message = str_replace(":rolleyes:","<img border=0 src=smiles/icon_rolleyes.gif>","$message");
$message = str_replace(":sad:","<img border=0 src=smiles/icon_sad.gif>","$message");
$message = str_replace(":smile:","<img border=0 src=smiles/icon_smile.gif>","$message");
$message = str_replace(":wink:","<img border=0 src=smiles/icon_wink.gif>","$message");
$message = str_replace(":twisted:","<img border=0 src=smiles/icon_twisted.gif>","$message");
$message = str_replace(":razz:","<img border=0 src=smiles/icon_razz.gif>","$message");
$message = str_replace(":surprised:","<img border=0 src=smiles/icon_surprised.gif>","$message");
$message = str_replace(":arrow:","<img border=0 src=smiles/icon_arrow.gif>","$message");

echo " <tr><td colspan=\"2\" class=\"genmed\">".$message."".$delete."</td></tr>
 </table><hr width=99%>";
}
$query = "SELECT COUNT(id) AS broi FROM 1";
$result = mysql_query($sql);
$numrows = $row['broi'];
$maxPage = ceil($numrows/$broinastranica);
$self = $_SERVER['PHP_SELF'];
$nomeranastranici = '';
for($page = 1; $page <= $maxPage; $page++)
{
if ($page == $pageNum)
{
$nomeranastranici .= " $page ";
}
else
{
$nomeranastranici .= " <a href=\"$self?page=$page\">$page</a> ";
}
}
if ($pageNum > 1)
{
$page = $pageNum - 1;
$predishna = " <a href=\"$self?page=$page\"> [<<<<<] </a> ";
$parva = " <a href=\"$self?page=1\">[първа]</a> ";
}
else
{
$predishna = ' ';
$parva = ' ';
}
if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$sledvashta = " <a href=\"$self?page=$page\"> [>>>>>] </a> ";
$posledna = " <a href=\"$self?page=$maxPage\">[последна]</a> ";
}
else
{
$sledvashta = ' ';
$posledna = ' ';
}
echo "<br><br>".$parva . $predishna . $nomeranastranici . $sledvashta . $posledna;
?>
</tr>
<br/>
 
Код: 
 <?php
include "conf.php";
$the_limit = "30";
$listed = "";
$listed_end = ""; 
$sql = mysql_query("SELECT * FROM `1` ORDER BY `id` DESC") or die(mysql_error());
while ($row = mysql_fetch_array($sql)) {
if ($admin==$_SERVER['REMOTE_ADDR']) { $delete = " <a href=del.php?id=$row[id]>-изтрий-</a>"; }

echo " <table class=\"chats\" width=\"98%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"><tr>
  <td width=\"50%\" align=left class=forumlink><strong>".$row[nick]."</strong></td>
  <td width=\"50%\" align=right class=\"genmed\"><strong>".date("H:i:s",$row['time'])."<br>".date("d.m.y",$row['time'])."</strong></td></tr>";
$message = $row[message];
$message = str_replace(":biggrin:","<img border=0 src=smiles/icon_biggrin.gif>","$message");
$message = str_replace(":confused:","<img border=0 src=smiles/icon_confused.gif>","$message");
$message = str_replace(":cool:","<img border=0 src=smiles/icon_cool.gif>","$message");
$message = str_replace(":cry:","<img border=0 src=smiles/icon_cry.gif>","$message");
$message = str_replace(":eek:","<img border=0 src=smiles/icon_eek.gif>","$message");
$message = str_replace(":evil:","<img border=0 src=smiles/icon_evil.gif>","$message");
$message = str_replace(":exclaim:","<img border=0 src=smiles/icon_exclaim.gif>","$message");
$message = str_replace(":idea:","<img border=0 src=smiles/smiles/icon_idea.gif>","$message");
$message = str_replace(":lol:","<img border=0 src=smiles/icon_lol.gif>","$message");
$message = str_replace(":mad:","<img border=0 src=smiles/icon_mad.gif>","$message");
$message = str_replace(":mrgreen:","<img border=0 src=smiles/icon_mrgreen.gif>","$message");
$message = str_replace(":neutral:","<img border=0 src=smiles/icon_neutral.gif>","$message");
$message = str_replace(":question:","<img border=0 src=smiles/icon_question.gif>","$message");
$message = str_replace(":redface:","<img border=0 src=smiles/icon_redface.gif>","$message");
$message = str_replace(":rolleyes:","<img border=0 src=smiles/icon_rolleyes.gif>","$message");
$message = str_replace(":sad:","<img border=0 src=smiles/icon_sad.gif>","$message");
$message = str_replace(":smile:","<img border=0 src=smiles/icon_smile.gif>","$message");
$message = str_replace(":wink:","<img border=0 src=smiles/icon_wink.gif>","$message");
$message = str_replace(":twisted:","<img border=0 src=smiles/icon_twisted.gif>","$message");
$message = str_replace(":razz:","<img border=0 src=smiles/icon_razz.gif>","$message");
$message = str_replace(":surprised:","<img border=0 src=smiles/icon_surprised.gif>","$message");
$message = str_replace(":arrow:","<img border=0 src=smiles/icon_arrow.gif>","$message");

echo " <tr><td colspan=\"2\" class=\"genmed\">".$message."".$delete."</td></tr>
 </table><hr width=99%>";
}
$page = trim($_GET['page']);
if(is_numeric($page)){
$page = $page * $the_limit;
if( (!$page) or ($page == "0") ){
$a = "0";
$b = $the_limit;
} else {
$a = $page;
$b = $a + $the_limit;
}
} else {
$a = "0";
$b = $the_limit;
}


$query = $sql." limit $a, $the_limit";
$result = mysql_query($query, $conn) or die (mysql_error());
$result_all = mysql_query($sql, $conn) or die (mysql_error());
$num_all = mysql_num_rows($result_all);
while($red = mysql_fetch_array($result)){
$listed.= $red['grad'].", ";
}
$num_pages = ceil($num_all / $the_limit);
for($i=0;$i<$num_pages;$i++){
$name = $i;
$name++;
if($name != $num_pages){
$last = " | ";
} else $last = "";


$pages.= "<a href=\"?page=".$i."\">".$name."</a>".$last;
}


echo "Показване на резултати от ".$a." до ".$b."<br /><br />";
echo $listed.$listed_end;
echo "<br /><br />";
echo $pages;
?>
</tr>
<br/>
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе