PDF (US Ltr)
- 2.4Mb
PDF (A4)
- 2.4Mb
HTML Download (TGZ)
- 251.4Kb
HTML Download (Zip)
- 258.8Kb
Copyright 1997-2021 the PHP Documentation Group.
RowResult::fetchOne
Get row from result
Description
public array mysql_xdevapi\RowResult::fetchOne();
Fetch one result from the result set.
Warning
This function is currently not documented; only its argument list is available.
Parameters
This function has no parameters.
Return Values
The result, as an associative array or null
if no results are present.
Examples
Example 5.93 mysql_xdevapi\RowResult::fetchOne
example
<?php
$session = mysql_xdevapi\getSession("mysqlx://user:password@localhost");
$session->sql("DROP DATABASE addressbook")->execute();
$session->sql("CREATE DATABASE addressbook")->execute();
$session->sql("CREATE TABLE addressbook.names(name text, age int)")->execute();
$session->sql("INSERT INTO addressbook.names values ('John', 42), ('Sam', 33)")->execute();
$schema = $session->getSchema("addressbook");
$table = $schema->getTable("names");
$row = $table->select('name', 'age')->where('age < 40')->execute()->fetchOne();
print_r($row);
The above example will output something similar to:
Array ( [name] => Sam [age] => 33 )