一个很好使的分页js
1.sql
create table movies(id int not null auto_increment,
movieName varchar(64) not null,primary key(id));
insert into movies values(null,'a');
select * from movies;
2.index.php
<html>movieName varchar(64) not null,primary key(id));
insert into movies values(null,'a');
select * from movies;
2.index.php
<head><title>Top 100 movie</title>
<style type="text/css">
body{font-family:"Trebuchet MS",Verdana,Arail;width:400px;}
h3{margin:0;padding:0;}
ul{list-style:none;margin:10px 0;padding:0;border:1px solid #000;}
li{padding:5px}
#prev{float:left;width:100px;}
#next{float:right;width:100px;text-align:right;}
#navigation{float:left;text-align:center;margin-left:40px;}
select{width:100px;}
strong{cursor:pointer;text-decoration:underline;}
</style>
</head>
<body>
<h3>Top 100 movis voted by peole</h3>
<a href="http://dd/">movie</a>
<ul id="list">
<?php
$mysqli=new mysqli('localhost','root','','test');
$result=$mysqli->query('select * from movies');
if($result->num_rows>0)
{
while ($row=$result->fetch_array())
{
echo '<li>'.$row[0].' '.$row[1].'</li>';
}
}else{
echo 'no records';
}
?>
</ul>
<div id="navigation"></div>
<p> </p>
<script type="text/javascript" src="../jquery-1.4.2.js"></script>
<script type="text/javascript">
$(document).ready(function(){
var totalMovies=$('#list > li').length;
var moviesPerPage=10;
var totalPages=Math.ceil(totalMovies/moviesPerPage);
createNavigation();
setDataAndEvents();
function createNavigation()
{
var navHTML='<strong id="prev">Previous</strong>';
navHTML+='<div><select id="goTo"><option value="">Go to page</option>';
for(var i=0;i<totalPages;i++){
navHTML+='<option value="'+(i+1)+'">Page '+(i+1)+'</option>';
}
navHTML+='</select>';
navHTML+='</div>';
navHTML+='<strong id="next">Next</strong>';
$('#navigation').html(navHTML);
$('#prev').hide();
$('#goTo').val(1);
}
function setDataAndEvents()
{
$('#list').data('currentPage',1);
$('#list>li:gt('+(moviesPerPage-1)+')').hide();
$('#prev').click(function(){
var current=$('#list').data('currentPage');
goToPage(--current);
});
$('#next').click(function(){
var current=$('#list').data('currentPage');
goToPage(++current);
});
$('#goTo').change(function(){
if($.trim($(this).val())=='') return;
goToPage($(this).val());
});
}
function goToPage(pageNumber)
{
if(pageNumber==1) $('#prev').hide();else $('#prev').show();
if(pageNumber==totalPages) $('#next').hide();else $('#next').show();
$('#list').data('currentPage',pageNumber);
$('#goTo').val(pageNumber);
var from=(pageNumber-1)*moviesPerPage;
var to=from+(moviesPerPage-1);
$('#list>li').show();
$('#list>li:lt('+(from)+')').hide();
$('#list>li:gt('+(to)+')').hide();
}
});
</script>
</body>
</html>