php ajax 静态分页过程形式-PHP源码-php.cn

Home

php教程

PHP源码

php ajax 静态分页过程形式

PHP中文网

May 25, 2016 pm 05:13 PM

跳至

js 端 及判断1?now-1:1;
	 break;
	 case &#39;next&#39;:
	      target=now+1>allpage?now:1;	 
	 break;
	 case &#39;last&#39;:
	     target=allpage>0?allpage:1;	 
	 break;
	 case &#39;constans&#39;:
		 target=$(&#39;#selpage&#39;).val()>0?$(&#39;#selpage&#39;).val():1;
	 default :
		 target=1;
    }
  var data="check="+act+"&nowpage="+now+"&perpage="+per+&#39;&target=&#39;+target;
  alert(data);
  return data;
}
//执行第一页
function goPageFirst()
{ 
   var param=getData(&#39;first&#39;);
   http_post(param);
}
//执行上一页
function goPagePrev()
{
  var param=getData(&#39;prev&#39;);
  http_post(param);
}
//执行下一页
function goPageNext()
{
  var param=getData(&#39;next&#39;);
   http_post(param);
}
//执行最后页
function goPageLast()
{
   var param=getData(&#39;last&#39;);
   http_post(param);
  
}
//选中到指定页面
function goPage()
{
    var param=getData(&#39;constans&#39;);
	http_post(param);
}
//post 请求数据加载
function http_post(db)
{
 $.post(&#39;./mysql.php&#39;,db,function(data){
     responseAjax(data);
  },&#39;text&#39;);
}

//返回数据的调处理
function responseAjax(msg)
{
	//alert(msg);
//alert(msg.content);
//$(&#39;#listDiv&#39;).html(msg.content);
$(&#39;#listDiv&#39;).html(msg);
}

server端 判断及实现

//@autor 499188204@qq.com
mb_internal_encoding(&#39;gb2312&#39;);
$con=mysql_connect("127.0.0.1","root","12345678") or die("连接失败");
$m=mysql_select_db("ec",$con);

$sql = &#39;SELECT `attr_id`,`cat_id`,`attr_name` 
FROM `ecs_attribute` &#39;;
$rs = mysql_query($sql );
$count =  mysql_num_rows($rs); //返回记录总数

//echo $count; //总记录数
//每页的记录数  10
//求总页数 ceil($count/10)
//echo &#39;&#39;;
if(!isset($_POST[&#39;check&#39;]))
{
$set[&#39;id&#39;]=0;
die(&#39;no access please!&#39;);
}
if(isset($_POST[&#39;perpage&#39;]) && $_POST[&#39;perpage&#39;]>0 )
{
	$per=$_POST[&#39;perpage&#39;];
}
else
{
    $per=15;
}
$page = ceil($count/$per);
//echo $page;
if(!isset($_POST[&#39;nowpage&#39;]))
{
 $nowPage=1;
}
else
{
$nowPage = $_POST[&#39;nowpage&#39;];
}

$start = ($nowPage-1)*$per+1;
 
  $sql = &#39;select `attr_id`,`cat_id`,`attr_name` from `ecs_attribute` limit &#39;.$start.&#39;,&#39;. $per;
//$sql = &#39;select `attr_id`,`cat_id`,`attr_name` from `ecs_attribute` limit 10  offset 20&#39;;

$rs = mysql_query($sql );




$str = "属性编号类型编号属性名字";
while($row = mysql_fetch_assoc($rs)){
$str .=&#39;&#39;.$row[&#39;attr_id&#39;].&#39;&#39;.$row[&#39;cat_id&#39;].&#39;&#39;.$row[&#39;attr_name&#39;].&#39;&#39;;
}
$str.="总计".$count."个记录分为".$page."页当前第".$nowPage."页,每页 | 第一页 上一页 下一页 最末页 ";
for($i=1;$i ".$i."";
	}
	else
	{
		$str .= "".$i."";
	}
}
$str .="";
echo mb_convert_encoding($str,&#39;UTF-8&#39;,&#39;gb2312&#39;);
//$set[&#39;content&#39;]=$str;
//echo json_encode($set);
?>		            		        	
				.code_report{float:right}
				.code_report p{ float: left; margin-left: 5px; background: url("/img/ask-icon.gif") no-repeat; padding: 6px 0 6px 15px; padding-left: 15px; height: 16px;}
				.code_report a{ background: url("/img/ask-icon.gif") 0 -160px no-repeat;padding-left: 20px; line-height: 15px;height: 16px; color: #333; text-decoration: none; display:inline-block; zoom:1; vertical-align: middle;}
				.code_report em{ height: 28px; line-height:28px; width: 14px; display: inline-block; float: left; background: url("/img/ask-icon.gif") top right;}
			" _ue_custom_node_="true">

Copy after login

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn