$_queryResult
$_queryResult
MysqliDb Class
$_instance : \MysqliDb
Static instance of self
rawQuery(string $query, array $bindParams) : array
Pass in a raw query and an array containing the parameters to bind to the prepaird statement.
string | $query | Contains a user-provided query. |
array | $bindParams | All variables to bind to the SQL statment. |
Contains the returned rows from the query.
where(string $whereProp, mixed $whereValue) : \MysqliDb
This method allows you to specify multipl (method chaining optional) WHERE statements for SQL queries.
string | $whereProp | The name of the database field. |
mixed | $whereValue | The value of the database field. |
orderBy( $orderByField, $orderbyDirection) : \MysqliDb
This method allows you to specify multiple (method chaining optional) ORDER BY statements for SQL queries.
$orderByField | ||
$orderbyDirection |
_determineType(mixed $item) : string
This method is needed for prepared statements. They require the data type of the field to be bound with "i" s", etc.
This function takes the input, determines what type it is, and then updates the param_type.
mixed | $item | Input to determine the type. |
The joined parameter types.
_buildQuery(int $numRows, array $tableData) : \mysqli_stmt
Abstraction method that will compile the WHERE statement, any passed update data, and the desired rows.
It then builds the SQL query.
int | $numRows | The number of rows total to return. |
array | $tableData | Should contain an array of data for updating the database. |
Returns the $stmt object.
_dynamicBindResults(\mysqli_stmt $stmt) : array
This helper method takes care of prepared statements' "bind_result method , when the number of variables to pass is unknown.
\mysqli_stmt | $stmt | Equal to the prepared statement object. |
The results of the SQL fetch.