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);
facebookShare on Facebook
TwitterTweet

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

David Yin

David is a blogger, geek, and web developer — founder of FreeInOutBoard.com. If you like his post, you can say thank you here

One Reply to “PHP connect DBF file update”

  1. i copied and tested the code you provided.. but still i always end up with this error.
    Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC dBase Driver] Syntax error in FROM clause., SQL state 37000 in SQLExecDirect in G:\wamp\www\MAPS\Map for Web 2011\trial.php on line 4
    [Microsoft][ODBC dBase Driver] Syntax error in FROM clause.
    what will i do to solve this problem?

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *