PHP连接访问本地DBF文件

[cjf275241568]

程序如下:
<?php
set_time_limit (0);
$cfg_dsn = "Driver={Microsoft Visual FoxPro Driver};SourceType=dbf;sourcedb=d:\;BackgroundFetch=yes";
$cfg_dsn_login = "";
$cfg_dsn_mdp = "";
$conn = odbc_connect($cfg_dsn,$cfg_dsn_login,$cfg_dsn_mdp);
$sql = " SELECT Qty FROM Pd101 ";
$exec = odbc_exec ($conn,$sql);
while ($rows = odbc_fetch_object( $exec ))
echo("<P>" . $array["Qty"] . "</P>");
?>
运行后一直错误,我想在网页上显示出DBF文件的信息,是不是写少什么语句,求大大帮忙,先谢谢了
运行后的错误提示:
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Visual FoxPro Driver]Cannot open file d:\pd101.dbf., SQL state S1000 in SQLExecDirect in D:\Apache2\htdocs\dbf1.php on line 16

Warning: odbc_fetch_object(): supplied argument is not a valid ODBC result resource in D:\Apache2\htdocs\dbf1.php on line 17

[cjf275241568]

是不是没分就没分帮忙啊?我刚刚来的是没分- -

[snowwhitecx]

楼主的问题解决了没有啊,我也遇到相同问题,希望能联系qq 99149154

[wldzjj]

你最后一行应该输出
echo(" <P>" . $row["Qty"] . " </P>");

[snowwhitecx]

<?php

//set_time_limit (0);
$cfg_dsn = "Driver={Microsoft Visual FoxPro

Driver};SourceType=dbf;sourcedb=c:\;BackgroundFetch=yes";
$cfg_dsn_login = "";
$cfg_dsn_mdp = "";
$conn = odbc_connect($cfg_dsn,$cfg_dsn_login,$cfg_dsn_mdp);
$sql = " SELECT * FROM rep.dbf ";
$exec = odbc_exec ($conn,$sql);
while ($rows = odbc_fetch_object( $exec ))
echo("-=" . $array[1] . " -= " . $array["jylsh"] ."<br>");

?>

我试了一下你的代码,是好用的,可能你的文件路径不对,但是虽然能娶到dbf的行数,里面的具体数据确实取不到的

[snowwhitecx]

echo(" <P>" . $row["Qty"] . " </P>");
这个也出不来内容,跟字段类型有关系么?

[snowwhitecx]

<?php

//set_time_limit (0);
$cfg_dsn = "Driver={Microsoft Visual FoxPro Driver};SourceType=dbf;sourcedb=c:\;BackgroundFetch=yes";
$cfg_dsn_login = "";
$cfg_dsn_mdp = "";
$conn = odbc_connect($cfg_dsn,$cfg_dsn_login,$cfg_dsn_mdp);
$sql = " SELECT * FROM rep ";
$result=dbase_add_record($db,$content);
while ($rows = odbc_fetch_object( $result ))
echo("-=" . $array[1] . " -= " . $array["Jylsh"] ."<br>");

?>
Fatal error: Cannot use object of type stdClass as array in E:\AppServ\www\aaa.php on line 12