class MySQLStatement extends Query (View source)

Provides a record-view for mysqli prepared statements

By default streams unbuffered data, but seek(), rewind(), or numRecords() will force the statement to buffer itself and sacrifice any potential performance benefit.

Methods

array
column(string $column = null)

Return an array containing all the values from a specific column. If no column is set, then the first will be returned

from  Query
array
keyedColumn()

Return an array containing all values in the leftmost column, where the keys are the same as the values.

from  Query
array
map()

Return a map from the first column to the second column.

from  Query
array
record()

Returns the first record in the result

from  Query
array
first() deprecated

No description

from  Query
string
value()

Returns the first column of the first record.

from  Query
string
table()

Return an HTML table containing the full result-set

from  Query
array
getIterator()

Return the next record in the query result.

int
numRecords()

Return the total number of items in the query result.

__construct(mysqli_stmt $statement, mysqli_result $metadata)

Hook the result-set given into a Query class, suitable for use by SilverStripe.

__destruct()

No description

nextRecord()

No description

Details

array column(string $column = null)

Return an array containing all the values from a specific column. If no column is set, then the first will be returned

Parameters

string $column

Return Value

array

array keyedColumn()

Return an array containing all values in the leftmost column, where the keys are the same as the values.

Return Value

array

array map()

Return a map from the first column to the second column.

Return Value

array

array record()

Returns the first record in the result

Return Value

array

array first() deprecated

deprecated Use record() instead

Return Value

array

string value()

Returns the first column of the first record.

Return Value

string

string table()

Return an HTML table containing the full result-set

Return Value

string

array getIterator()

Return the next record in the query result.

Return Value

array

int numRecords()

Return the total number of items in the query result.

Return Value

int

__construct(mysqli_stmt $statement, mysqli_result $metadata)

Hook the result-set given into a Query class, suitable for use by SilverStripe.

Parameters

mysqli_stmt $statement

The related statement, if present

mysqli_result $metadata

The metadata for this statement

__destruct()

nextRecord()