Метод |
Описание |
|
__construct ( $conf ) |
数据库连接串 |
|
__destruct ( ) |
析构函数 |
|
affectedRows ( $handle, integer $type ) : integer |
返回INSERT,UPDATE 或 DELETE 查询所影响的记录行数。 |
|
avg ( string $field = 'id', boolean | string $isMulti = false, boolean | string $useMaster = false ) : mixed |
获取 AVG(字段名) 的结果 |
|
buildSql ( null $offset = null, null $limit = null, boolean $isSelect = false ) : string | array |
构建sql |
|
callProcedure ( string $procedureName = '', array $bindParams = [], boolean | true $isSelect = true ) : array | integer |
调用存储过程 |
|
close ( ) |
关闭连接 |
|
commit ( ) : boolean |
提交事务 |
|
connect ( string $host, string $username, string $password, string $dbName, string $charset = 'utf8', string $engine = '', boolean $pConnect = false ) : mixed |
Db连接 |
|
count ( string $field = '*', boolean | string $isMulti = false, boolean | string $useMaster = false ) : mixed |
获取 COUNT(字段名或*) 的结果 |
|
decrement ( string $key, integer $val = 1, string $field = null, mixed $tablePrefix = null ) : boolean |
指定字段的值-1 |
|
delete ( string $key = '', boolean $and = true, mixed $tablePrefix = null ) : boolean |
根据key值删除数据 |
|
execute ( object $stmt, boolean $clearBindParams = true ) : boolean |
执行预处理语句 |
|
forceIndex ( string $table, string $index, string $tablePrefix = null ) |
强制使用索引 |
|
get ( string $key, boolean $and = true, boolean | string $useMaster = false, null | string $tablePrefix = null ) : array |
根据key取出数据 |
|
getAllTableStatus ( ) : array |
获取当前数据库中所有表的信息 |
|
getDbFields ( string $table, mixed $tablePrefix = null, integer $filter ) : mixed |
获取表字段 |
|
getTables ( ) : array |
获取当前db所有表名 |
|
increment ( string $key, integer $val = 1, string $field = null, mixed $tablePrefix = null ) : boolean |
指定字段的值+1 |
|
insertId ( PDO $link = null ) : integer |
获取上一INSERT的主键值 |
|
max ( string $field = 'id', boolean | string $isMulti = false, boolean | string $useMaster = false ) : mixed |
获取 MAX(字段名) 的结果 |
|
min ( string $field = 'id', boolean | string $isMulti = false, boolean | string $useMaster = false ) : mixed |
获取 MIN(字段名) 的结果 |
|
prepare ( string $sql, PDO $link = null, boolean $resetParams = true ) : PDOStatement |
预处理语句 |
|
rollBack ( boolean $rollBackTo = false ) : boolean |
回滚事务 |
|
savePoint ( string $pointName ) : boolean |
设置一个事务保存点 |
|
select ( integer $offset = null, integer $limit = null, boolean $useMaster = false ) : array |
获取多条数据 |
|
set ( string $table, array $data, mixed $tablePrefix = null ) : boolean | integer |
根据key 新增 一条数据 |
|
startTransAction ( ) : boolean |
开启事务 |
|
sum ( string $field = 'id', boolean | string $isMulti = false, boolean | string $useMaster = false ) : mixed |
获取 SUM(字段名) 的结果 |
|
truncate ( string $tableName ) : boolean |
根据表名删除数据 这个操作太危险慎用。不过一般情况程序也没这个权限 |
|
update ( string $key, array | null $data = null, boolean $and = true, mixed $tablePrefix = null ) : boolean |
根据key更新一条数据 |
|
version ( PDO $link = null ) : string |
获取mysql 版本 |
|