如何使用ODBC方法将PHP连接到DBF文件

Question

I have an dbf file. I would like to use PHP to read data out of this dbf file using the ODBC connection method.

I am using xampp to test this.

I have set up the ODBC. Here is the ODBC connection.

<?php
$conn=odbc_connect('TestDBF','');
if (!$conn) {
    echo "Failed";
}
?>

This is the error I get:

The dbf file is saved on the desktop. How I can use PHP script to use ODBC connection to read data out of this file?*

Answer 1

If I remember right php doesn't handle dbf out of the box and you need to install an extension or find a version that has been compiled with that capability. THis may have changed though as the last time I used it was in the php 5.x days.

Also there are difference versions of dbf, so you need to make sure yours is compatible with whatever extesion/driver you are using.