php 数据库类库_php 数据库类

----------------------------------------------------------

* @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] <= 0){

if($limit[1] > 0)

$this->queryStr = "SELECT * FROM (".$this->queryStr.") WHERE ROWNUM <= ".$limit[1];

}else{

$whereClause = "";

if($limit[1] > 0)

$whereClause = " WHERE ROWNUM <= ".($limit[0] $limit[1]);

$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);

}