MySQL and PHP

5.24.3 RowResult::fetchOne

Copyright 1997-2019 the PHP Documentation Group.

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.92 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
)