pdostatement.setfetchmode(3) [php man page]

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)

PDO.QUERY(3)								 1							      PDO.QUERY(3)

PDO
::query - Executes an SQL statement, returning a result set as a PDOStatement object

SYNOPSIS

       public PDOStatement PDO::query (string  $statement)

DESCRIPTION

       PDOStatement  PDO::query  (string   $statement,	int   $PDO::FETCH_COLUMN,  int	 $colno)  PDOStatement PDO::query (string  $statement, int
       $PDO::FETCH_CLASS, string  $classname, array   $ctorargs)  PDOStatement	PDO::query  (string   $statement,  int	 $PDO::FETCH_INTO,  object
       $object)

       PDO.query(3)  executes  an  SQL	statement  in  a  single  function  call, returning the result set (if any) returned by the statement as a
       PDOStatement object.

	For a query that you need to issue multiple times, you will realize better performance if you prepare a PDOStatement object using PDO.pre-
       pare(3) and issue the statement with multiple calls to PDOStatement.execute(3).

	If  you  do  not  fetch  all of the data in a result set before issuing your next call to PDO.query(3), your call may fail. Call PDOState-
       ment.closeCursor(3) to release the  database  resources	associated  with  the  PDOStatement  object  before  issuing  your  next  call	to
       PDO.query(3).

       Note

	       Although  this  function  is only documented as having a single parameter, you may pass additional arguments to this function. They
	      will be treated as though you called PDOStatement.setFetchMode(3) on the resultant statement object.

PARAMETERS

	      o $statement
		- The SQL statement to prepare and execute.  Data inside the query should be properly escaped.

RETURN VALUES

       PDO.query(3) returns a PDOStatement object, or FALSE on failure.

EXAMPLES

       Example #1

	      Demonstrate PDO::query

	       A nice feature of PDO.query(3) is that it enables you to iterate over the rowset returned by a successfully executed SELECT  state-
	      ment.

	      <?php
	      function getFruit($conn) {
		  $sql = 'SELECT name, color, calories FROM fruit ORDER BY name';
		  foreach ($conn->query($sql) as $row) {
		      print $row['name'] . "	";
		      print $row['color'] . "	";
		      print $row['calories'] . "
";
		  }
	      }
	      ?>

	      The above example will output:

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

SEE ALSO

       PDO.exec(3), PDO.prepare(3), PDOStatement.execute(3).

PHP Documentation Group 													      PDO.QUERY(3)