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
转载随意!带上文章地址吧。