November 9, 200916 yr What do other people use for portfolio scripts i currently just use the following where i calls a fews things from a database and limits it to 5 per page any one got any better? <?php $page = $_GET['page']; if(!$page || $page == 0 || !is_numeric($page)){ $page = 1; } $limit = 5; class paginate{ function init($limit, $page){ $query1 = mysql_query("SELECT * FROM portfolio"); $total_pages = ceil(mysql_num_rows($query1)/$limit); $prev = '<a href="?page=' . ($page-1) . '">Prev</a>'; $next = '<a href="?page=' . ($page+1) . '">Next</a>'; if($page <= 1){ $page = 1; $prev = ''; } elseif($page >= $total_pages){ $page = $total_pages; $next = ''; } if($page > 2){ $prev = '<a href="?page=1">First</a> ' . $prev; } if($page < ($total_pages - 1)){ $next = $next . ' <a href="?page=' . $total_pages . '">Last</a>'; } $start = ($limit*($page-1)); $query2 = mysql_query("SELECT * FROM portfolio LIMIT $start, $limit") or die("Error In Query " . mysql_error()); $times_done=0; while($row = mysql_fetch_array($query2)) { if($times_done=='5'){ $content .= '<br><br>'; $times_done=1; } else{ $times_done++; } $content .= '<li>'.$row['name'].'<br/>'.'<a href="http://'.$row['address'].'"<img src="'.$row['image'].'"width="400" />'.'</a>'.'</li>'; } $content .= '<br><hr>' . $prev . ' Page ' . $page . '/' . $total_pages . ' ' . $next; return $content; } } $class = &new paginate; echo $class->init($limit, $page); ?>
Create an account or sign in to comment