FiveTech Software tech support forums

Code: Select all | Expand

<?php

function parseRecord($record, $fields, $filterFields = []) {
    $result = [];
    $offset = 1;

    foreach ($fields as $field) {
       
        $value = rtrim(substr($record, $offset, $field['length']));
        
        if (empty($filterFields) || in_array($field['name'], $filterFields)) {
            if ($field['type'] === 'N') {
                $value = is_numeric($value) ? floatval($value) : 0.0;
            } elseif ($field['type'] === 'C') {
                $value = my_utf8_encode($value);
            }
            $result[$field['name']] = $value;
        }
        $offset += $field['length'];
    }
    return $result;
}

function read_dbf( $file_path) {
    
    $dbData = php4dbf_openFile( $file_path, true, [ 'LAST' ] );
    
    $records = [];
    $parsedRecords = [];   

    for ($i = 1; $i <= php4dbf_eof( $dbData ); $i++) {     
        $record = php4dbf_readRecordByIndex( $dbData, $i - 1 );
        if ($record !== null) {
            $parsedRecord = parseRecord( $record, $dbData['fields'], $dbData['filterFields']);
            $parsedRecords[] = $parsedRecord;
        }
    } 
    php4dbf_closeDbfFile($dbData);
    return $parsedRecords;  
}

$file_path = "........";
$records = read_dbf($file_path);

?>


 

Code: Select all | Expand

A DBF file consists of two main components:

Header: Contains metadata about the file, such as the number of records, the number and type of fields (columns), and other administrative information.
Data Area: Contains the actual records stored in the file. Each record consists of a series of fields corresponding to the table's columns.
Header
The header of the DBF file is divided into several sections:

File Type: A byte indicating the type of file and the dBASE version. Date of Last Update: The last three bytes of the header indicate the date of the last modification. Number of Records: A 4-byte value indicating the total number of records in the file. Header Length: A 2-byte value indicating the length of the header in bytes. Record Length: A 2-byte value indicating the length of a single record in bytes. Reserved Areas: Several reserved areas for future use or specific software applications. Field Descriptions: A variable number of 32-byte blocks containing the description of each field in the file. This description includes the field name, data type, field length, decimal places (for numeric fields), and other attributes.
Data Area
The data area stores the actual table data. Each record consists of a fixed number of bytes, as specified in the header. The data is stored in a row-organized structure, with each row representing a record and each column representing a field.

Fields: Fields can have different data types, such as strings (Char), numeric values (Num), logical values (Bool), date (Date), and other specific types depending on the dBASE version. Delete Mark: Each record begins with a byte indicating whether the record is marked as deleted. A value of 0x20 (space) means the record is active, while a value of 0x2A (asterisk) means the record is deleted.