Hi, I've tried a few forums to get help but most forums seem dead or have lazy helpers so I thought i'd try here
I am trying to convert an old pagination script to work with php5 or higher. I believe this script or similar has been discussed before on this forum but I thought I'd start a new topic. Not all of the script needs converting, only a few lines which contain mysql_ ect
This is the script i am working with but havnt included the config file but the info can be provided if needed.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Papermashup.com | PHP Pagination</title>
<link href="../style.css" rel="stylesheet" type="text/css" />
<style>
.paginate {
font-family:Arial, Helvetica, sans-serif;
padding: 3px;
margin: 3px;
}
.paginate a {
padding:2px 5px 2px 5px;
margin:2px;
border:1px solid #999;
text-decoration:none;
color: #666;
}
.paginate a:hover, .paginate a:active {
border: 1px solid #999;
color: #000;
}
.paginate span.current {
margin: 2px;
padding: 2px 5px 2px 5px;
border: 1px solid #999;
font-weight: bold;
background-color: #999;
color: #FFF;
}
.paginate span.disabled {
padding:2px 5px 2px 5px;
margin:2px;
border:1px solid #eee;
color:#DDD;
}
li{
padding:4px;
margin-bottom:3px;
background-color:#FCC;
list-style:none;}
ul{margin:6px;
padding:0px;}
</style>
</head>
<body>
<?php
require('includes/config.php');
$targetpage = 'pagination.php';
$limit = 10;
$stmt = $db->prepare("SELECT COUNT(*) as num FROM members");
$stmt->bindParam(':members', $q, PDO::PARAM_INT);
$stmt->execute();
$total_pages = $stmt->fetchColumn(0);
$stages = 3;
$page = (isset($_GET["page"])) ? (int)$_GET["page"] : 1;
if($page){
$start = ($page - 1) * $limit;
}else{
$start = 0;
}
// Get page data
$query1 = "SELECT * FROM members LIMIT $start, $limit";
$result = mysql_query($query1);
// Initial page num setup
if ($page == 0){$page = 1;}
$prev = $page - 1;
$next = $page + 1;
$lastpage = ceil($total_pages/$limit);
$LastPagem1 = $lastpage - 1;
$paginate = '';
if($lastpage > 1)
{
$paginate .= '<div class="paginate">';
// Previous
if ($page > 1){
$paginate.= '<a href="$targetpage?page=$prev">previous</a>';
}else{
$paginate.= '<span class="disabled">previous</span>'; }
// Pages
if ($lastpage < 7 + ($stages * 2)) // Not enough pages to breaking it up
{
for ($counter = 1; $counter <= $lastpage; $counter++)
{
if ($counter == $page){
$paginate.= '<span class="current">$counter</span>';
}else{
$paginate.= '<a href="$targetpage?page=$counter">$counter</a>';}
}
}
elseif($lastpage > 5 + ($stages * 2)) // Enough pages to hide a few?
{
// Beginning only hide later pages
if($page < 1 + ($stages * 2))
{
for ($counter = 1; $counter < 4 + ($stages * 2); $counter++)
{
if ($counter == $page){
$paginate.= '<span class="current">$counter</span>';
}else{
$paginate.= '<a href="$targetpage?page=$counter">$counter</a>';}
}
$paginate.= '...';
$paginate.= '<a href="$targetpage?page=$LastPagem1">$LastPagem1</a>';
$paginate.= '<a href="$targetpage?page=$lastpage">$lastpage</a>';
}
// Middle hide some front and some back
elseif($lastpage - ($stages * 2) > $page && $page > ($stages * 2))
{
$paginate.= '<a href="$targetpage?page=1">1</a>';
$paginate.= '<a href="$targetpage?page=2">2</a>';
$paginate.= '...';
for ($counter = $page - $stages; $counter <= $page + $stages; $counter++)
{
if ($counter == $page){
$paginate.= '<span class="current">$counter</span>';
}else{
$paginate.= '<a href="$targetpage?page=$counter">$counter</a>';}
}
$paginate.= '...';
$paginate.= '<a href="$targetpage?page=$LastPagem1">$LastPagem1</a>';
$paginate.= '<a href="$targetpage?page=$lastpage">$lastpage</a>';
}
// End only hide early pages
else
{
$paginate.= '<a href="$targetpage?page=1">1</a>';
$paginate.= '<a href="$targetpage?page=2">2</a>';
$paginate.= '...';
for ($counter = $lastpage - (2 + ($stages * 2)); $counter <= $lastpage; $counter++)
{
if ($counter == $page){
$paginate.= '<span class="current">$counter</span>';
}else{
$paginate.= '<a href="$targetpage?page=$counter">$counter</a>';}
}
}
}
// Next
if ($page < $counter - 1){
$paginate.= '<a href="$targetpage?page=$next">next</a>';
}else{
$paginate.= '<span class="disabled">next</span>';
}
$paginate.= '</div>';
}
echo $total_pages.' Results';
// pagination
echo $paginate;
?>
<ul>
<?php
while($row = mysql_fetch_array($result))
{
echo '<li>'.$row['username'].'</li>';
}
?>
</ul>
</body>
</html>
the error i am getting is this: Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\pagination.php on line 188
the url I am testing it on is this: http://www.finchkeeper.com/pagination.php
I would appreciate what help I can get with this, it would be great to have this topic marked as [solved]. thanks