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

php ajax 静态分页过程形式
PHP中文网
Release： 2016-05-25 17:13:26
Original
1355 people have browsed it
跳至
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
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
php ajax 静态分页 过程形式

php ajax 静态分页过程形式
