YouTipPDOStatement::fetchColumn |
-- Learning is not just about technology, but also about dreams!
- Home
- HTML
- JavaScript
- CSS
- Vue
- React
- Python3
- Java
- C
- C++
- C#
- AI
- Go
- SQL
- Linux
- VS Code
- Bootstrap
- Git
- Local Bookmarks
PHP Tutorial
PHP Tutorial PHP Introduction PHP Installation PHP Syntax PHP Variables PHP echo/print PHP EOF(heredoc) PHP Data Types PHP Type Comparisons PHP Constants PHP String PHP Operators PHP If...Else PHP Switch PHP Arrays PHP Array Sorting PHP Superglobals PHP While Loop PHP For Loop PHP Functions PHP Magic Constants PHP Namespaces PHP OOP PHP Quiz
PHP Forms
PHP Forms PHP Form Validation PHP Form - Required Fields PHP Form - Validate Email and URL PHP Complete Form Example PHP $_GET Variable PHP $_POST Variable
PHP Advanced Tutorial
PHP Multidimensional Arrays PHP Date PHP Include PHP File PHP File Upload PHP Cookie PHP Session PHP E-mail PHP Secure E-mail PHP Error PHP Exception PHP Filters PHP Advanced Filters PHP JSON
PHP 7 New Features
PHP Database
PHP MySQL Introduction PHP MySQL Connect PHP MySQL Create Database PHP MySQL Create Table PHP MySQL Insert Data PHP MySQL Insert Multiple Data PHP MySQL Prepared Statements PHP MySQL Read Data PHP MySQL Where PHP MySQL Order By PHP MySQL Update PHP MySQL Delete PHP ODBC
PHP XML
XML Expat Parser XML DOM XML SimpleXML
PHP and AJAX
AJAX Introduction AJAX PHP AJAX Database AJAX XML AJAX Live Search AJAX RSS Reader AJAX Poll
PHP Reference Manual
PHP Array PHP Calendar PHP cURL PHP Date PHP Directory PHP Error PHP Filesystem PHP Filter PHP FTP PHP HTTP PHP Libxml PHP Mail PHP Math PHP Misc PHP MySQLi PHP PDO PHP SimpleXML PHP String PHP XML PHP Zip PHP Timezones PHP Image Processing PHP RESTful PHP PCRE PHP Available Functions PHP Composer
Deep Dive
- Software
- Web Services
- Computer Science
- Programming
- Scripting Languages
- Programming Languages
- Web Design & Development
- Scripts
- Development Tools
PDOStatement::fetchColumn
PDOStatement::fetchColumn — Returns a single column from the next row of a result set. (PHP 5 >= 5.1.0, PECL pdo >= 0.9.0)
Description
Syntax
string PDOStatement::fetchColumn ([ int $column_number = 0 ] )Returns a single column from the next row of a result set, or FALSE if there are no more rows.
Parameters
column_number
The index number of the column you wish to retrieve from the row (0-indexed). If no value is provided, PDOStatement::fetchColumn() will retrieve the first column.
Return Values
PDOStatement::fetchColumn() returns a single column from the next row of a result set.
Note: If you use PDOStatement::fetchColumn() to retrieve data, there is no way to return another column from the same row.
Examples
Fetching the first column of the next row
<?php
$sth = $dbh->prepare("SELECT name, colour FROM fruit");
$sth->execute();
/* Fetch the first column from the result set */
print("Fetching the first column from the result set:n");
$result = $sth->fetchColumn();
print("name = $resultn");
print("Fetching the second column from the result set:n");
$result = $sth->fetchColumn(1);
print("colour = $resultn");
?>The above example will output:
Fetching the first column from the result set:
name = lemon
Fetching the second column from the result set:
colour = red