Need help with php-xbase?
Click the “chat” button below for chat support from the developer who created it, or find similar developers for support.

About the developer

luads
151 Stars 74 Forks MIT License 206 Commits 3 Opened issues

Description

A simple parser for *.dbf files using PHP

Services available

!
?

Need anything else?

Contributors list

PHP XBase

Build Status Test Coverage Latest Stable Version Total Downloads License

A simple library for dealing with dbf databases like dBase and FoxPro. It's a port of PHPXbase class written by Erwin Kooi, updated to a PSR-2 compliant code and tweaked for performance and to solve some issues the original code had.

Installation

You can install it through Composer:

shell script
$ composer require hisamu/php-xbase

Sample usage

More samples in

tests
folder.

Reading data

use XBase\TableReader;

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

while ($record = $table->nextRecord()) { echo $record->get('my_column'); //or echo $record->my_column; }

If the data in DB is not in UTF-8 you can specify a charset to convert the data from:

use XBase\TableReader;

$table = new TableReader( 'test.dbf', [ 'encoding' => 'cp1251' ] );

It is also possible to read Memos from dedicated files. Just make sure that .fpt file with the same name as main database exists.

Performance

You can pass an array of the columns that you need to the constructor, then if your table has columns that you don't use they will not be loaded. This way the parser can run a lot faster.

use XBase\TableReader;

$table = new TableReader( 'test.dbf', [ 'columns' => ['my_column', 'another_column'] ] );

while ($record = $table->nextRecord()) { echo $record->my_column; echo $record->another_column; }

If you know the column type already, you can also call the type-specific function for that field, which increases the speed too.

while ($record = $table->nextRecord()) {
    echo $record->get('my_column');
    echo $record->get('another_column');
}

Editing Data

To open a table for editing, you have to use a

TableEditor
object, as on this example:
use XBase\TableEditor;

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

for ($i = 0; $i < 10; $i++) { $record = $table->nextRecord();

$record-&gt;set('field', 'string');
//or
$record-&gt;field = 'string';

$table-&gt;writeRecord();

}

$table ->save() ->close();

Add new record

use XBase\TableEditor;

$table = new TableEditor( 'file.dbf', [ 'editMode' => TableEditor::EDIT_MODE_CLONE, //default ] ); $record = $table->appendRecord(); $record->set('name', 'test name'); $record->set('age', 20);

$table ->writeRecord() ->save() ->close();

Delete record

use XBase\TableEditor;

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

while ($record = $table->nextRecord()) { if ($record->get('delete_this_row')) { $table->deleteRecord(); //mark record deleted }
}

$table ->pack() //remove deleted rows ->save() //save changes ->close();

Creating table

To create a table file you need to use the

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

// you can specify any other database version from TableType $header = HeaderFactory::create(TableType::DBASE_III_PLUS_MEMO); $filepath = '/path/to/new/file.dbf';

$tableCreator = new TableCreator($filepath, $header); $tableCreator ->addColumn(new Column([ 'name' => 'name', 'type' => FieldType::CHAR, 'length' => 20, ])) ->addColumn(new Column([ 'name' => 'birthday', 'type' => FieldType::DATE, ])) ->addColumn(new Column([ 'name' => 'is_man', 'type' => FieldType::LOGICAL, ])) ->addColumn(new Column([ 'name' => 'bio', 'type' => FieldType::MEMO, ])) ->addColumn(new Column([ 'name' => 'money', 'type' => FieldType::NUMERIC, 'length' => 20, 'decimalCount' => 4, ])) ->addColumn(new Column([ 'name' => 'image', 'type' => FieldType::MEMO, ])) ->save(); //creates file

$table = new TableEditor($filepath); //... add records

Troubleshooting

I'm not an expert on dBase and I don't know all the specifics of the field types and versions, so the lib may not be able to handle some situations. If you find an error, please open an issue and send me a sample table that I can reproduce your problem, and I'll try to help.

Useful links

Xbase File Format Description

File Structure for dBASE 7

DBF AND DBT/FPT FILE STRUCTURE

We use cookies. If you continue to browse the site, you agree to the use of cookies. For more information on our use of cookies please see our Privacy Policy.