Login or Register to Ask a Question and Join Our Community

Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

pdostatement(3) [php man page]

PDOSTATEMENT(3) 							 1							   PDOSTATEMENT(3)

The PDOStatement class

INTRODUCTION

	Represents a prepared statement and, after the statement is executed, an associated result set.

CLASS SYNOPSIS

       PDOStatement

       PDOStatementTraversable

       Properties

       o readonly string$queryString

       Methods

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

       o public  bool  PDOStatement::bindParam	(mixed	 $parameter, mixed  &$variable, [int  $data_type = PDO::PARAM_STR], [int  $length], [mixed
	 $driver_options])

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

       o public bool PDOStatement::closeCursor (void  )

       o public int PDOStatement::columnCount (void  )

       o public void PDOStatement::debugDumpParams (void  )

       o public string PDOStatement::errorCode (void  )

       o public array PDOStatement::errorInfo (void  )

       o public bool PDOStatement::execute ([array  $input_parameters])

       o public mixed PDOStatement::fetch ([int  $fetch_style], [int  $cursor_orientation = PDO::FETCH_ORI_NEXT], [int	$cursor_offset])

       o public array PDOStatement::fetchAll ([int  $fetch_style], [mixed  $fetch_argument], [array  $ctor_args = array()])

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

       o public mixed PDOStatement::fetchObject ([string  $class_name = "stdClass"], [array  $ctor_args])

       o public mixed PDOStatement::getAttribute (int  $attribute)

       o public array PDOStatement::getColumnMeta (int	$column)

       o public bool PDOStatement::nextRowset (void  )

       o public int PDOStatement::rowCount (void  )

       o public bool PDOStatement::setAttribute (int  $attribute, mixed  $value)

       o public bool PDOStatement::setFetchMode (int  $mode)

PROPERTIES

	      o $queryString
		- Used query string.

PHP Documentation Group 													   PDOSTATEMENT(3)

Check Out this Related Man Page

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)
Man Page