Documentation Home
MySQL PHP API
Download this Manual
PDF (US Ltr) - 2.4Mb
PDF (A4) - 2.4Mb
HTML Download (TGZ) - 250.9Kb
HTML Download (Zip) - 258.4Kb


MySQL PHP API  /  ...  /  RowResult::fetchOne

5.24.3 RowResult::fetchOne

Copyright 1997-2019 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
)