关于搜索的问题 在第2部中你直接用URL来传递啊,只要传递你的条件变量和开始的记录变量,这样子就可以显示下一页了。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 1、$title = $POST['title'];$author = $_POST['author'];$postime = $_POST['postime'];if(empty($title.$author.$postime)) die("必须选择一个搜索条件"); //当然这件事应在浏览器用js完成2、session_start();if(提交) { $expr = ...//构造查询条件 $_SESSION['expr'] = $expr;}else $expr = $_SESSION['expr'];$sql = "SELECT * FORM table WHERE $expr LIMIT $start,$rows"; 我是这样写的$sql = "SELECT * FROM table WHERE ":if ($title) $sql .= "title LIKE '%$title%' ";if ($author) $sql .= "AND author = '$author' ";if ($potime) $sql .= "AND postime = '$postime' ";$sql .= "LIMIT $start, $rows DESC ";如果$title为空的话 $sql = "SELECT * FROM table WHERE AND author = '$author' AND postime = '$postime' ";这样不就错了吗,怎么解决呢? //构造查询条件$expr = "";if ($title) $expr .= "title LIKE '%$title%'";if ($author) $expr .= (empty($exrp)?"":" AND "). author = '$author'";if ($potime) $expr .= (empty($exrp)?"":" AND ")."postime = '$postime'";$sql = $sql = "SELECT * FROM table WHERE $exrp LIMIT $start, $rows DESC"; TP,控制器$this->只能调用当前控制器方法、属性。 PHP与ASP的哪个更实用 急问。这个怎么DIV + CSS怎么老是实现不了??? 平面内分布若干点,如何获得点最稠密的区域 验证码填写正确,却显示错误。刷新验证码后,再填写,不再报错,是不是和session有关? 这个错误怎么解决啊? <? php_track_vars?> 是何意思? 如何修改一个文件里面的内容? checkdate() 的用法?参数格式是什么??在线等候....... php+mysql可以处理亿级的数据吗? session 问题 有关日期问题
$title = $POST['title'];
$author = $_POST['author'];
$postime = $_POST['postime'];
if(empty($title.$author.$postime))
die("必须选择一个搜索条件"); //当然这件事应在浏览器用js完成2、
session_start();
if(提交) {
$expr = ...//构造查询条件
$_SESSION['expr'] = $expr;
}else
$expr = $_SESSION['expr'];$sql = "SELECT * FORM table WHERE $expr LIMIT $start,$rows";
$sql = "SELECT * FROM table WHERE ":
if ($title)
$sql .= "title LIKE '%$title%' ";
if ($author)
$sql .= "AND author = '$author' ";
if ($potime)
$sql .= "AND postime = '$postime' ";
$sql .= "LIMIT $start, $rows DESC ";如果$title为空的话
$sql = "SELECT * FROM table WHERE AND author = '$author' AND postime = '$postime' ";
这样不就错了吗,怎么解决呢?
$expr = "";
if ($title)
$expr .= "title LIKE '%$title%'";
if ($author)
$expr .= (empty($exrp)?"":" AND "). author = '$author'";
if ($potime)
$expr .= (empty($exrp)?"":" AND ")."postime = '$postime'";
$sql = $sql = "SELECT * FROM table WHERE $exrp LIMIT $start, $rows DESC";