<?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);
<?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);