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

PDOSTATEMENT.BINDVALUE(3)						 1						 PDOSTATEMENT.BINDVALUE(3)

PDOStatement::bindValue - Binds a value to a parameter

SYNOPSIS
       public bool PDOStatement::bindValue (mixed  $parameter, mixed  $value, [int  $data_type = PDO::PARAM_STR])

DESCRIPTION
	Binds a value to a corresponding named or question mark placeholder in the SQL statement that was used to prepare the statement.

PARAMETERS
	      o $parameter
		- Parameter identifier. For a prepared statement using named placeholders, this will be a parameter name of the form $:name. For a
		prepared statement using question mark placeholders, this will be the 1-indexed position of the parameter.

	      o $value
		- The value to bind to the parameter.

	      o $data_type
		- Explicit data type for the parameter using the PDO::PARAM_* constants.

RETURN VALUES
	Returns TRUE on success or FALSE on failure.

EXAMPLES
       Example #1

	      Execute a prepared statement with named placeholders

	      <?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->bindValue(':calories', $calories, PDO::PARAM_INT);
	      $sth->bindValue(':colour', $colour, PDO::PARAM_STR);
	      $sth->execute();
	      ?>

       Example #2

	      Execute a prepared statement with question mark placeholders

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

SEE ALSO
       PDO.prepare(3), PDOStatement.execute(3), PDOStatement.bindParam(3).

PHP Documentation Group 												 PDOSTATEMENT.BINDVALUE(3)