how to display the images in the table with paging

hi can any one tell how to display the images in the table with paging
this what i did i am getting all the images in one page it self
i need only 9 images in one page and at the bottom i need the navigation bar
please help me out

here is my code

<html>
<title> Fox Innovas </title>
<body bgcolor="black">
<table BORDERCOLOR="#C6C6C6" width="100%" bgcolor='darkblue'>
<tr width="60%"><td bgcolor="DarkBlue">Hakman & Co </td>
<td>
<tr></tr>
<tr>
<td width="65%"></td>
<td width="10%" align="Right"><a href="hakman3.php">Login Page Ś</a></td>
<td width="15%" align="Right"><a href="about.php">About FoxInnovas Ś</a></td>
<td width="11%" align="Left" ><a href="contact.php">Contact Us</a></td>
</tr>
</td>
</tr>

</table>

<?php
function connect()
{
$dbhost='localhost';
$dbuser='';
$dbpass='';
$conn= mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql'.mysql_error());
$dbname='hakman';
mysql_select_db($dbname);
return $conn;
}
?>
<form method='GET' action='img.php'>
<?php
$c=connect();
$query="select img_name from styles";
$sql=mysql_query($query);
$result=mysql_num_rows($sql);

//echo ''.$result.'';

$limit=6;
$nrow=ceil($result/6); //no of rows we get
$npages=ceil($result/$limit); // no of pages we get

//echo ''.$nrow.' ';

//echo ''.$npages.' ';

$page=1;
$query=mysql_query("select img_name from styles LIMIT ".($page-1)*$limit.",$limit");

echo '<table border="5" align="center" width="55%" height="60%" BORDERCOLOR="#C6C6C6" >';
for($r=1;$r<=$nrow;$r++)
{
echo '<tr>';
for($d=1;$d<=3;$d++)
{
$obj=mysql_fetch_object($sql);
$imageSrc=$obj->img_name;
$cimage="images/".$obj->img_name;
echo '<td border="1" width="25px" height="25px" name="img1"><a href="img.php?src='.$imageSrc.'"><img width="187px" height="109px" src='.$cimage.'></a></td>';
}
echo '</tr>';
}
echo '</table>';

$Nav="";
If($page > 1)
{
$Nav .= "<A HREF=\"styl.php?page=" . ($page-1) . urlencode($query) . "\"><< Prev</A>";
}
For($i = 1 ; $i <= $NumberOfPages ; $i++)
{
If($i == $page)
{
$Nav .= "$i";
}
Else
{
$Nav .= "<A HREF=\"styl.php?page=" . $i .urlencode($query) . "\">$i</A>";
}
}
If($page < $NumberOfPages)
{
$Nav .= "<A HREF=\"styl.php?page=" . ($page+1) . urlencode($query) . "\">Next >></A>";
}

Echo " " . $Nav;
?>

</form>
<a href="hakman3.php">Back to login Page</a>
</body>
</html>

thanks in advance

[edited by: eelixduppy at 1:22 pm (utc) on Sep. 10, 2008]
[edit reason] removed credentials [/edit]

how to display the images in the table with paging

ravii

d40sithui

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week