PHP Conference Nagoya 2025

dba_fetch

(PHP 4, PHP 5, PHP 7, PHP 8)

dba_fetchFetch data specified by key

Description

dba_fetch(string|array $key, Dba\Connection $dba, int $skip = 0): string|false

Overloaded signature deprecated as of 8.3.0:

dba_fetch(string|array $key, int $skip, resource $dba): string

dba_fetch() fetches the data specified by key from the database specified with dba.

Parameters

key

The key the data is specified by.

Note:

When working with inifiles this function accepts arrays as keys where index 0 is the group and index 1 is the value name. See: dba_key_split().

dba

A Dba\Connection instance, returned by dba_open() or dba_popen().

skip

The number of key-value pairs to ignore when using cdb databases. This value is ignored for all other databases which do not support multiple keys with the same name.

Return Values

Returns the associated string if the key/data pair is found, false otherwise.

Changelog

Version Description
8.4.0 The dba parameter expects a Dba\Connection instance now; previously, a valid dba resource was expected.
8.3.0 Calling dba_fetch() with dba as the 3rd argument is now deprecated.
8.2.0 dba_fetch()'s optional skip argument is now at the end in line with PHP userland semantics. The previously overloaded signature is still accepted but discouraged.

See Also

add a note

User Contributed Notes 1 note

up
2
khan666 at lycos dot co dot kr
13 years ago
:: fetch array sort.

ex) TEST_DATA.DB

1/korea/5000/word 1
10/japan/25000/word 10
21/china/130000/word 21
2/usa/35000/word 2

<?php
# LIST SORT
$DB4_DATABASE = "TEST_DATA.DB4";
$DIV = "/";
$_FILE = "$DATA_DIR/HUTM_NETWORK_ROUTER.DB"; // DB4 FileName

$db = dba_open($DB4_DATABASE,"r","db4");
$key = dba_firstkey($db);
$ii = 0;
while(
$key != NULL)
{
$LIST[$ii] = explode($DIV,dba_fetch($key, $db)); // fetch array
$key = dba_nextkey($db);
$ii++;
}
dba_close($db);
$total = $ii; // total count

# date sort
sort($LIST,SORT_NUMERIC); // numeric key sort ..

# list display
for($i=0;$i<$total;$i++)
{
$oData = explode($DIV,$LIST[$i]); // key + value (sort)

$key = trim(chop($oData[0])); # 키번호
$name = trim(chop($oData[1])); # 이름
$count = trim(chop($oData[2])); # 수
$word = trim(chop($oData[3])); # 설명

echo "$key / $name / $count / $word <br>\r\n";
}
?>

::result::

1/korea/5000/word 1
2/usa/35000/word 2
10/japan/25000/word 10
21/china/130000/word 21
To Top