dba_fetch()

(PHP 4, PHP 5, PHP 7)

Fetch data specified by key

说明

dba_fetch(string $key,resource $handle): string

dba_fetch(string $key,int $skip,resource $handle): string

dba_fetch() fetches the data specified by$keyfrom the database specified with$handle.

参数

$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().

返回值

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

参见

• 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