🔥码云GVP开源项目 12k star Uniapp+ElementUI 功能强大 支持多语言、二开方便! 广告
### 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 ); } ~~~