<!-- /* Font Definitions */ @font-face {font-family:宋体; panose-1:2 1 6 0 3 1 1 1 1 1; mso-font-alt:SimSun; mso-font-charset:134; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:3 135135232 16 0 262145 0;} @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:-1610611985 1107304683 0 0 159 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-1610611985 1073750139 0 0 159 0;} @font-face {font-family:"/@宋体"; panose-1:2 1 6 0 3 1 1 1 1 1; mso-font-charset:134; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:3 135135232 16 0 262145 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; text-align:justify; text-justify:inter-ideograph; mso-pagination:none; font-size:10.5pt; mso-bidi-font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-fareast-font-family:宋体; mso-bidi-font-family:"Times New Roman"; mso-font-kerning:1.0pt;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; font-size:10.0pt; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt; mso-ascii-font-family:Calibri; mso-fareast-font-family:宋体; mso-hansi-font-family:Calibri; mso-font-kerning:0pt;} /* Page Definitions */ @page {mso-page-border-surround-header:no; mso-page-border-surround-footer:no;} @page Section1 {size:595.3pt 841.9pt; margin:72.0pt 90.0pt 72.0pt 90.0pt; mso-header-margin:42.55pt; mso-footer-margin:49.6pt; mso-paper-source:0; layout-grid:15.6pt;} div.Section1 {page:Section1;} -->
页面共有 个,包括 goods_list.html 202.js
其中的 goods_list.html 代码
<script language="javascript" src="js/202.js"></script>
<body οnlοad="dostart('<{$page}>','goods_list2.php')">
<br/>
<br/>
<div id="pages"></div>
</body>
202.js 中的代码
function dostart(id,url) {
createXMLHttpRequest();
var url = url+"?page="+id+"&urla="+url;
//alert(url);
XMLHttp.open("GET",url,true);
XMLHttp.onreadystatechange = readusr;
//XMLHttp.setRequestHeader("Content-Type","application/x-www-form-urlencoded;");
XMLHttp.send(null);
}
/**
* @desc Recieve dates from Server
*/
function readusr() {
if(XMLHttp.readyState == 4) {
if(XMLHttp.status == 200){
//alert(XMLHttp.responseText);
document.getElementById('pages').innerHTML=XMLHttp.responseText;
}
}
/**
* 商品品牌
*/
function dis(id)
{
talktoServer("brand_list2.php?hid="+id,"pages",false);
}
//--------------------------------------- 上架 / 精品 / 新品 / 热销
function disbest(id,shangjiaid,page)
{
talktoServer('goods_list2.php?shangjiaid='+shangjiaid+'&id='+id+'&page='+page+'&urla=goods_list2.php',"pages",false);
}
在 goods_list2.php 中的代码
require('include/ajax_pageft.php'); // 引用分页类
//------------------------------------------------ 上架 / 精品 / 新品 / 热销 start
if($_GET['shangjiaid']){
$id = $_GET['id'];
$shangjiaid = intval($_GET['shangjiaid']);
$sqlshangjia = "select * from `behavior` where `goods_id` ='".$id."'and `behdefine_id`='".$shangjiaid."'";
$queryshangjia = $db->query($sqlshangjia);
$rsshangjia = mysql_fetch_array($queryshangjia);
if($rsshangjia['display']==1){
$sql = "update `behavior` set `display`='0' where `goods_id` ='".$id."' and `behdefine_id`='".$shangjiaid."'";
$query = $db->query($sql);
//echo $sql;
}
if($rsshangjia['display']==0){
$sql = "update `behavior` set `display`='1' where `goods_id` ='".$id."' and `behdefine_id`='".$shangjiaid."'";
$query = $db->query($sql);
//echo $sql;
}
}
//------------------------------------------------end
查询条数的 sql 语句
from `goods` as `g` where `recover`=0";
$query = $db->query($sql);
$num = $db->num_rows($query);
//-------------
if($_GET['page'])
$page = $_GET['page'];
else
$page = 1;
pageft($num,5);
if($firstcount<0)
$firstcount=0;
?>
分页 limit 的 sql 语句
from `goods` as `g` where `recover`=0 limit ".$firstcount.",5";
$query = $db->query($sql);
while($rs= mysql_fetch_array($query))
{
?>
结尾: <?echo $pagenav?>
在点击即点即改时执行的代码为上面红色的部分 disbest 将分页的页码值传过去,在 goods_list2.php 中接受传过的 page 值