Methods |
public
|
closeCursor(): bool
Closes the cursor, enabling the statement to be executed again.
Closes the cursor, enabling the statement to be executed again.
Deprecated
Use Result::free() instead.
Returns
TRUE on success or FALSE on failure.
Implemented by
|
#
|
public
|
columnCount(): int
Returns the number of columns in the result set
Returns the number of columns in the result set
Returns
The number of columns in the result set represented
by the PDOStatement object. If there is no result set,
this method should return 0.
Implemented by
|
#
|
public
|
setFetchMode(int $fetchMode, mixed $arg2 = null, mixed $arg3 = null): bool
Sets the fetch mode to use while iterating this statement.
Sets the fetch mode to use while iterating this statement.
Deprecated
Use one of the fetch- or iterate-related methods.
Parameters
$fetchMode |
The fetch mode must be one of the {@link FetchMode} constants.
|
Implemented by
|
#
|
public
|
fetch(int|null $fetchMode = null, int $cursorOrientation = PDO::FETCH_ORI_NEXT, int $cursorOffset = 0): mixed
Returns the next row of a result set.
Returns the next row of a result set.
Deprecated
Use fetchNumeric(), fetchAssociative() or fetchOne() instead.
Parameters
$fetchMode |
Controls how the next row will be returned to the caller.
The value must be one of the {@link FetchMode} constants,
defaulting to {@link FetchMode::MIXED}.
|
$cursorOrientation |
For a ResultStatement object representing a scrollable cursor,
this value determines which row will be returned to the caller.
This value must be one of the \PDO::FETCH_ORI_* constants,
defaulting to \PDO::FETCH_ORI_NEXT. To request a scrollable
cursor for your ResultStatement object, you must set the \PDO::ATTR_CURSOR
attribute to \PDO::CURSOR_SCROLL when you prepare the SQL statement with
\PDO::prepare().
|
$cursorOffset |
For a ResultStatement object representing a scrollable cursor for which the
cursorOrientation parameter is set to \PDO::FETCH_ORI_ABS, this value
specifies the absolute number of the row in the result set that shall be
fetched.
For a ResultStatement object representing a scrollable cursor for which the
cursorOrientation parameter is set to \PDO::FETCH_ORI_REL, this value
specifies the row to fetch relative to the cursor position before
ResultStatement::fetch() was called.
|
Returns
The return value of this method on success depends on the fetch mode. In all cases, FALSE is
returned on failure.
Implemented by
|
#
|
public
|
fetchAll(int|null $fetchMode = null, int|string|null $fetchArgument = null, mixed[]|null $ctorArgs = null): mixed[]
Returns an array containing all of the result set rows.
Returns an array containing all of the result set rows.
Deprecated
Use fetchAllNumeric(), fetchAllAssociative() or fetchFirstColumn() instead.
Parameters
$fetchMode |
Controls how the next row will be returned to the caller.
The value must be one of the {@link FetchMode} constants,
defaulting to {@link FetchMode::MIXED}.
|
$fetchArgument |
This argument has a different meaning depending on the value
of the $fetchMode parameter:
* {@link FetchMode::COLUMN}:
Returns the indicated 0-indexed column.
* {@link FetchMode::CUSTOM_OBJECT}:
Returns instances of the specified class, mapping the columns of each row
to named properties in the class.
* {@link PDO::FETCH_FUNC}: Returns the results of calling
the specified function, using each row's
columns as parameters in the call.
|
$ctorArgs |
Controls how the next row will be returned to the caller.
The value must be one of the {@link FetchMode} constants,
defaulting to {@link FetchMode::MIXED}.
|
Implemented by
|
#
|
public
|
fetchColumn(int $columnIndex = 0): mixed|false
Returns a single column from the next row of a result set or FALSE if there are no more rows.
Returns a single column from the next row of a result set or FALSE if there are no more rows.
Deprecated
Parameters
$columnIndex |
0-indexed number of the column you wish to retrieve from the row.
If no value is supplied, fetches the first column.
|
Returns
A single column in the next row of a result set, or FALSE if there are no more rows.
Implemented by
|
#
|