PHP echo_dbf Beispiele

Beispiel #1

Datei: convert-kode-supplier.php Projekt: nurulimamnotes/AhadPOS2

<?php

include "../config/config.php";
echo_dbf('/home/ubuntu/Documents/_workshop/devel/indopos/tools/SUPLIER.DBF');
exit;
function echo_dbf($dbfname)
{
    $fdbf = fopen($dbfname, 'r');
    $fields = array();
    $buf = fread($fdbf, 32);
    $header = unpack("VRecordCount/vFirstRecord/vRecordLength", substr($buf, 4, 8));
    ////echo 'Header: '.json_encode($header).'<br/>';
    $goon = true;
    $unpackString = '';
    while ($goon && !feof($fdbf)) {
        // read fields:
        $buf = fread($fdbf, 32);
        if (substr($buf, 0, 1) == chr(13)) {
            $goon = false;
        } else {
            $field = unpack("a11fieldname/A1fieldtype/Voffset/Cfieldlen/Cfielddec", substr($buf, 0, 18));
            ////echo 'Field: '.json_encode($field).'<br/>';
            $unpackString .= "A{$field['fieldlen']}{$field['fieldname']}/";
            array_push($fields, $field);
        }
    }
    fseek($fdbf, $header['FirstRecord'] + 1);
    // move back to the start of the first record (after the field definitions)
    for ($i = 1; $i <= $header['RecordCount']; $i++) {
        $buf = fread($fdbf, $header['RecordLength']);
        $record = unpack($unpackString, $buf);

Beispiel #2

Datei: convert-dbf-2-mysql.php Projekt: nurulimamnotes/AhadPOS2

<?php

$server = "localhost";
$username = "******";
$password = "";
$database = "test2";
// Koneksi dan memilih database di server
mysql_connect($server, $username, $password) or die("Koneksi gagal");
mysql_select_db($database) or die("Database tidak bisa dibuka");
echo_dbf('/home/sufehmi/Documents/_workshop/devel/old-Ahad-POS/GDG_12.DBF');
exit;
function echo_dbf($dbfname)
{
    $fdbf = fopen($dbfname, 'r');
    $fields = array();
    $buf = fread($fdbf, 32);
    $header = unpack("VRecordCount/vFirstRecord/vRecordLength", substr($buf, 4, 8));
    ////echo 'Header: '.json_encode($header).'<br/>';
    $goon = true;
    $unpackString = '';
    echo "Total record: " . $header['RecordCount'] . " \n";
    while ($goon && !feof($fdbf)) {
        // read fields:
        $buf = fread($fdbf, 32);
        if (substr($buf, 0, 1) == chr(13)) {
            $goon = false;
        } else {
            $field = unpack("a11fieldname/A1fieldtype/Voffset/Cfieldlen/Cfielddec", substr($buf, 0, 18));
            ////echo 'Field: '.json_encode($field).'<br/>';
            $unpackString .= "A{$field['fieldlen']}{$field['fieldname']}/";
            array_push($fields, $field);