<?php
$conn = mysql_connect(“localhost”,”root”,”") or die(“Error”.mysql_error());
mysql_select_db(“project”,$conn);
//print_r($_POST);
$qry = “SELECT * FROM image_gallery ORDER BY image_id DESC”;
$rslt = mysql_query($qry);
$numrows = mysql_num_rows($rslt);
if($_REQUEST['pageNo']!=”) {
$pageno = $_REQUEST['pageNo'];
} else {
$pageno = 1;
}
$rows_per_page = 2;
$lastpage = ceil($numrows/$rows_per_page);
$limit = ‘LIMIT ‘ .($pageno – 1) * $rows_per_page .’,’ .$rows_per_page;
$sql = $qry.” “. $limit = ‘LIMIT ‘ .($pageno – 1) * $rows_per_page .’,’ .$rows_per_page;
$sql_photo = mysql_query($sql);
?>
<!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=iso-8859-1″ />
<title>Untitled Document</title>
</head>
<body>
<form id=”form1″ name=”form1″ method=”post” action=”">
<table width=”50%” border=”1″ cellspacing=”15″ cellpadding=”15″ align=”center”>
<tr>
<td colspan=”3″ align=”center”><h3><font color=”#003366″>PAGINATION</font></h3></td>
</tr>
<tr>
<td>
<?php
if ($pageno == 1){ ?> <img src=”images/left_arrow.jpg” width=”28″ height=”29″ /> <?php
}else {
$prevpage = $pageno-1;
?>
<a href=”pagination.php?pageNo=<?php echo $prevpage; ?>” width=”28″ height=”29″ /><< Previous</a>
<?php } ?>
</td>
<td>
<?php
while($row = mysql_fetch_array($sql_photo)){ ?>
<img src=”images/<?php echo $row['image_name']; ?>” />
<?php } ?>
</td>
<td>
<?php if ($pageno == $lastpage) { ?> <img src=”images/right_arrow.jpg” width=”28″ height=”29″ />
<?php
} else { $nextpage = $pageno+1; ?>
<a href=”pagination.php?pageNo=<?php echo $nextpage; ?>” width=”28″ height=”29″ />Next >></a>
<?php } ?>
</td>
</tr>
</table>
</form>
</body>
</html>
