用odbc连接的话,可以用odbc_fetch_array!
解决方案 »
- 只有这几行代码,为什么会报错,各位大侠帮忙看看那错了?
- 这句话代表什么意思?
- PHP添加水印后图像变的全黑
- 怎么把字符串转换成16进制编码形式的字符串??
- 打开的php的网页,却弹出下载的对话框!为什么?在线等(斑竹999)
- [急盼]请问 php 如何得到 smarty 模版中标但提交的变量?
- Unix的时间戳值 如 1056804717 用什么函数转换回一般的日期啊
- 计算机名打开站点?
- Header跳转的问题,我不明白,在线等待
- PHP项目增加一个搜索功能,
- php 怪问题,高手进来看下
- 关于Cannot add header information - headers already sent...”。
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("database\#conn#.mdb");$conn->Open($connstr);$rs = @new COM("ADODB.RecordSet")
$conn = @new COM("ADODB.Connection") or die ("ADO连接失败!");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("database\#conn#.mdb"); $conn->Open($connstr); $rs = @new COM("ADODB.RecordSet")
$sql="select * from daohan";
$rs->open($sql,$conn);
if(!$rs->eof)//$rs->bof
{
while($rs->fields=odbc_fetch_array($rs))
{ $data1[$rs->fields['name1']][$rs->fields['name2']][]=$rs->fields['NUM']; }
$rs->movenext();
}
$conn = @new COM("ADODB.Connection") or die ("ADO连接失败!");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("database\#conn#.mdb"); $conn->Open($connstr); $rs = @new COM("ADODB.RecordSet")
$sql="select * from daohan";
$rs->open($sql,$conn);
if(!$rs->eof)//$rs->bof
{
while($rs->fields=odbc_fetch_array($rs))
{
$name1 = $rs->fields['name1']->value;
$name2 = $rs->fields['name2']->value;
$data1[$name1][$name2][]=$rs->fields['NUM']->value; }
$rs->movenext();
}
Fatal error: Call to undefined method com::fieldsodbc_fetch_array() ODBC连接才能用odbc_fetch_array吧
我连接是ADODBADODB有没类似fieldsodbc_fetch_array的函数
$conn = @new COM("ADODB.Connection") or die ("ADO连接失败!");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("database\#conn#.mdb"); $conn->Open($connstr); $rs = @new COM("ADODB.RecordSet")
$sql="select * from daohan";
$rs->open($sql,$conn);
while($rs->eof)
{
$name1 = $rs->fields['name1']->value;
$name2 = $rs->fields['name2']->value;
$data1[$name1][$name2][]=$rs->fields['NUM']->value;
$rs->movenext();
} copy你的,没有注意看!呵呵.
问题解决了$conn = @new COM("ADODB.Connection") or die ("ADO连接失败!");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("database\#conn#.mdb"); $conn->Open($connstr); $rs = @new COM("ADODB.RecordSet")
$sql="select * from daohan";
$rs->open($sql,$conn);
while(!$rs->eof)
{
$name1 = $rs->fields['name1']->value;
$name2 = $rs->fields['name2']->value;
$data1[$name1][$name2][]=$rs->fields['NUM']->value;
$rs->movenext(); }