PHP reads the DBF file generated by VFP 8.0, 9.0
Seek the guidance of the Great God ...
DBF files manufactured by VFP8.0 above, with Tabel type> autoinc field or BLOB field, want to read through PHP, no?
The code is very simple as follows "
$add = ' C://batman//daten//ladert2. DBF ';
$e = "Driver={microsoft Visual FoxPro Driver}; SOURCETYPE=DBF; Sourcedb= ". $add."; Exclusive=no;collate=machine; Null=no;deleted=no; Backgroundfetch=no; ";
$odbc =odbc_connect ($e, ', ');
Echo $add;
$query = "SELECT * from". $add. ";";
$result _id = Odbc_do ($odbc, $query);
Odbc_result_all ($result _id, "Border=1 width=50%");
Odbc_close ($ODBC);
?>
Error
C://batman//daten//ladert2. Dbf
WARNING:ODBC_DO (): SQL error: [MICROSOFT][ODBC Visual FoxPro driver]not a table., SQL state S0002 in SQLExecDirect in \ c Xampp\htdocs\dbf.php on line 7
Structure of the file:
The ODBC driver was installed and then read at 8. 0 previous DBF files are possible, but the newest is no solution? is the ODBC driver on the Internet now just for the old version?
Don't know what the great gods have to do? vfp?9.0?? PHP ODBC
Share to:
------Solution--------------------
Did you try PDO, brother?
