dba_fetch
(PHP 4, PHP 5)
dba_fetch — Fetch data specified by key
Description
$key
, resource $handle
)$key
, int $skip
, resource $handle
)
dba_fetch() fetches the data specified by
key from the database specified with
handle.
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().
-
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.
-
handle -
The database handler, returned by dba_open() or dba_popen().
Return Values
Returns the associated string if the key/data pair is found, FALSE
otherwise.
Changelog
| Version | Description |
|---|---|
| 4.3.0 |
The skip parameter is available to support
cdb's capability of multiple keys having the same name.
|
See Also
- dba_exists() - Check whether key exists
- dba_delete() - Delete DBA entry specified by key
- dba_insert() - Insert entry
- dba_replace() - Replace or insert entry
- dba_key_split() - Splits a key in string representation into array representation
Коментарии
:: 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