access 查询放到数组问题 用odbc连接的话,可以用odbc_fetch_array! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 楼主用的是ODBC连接ACCESS的吧??如果是,楼上的说的正确。 $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") 应该怎么写呢,我怎么写都不对$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();} 我不是很擅长ACCESS,但是好像,直接用$rs->fields,就可以获得数组了,你试一下的。 $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的函数 Warning: odbc_fetch_array(): supplied argument is not a valid ODBC result resource in $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你的,没有注意看!呵呵. 多谢jakey9826 问题解决了$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(); } 楼主是否结错了,把Jakey9826的分给了我的,呵呵。 php的post传值出现问题,新安装的wamp 【正则表达式问题】怎么匹配单独(两端非空格)的2个空格 PHP调用外部文件问题?? 请教有用过 Sphinx 吗?应该怎么跟php结合使用? 本人新手,求大神帮我解决 我错了,再也不犯了,马上跳槽! 怎么处理mysql乱码问题? php错误提示???在线等!!!!! php不支持mysql,怎样解决 请问大神们有碰到过这个问题吗?我是了很多方法都没解决 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(); }