pdostatement.setfetchmode(3) php man page | unix.com

PDOSTATEMENT.SETFETCHMODE(3)						 1					      PDOSTATEMENT.SETFETCHMODE(3)

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

SYNOPSIS
       public bool PDOStatement::setFetchMode (int  $mode)

DESCRIPTION
       bool  PDOStatement::setFetchMode  (int	$PDO::FETCH_COLUMN,  int   $colno) bool PDOStatement::setFetchMode (int  $PDO::FETCH_CLASS, string
       $classname, array  $ctorargs) bool PDOStatement::setFetchMode (int  $PDO::FETCH_INTO, object  $object)

PARAMETERS
	      o $mode
		- The fetch mode must be one of the PDO::FETCH_* constants.

	      o $colno
		- Column number.

	      o $classname
		- Class name.

	      o $ctorargs
		- Constructor arguments.

	      o $object
		- Object.

RETURN VALUES
	Returns TRUE on success or FALSE on failure.

EXAMPLES
       Example #1

	      Setting the fetch mode

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

	      <?php
	      $sql = 'SELECT name, colour, calories FROM fruit';
	      try {
		$stmt = $dbh->query($sql);
		$result = $stmt->setFetchMode(PDO::FETCH_NUM);
		while ($row = $stmt->fetch()) {
		  print $row[0] . "	" . $row[1] . "	" . $row[2] . "
";
		}
	      }
	      catch (PDOException $e) {
		print $e->getMessage();
	      }
	      ?>

	      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 Documentation Group 											      PDOSTATEMENT.SETFETCHMODE(3)