### findAll **從數據表中查找記錄** **參數** conditions ： 查找條件，數組array("字段名"=>"查找值")或字符串， 請注意在使用字符串時請自行使用\_\_val\_escape來對輸入值進行過濾 sort： 排序，等同于“ORDER BY ” fields： 返回的字段范圍，默認為返回全部字段的值 ~~~ public function findAll($conditions = null, $sort = null, $fields = null, $limit = null) { $where = ""; $fields = empty ( $fields ) ? "*" : $fields; if (is_array ( $conditions )) { $join = array (); foreach ( $conditions as $key => $condition ) { $condition = $this->__val_escape ( $condition ); $join [] = "{$key} = '{$condition}'"; } $where = "WHERE " . join ( " AND ", $join ); } else { if (null != $conditions) $where = "WHERE " . $conditions; } if (null != $sort) $sort = "ORDER BY {$sort}"; if (null != $limit) $limit = "LIMIT {$limit}"; $sql = "SELECT {$this->tbl_name}.{$fields} FROM {$this->tbl_name} {$where} {$sort} {$limit}"; return $this->_db->getArray ( $sql ); } ~~~