AbstractSql
in package
implements
SqlInterface
AbstractYes
This is a simple SQL implementation that other SQL can inherit from.
Table of Contents
Interfaces
- SqlInterface
- Describes SQL interface.
Properties
- $affected_rows : int
- $database : MySqlDTO|PostgreSqlDTO|mixed
- $executed : string
- $functions : array<string|int, string>
- $insert_id : int
- $queried : string
Methods
- getAffectedRows() : int
- Retrieve number of affected rows in the last execute() operation.
- getExecuted() : string
- Retrieve the last command that was run in execute() operation.
- getInsertId() : int
- Retrieve the ID generated in the last execute() operation.
- getQueried() : string
- Retrieve the last command that was run in query() operation.
- isFunction() : bool
- Check if data expression is sql function.
Properties
$affected_rows
protected
int
$affected_rows
= 0
$database
protected
MySqlDTO|PostgreSqlDTO|mixed
$database
= null
$executed
protected
string
$executed
= ""
$functions
protected
array<string|int, string>
$functions
= []
$insert_id
protected
int
$insert_id
= 0
$queried
protected
string
$queried
= ""
Methods
getAffectedRows()
Retrieve number of affected rows in the last execute() operation.
public
getAffectedRows() : int
Return values
intgetExecuted()
Retrieve the last command that was run in execute() operation.
public
getExecuted() : string
Return values
stringgetInsertId()
Retrieve the ID generated in the last execute() operation.
public
getInsertId() : int
Return values
intgetQueried()
Retrieve the last command that was run in query() operation.
public
getQueried() : string
Return values
stringisFunction()
Check if data expression is sql function.
public
isFunction(string $Expression) : bool
Parameters
- $Expression : string
-
The sql expression.