pg_fetch_all_columns
Be aware that pg_fetch_all() is subject to the same limitations as pg_fetch_assoc(), in that if your query returns multiple columns with the same name (or alias) then only the rightmost one will be returned in the associative array, other ones will not.
A simple example:
<?php
$res = pg_query(
"SELECT a.*, b.* -- Fetch all columns from both tables
FROM table1 AS a
LEFT OUTER JOIN table2 as b
USING (column)"
);
$rows = pg_fetch_all($res);
?>
In this example, since we're selecting columns via *, if any columns from table2 share the same names as those in table1, they will be the ones returned despite that table2 (as the optional side of an outer join) may return NULL values.
This is not a bug, just a limitation of associative arrays in general, and is easy enough to avoid by structuring your queries carefully and using column aliases to avoid confusion.
pg_fetch_all
(PHP 4 >= 4.3.0, PHP 5)
pg_fetch_all — Lit toutes les lignes d'un résultat
Description
array pg_fetch_all
( resource $result
)
pg_fetch_all() retourne un tableau qui contient toutes les lignes du résultat result .
Note: Cette fonction définit les champs NULL à la valeur PHP NULL.
Liste de paramètres
- result
-
Ressource résultat de requête PostgreSQL, retourné par pg_query(), pg_query_params() ou pg_execute() (entre autres).
Valeurs de retour
Un tableau array de toutes les lignes dans le jeu de résultats. Chaque ligne est un tableau de valeurs des champs indexée par le nom des champs.
FALSE est retournée s'il n'y a pas de lignes dans le jeu de résultats ou si une erreur survient.
Exemples
Exemple #1 Exemple avec pg_fetch_all()
<?php
$conn = pg_pconnect ("dbname=publisher");
if (!$conn) {
echo "Une erreur est survenue.\n";
exit;
}
$result = pg_query ($conn, "SELECT * FROM auteurs");
if (!$result) {
echo "Une erreur est survenue.\n";
exit;
}
$arr = pg_fetch_all ($result);
var_dump($arr);
?>
Voir aussi
- pg_fetch_row() - Lit une ligne dans un tableau
- pg_fetch_array() - Lit une ligne de résultat PostgreSQL dans un tableau
- pg_fetch_object() - Lit une ligne de résultat PostgreSQL dans un objet
- pg_fetch_result() - Retourne les valeurs d'un résultat
add a note
User Contributed Notespg_fetch_all
strata_ranger at hotmail dot com
11-Jun-2009 03:00
11-Jun-2009 03:00
prefer_not_to at say dot com
02-Jun-2009 05:09
02-Jun-2009 05:09
For those wondering, this function returns a two-dimentional array, the first dimension being a 0-based indexed array, the second dimension an associative. So you might access the first authors surname using $authors[0]["surname"].
Certainly this is the case in PHP 5.2.9, I can't vouch for other versions though.
viniciusweb at gmail dot com
21-Mar-2005 02:20
21-Mar-2005 02:20
This function returns NULL if the parameter is false.
frig1 at gmx dot at
03-Feb-2005 04:15
03-Feb-2005 04:15
I'm using PHP 5.0.1 and pg_fetch_all and here pg_fetch_all is also not recognized as function
10-Jun-2003 12:36
Also for those who are trying to move off oracle, pg_fetch_all returns an array with rows and columns inverted in the sense of ocifetchall. You would need to transpose this result array before your code takes the first index a column name and the second index a row index.
php dot net at mechintosh dot com
16-May-2003 06:42
16-May-2003 06:42
For versions of PHP that don't yet support the new names or newer functions I wrote a couple functions like this one
if (! function_exists("pg_fetch_all")) {
function pg_fetch_all($res, $kind="assoc") {
$i = 0; // this is needed for the row integer in the looped pg_fetch_array
if ($kind == "assoc") {
while ($row = pg_fetch_array($res, $i, PGSQL_ASSOC)) {
$array_out[] = $row;
$i++;
}else{
while ($row = pg_fetch_array($res)) {
$array_out[] = $row;
}
}
return $array_out;
}
}
tasmanian at devil dot com
27-Mar-2003 06:42
27-Mar-2003 06:42
It seems like pg_fetch_all() only works on version 4.3.x. I tried it with 4.2.2 and it does not recognize the function, so I assume it won't work on 4 => 4.2.x.
jcomeau at whatisthewww dot com
19-Feb-2003 08:02
19-Feb-2003 08:02
pg_fetch_all, despite the app note, accepts only one argument, the resultset. It does exactly what is expected, returning a two-dimensional array of the resultset. I suspect the app note given was just copied from pg_fetch_array, which is what you want to use for a single row.