<?php
$dsn = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=E:\\Databases\data.mdb";
$conn = odbc_connect($dsn, "", "")
or die ("Failed connecting to the Access Database");
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Microsoft Access 2003</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"><style type="text/css">
<!--
body,td,th {
font-size: 13px;
font-family: Arial, Helvetica, sans-serif;
}
-->
</style></head>
<body>
<?php
$sql = "SELECT * FROM Products ORDER BY ProductID ASC";
$rs = odbc_exec($conn, $sql);
?>
<table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#66CC00">
<tr>
<td width="60" height="21" align="center" bgcolor="#E7FFD7">產品編號</td>
<td height="21" align="center" bgcolor="#E7FFD7">產品名稱</td>
<td width="200" align="center" bgcolor="#E7FFD7">產品描述</td>
<td width="70" height="21" align="center" bgcolor="#E7FFD7">產品價格</td>
</tr>
<?php while ($row = odbc_fetch_array($rs)) { ?>
<tr>
<td width="60" height="28" align="center" bgcolor="#E7FFD7"><?=$row["ProductID"]?></td>
<td height="28" align="center" bgcolor="#FFFFFF"><?=$row["ProductName"]?></td>
<td width="200" align="center" bgcolor="#FFFFFF"><?=$row["ProductDescription"]?></td>
<td width="70" height="28" align="center" bgcolor="#FFFFFF">$<?=$row["ProductPrice"]?></td>
</tr>
<?php } ?>
</table>
</body>
</html>
<?php
odbc_close($conn);
?>
|
目前共有6篇帖子。
【示例】PHP通過ODBC連接資料庫
回復帖子 |
