[ Index ] |
PHP Cross Reference of Joomla 4.2.2 documentation |
[Source view] [Print] [Project Stats]
Part of the Joomla Framework Database Package
Copyright: | Copyright (C) 2005 - 2021 Open Source Matters, Inc. All rights reserved. |
License: | GNU General Public License version 2 or later; see LICENSE |
File Size: | 629 lines (15 kb) |
Included or required: | 0 times |
Referenced: | 0 times |
Includes or requires: | 0 files |
MysqliStatement:: (13 methods):
__construct()
prepareParameterKeyMapping()
bindParam()
bindValues()
closeCursor()
errorCode()
errorInfo()
execute()
fetch()
fetchColumn()
fetchData()
rowCount()
setFetchMode()
Class: MysqliStatement - X-Ref
MySQLi Database Statement.__construct(\mysqli $connection, string $query) X-Ref |
Constructor. param: \mysqli $connection The database connection resource param: string $query The query this statement will process |
prepareParameterKeyMapping($sql) X-Ref |
Replace named parameters with numbered parameters param: string $sql The SQL statement to prepare. return: string The processed SQL statement. |
bindParam($parameter, &$variable, string $dataType = ParameterType::STRING, ?int $length = null, ?array $driverOptions = null) X-Ref |
Binds a parameter to the specified variable name. param: string|integer $parameter Parameter identifier. For a prepared statement using named placeholders, this will be a parameter param: mixed $variable Name of the PHP variable to bind to the SQL statement parameter. param: integer $dataType Constant corresponding to a SQL datatype, this should be the processed type from the QueryInterface. param: integer $length The length of the variable. Usually required for OUTPUT parameters. param: array $driverOptions Optional driver options to be used. return: boolean |
bindValues(array $values) X-Ref |
Binds a array of values to bound parameters. param: array $values The values to bind to the statement return: boolean |
closeCursor() X-Ref |
Closes the cursor, enabling the statement to be executed again. return: void |
errorCode() X-Ref |
Fetches the SQLSTATE associated with the last operation on the statement handle. return: string |
errorInfo() X-Ref |
Fetches extended error information associated with the last operation on the statement handle. return: array |
execute(?array $parameters = null) X-Ref |
Executes a prepared statement param: array|null $parameters An array of values with as many elements as there are bound parameters in the SQL statement being executed. return: boolean |
fetch(?int $fetchStyle = null, int $cursorOrientation = FetchOrientation::NEXT, int $cursorOffset = 0) X-Ref |
Fetches the next row from a result set param: integer|null $fetchStyle Controls how the next row will be returned to the caller. This value must be one of the param: integer $cursorOrientation For a StatementInterface object representing a scrollable cursor, this value determines which row param: integer $cursorOffset For a StatementInterface object representing a scrollable cursor for which the cursorOrientation return: mixed The return value of this function on success depends on the fetch type. In all cases, boolean false is returned on failure. |
fetchColumn($columnIndex = 0) X-Ref |
Returns a single column from the next row of a result set param: integer $columnIndex 0-indexed number of the column you wish to retrieve from the row. return: mixed Returns a single column from the next row of a result set or boolean false if there are no more rows. |
fetchData() X-Ref |
Fetch the data from the statement. return: array|boolean |
rowCount() X-Ref |
Returns the number of rows affected by the last SQL statement. return: integer |
setFetchMode(int $fetchMode, ...$args) X-Ref |
Sets the fetch mode to use while iterating this statement. param: integer $fetchMode The fetch mode, must be one of the FetchMode constants. param: mixed ...$args Optional mode-specific arguments. return: void |
Generated: Wed Sep 7 05:41:13 2022 | Chilli.vc Blog - For Webmaster,Blog-Writer,System Admin and Domainer |