php链接access并查询列出

<?php
$odbc = "Driver={Microsoft Access Driver (*.mdb)};Dbq=".realpath("db.mdb");
$conn = odbc_connect($odbc, '', '', SQL_CUR_USE_ODBC);
$sql ="select * from user";
$query = odbc_exec($conn, $sql);
$num = odbc_num_fields($query);
echo "<table><tr><th>ID</th><th>username</th><th>password</th></tr>";
while ($row = odbc_fetch_row($query))
{
echo "<tr>";
echo "<td>".odbc_result($query,"id")."</td>";
echo "<td>".odbc_result($query,"username")."</td>";
echo "<td>".odbc_result($query,"password")."</td>";
echo "</tr>";
}
echo "</table>";
?>

posted @ 2019-11-25 17:13  黑旗君  阅读(376)  评论(0编辑  收藏  举报