(PHP 5 >= 5.1.0, PHP 7, PHP 8, PECL pdo >= 0.1.0) Show PDOStatement::fetchAll — Fetches the remaining rows from a result set Descriptionpublic PDOStatement::fetchAll(int public
PDOStatement::fetchAll(int public PDOStatement::fetchAll(int public
PDOStatement::fetchAll(int Parametersmode Controls the contents of the returned array as documented in
PDOStatement::fetch(). Defaults to value of To return an array consisting of all values of a single column from the result set, specify To fetch only the unique values of a single column from the result set, bitwise-OR
To return an associative array grouped by the values of a specified column, bitwise-OR args This argument has a different meaning depending on the value of the
constructorArgs Arguments of custom class constructor when the Return ValuesPDOStatement::fetchAll() returns an array containing all of the remaining rows in the result set. The array represents each row as either an array of column values or an object with properties corresponding to each column name. An empty array is returned if there are zero results to fetch. Using this method to fetch large result sets will result in a heavy demand on system and possibly network resources. Rather than retrieving all of the data and manipulating it in PHP, consider using the database server to manipulate the result sets. For example, use the WHERE and ORDER BY clauses in SQL to restrict results before retrieving and processing them with PHP. Changelog
ExamplesExample #1 Fetch all remaining rows in a result set
The above example will output something similar to: Fetch all of the remaining rows in the result set: Array ( [0] => Array ( [name] => apple [0] => apple [colour] => red [1] => red ) [1] => Array ( [name] => pear [0] => pear [colour] => green [1] => green ) [2] => Array ( [name] => watermelon [0] => watermelon [colour] => pink [1] => pink ) ) Example #2 Fetching all values of a single column from a result set The following example demonstrates how to return all of the values of a single column from a result set, even though the SQL statement itself may return multiple columns per row.
The above example will output something similar to: Array(3) ( [0] => string(5) => apple [1] => string(4) => pear [2] => string(10) => watermelon ) Example #3 Grouping all values by a single column The following example demonstrates how to return an associative array grouped by the values of the specified column in the result set. The array contains three keys: values
The above example will output something similar to: array(3) { ["apple"]=> array(2) { [0]=> string(5) "green" [1]=> string(3) "red" } ["pear"]=> array(2) { [0]=> string(5) "green" [1]=> string(6) "yellow" } ["watermelon"]=> array(1) { [0]=> string(5) "pink" } } Example #4 Instantiating a class for each result The following example demonstrates the behaviour of the
The above example will output something similar to: array(3) { [0]=> object(fruit)#1 (2) { ["name"]=> string(5) "apple" ["colour"]=> string(5) "green" } [1]=> object(fruit)#2 (2) { ["name"]=> string(4) "pear" ["colour"]=> string(6) "yellow" } [2]=> object(fruit)#3 (2) { ["name"]=> string(10) "watermelon" ["colour"]=> string(4) "pink" } [3]=> object(fruit)#4 (2) { ["name"]=> string(5) "apple" ["colour"]=> string(3) "red" } [4]=> object(fruit)#5 (2) { ["name"]=> string(4) "pear" ["colour"]=> string(5) "green" } } Example #5 Calling a function for each result The following example demonstrates the behaviour of the
The above example will output something similar to: array(3) { [0]=> string(12) "apple: green" [1]=> string(12) "pear: yellow" [2]=> string(16) "watermelon: pink" [3]=> string(10) "apple: red" [4]=> string(11) "pear: green" } See Also
simplerezo at gmail dot com ¶ 5 years ago
dyukemedia at gmail dot com ¶ 7 years ago
esw at pixeloution dot removeme dot com ¶ 12 years ago
__construct() { Ant P. ¶ 13 years ago
Daniel Hofmann ¶ 13 years ago
fractalesque at gmail dot com ¶ 8 years ago
Anonymous ¶ 11 years ago
michael dot arnauts at gmail dot com ¶ 8 years ago
// ... Anonymous ¶ 14 years ago
Hayley Watson ¶ 11 years ago
stas at metalinfo dot ru ¶ 15 years ago
info at yuriblanc dot it ¶ 7 years ago
Anonymous ¶ 5 years ago
lu_kors ¶ 4 years ago
$results = $stmt->fetchAll(PDO::FETCH_GROUP|PDO::FETCH_ASSOC|PDO::FETCH_UNIQUE); mxrgus ¶ 12 years ago
harlequin2 at gmx dot de ¶ 14 years ago
jeroen dot deklerk at hotmail dot com ¶ 5 years ago
akira at etnforum dot com ¶ 7 years ago
= new DB(); mrshelly at hotmail dot com ¶ 13 years ago
= 'sa'; Dennis ¶ 12 years ago
php at erikthiart dot com ¶ 1 year ago
= $pdo->query('SELECT sex, name, car FROM users')->fetchAll(PDO::FETCH_GROUP);/* array ( herhor67 at interia dot pl ¶ 1 year ago
geompse at gmail dot com ¶ 1 year ago
Leonardo Costa linux at linuxmanbr dot com dot br ¶ 3 years ago
sidi dot khalifa at live dot fr ¶ 3 years ago
rudigerw at hotmail dot com ¶ 4 years ago
davey at php dot net ¶ 13 years ago
$result && $query->rowCount() > 0) { janniet at kiekies dot net ¶ 7 years ago
ramon at monztro dot com ¶ 10 years ago
GyoreG ¶ 8 years ago
Dean S. ¶ 6 years ago
How fetch data from database in PHP and display PDO?Fetch data from a result set by calling one of the following fetch methods: To return a single row from a result set as an array or object, call the PDOStatement::fetch method. To return all of the rows from the result set as an array of arrays or objects, call the PDOStatement::fetchAll method.
How fetch data from database in PHP and display in table?php $connect=mysql_connect('localhost', 'root', 'password'); mysql_select_db("name"); //here u select the data you want to retrieve from the db $query="select * from tablename"; $result= mysql_query($query); //here you check to see if any data has been found and you define the width of the table If($result){ echo "< ...
How fetch data from PostgreSQL database in PHP and display HTML table?PHP provides PostgreSQL libs to communicate PHP with Postgres database.. Enable Postgres module from php.ini file.. Create connection string using postgres database.. Get data and display into an HTML template.. How does PDO select data?First, connect to a MySQL database. Check it out the connecting to MySQL database using PDO tutorial for detail information. Then, construct a SELECT statement and execute it by using the query() method of the PDO object. The query() method of the PDO object returns a PDOStatement object, or false on failure.
|