php 与access 数据库连接实例
<?php echo "<table border='1'>"; echo "<tr>"; echo "<th>personID</th>"; echo "<th>FirstName</th>"; echo "<th>LastName</th>"; echo "<th>Age</th>"; echo "</tr>"; $connstr = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" . realpath("SpiderResult.mdb"); $conn = odbc_connect($connstr, "", "", SQL_CUR_USE_ODBC); $query = odbc_do($conn, "select top 10 * from content"); while (odbc_fetch_row($query)) { echo "<tr>"; $personID = odbc_result($query, 1); $FirstName = odbc_result($query, 2); $LastName = odbc_result($query, 3); $Age = odbc_result($query, 4); echo "<td>" . $personID . "</td>"; echo "<td>" . $FirstName . "</td>"; echo "<td>" . $LastName . "</td>"; echo "<td>" . $Age . "</td>"; echo "</tr>"; } echo "</table>"; odbc_close($conn);
永久链接:http://www.phprm.com/code/access_php.html
转载随意!带上文章地址吧。