PHP connect DBF file update

I posted PHP connect DBF file with a sample. Now Pierre left the message and asked why error comes up.
I doing some tests and get the answer.
1) The database.dbf is reserved name.
2) The field name is always capital.

Let me give the better sample here.

require_once('odbc.php');
$strsql= 'SELECT * FROM dat.dbf';
$query = odbc_exec($odbc, $strsql) or die (odbc_errormsg());
while($row = odbc_fetch_array($query))
{
echo 'Client Name: '.$row['NAME'].'
';
echo 'Client Phone Number: '.$row['PHONE'].'
';
echo '<hr />';
}
odbc_close($odbc);

Share on Facebook

Tweet

Related posts:

PHP connect DBF file How to connect DBF file and read data by PHP script PHP bench test results of PHP 5.3, PHP 5.4, and PHP 5.5 What can go wrong when including another file into your php file How to add php script into .tpl file How to untar a tar file or gzip-bz2 tar file in linux PHP – Parse error: syntax error, unexpected end of file