1. class
  2. App
  3. \
  4. G6K
  5. \
  6. Manager
  7. \
  8. Json
  9. \
  10. JsonSQL
  11. \
  12. Statement

Statement

abstract class Statement

The class JsonSQLStatement represents a prepared statement and, after the statement is executed, an associated result set.

Properties

protected JsonSQL $jsonsql
protected object $request
protected array $result
protected int $rowCount
protected array $params
protected Engine $engine

Methods

__construct(JsonSQL $jsonsql, stdClass $request)

Class Constructor

create(JsonSQL $jsonsql, stdClass $request)

Statement factory

bool
bindValue(mixed $parameter, mixed $value, int $type = \PDO::PARAM_STR)

Binds a value to a corresponding named or question mark placeholder in the SQL statement that was used to prepare the statement.

bool
bindParam(mixed $parameter, mixed $variable, int $type = \PDO::PARAM_STR)

Binds a PHP variable to a corresponding named or question mark placeholder in the SQL statement that was used to prepare the statement.

bool
execute(array $parameters = array())

Executes a prepared statement.

int
rowCount()

Returns the number of rows affected by the last SQL statement

int
columnCount()

Returns the number of columns in the result set

void
checkValue(string $value, int $type = \PDO::PARAM_STR)

Checks if a value corresponds to its type and if it is safety in case of string

bool
executeCompoundSelect()

Executes a prepared select statement with set opertations.

bool
executeSelect()

Executes a prepared select statement.

bool
executeInsert()

Executes a prepared insert statement.

bool
executeUpdate()

Executes a prepared update statement.

bool
executeDelete()

Executes a prepared delete statement.

bool
executeCreateTable()

Executes a prepared 'create table' statement.

bool
executeAlterTable()

Executes a prepared 'alter table' statement.

bool
executeTruncate()

Executes a prepared 'truncate' statement.

bool
executeDropTable()

Executes a prepared 'drop table' statement.

Details

at line 92
protected __construct(JsonSQL $jsonsql, stdClass $request)

Class Constructor

Parameters

JsonSQL $jsonsql The JsonSQL instance
stdClass $request The prepared statement

at line 109
create(JsonSQL $jsonsql, stdClass $request)

Statement factory

Parameters

JsonSQL $jsonsql The JsonSQL instance
stdClass $request &$request The prepared statement

at line 138
bool bindValue(mixed $parameter, mixed $value, int $type = \PDO::PARAM_STR)

Binds a value to a corresponding named or question mark placeholder in the SQL statement that was used to prepare the statement.

Parameters

mixed $parameter The parameter identifier
mixed $value The value to bind to the parameter
int $type The data type for the parameter using the PDO::PARAM_* constants.

Return Value

bool true on success or false on failure.

at line 189
bool bindParam(mixed $parameter, mixed $variable, int $type = \PDO::PARAM_STR)

Binds a PHP variable to a corresponding named or question mark placeholder in the SQL statement that was used to prepare the statement.

the variable is bound as a reference and will only be evaluated at the time that execute() is called.

Parameters

mixed $parameter The parameter identifier
mixed $variable &$variable The variable to bind to the parameter
int $type The data type for the parameter using the PDO::PARAM_* constants.

Return Value

bool true on success or false on failure.

at line 202
bool execute(array $parameters = array())

Executes a prepared statement.

Parameters

array $parameters An array of values with as many elements as there are bound parameters in the SQL statement being executed. All values are treated as PDO::PARAM_STR.

Return Value

bool true on success or false on failure.

at line 242
int rowCount()

Returns the number of rows affected by the last SQL statement

Return Value

int The number of rows.

at line 253
int columnCount()

Returns the number of columns in the result set

Return Value

int The number of columns in the result set. If there is no result set, returns 0.

at line 266
protected void checkValue(string $value, int $type = \PDO::PARAM_STR)

Checks if a value corresponds to its type and if it is safety in case of string

Parameters

string $value The value
int $type The expected type

Return Value

void

Exceptions

JsonSQLException

at line 287
abstract protected bool executeCompoundSelect()

Executes a prepared select statement with set opertations.

Return Value

bool Always true.

at line 295
abstract protected bool executeSelect()

Executes a prepared select statement.

Return Value

bool Always true.

at line 303
abstract protected bool executeInsert()

Executes a prepared insert statement.

Return Value

bool Always true.

at line 311
abstract protected bool executeUpdate()

Executes a prepared update statement.

Return Value

bool Always true.

at line 319
abstract protected bool executeDelete()

Executes a prepared delete statement.

Return Value

bool Always true.

at line 327
abstract protected bool executeCreateTable()

Executes a prepared 'create table' statement.

Return Value

bool TRUE.

at line 335
abstract protected bool executeAlterTable()

Executes a prepared 'alter table' statement.

Return Value

bool TRUE.

at line 343
abstract protected bool executeTruncate()

Executes a prepared 'truncate' statement.

Return Value

bool Always true.

at line 351
abstract protected bool executeDropTable()

Executes a prepared 'drop table' statement.

Return Value

bool TRUE.