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'].'<br />';
echo 'Client Phone Number: '.$row['PHONE'].'<br />';
echo '<hr />';
}
odbc_close($odbc);
Stumble It!
Leave a comment