MySQLStatement
class MySQLStatement extends Query
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
Return an array containing all the values from a specific column. If no column is set, then the first will be returned
Return an array containing all values in the leftmost column, where the keys are the same as the values.
Return the next record in the query result.
Return the total number of items in the query result.
Hook the result-set given into a Query class, suitable for use by SilverStripe.
No description
No description
Details
in Query at line 40
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
in Query at line 61
array
keyedColumn()
Return an array containing all values in the leftmost column, where the keys are the same as the values.
in Query at line 77
array
map()
Return a map from the first column to the second column.
in Query at line 93
array
record()
Returns the first record in the result
in Query at line 102
array
first()
deprecated
deprecated Use record() instead
in Query at line 112
string
value()
Returns the first column of the first record.
in Query at line 126
string
table()
Return an HTML table containing the full result-set
at line 105
array
getIterator()
Return the next record in the query result.
at line 112
int
numRecords()
Return the total number of items in the query result.
at line 64
__construct(mysqli_stmt $statement, mysqli_result $metadata)
Hook the result-set given into a Query class, suitable for use by SilverStripe.