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> ²ÎÊýÀàÐͲ»ÕýÈ·£¬»ò²»ÔÚ¿ÉÒÔ½ÓÊܵķ¶Î§Ö®ÄÚ£¬»
Ïà¹ØÎÊ´ð£º
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
Ôڲɼ¯Ò»¸öÒ³ÃæµÄʱºòͨ³£¶¼ÊÇʹÓÃfile_get_contents($url)
²»¹ý·µ»ØµÄ½á¹ûÓÐʱºò»á²»È«
Èç¹ûÔÚhtmlÖÐʹÓà document.ready,ÔÚÒ³Ãæ×¼±¸ºÃºó£¬Ê¹ÓÃajax¶ÁÈ¡±ðÒ»²¿·ÖµÄÊý¾Ý
ÔÙͨ¹ýÐÞ¸Ähtml±êÇ©µÄÄÚÈÝ£¬¾Í²¿·ÖµÄÊý¾Ý¾ ......
ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã
ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´...
ÆÚ´ý¸ßÈËÖ¸µã ÎÒ ......
±±¾©2ÄêPHP¾ÑéÇó¼æÖ°
½Ó·Ö
·¹ý½Ó·Ö£¡.¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£
jf~~~~~~~~~~~~~~Ö§³Ö
ßÀ¡£¡£ÎÒÃÇÐèÒª¼æÖ°£¬¿ÉÊÇÔõôÁªÏµÄãѽ£¿
¶¥¡£¡£¡£ »Ø¸´ÄÚÈÝ »Ø¸´ÄÚÈÝÌ«¶ÌÁË£¡
º¼ÖÝÄãÈ¥²»È¥°¡ ¡£¡£¡£¡£¡ ......
´íÎóÌáʾ£º
Error creating bean with name 'DAOProxy' defined in class path resource [appcontext.xml]: Cannot resolve reference to bean 'transactionManager' while setting bean property 'transactionMana ......