使用PHP配置并连接access数据库
<p><p>首先下载 <a href="http://www.blueidea.com/articleimg/2005/12/3080/php-5.1.1-installer.rar" target="_blank"><u><font color="#0000ff">php-5.1.1-installer.exe</font></u></a></p><p> 才2M多,刷的就下来了，okok,然后运行,转到D盘吧，一路顺风，点击next。然后建一个目录<a href="http://www.phpchina.com/javascript:;" onClick="javascript:tagshow(event, 'php');" target="_self"><u><strong>php</strong></u></a>,新建文件info.php输入<a href="http://www.phpchina.com/javascript:;" onClick="javascript:tagshow(event, '%B4%FA%C2%EB');" target="_self"><u><strong>代码</strong></u></a>:</p><p><span class="code"><table style="border: 1px dotted rgb(204, 204, 204); table-layout: fixed;" align="center" border="0" cellpadding="6" cellspacing="0" width="95%"><tbody><tr><td bgcolor="#f3f3f3"><html> <br><body> <br><? phpinfo(); ?> <br></body> <br><html></td></tr></tbody></table></span></p><p> 在iis里数据http://localhost/php/info.php</p><p> 如果出现一长串的PHP Version 5.1.1等样子的话,恭喜,配置好了。</p><p> 如图:</p><p> <img alt="" src="http://edu.itbulo.com/UploadFiles_1485/200611/20061127222714253.gif" height="320" width="510"></p><p> 新建php/data/db.mdb,建表szd_t,输入点数据吧，如图:</p><p> <img alt="" src="http://edu.itbulo.com/UploadFiles_1485/200611/20061127222714232.gif" height="92" width="211"></p><p> 建立文件default.php;输入:</p><table style="border: 1px dotted rgb(204, 204, 204); table-layout: fixed;" align="center" border="0" cellpadding="6" cellspacing="0" width="95%"><tbody><tr><td bgcolor="#f3f3f3"><p> <?<br> $conn = new com("ADODB.Connection"); <br> $connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("data/db.mdb"); <br> $conn->Open($connstr); <br> $rs = new com("ADODB.RecordSet"); <br> $rs->Open("select * from szd_t",$conn,1,1); <br> while(! $rs->eof) { <br> $f = $rs->Fields(1); <br> echo $f->value; <br> $rs->MoveNext(); <br> } <br> ?></p></td></tr></tbody></table><p> 浏览,还打印你刚在<a href="http://www.phpchina.com/javascript:;" onClick="javascript:tagshow(event, '%CA%FD%BE%DD%BF%E2');" target="_self"><u><strong>数据库</strong></u></a>的记录,成功成功,哈哈哈,完毕。如图:</p><p> <img alt="" src="http://edu.itbulo.com/UploadFiles_1485/200611/20061127222715717.gif" height="133" width="230"></p><div>
