(PHP 4, PHP 5, PHP 7, PHP 8)
pg_fetch_array — Fetch a row as an array
pg_fetch_array() returns an array that corresponds to the fetched row (record).
pg_fetch_array() is an extended version of pg_fetch_row(). In addition to storing the data in the numeric indices (field number) to the result array, it can also store the data using associative indices (field name). It stores both indices by default.
Bilginize: Bu işlev NULL alanlara PHP
null
değerini atar.
pg_fetch_array() is NOT significantly slower than using pg_fetch_row(), and is significantly easier to use.
result
pg_query(), pg_query_params() veya pg_execute() işlevinden dönen PgSql\Result nesnesi.
row
Row number in result to fetch. Rows are numbered from 0 upwards. If
omitted or null
, the next row is fetched.
mode
Dizinin nasıl indisleneceğini belirleyen seçimlik bağımsız değişken.
kip
bir sabit olup şu değerleri alabilir:
PGSQL_ASSOC
, PGSQL_NUM
ve
PGSQL_BOTH
.
PGSQL_NUM
ile işlev sayısal indisli bir dizi,
PGSQL_ASSOC
ile ilişkisel bir dizi ve
PGSQL_BOTH
ile hem sayısal hem de ilişkisel indisli bir
dizi döndürür.
An array indexed numerically (beginning with 0) or
associatively (indexed by field name), or both.
Each value in the array is represented as a
string. Database NULL
values are returned as null
.
false
is returned if row
exceeds the number
of rows in the set, there are no more rows, or on any other error.
Fetching from the result of a query other than SELECT will also return false
.
Sürüm: | Açıklama |
---|---|
8.1.0 |
sonuç bağımsız değişkeni artık
PgSql\Result nesnesi kabul ediyor, evvelce bir
özkaynak kabul ederdi.
|
Örnek 1 pg_fetch_array() example
<?php
$conn = pg_pconnect("dbname=publisher");
if (!$conn) {
echo "An error occurred.\n";
exit;
}
$result = pg_query($conn, "SELECT author, email FROM authors");
if (!$result) {
echo "An error occurred.\n";
exit;
}
$arr = pg_fetch_array($result, 0, PGSQL_NUM);
echo $arr[0] . " <- Row 1 Author\n";
echo $arr[1] . " <- Row 1 E-mail\n";
// The row parameter is optional; NULL can be passed instead,
// to pass a result_type. Successive calls to pg_fetch_array
// will return the next row.
$arr = pg_fetch_array($result, NULL, PGSQL_ASSOC);
echo $arr["author"] . " <- Row 2 Author\n";
echo $arr["email"] . " <- Row 2 E-mail\n";
$arr = pg_fetch_array($result);
echo $arr["author"] . " <- Row 3 Author\n";
echo $arr[1] . " <- Row 3 E-mail\n";
?>