Forum Moderators: coopster
<?php
/*
var$dbhost= "localhost";
var$dbuser= "root";
var$dbpass= "";
var $dbname= "mpcb";
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ("Error connecting to database");
mysql_select_db($dbname);
*/
class connect
{
var$dbhost;
var$dbuser;
var$dbpass;
var $dbname;
var $conn;
var $database;
var $Host = "localhost";// Hostname of our MySQL server
var $Database ="mpcb";// Logical database name on that server
var $User = "root";// Database user
var $Password = " ";// Database user's password
var $Link_ID = 0;// Result of mysql_connect()
var $Query_ID = 0;// Result of most recent mysql_query()
var $Record= array();// Current mysql_fetch_array()-result
var $Row;// Current row number
var $Errno = 0;// Error state of query
var $Error = "";
function connect()
{
$dbhost= "localhost";
$dbuser= "root";
$dbpass= "";
$dbname= "mpcb";
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ("Error connecting to database");
$database=mysql_select_db($dbname);
}
}
?>
<!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 type="text/css">
.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;
}
tr{
padding:4px;
margin-bottom:3px;
background-color:#FCC;
list-style:none;}
tr{margin:6px;
padding:0px;}
</style>
</head>
<body>
<?php
$link = '| <a href="http://papermashup.com/easy-php-pagination/">Back To Tutorial</a>';
?>
<?php
//require('include/session.class.php');
include('include/connect.php');
//$sessTest= new sessions();
$dbtest=new connect;// database obj
$tableName="countries";
$targetpage = "index.php";
$limit = 10;
$SQry='SELECT Name,Address,EICNo,scan_copy,grantdate FROM consent where scan_copy <> " " order by grantdate asc';
$que ='SELECT COUNT(*) as num FROM consent';
$query=$dbtest->query($SQry);
echo '<br />first query: '.$query.'<Br />';
$qu=$dbtest->query($que);
echo '<br />'.$que.'<Br />';
$total_pages = mysql_fetch_array(mysql_query($query));
$total_pages = $total_pages['num'];
$stages = 3;
$page = mysql_escape_string($_GET['page']);
if($page){
$start = ($page - 1) * $limit;
}else{
$start = 0;
}
// Get page data
$query1 = "SELECT * FROM consent 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 "<table border=1 width=100%>";
echo('<tr ><td width =100>'.$row['SrNo'].'</td>');
echo('<td width =500>'.$row['Name'].'</td>');
echo('<td width =100>'.$row['EICNo'].'</td>');
echo('<td width =600> '.$row['Address'].'</td>');
echo('<td>'.$row['grantdate'].'</td>');
echo("<td><a href=".$row['scan_copy']."><img src ='http://uwau.org/files/pdf-icon.jpg' width=75 height=50 alt='download here'></a></td>");
/*
echo '<table border="1" width="300"><tr>';
echo '<td width="200">'.$row['id'].'</td>';
echo '<td width="200">'.$row['name'].'</td>';
echo '<td width="200">'.$row['mark'].'</td>';
*/
echo "</tr></table>";}
?>
</ul>
</body>
</html>
$total_pages = mysql_fetch_array(mysql_query($query));
$page = mysql_escape_string($_GET['page']);
