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

PDOSTATEMENT.FETCHCOLUMN(3)						 1					       PDOSTATEMENT.FETCHCOLUMN(3)

PDOStatement::fetchColumn - Returns a single column from the next row of a result set

SYNOPSIS

       public mixed PDOStatement::fetchColumn ([int  $column_number])

DESCRIPTION

	Returns a single column from the next row of a result set or FALSE if there are no more rows.

       Note

	      PDOStatement.fetchColumn(3) should not be used to retrieve boolean columns, as it is impossible to distinguish a value of FALSE from
	      there being no more rows to retrieve. Use PDOStatement.fetch(3) instead.

PARAMETERS

	      o $column_number
		- 0-indexed number of the column you wish to retrieve from the row. If no value is supplied,  PDOStatement.fetchColumn(3)  fetches
		the first column.

RETURN VALUES

       PDOStatement.fetchColumn(3) returns a single column in the next row of a result set.

       Warning

	       There is no way to return another column from the same row if you use PDOStatement.fetchColumn(3) to retrieve data.

EXAMPLES

       Example #1

	      Return first column of the next row

	      <?php
	      $sth = $dbh->prepare("SELECT name, colour FROM fruit");
	      $sth->execute();

	      print("Fetch the first column from the first row in the result set:
");
	      $result = $sth->fetchColumn();
	      print("name = $result
");

	      print("Fetch the second column from the second row in the result set:
");
	      $result = $sth->fetchColumn(1);
	      print("colour = $result
");
	      ?>

	      The above example will output:

	      Fetch the first column from the first row in the result set:
	      name = lemon
	      Fetch the second column from the second row in the result set:
	      colour = red

SEE ALSO

       PDO.query(3), PDOStatement.fetch(3), PDOStatement.fetchAll(3), PDO.prepare(3), PDOStatement.setFetchMode(3).

PHP Documentation Group 											       PDOSTATEMENT.FETCHCOLUMN(3)

Linux and UNIX Man Pages

pdostatement.bindcolumn(3) [php man page]

Check Out this Related Man Page