php 数据库类
- WBOYOriginal
- 2016-06-08 17:30:26925browse
+----------------------------------------------------------
* @param mixed $where 数据
* @param string $tables 数据表名
* @param string $fields 字段名
* @param string $order 排序
* @param string $limit
* @param string $group
* @param string $having
* @param boolean $cache 是否缓存
* @param boolean $lazy 是否惰性加载
* @param boolean $lock 是否加锁
+----------------------------------------------------------
* @return ArrayObject
+----------------------------------------------------------
* @throws ThinkExecption
+----------------------------------------------------------
*/
public function find($where,$tables,$fields='*',$order=null,$limit=null,$group=null,$having=null,$join=null,$cache=false,$lazy=false,$lock=false)
{
if(in_array($this->getDbType(),array('MSSQL','IBASE'),true) ) {
$this->queryStr = 'SELECT '.$this->parseLimit($limit)
.$this->parseFields($fields)
.' FROM '.$tables
.$this->parseJoin($join)
.$this->parseWhere($where)
.$this->parseGroup($group)
.$this->parseHaving($having)
.$this->parseOrder($order);
}else{
$this->queryStr = 'SELECT '.$this->parseFields($fields)
.' FROM '.$tables
.$this->parseJoin($join)
.$this->parseWhere($where)
.$this->parseGroup($group)
.$this->parseHaving($having)
.$this->parseOrder($order);
if("ORACLE" == $this->getDbType())
if($limit[0]
if($limit[1] > 0)
$this->queryStr = "SELECT * FROM (".$this->queryStr.") WHERE ROWNUM
}else{
$whereClause = "";
if($limit[1] > 0)
$whereClause = " WHERE ROWNUM
$this->queryStr = "SELECT * FROM ( SELECT ROW_.*, ROWNUM ROWNUM_ FROM ("
.$this->queryStr.") ROW_"
.$whereClause
.") WHERE ROWNUM_ > "
.$limit[0];
}
else
$this->queryStr .= $this->parseLimit($limit);
}
return $this->query('',$cache,$lazy,$lock);
}