php读取access数据库问题???
$conn = new COM("ADODB.Connection") or die ("ADO Connection faild.");
$connstr = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=".realpath("app.mdb");
$conn->Open($connstr);
function proshow($condition1,$condition2)
{
if ($condition1=="" || $condition2="")
{
$condition="";
}
else
{
$condition=" where".$condition1."=".$condition2." ";
}
$rr = new COM("ADODB.RecordSet");
$rr->Open("select * from PE_Product '$condition' order by ProductID desc",$conn);
while(!$rr->EOF)
{
$p_name=$rr->Fields("ProductName");
$p_price=$rr->Fields("Price");
echo "<div>名字:".$p_name->value."</div>";
echo "<div>零售价:".$p_price->value."</div>";
$rr->Movenext();
}
}
proshow("","");
$rr->close();
//////////////////
为什么调用proshow()函数会出现错误???
错误提示:
Fatal error: Uncaught exception 'com_exception' with message '<b>Source:</b> ADODB.Recordset<br/><b>Description:</b> 参数类型不正确,或不在可以接受的范围之内,或与其他参数冲突。' in F:\phpsite\shop\index.php:23 Stack trace: #0 F:\phpsite\shop\index.php(23): com->Open('select * from P...', NULL) #1 F:\phpsite\shop\index.php(39): proshow() #2 {main} thrown in F:\phpsite\shop\index.php on line 23