请教DWZ PHP网站后台换页问题

本帖最后由 gdljw 于 2013-03-30 11:45:59 编辑

dwz php 换页

最后搞PHP+DWZ做网站后台，网上找到这代码，试用正常可以换页,但是我想加一个条件caidid=caidid分页，直接在$sql= "select id,u_id,u_name,last_logintime,last_ip,last_imei,last_phone_number,last_logintype from users  where  CateId='$CateId2'  and $tiaojian like '%$neirong%'  order by $orderField {$orderDirection} limit {$fup_page},{$numPerPage}";

就换不了页了，请问要怎设置？

<?php require_once '../include/config.php';$connect = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD)                or die('Could not connect to mysql server.');        mysql_select_db(DB_DATABASE, $connect)                or die('Could not select database.');?><?phpecho '<form id="pagerForm" method="post" action="back/user.php"><input name="status" value="'.$status.'" type="hidden"><input name="keywords" value="'.$keywords.'" type="hidden"><input name="pageNum" value="1" type="hidden"><input name="numPerPage" value="'.$numPerPage.'" type="hidden"><input name="CateId2" value="'.$CateId2.'" type="hidden"><input name="orderField" value="'.$orderField.'" type="hidden"><input name="orderDirection" value="'.$orderDirection.'" type="hidden"></form>';//定义条件sql$CateId = get_CateId_by_UId( $UId );$tiaojian = empty($_POST["tiaojian"])?'u_name':$_POST["tiaojian"];$neirong = empty($_POST["keywords"])?"":$_POST["keywords"];$CateId2 =  empty($_POST["CateId2"])?'CateId':$_POST["CateId2"];$orderField = empty($_POST["orderField"])?"id":$_POST["orderField"];$query = mysql_query("select * from users");$totalCount   = mysql_num_rows($query);$pageNumShown=10;$_POST["pageNum"]!=""?$pageNum=$_POST["pageNum"]:$pageNum=1;$numPerPage=empty($_POST["numPerPage"])?20:$_POST["numPerPage"];$fup_page=($pageNum-1)*$numPerPage;$sql= "select id,u_id,u_name,last_logintime,last_ip,last_imei,last_phone_number,last_logintype from users  where $tiaojian like '%$neirong%'  order by $orderField {$orderDirection} limit {$fup_page},{$numPerPage}";$result = mysql_query($sql);?><div class="pageHeader">	<form onsubmit="return navTabSearch(this);" action="back/user.php" method="post">	<div class="searchBar">		<table class="searchContent">			<tr>				<td>					搜索内容：<input type="text" name="keywords" />				</td>				<td>					<select class="combox" name="tiaojian">						<option value="u_name">名称</option>						<option value="u_id">登录账户</option>					</select>				</td>			</tr>		</table>		<div class="subBar">			<ul>				<li><div class="buttonActive"><div class="buttonContent"><button type="submit">检索</button></div></div></li>			</ul>		</div>	</div>	</form></div><div class="pageContent">	<div class="panelBar">		<ul class="toolBar">			<li><a class="add" href="demo_page4.html" target="navTab"><span>添加项目</span></a></li>		</ul>	</div>	<table class="table" width="100%" layoutH="138">		<thead>			<tr>                                <th  width="20" align="center">用户名</th>                                <th  width="50" align="center">名称</th>				<th width="30" align="center">最后登录时间</th>				<th width="20" align="center">最后登录IP</th>				<th width="20" align="center">IMEI码</th>                                <th width="20" align="center">登录电话号码</th>                                <th width="10" align="center">登录类型</th>                                <th width="10" align="center">删除</th>			</tr>		</thead>		<tbody>                                    <?php                $i=1;                while($row=mysql_fetch_array($result)){             echo'<tr target="sid_user" >';            echo "<td>{$row[1]}</td>";            echo "<td>{$row[2]}</td>";            echo "<td>{$row[3]}</td>";            echo "<td>{$row[4]}</td>";            echo "<td>{$row[5]}</td>";            echo "<td>{$row[6]}</td>";            echo "<td>[<a href='javascript:delusers(".$row[0].")' onClick=\"return confirm('您确定要删除该帐号吗?');\">删除</a>]</td><td>";            echo'</tr>';            $i++;	 }                                ?>		</tbody>	</table>	<div class="panelBar">		<div class="pages">			<span>显示</span>			<select class="combox" name="numPerPage" onchange="navTabPageBreak({numPerPage:this.value})">				<option value="20">20</option>				<option value="50">50</option>				<option value="100">100</option>				<option value="200">200</option>			</select>			<span>条，共<?php echo $totalCount?>条</span>		</div>	<?php        echo '<div class="pagination" targettype="navTab" totalcount="'.$totalCount.'" numperpage="'.$numPerPage.'" pagenumshown="'.$pageNumShown.'" currentpage="'.$pageNum.'"></div>';        if ($_GET["command"] == "del") {    if (DB::delUser($_GET["uid"])) {        echo "<script>alert('删除成功!');</script>";    }else        echo "<script>alert('删除失败!');</script>";}if ($_GET["command"] == "delgroup") {    if (DB::deleteGroup($_GET["gid"])) {        echo "<script>alert('删除成功!');</script>";    }else        echo "<script>alert('删除失败!');</script>";}        ?>	</div></div><script>    function delusers(id){        var u_id =id;        $.ajax({             type: "POST",             url: "js_helper.php?option=deluser",            dataType: "json",             data: {"uid":u_id},             success: function(json){                 if(json.success==1){alert("删除成功！");}else{alert("删除失败！");}            },            error: function(xhr, desc, exception) {                alert(xhr + ":" + desc + ":" + exception);                        }        });      }</script>

回复讨论(解决方案)

又是自已解决。。

怎么解决的？

可否给源码参考下？

PHP+DWZ？
我们用的是PHP+