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)
Check Out this Related Man Page
PDOSTATEMENT(3) 1 PDOSTATEMENT(3)The PDOStatement classINTRODUCTION
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)