Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $sqlCount = "select count(*) from album";
- $rsCount = mysql_fetch_array(mysql_query($sqlCount));
- $banyakData = $rsCount[0];
- $page = isset($_GET['page']) ? $_GET['page'] : 1;
- $limit = 10;
- $mulai_dari = $limit * ($page - 1);
- $query = mysql_query("SELECT * FROM album order by tgl_album desc LIMIT $mulai_dari, $limit");
- while ($Alb = mysql_fetch_array($query)) {
- $id_alb = $Alb[0];
- echo "<a href='showgaleri.php?album=$id_alb&page=$page' style='text-decoration:none'><font face='verdana' size='2' color='#FFF'>".$Alb[1]."</font></a><br/>";
- echo "<font face='verdana' size='1' color='#aaaaaa'>".$Alb[2]."</font><br/>";
- }
- $banyakHalaman = ceil($banyakData / $limit);
- echo '<font face="verdana" size="1" color="#000">Page: </font>';
- for($i = 1; $i <= $banyakHalaman; $i++){
- if($page != $i){
- $id_alb=$_GET['album'];
- echo '<font face="verdana" size="1" color="#fff"> [<a href="galeri.php?album='.$id_alb.'&page='.$i.'" style="text-decoration:none" >'.$i.'</a>] </font>';
- }else{
- echo '<font face="verdana" size="1" color="#fff">['.$i.']</font>';
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement