php ajax static paging process form_PHP tutorial

Copy code The code is as follows: js end and judgment $(function(){ //var url=$(this)[0].location. href; //alert(url); goPageFirst(); $('#selpage').bind('change',goPage); }); // Return the current page number function getNowPage() { return parseInt($('#nowPage').html()); } //Return the number of items displayed on each page function getPer() { return $('#perPage').val(); } //Return the total number of records function getTotal() { return parseInt($('#total').html()); } //Return the total number of pages function getAllPage() { return parseInt( $('#allpage').html()); } //Combined string parameters function getData(act) { var target=1; var now=getNowPage()+1; var per=getPer(); var sum=getTotal(); var allpage=getAllPage(); switch(act) { case 'first': target=1; break; case 'prev': target=now>1?now-1:1; break; case 'next': target=now+1>allpage?now:1; break; case 'last': target=allpage>0?allpage:1; break ; case 'consstans': target=$('#selpage').val()>0?$('#selpage').val():1; default : target=1; } var data="check="+act+"&nowpage="+now+"&perpage="+per+'&target='+target; alert(data); return data; } //Execute the first page function goPageFirst() { var param=getData('first'); http_post(param); } //Execute the previous page function goPagePrev() { var param=getData('prev'); http_post(param); } //Execute the next page function goPageNext() { var param=getData('next'); http_post(param); } //Execute the last Page function goPageLast() { var param=getData('last'); http_post(param); } //Select to the specified page function goPage() { var param=getData('constans'); http_post(param); } //post request data loading function http_post(db) { $.post('./mysql.php',db,function(data){ responseAjax(data); },'text'); } //Return data processing function responseAjax(msg) { //alert(msg); //alert(msg.content); //$('# listDiv').html(msg.content); $('#listDiv').html(msg); } Server-side judgment and implementation //@autor 499188204@qq. com mb_internal_encoding('gb2312'); $con=mysql_connect("127.0.0.1","root","12345678") or die("Connection failed"); $m=mysql_select_db( "ec",$con); $sql = 'SELECT `attr_id`,`cat_id`,`attr_name` FROM `ecs_attribute` '; $rs = mysql_query($sql ); $count = mysql_num_rows($rs); //Return the total number of records //echo $count; //The total number of records //The number of records per page 10 //Find the total number of pages ceil ($count/10) //echo ' '; if(!isset($_POST['check'])) { $set['id' ]=0; die('no access please!'); } if(isset($_POST['perpage']) && $_POST['perpage']>0 ) { $per=$_POST['perpage']; } else { $per=15; } $page = ceil($count /$per); //echo $page; if(!isset($_POST['nowpage'])) { $nowPage=1; } else { $nowPage = $_POST['nowpage']; } $start = ($nowPage-1)*$per+1; $sql = 'select ` attr_id`,`cat_id`,`attr_name` from `ecs_attribute` limit '.$start.','. $per; //$sql = 'select `attr_id`,`cat_id`,`attr_name` from ` ecs_attribute` limit 10 offset 20'; $rs = mysql_query($sql );

$str = " Type number Attribute name "; while($row = mysql_fetch_assoc($rs) ){ $str .=' '.$row['attr_id'].' '.$row['cat_id'].'&lt ;/td> '.$row['attr_name'].' '; } $str.=" Total ".$count." ".$page." The current page of page ".$nowPage." Page, per page | First page Previous page Next page Last page "; for($i=1;$i { if($nowPage==$i) { $str .= " ".$i." "; } else { $str .= " ".$i." "; } } $str .=" "; echo mb_convert_encoding($str,'UTF-8','gb2312'); //$set['content']=$str; //echo json_encode($set); ?>

http://www.bkjia.com/PHPjc/324309.html www.bkjia.com true http://www.bkjia.com/PHPjc/324309.html TechArticle 复制代码 代码如下: js 端 及判断 script language='javascript' $(function(){ //var url=$(this)[0].location.href; //alert(url); goPageFirst(); $('#selpage').bind('change',...