会python真的可以为所欲为0(回)
356天前
这里还有人吗1(回)
541天前这里还有人吗0(回)
541天前
每天面对着电脑屏幕，敲打键盘。我所面对的并不只是代码，而是一种生活方式。0(回)
765天前到处都是羊，不想上班0(回)
845天前
鸽子
0(回)
850天前<?php |
//读取access数据库数据库案例，很久之前的项目了，存在这里备忘，仅供参考 |
$conn = new com("ADODB.Connection"); |
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("./SpiderResult.mdb"); |
$conn->Open($connstr); |
$rs = new com("ADODB.RecordSet"); |
$rs->Open("select * from Content",$conn,1,1); |
while(! $rs->eof){ |
echo $rs->Fields(1)->value; |
echo "<br>"; |
echo $rs->Fields(2)->value; |
echo "<br>"; |
echo $rs->Fields(3)->value; |
echo "<br>"; |
echo "<hr>"; |
$rs->MoveNext(); |
} |
// 数据写入方法 |
$connstr="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("../chen416/mydata.mdb"); |
$connid=odbc_connect($connstr,"","",SQL_CUR_USE_ODBC); |
$issuetime=date("Y-m-d H:i:s"); |
$sql="insert into userinfo (username,userword,email) values('u2','w2','uw@163.com')"; |
$result=odbc_exec($connid,$sql); |
if($result) echo "successful"; |
else echo "failed"; |
// 读取数据库 |
$conn=new COM("ADODB.Connection"); |
$dsn="DRIVER={Microsoft Access Driver (*.mdb)};DBQ=".realpath("../mydata.mdb").";"; |
$conn->open($dsn); |
$sql="select * from userinfo"; |
$rs=$conn->Execute($sql); |
$row="0"; |
while(!$rs->EOF){ |
$string =""; |
for ($i=0;$i<$rs->Fields->count;$i++){ |
if ($i==0){ |
$string.=$rs->Fields($i)->Value; |
continue; |
} |
$string.='|'.$rs->Fields($i)->Value; |
} |
$string.="\n"; |
if ($row==300){ |
break; |
} |
$row++; |
echo "<br>"; |
echo $string; |
$rs->MoveNext(); |
} |
// 删除数据方法 |
$conn = new com("ADODB.Connection"); |
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("../mydata.mdb"); |
$conn->Open($connstr); |
$query = "delete from userinfo where uid=1"; |
$result =$conn->Execute($query); |
if($result) echo "删除成功"; |
else echo "删除失败"; |
// PHP更新数据方法： |
$conn = new com("ADODB.Connection"); |
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("../mydata.mdb"); |
$conn->Open($connstr); |
$query = "update userinfo set username='ganjun' where uid=2"; |
$result =$conn->Execute($query); |
if($result)echo "更新数据成功"; |
else echo "更新数据失败"; |
?> |
