Htaccess    html   Php    javascript   Asp   css    maths  Past Questions  Practice Tests Online

pdostatement setfetchmode function syntax tag tutorial 2013 Donate at flattr Flattr this

Alert! Connect with 10,000 Chating Online. Join Now

Php pdostatement setfetchmode () function

Write your php code

<?php ?>

Php Result

Your code below

(no version information, might be only in CVS)

PDOStatement::setFetchMode --  Set the default fetch mode for this statement


bool PDOStatement::setFetchMode ( int mode )


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.



The fetch mode must be one of the PDO_FETCH_* constants.

Return Values

Returns 1 on success or FALSE on failure.


Example 1. Setting the fetch mode

The following example demonstrates how PDOStatement::setFetchMode() changes the default fetch mode for a PDOStatement object.

= 'SELECT name, colour, calories FROM fruit';
try {
$stmt = $dbh->query($sql);
$result = $stmt->setFetchMode(PDO_FETCH_NUM);
  while (
$row = $stmt->fetch()) {
$row[0] . "\t" . $row[1] . "\t" . $row[2] . "\n";
catch (PDOException $e) {

The above example will output:

apple   red     150
banana  yellow  250
orange  orange  300
kiwi    brown   75
lemon   yellow  25
pear    green   150
watermelon      pink    90

Php pdostatement setfetchmode Function syntax tag

pdostatement setfetchmode 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 setfetchmode 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.

Function index







Date & Time

Directory function




Form data handling

Mathematics operators


Php Mysql

Network Functions


php tutorial guides,functions, classes, code examples and tags for creating simple dynamic site to mysql database driven sites
Htaccess    html   Php    javascript   Asp   css    maths  Past Questions  Practice Tests Online