帮忙看下这个涵数控制排序的是哪几个语句?
public function getList($items) {
$orderby = empty($items['orderby']) ?' ORDER BY v.avatarflag DESC': $items['orderby'];
$pagesize = empty($items['pagesize']) ?intval(parent::$cfg['userpagesize']) : intval($items['pagesize']);
$where = " WHERE s.flag='1' AND s.lovestatus='1'".$items['searchsql'];
$start = ($items['page']-1)*$pagesize;
$countwhere = empty($items['countwhere']) ?'': ' '.$items['countwhere'];
$countsql = "SELECT COUNT(*) AS my_count FROM ".DB_PREFIX."user_params as ps".
" WHERE ps.flag='1' AND ps.lovestatus='1'".$countwhere ;
$total = parent::$obj->fetch_count($countsql);
if ($total == 0) {
$data = null;
}
else {
$params_sql = $this->_buildParamsSql()." WHERE ps.flag='1' AND ps.lovestatus='1'"
.$countwhere." ORDER BY ps.userid DESC LIMIT ".$start.", ".$pagesize."";
$users = parent::$obj->getall($params_sql);
$ids = $this->_getUserIds($users);
$sql = $this->_buildSql()." WHERE v.userid IN (".$ids.") ORDER BY v.userid DESC";
$data = parent::$obj->getall($sql);
}
return array($total,$this->_handleList($data,'userid'));
}
public function getList($items) {
$orderby = empty($items['orderby']) ?' ORDER BY v.avatarflag DESC': $items['orderby'];
$pagesize = empty($items['pagesize']) ?intval(parent::$cfg['userpagesize']) : intval($items['pagesize']);
$where = " WHERE s.flag='1' AND s.lovestatus='1'".$items['searchsql'];
$start = ($items['page']-1)*$pagesize;
$countwhere = empty($items['countwhere']) ?'': ' '.$items['countwhere'];
$countsql = "SELECT COUNT(*) AS my_count FROM ".DB_PREFIX."user_params as ps".
" WHERE ps.flag='1' AND ps.lovestatus='1'".$countwhere ;
$total = parent::$obj->fetch_count($countsql);
if ($total == 0) {
$data = null;
}
else {
$params_sql = $this->_buildParamsSql()." WHERE ps.flag='1' AND ps.lovestatus='1'"
.$countwhere." ORDER BY ps.userid DESC LIMIT ".$start.", ".$pagesize."";
$users = parent::$obj->getall($params_sql);
$ids = $this->_getUserIds($users);
$sql = $this->_buildSql()." WHERE v.userid IN (".$ids.") ORDER BY v.userid DESC";
$data = parent::$obj->getall($sql);
}
return array($total,$this->_handleList($data,'userid'));
}
解决方案 »
- 用php正则过滤程序标记开头到结尾全部过滤掉,请看说明
- 大家知道magic这么一个模板技术吗?
- google checkout支付问题(php)
- 向mysql插入数据时错误,Duplicate entry '0' for key 1
- 求 -> 快捷输入办法
- 新手求助如何读取数据库中这条记录的字符并更新它
- 基于thinkphp的openSNS微信登录问题,请大神指教一下,跪求呀
- dedecms自定义模型问题
- linux下PHP与qt结合开发
- 后台登陆的时候,明明看见后台文件存在,但是浏览器确提示404nofound 不过换个域名又可以正常访问。但是用之前的域名就是nofound,太奇怪了
- mysql 两张数据表导入问题
- zend studio 运行php脚本出现no test was executed 和 error launch "new configuration"
本来 $orderby = empty($items['orderby']) ?' ORDER BY v.avatarflag DESC': $items['orderby']; 是用于构造排序子句的,但后面并没有使用
而是硬写上去
$sql = $this->_buildSql()." WHERE v.userid IN (".$ids.") ORDER BY v.userid DESC";
这个是你的排序 Order by ,不过后面貌似没有用到(只是当前你贴出来的代码)$params_sql = $this->_buildParamsSql()." WHERE ps.flag='1' AND ps.lovestatus='1'"
.$countwhere." ORDER BY ps.userid DESC LIMIT ".$start.", ".$pagesize."";
这里面的order by ps.userid DESC是你的排序
.$countwhere." ORDER BY ps.userid DESC LIMIT ".$start.", ".$pagesize."";
这句有没有控制结果排序?
public function getLikeList($items) {
$orderby = empty($items['orderby']) ?' ORDER BY v.userid DESC': $items['orderby'];
$pagesize = empty($items['pagesize']) ?30 : intval($items['pagesize']);
$start = ($items['page']-1)*$pagesize;
$where = empty($items['searchsql']) ?'': ' '.$items['searchsql'];
$countsql = "SELECT COUNT(*) AS my_count FROM ".DB_PREFIX."user as v".
" WHERE 1=1".$where;
$total = parent::$obj->fetch_count($countsql);
if ($total == 0) {
$data = null;
}
else {
$like_sql = $this->_buildLikeSql()." WHERE 1=1"
.$where.$orderby." LIMIT ".$start.", ".$pagesize."";
$users = parent::$obj->getall($like_sql);
$ids = $this->_getUserIds($users);
$sql = $this->_buildSql()." WHERE v.userid IN (".$ids.") ORDER BY v.userid DESC";
$data = parent::$obj->getall($sql);
}
return array($total,$this->_handleList($data,'userid'));
}