\sR\dbQuery

Summary

Methods
Constants
all()
row()
one()
query()
getPdo()
exec()
beginTransaction()
commit()
rollBack()
error()
builder()
table()
No constants found
No protected methods found
N/A
No private methods found
N/A

Methods

all()

all(string  $sql, array  $bind = array()) : array|null

查询所有列

Parameters

string $sql
array $bind

Returns

array|null

row()

row(string  $sql, array  $bind = array()) : array|null

查询单行

Parameters

string $sql
array $bind

Returns

array|null

one()

one(  $sql, array  $bind = array()) : mixed

查询单个值

Parameters

$sql
array $bind

Returns

mixed

query()

query(string  $sql, array  $bind = array()) : integer

数据查询,返回影响行

Parameters

string $sql
array $bind

Returns

integer

getPdo()

getPdo() : \PDO

Returns

\PDO

exec()

exec(  $sql) : integer

Parameters

$sql

Returns

integer

beginTransaction()

beginTransaction() : boolean

Returns

boolean

commit()

commit() : mixed

Returns

mixed

rollBack()

rollBack() : mixed

Returns

mixed

error()

error() : \Exception|null

Returns

\Exception|null

table()

table(string  $table, null  $alias = null) : \sR\db\Builder

数据表查询

Parameters

string $table
null $alias

Returns

\sR\db\Builder