Tag: DBF

How to connect DBF file and read data by PHP script

Afte last post, my php-fpm support the dbase database file now.  Here is an example php script. $db = dbase_open('../db/clients.dbf',0); if ($db){ $record_numbers = dbase_numrecords($db); for ($i = 1; $i <= $record_numbers; $i++) { $row = dbase_get_record_with_names($db, $i); if ( strpos(trim($row['CLIENTNAME']), $clientname) !== FALSE and $row['deleted'] != 1) { $clientid = $row['CLIENTID']); echo 'Customer ID

Install dbase extension on php7, Ubuntu 16.04

I followed the instruction mostly based on mote0230 github. Please be noticed that updating (and probably inserting) with arrays that contain named indexes, is not working. For my project, it is OK. I just need to read the data from dbf files. dbase-pecl-php7 # PHP 7 sudo add-apt-repository ppa:ondrej/php sudo apt-get install php7.0-fpm php7.0-curl php7.0-mysql

PHP connect DBF file

DBF is very old format databse type. About 10 years ago, I use dBase which use DBF format. Now I will show you how to connect the DBF file from PHP script. 1) Add a system DSN in ODBC Data Source Administrator I have a source named dd.