入門級範例:使用 mysql_connect 連線、mysql_select_db 選擇資料庫、mysql_query 執行 SQL、mysql_fetch_array 逐列取得資料並輸出 HTML 表格。注意:mysql_* 已移除,現代專案請用 PDO/MySQLi。
<?php
$con = mysql_connect('localhost', 'peter', 'abc123');
if (!$con) die('連線失敗: ' . mysql_error());
mysql_select_db('cinema', $con);
mysql_query('SET NAMES utf8', $con);
$sql = 'SELECT * FROM `t_hall`';
$query = mysql_query($sql, $con);
echo '<table align="center" border="1" cellspacing="0" width="550">';
echo '<tr><th>影廳編號</th><th>大廳名</th><th>座位行</th><th>座位列</th></tr>';
while ($row = mysql_fetch_array($query)) {
echo '<tr onclick="GetText()">'
. '<td>' . htmlspecialchars($row['HID']) . '</td>'
. '<td>' . htmlspecialchars($row['HHall']) . '</td>'
. '<td>' . htmlspecialchars($row['HSeatline']) . '</td>'
. '<td>' . htmlspecialchars($row['HSeatrow']) . '</td>'
. '</tr>';
}
echo '</table>';
mysql_free_result($query);
mysql_close($con);
?>
<?php
$pdo = new PDO('mysql:host=localhost;dbname=cinema;charset=utf8mb4', 'user', 'pass', [
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
]);
$stmt = $pdo->query('SELECT HID, HHall, HSeatline, HSeatrow FROM t_hall');
?>
<table>
<thead><tr><th>影廳編號</th><th>大廳名</th><th>座位行</th><th>座位列</th></tr></thead>
<tbody>
<?php while ($row = $stmt->fetch()): ?>
<tr>
<td><?= htmlspecialchars($row['HID']) ?></td>
<td><?= htmlspecialchars($row['HHall']) ?></td>
<td><?= htmlspecialchars($row['HSeatline']) ?></td>
<td><?= htmlspecialchars($row['HSeatrow']) ?></td>
</tr>
<?php endwhile; ?>
</tbody>
</table>
prepare())。close()。