Php pdostatement fetchsingle () function

Write your php code

(no version information, might be only in CVS)

PDOStatement::fetchSingle -- Returns the first column in the next row of a result set

Syntax

string PDOStatement::fetchSingle ( void )

Warning

This function is EXPERIMENTAL. The behaviour of this function, the name of this function, and anything else documented about this function may change without notice in a future release of PHP. Use this function at your own risk.

Return Values

PDOStatement::fetchSingle() returns the first column in the next row of a result set as a string value.

Warning

There is no way to return the second or subsequent columns from a row if you use this method to retrieve data.

Examples

Example 1. Return first column of the next row


<?php
$sth = $dbh->prepare("SELECT name, colour FROM fruit");
$sth->execute();

/* Fetch the first column from the next row in the result set */
print("Fetch the first column from the next row in the result set:\n");
$result = $sth->fetchSingle();
print("$result\n");

$result = $sth->fetchSingle();
print("$result\n");
?>

The above example will output:

Fetch the first column from the next row in the result set:
lemon
orange

Php pdostatement fetchsingle Function syntax tag

pdostatement fetchsingle php code on this is provided for your study purpose, it will guide you to know how create and design a website using php. use it to practice and train your self online

Php pdostatement fetchsingle syntax tutorial

php tutorial guide and code design are for easy learning and programming. The code practice section provided at the top is for practising of this syntax. Use the code section up to practice your php programming online. Learning php is very easy, all you need is to use the examples on this site and practice them to perfect your skills.