pdo.getattribute(3) [php man page]

PDO.GETATTRIBUTE(3)							 1						       PDO.GETATTRIBUTE(3)

PDO
::getAttribute - Retrieve a database connection attribute

SYNOPSIS

       public mixed PDO::getAttribute (int  $attribute)

DESCRIPTION

	This  function	returns  the  value  of a database connection attribute. To retrieve PDOStatement attributes, refer to PDOStatement.getAt-
       tribute(3).

	Note that some database/driver combinations may not support all of the database connection attributes.

PARAMETERS

	      o $attribute
		- One of the PDO::ATTR_* constants. The constants that apply to database connections are as follows:

		     o PDO::ATTR_AUTOCOMMIT

		     o PDO::ATTR_CASE

		     o PDO::ATTR_CLIENT_VERSION

		     o PDO::ATTR_CONNECTION_STATUS

		     o PDO::ATTR_DRIVER_NAME

		     o PDO::ATTR_ERRMODE

		     o PDO::ATTR_ORACLE_NULLS

		     o PDO::ATTR_PERSISTENT

		     o PDO::ATTR_PREFETCH

		     o PDO::ATTR_SERVER_INFO

		     o PDO::ATTR_SERVER_VERSION

		     o PDO::ATTR_TIMEOUT

RETURN VALUES

	A successful call returns the value of the requested PDO attribute. An unsuccessful call returns null.

EXAMPLES

       Example #1

	      Retrieving database connection attributes

	      <?php
	      $conn = new PDO('odbc:sample', 'db2inst1', 'ibmdb2');
	      $attributes = array(
		  "AUTOCOMMIT", "ERRMODE", "CASE", "CLIENT_VERSION", "CONNECTION_STATUS",
		  "ORACLE_NULLS", "PERSISTENT", "PREFETCH", "SERVER_INFO", "SERVER_VERSION",
		  "TIMEOUT"
	      );

	      foreach ($attributes as $val) {
		  echo "PDO::ATTR_$val: ";
		  echo $conn->getAttribute(constant("PDO::ATTR_$val")) . "
";
	      }
	      ?>

SEE ALSO

       PDO.setAttribute(3), PDOStatement.getAttribute(3), PDOStatement.setAttribute(3).

PHP Documentation Group 												       PDO.GETATTRIBUTE(3)

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)