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.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(3) [php man page]

Check Out this Related Man Page