pdostatement.bindcolumn(3) [php man page]

PDOSTATEMENT.BINDCOLUMN(3)						 1						PDOSTATEMENT.BINDCOLUMN(3)

PDOStatement::bindColumn - Bind a column to a PHP variable

SYNOPSIS

       public bool PDOStatement::bindColumn (mixed  $column, mixed  &$param, [int  $type], [int  $maxlen], [mixed  $driverdata])

DESCRIPTION

       PDOStatement.bindColumn(3)  arranges  to  have  a  particular variable bound to a given column in the result-set from a query. Each call to
       PDOStatement.fetch(3) or PDOStatement.fetchAll(3) will update all the variables that are bound to columns.

       Note

	       Since information about the columns is not always available to PDO until the statement is executed,  portable  applications  should
	      call this function afterPDOStatement.execute(3).

	       However, to be able to bind a LOB column as a stream when using the PgSQL driver, applications should call this method before call-
	      ing PDOStatement.execute(3), otherwise the large object OID will be returned as an integer.

PARAMETERS

	      o $column
		- Number of the column (1-indexed) or name of the column in the result set. If using the column  name,	be  aware  that  the  name
		should match the case of the column, as returned by the driver.

	      o $param
		- Name of the PHP variable to which the column will be bound.

	      o $type
		- Data type of the parameter, specified by the PDO::PARAM_* constants.

	      o $maxlen
		- A hint for pre-allocation.

	      o $driverdata
		- Optional parameter(s) for the driver.

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      Binding result set output to PHP variables

	       Binding columns in the result set to PHP variables is an effective way to make the data contained in each row immediately available
	      to your application. The following example demonstrates how PDO allows you to bind and retrieve columns with a  variety  of  options
	      and with intelligent defaults.

	      <?php
	      function readData($dbh) {
		$sql = 'SELECT name, colour, calories FROM fruit';
		try {
		  $stmt = $dbh->prepare($sql);
		  $stmt->execute();

		  /* Bind by column number */
		  $stmt->bindColumn(1, $name);
		  $stmt->bindColumn(2, $colour);

		  /* Bind by column name */
		  $stmt->bindColumn('calories', $cals);

		  while ($row = $stmt->fetch(PDO::FETCH_BOUND)) {
		    $data = $name . "	" . $colour . "	" . $cals . "
";
		    print $data;
		  }
		}
		catch (PDOException $e) {
		  print $e->getMessage();
		}
	      }
	      readData($dbh);
	      ?>

	      The above example will output:

	      apple   red     150
	      banana  yellow  175
	      kiwi    green   75
	      orange  orange  150
	      mango   red     200
	      strawberry      red     25

SEE ALSO

       PDOStatement.execute(3), PDOStatement.fetch(3), PDOStatement.fetchAll(3), PDOStatement.fetchColumn(3).

PHP Documentation Group 												PDOSTATEMENT.BINDCOLUMN(3)

Check Out this Related Man Page

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)

Linux and UNIX Man Pages

pdostatement.bindcolumn(3) [php man page]

Check Out this Related Man Page