Странициране
- Автор Blagoicho
- Начална дата
Код:
<?php
//Попълвате данните за свързване
$connect = mysql_connect("localhost", "", "");
$select_db = mysql_select_db("haznata_lyrics");
mysql_query('set names cp1251',$connect);
$page = (int) $_GET['page'];
$max= "10";
$end = $page+$max;
if($_GET['id']){
$lyricid = $_GET['id'];
$query1 = "SELECT * FROM `lyrics` where id = '$lyricid'";
$result1=mysql_query($query1);
while($r = mysql_fetch_array($result1)) {
extract($r);
$text2 = nl2br("$text");
echo "$izpulnitel - $pesen<br><br><br>$text2<br><br><a href='$link'>Свали песента!</a>";
}
}
else {
$query = "SELECT * FROM `lyrics` ORDER BY id DESC LIMIT $page,$end";
$result=mysql_query($query);
while($r = mysql_fetch_array($result)) {
extract($r);
echo "<a href='view.php?id=$id'>$izpulnitel - $pesen</a><br>";
}
$next = $end+1;
$prev = $page-10;
echo "<a href=\"view.php?page=".$next."\">следваща</a>";
echo "<a href=\"view.php?page=".$prev."\">предишна</a>";
}
?>