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)

PDOSTATEMENT.DEBUGDUMPPARAMS(3) 					 1					   PDOSTATEMENT.DEBUGDUMPPARAMS(3)

PDOStatement::debugDumpParams - Dump an SQL prepared command

SYNOPSIS

       public void PDOStatement::debugDumpParams (void	)

DESCRIPTION

	Dumps the information contained by a prepared statement directly on the output. It will provide the SQL query in use, the number of param-
       eters used ( Params), the list of parameters with their key name or position, their name, their position in the query (if this is supported
       by the PDO driver, otherwise, it will be -1), type ( param_type) as an integer, and a boolean value is_param.

	This is a debug function, which dumps the data directly to the normal output.

       Tip

	      As  with anything that outputs its result directly to the browser, the output-control functions can be used to capture the output of
	      this function, and save it in a string (for example).

	This will only dump the parameters in the statement at the moment of the dump. Extra parameters are not stored in the statement,  and  not
       displayed.

RETURN VALUES

	No value is returned.

EXAMPLES

       Example #1

	      PDOStatement.debugDumpParams(3) example with named parameters

	      <?php
	      /* Execute a prepared statement by binding PHP variables */
	      $calories = 150;
	      $colour = 'red';
	      $sth = $dbh->prepare('SELECT name, colour, calories
		  FROM fruit
		  WHERE calories < :calories AND colour = :colour');
	      $sth->bindParam(':calories', $calories, PDO::PARAM_INT);
	      $sth->bindValue(':colour', $colour, PDO::PARAM_STR, 12);
	      $sth->execute();

	      $sth->debugDumpParams();

	      ?>

	      The above example will output:

	      SQL: [96] SELECT name, colour, calories
		  FROM fruit
		  WHERE calories < :calories AND colour = :colour
	      Params:  2
	      Key: Name: [9] :calories
	      paramno=-1
	      name=[9] ":calories"
	      is_param=1
	      param_type=1
	      Key: Name: [7] :colour
	      paramno=-1
	      name=[7] ":colour"
	      is_param=1
	      param_type=2

       Example #2

	      PDOStatement.debugDumpParams(3) example with unnamed parameters

	      <?php

	      /* Execute a prepared statement by binding PHP variables */
	      $calories = 150;
	      $colour = 'red';
	      $name = 'apple';

	      $sth = $dbh->prepare('SELECT name, colour, calories
		  FROM fruit
		  WHERE calories < ? AND colour = ?');
	      $sth->bindParam(1, $calories, PDO::PARAM_INT);
	      $sth->bindValue(2, $colour, PDO::PARAM_STR);
	      $sth->execute();

	      $sth->debugDumpParams();

	      ?>

	      The above example will output:

	      SQL: [82] SELECT name, colour, calories
		  FROM fruit
		  WHERE calories < ? AND colour = ?
	      Params:  2
	      Key: Position #0:
	      paramno=0
	      name=[0] ""
	      is_param=1
	      param_type=1
	      Key: Position #1:
	      paramno=1
	      name=[0] ""
	      is_param=1
	      param_type=2

SEE ALSO

       PDO.prepare(3), PDOStatement.bindParam(3), PDOStatement.bindValue(3).

PHP Documentation Group 											   PDOSTATEMENT.DEBUGDUMPPARAMS(3)