关于php读取access数据库的问题

weixin_42698772 2018-07-15 11:07:15
我的代码如下:
<?php
header("content-type:text/html;charset=gbk");
$odbc = "Driver={Microsoft Access Driver (*.mdb)};Dbq=".realpath("pscard.mdb");
$conn = odbc_connect($odbc, '', '', SQL_CUR_USE_ODBC);
$sql ="select * from pscard";
$query = odbc_exec($conn, $sql);
print $query."</br>";
$num = odbc_num_fields($query);
if ($num != 0)
for($i=1; $i<$num; $i++)
{
$row = odbc_fetch_row($query);
echo "->".odbc_result($query,"psname")."</br>";
}
else
print "No data";
$query->close();
?>

配置的iis服务,报错如下:
HTTP 错误 502.2 - Bad Gateway
指定的 CGI 应用程序由于未返回完整的一组 HTTP 头而产生错误行为。它实际返回的头是“PHP Warning: PHP Startup: Unable to load dynamic library 'interbase' (tried: ext\interbase (�Ҳ���ָ����ģ�顣), ext\php_interbase.dll (�Ҳ���ָ����ģ�顣)) in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library 'oci8_12c' (tried: ext\oci8_12c (�Ҳ���ָ����ģ�顣), ext\php_oci8_12c.dll (�Ҳ���ָ����ģ�顣)) in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library 'pdo_firebird' (tried: ext\pdo_firebird (�Ҳ���ָ����ģ�顣), ext\php_pdo_firebird.dll (�Ҳ���ָ����ģ�顣)) in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library 'pdo_oci' (tried: ext\pdo_oci (�Ҳ���ָ����ģ�顣), ext\php_pdo_oci.dll (�Ҳ���ָ����ģ�顣)) in Unknown on line 0 MIB search path: c:/usr/share/snmp/mibs Cannot find module (IP-MIB): At line 0 in (none) Cannot find module (IF-MIB): At line 0 in (none) Cannot find module (TCP-MIB): At line 0 in (none) Cannot find module (UDP-MIB): At line 0 in (none) Cannot find module (HOST-RESOURCES-MIB): At line 0 in (none) Cannot find module (SNMPv2-MIB): At line 0 in (none) Cannot find module (SNMPv2-SMI): At line 0 in (none) Cannot find module (NOTIFICATION-LOG-MIB): At line 0 in (none) Cannot find module (UCD-SNMP-MIB): At line 0 in (none) Cannot find module (UCD-DEMO-MIB): At line 0 in (none) Cannot find module (SNMP-TARGET-MIB): At line 0 in (none) Cannot find module (NET-SNMP-AGENT-MIB): At line 0 in (none) Cannot find module (DISMAN-EVENT-MIB): At line 0 in (none) Cannot find module (SNMP-VIEW-BASED-ACM-MIB): At line 0 in (none) Cannot find module (SNMP-COMMUNITY-MIB): At line 0 in (none) Cannot find module (SNMP-FRAMEWORK-MIB): At line 0 in (none) Cannot find module (SNMP-MPD-MIB): At line 0 in (none) Cannot find module (SNMP-USER-BASED-SM-MIB): At line 0 in (none) Cannot find module (SNMP-NOTIFICATION-MIB): At line 0 in (none) Cannot find module (SNMPv2-TM): At line 0 in (none) PHP Fatal error: Uncaught Error: Call to a member function close() on null in E:\iis\index.php:17 Stack trace: #0 {main} thrown in E:\iis\index.php on line 17 X-Powered-By: PHP/7.2.7 content-type:text/html;charset=gbk </br>No data<br /> <b>Fatal error</b>: Uncaught Error: Call to a member function close() on null in E:\iis\index.php:17 Stack trace: #0 {main} thrown in <b>E:\iis\index.php</b> on line <b>17</b><br /> ”。
...全文
235 1 打赏 收藏 转发到动态 举报
写回复
用AI写文章
1 条回复
切换为时间正序
请发表友善的回复…
发表回复
luyaran 2018-07-18
  • 打赏
  • 举报
回复
没看太明白。。。

21,886

社区成员

发帖
与我相关
我的任务
社区描述
从PHP安装配置,PHP入门,PHP基础到PHP应用
社区管理员
  • 基础编程社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧