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> ²ÎÊýÀàÐͲ»ÕýÈ·£¬»ò²»ÔÚ¿ÉÒÔ½ÓÊܵķ¶Î§Ö®ÄÚ£¬»
Ïà¹ØÎÊ´ð£º
1.¾«Í¨ÃæÏò¶ÔÏóµÄÉè¼ÆºÍ¿ª·¢£»
2.ÊìÁ·Ê¹ÓÃPHPÓïÑÔ(5.0+)½øÐÐÊý¾Ý¿â£¬ÍøÂçͨÐÅ£¬Îļþ¶Áд£¬°²È«»úÖÆµÈ¿ª·¢£»
3.ÊìÁ·Ê¹ÓÃMYSQL(5.0+)Êý¾Ý¿â¿ª·¢£¬°üÀ¨»ù±¾µÄÊý¾Ý¿âÉè¼Æ/ÓÅ»¯/°²È«£¬¸´ÔÓµÄT-SQLÓï¾ä±àд£¬ÊìÁ·±àдMYS ......
ÇëÎÊ£¬ÒÔÏ´úÂ룬Ϊʲô²»¹ÜÓ㿾Ístr_replaceÕâ¸öº¯Êý£¬Ì滻ôÓÐÆð×÷Óã¿
PHP code:
$gg='<script type=\"text/JavaScript\">
alimama_pid=\"mm_14281022_2030060_8250750\";
alima ......
index.phpÄÚÈÝ£º
$smarty->assign('name',strtotime('-0'));
$smarty->display("index.html");
index.htmlÄÚÈÝ£º
{$name|date_format:'%Y-%m-%d'}<hr>
{$ ......
<?php
@session_start();
require_once './module/t_doctor.inc';
$t_doctor = new t_doctor();
if(isset($Submit)){
$sql="select * from t_doctor WHERE docname='".$usernam ......