Php Pagination

Posted on by

paggination

<html xmlns=”http://www.w3.org/1999/xhtml”&gt;
<head>

<style type=”text/css”>
#content {
width: 900px;
margin: 0 auto;
font-family: Arial, Helvetica, sans-serif;
}
/*pagginaion stat here*/
.admin_pagination {
float: right;
left: 0;
padding-top: 2px;
position: relative;
top: 0;
width: auto;
padding-left:10px;
}
.admin_pagination ul {
list-style: none outside none;
margin: 0;
padding:0;
}
.admin_pagination ul li {
display: inline;
margin:0 2px;
padding: 0;
}
.admin_pagination ul li.current a{
background-color: #6f6f6f;
border: 1px solid #6f6f6f;
color: #fff;
padding: 4px 7px;
text-decoration: none;

-moz-border-radius:4px;
-webkit-border-radius:4px;
-khtml-border-radiust:4px;
-o-border-radius:4px;
border-radius:4px;
}

.admin_pagination ul li a {
background-color: #fff;
color: #5A5A5A;
padding: 4px 7px;
text-decoration: none;

border: 1px solid #ccc;

-moz-border-radius:4px;
-webkit-border-radius:4px;
-khtml-border-radiust:4px;
-o-border-radius:4px;
border-radius:4px;
}
.admin_pagination ul li  a:hover{
background-color: #6f6f6f;
border: 1px solid #6f6f6f;
color: #fff;
padding: 4px 7px;
text-decoration: none;

-moz-border-radius:4px;
-webkit-border-radius:4px;
-khtml-border-radiust:4px;
-o-border-radius:4px;
border-radius:4px;
}
/*pagginaion end here*/

</style>

</head>
<body>
<div id=”content”>
<a href=”simple-php-pagination.php”>Go to Main Page</a>
<?php
$query1=@mysql_connect(“localhost”,”root”,””);
@mysql_select_db(“freeze_demo”,$query1);
$start=0;
$limit=8;
if(!isset($_GET[‘id’])){
$id=0;
$start=0;
}
else{
if(isset($_GET[‘id’]))
{
$id=$_GET[‘id’];
$start=($id-1)*$limit;
}
}
$query=@mysql_query(“select * from pagination LIMIT $start, $limit”);
echo “<ul>”;
while($sql=@mysql_fetch_array($query))
{
echo “<li>”.$sql[‘namefield’].”</li>”;
}
echo “</ul>”;
$totalrows=@mysql_num_rows(@mysql_query(“select * from pagination”));
$totalceil=ceil($totalrows/$limit);
echo ‘<div class=”admin_pagination”>’;
echo “<ul class=’page’>”;
if($id>1)
{
echo “<li><span><a href=’?id=”.($id-1).”‘ class=’previous’>PREVIOUS</a></span></li>”;
}
if($id!=$totalceil)
{
echo “<li><span><a href=’?id=”.($id+1).”‘ class=’next’>NEXT</a></span></li>”;
}

for($i=1;$i<=$totalceil;$i++)
{
if($i==$id) { echo “<li class=’current’><a>”.$i.”</a></li>”; }

else { echo “<li><a href=’?id=”.$i.”‘>”.$i.”</a></li>”; }
}
echo “</ul>”;
echo “</div>”;
?>
</div>
</body>
</html>

Leave a comment