как да страницизирам този код

B

bankera1990

Registered
Код: 
<?php 
$user=$_SESSION['username']; 
echo"<center><div aling=\"center\"><b><a href=\"index.php?m=love\"><font color=\"red\">Любими Песни</font></a> | <a href=\"index.php?m=love&ext=lovealbum\">Любими Албуми</a> | <a href=\"index.php?m=love&ext=lovevideo\">Любими Клипове</a></b></div><br />"; 
$db=mysql_query("SELECT * FROM users WHERE username='$user'"); 
while ($r=mysql_fetch_array($db)) 
{ 
$id=$r['id']; 
}
$sql=mysql_query ("SELECT * FROM love WHERE idu='$id'"); 
$love=mysql_num_rows($sql); 
if ($love > 0) 
{
$i="0";
$nared="5";
echo '<table align="center" border="0">'; 
while ($r=mysql_fetch_array($sql)) 
{
$idf=$r['idf']; 
$sql2=mysql_query ("SELECT * FROM songs WHERE id='$idf'"); 
while ($r2=mysql_fetch_array($sql2))
{ 
$i++;
$width=ceil(100/$nared);
$id=$r['id']; 
$name=$r2['name'];
$name1=$r2['name'];
if (strlen($name1)>15)
{$t='...';}
$name1 = substr($name1,0,15);
$link=mysql_query ("SELECT link FROM songs WHERE id='$idf'") or die(mysql_error()); 
$linkrow=mysql_fetch_array($link); 
{
$pick=mysql_query ("SELECT pick FROM songs WHERE id='$idf'") or die(mysql_error()); 
$pickrow=mysql_fetch_array($pick); 
if($pickrow[pick] == NULL)
{
echo "
<td width='140' align='center' border='1' background='$rk2' class='input'>
<a href='index.php?m=play&id=$idf' title='$name'><img src='images/noavatar.jpg' height='120px' width='125px' alt='$name' style='border:2px solid #13B1E1;'></img></a>

<object type=\"application/x-shockwave-flash\" data=\"modules/dewplayer-rect.swf\" width=\"61\" height=\"20\" id=\"dewplayer\" name=\"dewplayer\">
<param name=\"wmode\" value=\"transparent\" />
<param name=\"movie\" value=\"modules/dewplayer-rect.swf\" />
<param name=\"flashvars\" value=\"mp3=$linkrow[link]&autostart=0&autoreplay=0&showtime=1&bgcolor=\"/>
</object>

<a href='index.php?m=play&id=$idf'><center>$name1$t</center></a><br />
<a href='index.php?m=love&id=$id&b=delete&id=$r[id]'>Премахни от Любими</a></td>"; 
} 
else 
{ 
echo "<td width='140' align='center' border='1' background='$rk2' class='input'>
<a href='index.php?m=play&id=$idf' title='$name'><img src='$pickrow[pick]' height='120px' width='125px' alt='$name' style='border:2px solid #13B1E1;'></img></a>

<object type=\"application/x-shockwave-flash\" data=\"modules/dewplayer-rect.swf\" width=\"61\" height=\"20\" id=\"dewplayer\" name=\"dewplayer\">
<param name=\"wmode\" value=\"transparent\" />
<param name=\"movie\" value=\"modules/dewplayer-rect.swf\" />
<param name=\"flashvars\" value=\"mp3=$linkrow[link]&autostart=0&autoreplay=0&showtime=1&bgcolor=\"/>
</object>

<a href='index.php?m=play&id=$idf'><center>$name1$t</center></a><br />
<a href='index.php?m=love&id=$id&b=delete&id=$r[id]'>Премахни от Любими</a></td>"; 
} 
if ($i==$nared)
{
echo "</tr>
<tr>";
$i=0;
}
} }
} 
echo '</table>';
} 
else 
{ 
echo "Няма Любими песни във вашият списък !"; 
}
?>

как да добавя страницизиране в този файл искам да го добавя защото ако станат 30 или повече записа :# ще стане много искам да ми изкарва по 10 на страничка :)
 
<?php
$user=$_SESSION['username'];
echo"<center><div aling=\"center\"><b><a href=\"index.php?m=love\"><font color=\"red\">Любими Песни</font></a> | <a href=\"index.php?m=love&ext=lovealbum\">Любими Албуми</a> | <a href=\"index.php?m=love&ext=lovevideo\">Любими Клипове</a></b></div><br />";
$db=mysql_query("SELECT * FROM users WHERE username='$user'");
while ($r=mysql_fetch_array($db))
{
$id=$r['id'];
}
$sql=mysql_query ("SELECT * FROM love WHERE idu='$id'");
$love=mysql_num_rows($sql);
if ($love > 0)
{
$i="0";
$nared="5";
echo '<table align="center" border="0">';
while ($r=mysql_fetch_array($sql))
{
$idf=$r['idf'];
$rq = mysql_query("SELECT * FROM `songs` WHERE id='$idf'");
$limit = 10;
$broi = mysql_num_rows($rq);
if((int)$_GET['page']>0) {
$page=(int)$_GET['page'];
}
else {
$page=0;
}
$maxpage = ceil($broi/$limit);
$sql2=mysql_query ("SELECT * FROM songs WHERE id='$idf' LIMIT ".$limit*$page.", ".$limit."");
while ($r2=mysql_fetch_array($sql2))
{
$i++;
$width=ceil(100/$nared);
$id=$r['id'];
$name=$r2['name'];
$name1=$r2['name'];
if (strlen($name1)>15)
{$t='...';}
$name1 = substr($name1,0,15);
$link=mysql_query ("SELECT link FROM songs WHERE id='$idf'") or die(mysql_error());
$linkrow=mysql_fetch_array($link);
{
$pick=mysql_query ("SELECT pick FROM songs WHERE id='$idf'") or die(mysql_error());
$pickrow=mysql_fetch_array($pick);
if($pickrow[pick] == NULL)
{
echo "
<td width='140' align='center' border='1' background='$rk2' class='input'>
<a href='index.php?m=play&id=$idf' title='$name'><img src='images/noavatar.jpg' height='120px' width='125px' alt='$name' style='border:2px solid #13B1E1;'></img></a>

<object type=\"application/x-shockwave-flash\" data=\"modules/dewplayer-rect.swf\" width=\"61\" height=\"20\" id=\"dewplayer\" name=\"dewplayer\">
<param name=\"wmode\" value=\"transparent\" />
<param name=\"movie\" value=\"modules/dewplayer-rect.swf\" />
<param name=\"flashvars\" value=\"mp3=$linkrow[link]&autostart=0&autoreplay=0&showtime=1&bgcolor=\"/>
</object>

<a href='index.php?m=play&id=$idf'><center>$name1$t</center></a><br />
<a href='index.php?m=love&id=$id&b=delete&id=$r[id]'>Премахни от Любими</a></td>";
}
else
{
echo "<td width='140' align='center' border='1' background='$rk2' class='input'>
<a href='index.php?m=play&id=$idf' title='$name'><img src='$pickrow[pick]' height='120px' width='125px' alt='$name' style='border:2px solid #13B1E1;'></img></a>

<object type=\"application/x-shockwave-flash\" data=\"modules/dewplayer-rect.swf\" width=\"61\" height=\"20\" id=\"dewplayer\" name=\"dewplayer\">
<param name=\"wmode\" value=\"transparent\" />
<param name=\"movie\" value=\"modules/dewplayer-rect.swf\" />
<param name=\"flashvars\" value=\"mp3=$linkrow[link]&autostart=0&autoreplay=0&showtime=1&bgcolor=\"/>
</object>

<a href='index.php?m=play&id=$idf'><center>$name1$t</center></a><br />
<a href='index.php?m=love&id=$id&b=delete&id=$r[id]'>Премахни от Любими</a></td>";
}
if ($i==$nared)
{
echo "</tr>
<tr>";
$i=0;
}
} }
}
echo '</table>';
for($i=0;$i<$maxpage;$i++) {
echo "<a href='?page=$i'> ".($i+1)."</a>";
}
}
else
{
echo "Няма Любими песни във вашият списък !";
}
?>
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе