PHP 的 DBA(Database (dbm-style) Abstraction Layer) 可以接 Oracle Berkeley DB.
這邊有相容的 DB Layer 列表: PHP: Requirements - Manual
註: 此篇文章的範例使用 db4, 確定 PHP 5.3.3 以上可以正常執行, 不能執行的話, 可以換成 dbm 先測試看看. 🙂
Debian、Ubuntu Linux 安裝管理套件
- apt-get install db-util # 就可以有 db_dump、db_load、db_hotbackup、db_stat 等可以使用
PHP 的 DBA 基本操作 程式範例
下述的範例, dba_open() 可以於最上面打開, 於最下面 dba_close() 即可.
此範例內容於每個區塊都 open / close, 主要是要方便 copy 用, 只要拷貝此一區塊的程式, 就可以直接套用.
- <?php
- define('DB_FILE', '/tmp/dbadata.db'); // 此檔案即為 DB 檔, 請隨意命名
- if (!file_exists(DB_FILE)) {
- $dbh = dba_open(DB_FILE, 'n', 'db4');
- dba_close($dbh);
- }
- $result = array('abc', 'def');
- // 新增
- $dbh = dba_open(DB_FILE, 'c', 'db4');
- dba_replace('key1', serialize($result), $dbh);
- dba_replace('key2', serialize($result), $dbh);
- dba_close($dbh);
- // 抓取、確認 (修改模式也可以讀取 "c")
- $dbh = dba_open(DB_FILE, 'c', 'db4');
- $data = dba_fetch('key1', $dbh);
- echo "key1\n";
- print_r(unserialize($data));
- $data = dba_fetch('key2', $dbh);
- echo "key2\n";
- print_r(unserialize($data));
- dba_close($dbh);
- // 修改
- $dbh = dba_open(DB_FILE, 'c', 'db4');
- dba_replace('key1', 'abc', $dbh);
- dba_close($dbh);
- // 抓取、確認 (讀取 "r")
- $dbh = dba_open(DB_FILE, 'r', 'db4');
- $data = dba_fetch('key1', $dbh);
- echo "key1\n";
- print_r($data);
- dba_close($dbh);
- // 刪除
- $dbh = dba_open(DB_FILE, 'c', 'db4');
- dba_delete('key2', $dbh);
- dba_close($dbh);
- // Dump all
- $dbh = dba_open(DB_FILE, 'r', 'db4');
- $key = dba_firstkey($dbh);
- $i = 0;
- $list = array();
- while ($key != NULL) {
- $list[$i][$key] = dba_fetch($key, $dbh);
- $key = dba_nextkey($dbh);
- $i++;
- }
- print_r($list);
- ?>
