如何在PHP中轻松读写DBF/FPT文件？hisamu/php-xbase助你高效处理XBase数据库

<code class="bash">composer require hisamu/php-xbase</code>

<pre class="brush:php;toolbar:false;"><?php

require 'vendor/autoload.php';

use XBase\TableReader;

$table = new TableReader('test.dbf');

echo "开始读取DBF文件...\n";
while ($record = $table->nextRecord()) {
    // 可以通过字段名直接访问，或者使用get()方法
    echo "ID: " . $record->id . ", Name: " . $record->name . "\n";
    // 或者
    // echo "ID: " . $record->get('id') . ", Name: " . $record->get('name') . "\n";
}
echo "DBF文件读取完毕。\n";
?>

<pre class="brush:php;toolbar:false;"><?php
use XBase\TableReader;

$table = new TableReader(
    'test.dbf',
    [
        'encoding' => 'cp1251' // 或者 'GBK', 'BIG5' 等
    ]
);
// ... 继续读取数据，数据将自动转换为UTF-8
?>

<pre class="brush:php;toolbar:false;"><?php
use XBase\TableReader;

$table = new TableReader(
    'test.dbf',
    [
        'columns' => ['my_column', 'another_column'] // 只加载这两列
    ]
);

while ($record = $table->nextRecord()) {
    echo $record->my_column . ", " . $record->another_column . "\n";
}
?>

<pre class="brush:php;toolbar:false;"><?php
require 'vendor/autoload.php';

use XBase\TableEditor;

$table = new TableEditor('test.dbf');

// 遍历并修改前10条记录
for ($i = 0; $i < 10; $i++) {
    $record = $table->nextRecord();
    if ($record) {
        $record->set('field', 'new_string_value_' . $i); // 修改字段值
        $table->writeRecord(); // 写入修改后的记录
    }
}

// 添加新记录
$newRecord = $table->appendRecord();
$newRecord->set('name', '新用户');
$newRecord->set('age', 30);
$table->writeRecord(); // 写入新记录

// 删除记录（标记删除，实际删除需pack()）
while ($record = $table->nextRecord()) {
    if ($record->get('status') === 'deleted') {
        $table->deleteRecord(); // 标记为已删除
    }
}

// 物理删除所有标记为删除的记录，并保存更改
$table
    ->pack() // 移除已删除的行
    ->save() // 保存所有更改
    ->close(); // 关闭文件
echo "DBF文件编辑和保存完毕。\n";
?>

<pre class="brush:php;toolbar:false;"><?php
require 'vendor/autoload.php';

use XBase\Enum\FieldType;
use XBase\Enum\TableType;
use XBase\Header\Column;
use XBase\Header\HeaderFactory;
use XBase\TableCreator;
use XBase\TableEditor;

$filepath = 'new_users.dbf';

// 创建一个Dbase III Plus Memo类型的表头
$header = HeaderFactory::create(TableType::DBASE_III_PLUS_MEMO);

$tableCreator = new TableCreator($filepath, $header);
$tableCreator
    ->addColumn(new Column([
        'name'   => 'name',
        'type'   => FieldType::CHAR,
        'length' => 50,
    ]))
    ->addColumn(new Column([
        'name'   => 'birthday',
        'type'   => FieldType::DATE,
    ]))
    ->addColumn(new Column([
        'name'   => 'is_vip',
        'type'   => FieldType::LOGICAL,
    ]))
    ->addColumn(new Column([
        'name'   => 'notes',
        'type'   => FieldType::MEMO, // 支持Memo字段
    ]))
    ->addColumn(new Column([
        'name'         => 'balance',
        'type'         => FieldType::NUMERIC,
        'length'       => 10,
        'decimalCount' => 2,
    ]))
    ->save(); // 创建文件

// 现在可以像编辑现有表一样向新表添加记录
$tableEditor = new TableEditor($filepath);
$record = $tableEditor->appendRecord();
$record->set('name', '张三');
$record->set('birthday', new DateTime('1990-01-15'));
$record->set('is_vip', true);
$record->set('notes', '一位重要的客户。');
$record->set('balance', 1234.56);
$tableEditor->writeRecord();

$record = $tableEditor->appendRecord();
$record->set('name', '李四');
$record->set('birthday', new DateTime('1985-05-20'));
$record->set('is_vip', false);
$record->set('notes', '普通客户。');
$record->set('balance', 500.00);
$tableEditor->writeRecord();

$tableEditor->save()->close();
echo "新DBF文件创建并填充完毕。\n";
?>