注意:mysql_* 函數已於 PHP 5.5 棄用、PHP 7.0 移除。新專案請改用 mysqli 或 PDO。本文僅作歷史代碼維護參考。
mysql_fetch_row(resource $result): array|false
返回數值索引陣列(0 起始),對應結果集當前行;無更多行返回 false。
<?php
$user = 'abc'; $pass = '1234';
$link = mysql_connect('localhost', $user, $pass) or die('連線失敗');
mysql_select_db('w3db', $link) or die('選庫失敗');
$query = "SELECT ISBN, Title, Author FROM articles";
$result = mysql_query($query, $link);
while ($row = mysql_fetch_row($result)) {
echo "ISBN = {$row[0]}<br>\n";
echo "Title = {$row[1]}<br>\n";
echo "Author = {$row[2]}<br>\n";
}
mysql_free_result($result);
mysql_close($link);
?>
$mysqli = new mysqli('localhost', 'user', 'pass', 'db');
$stmt = $mysqli->prepare('SELECT ISBN, Title, Author FROM articles');
$stmt->execute();
$res = $stmt->get_result();
while ($row = $res->fetch_row()) { /* ... */ }
$pdo = new PDO('mysql:host=localhost;dbname=db', 'user', 'pass');
$stmt = $pdo->query('SELECT ISBN, Title, Author FROM articles');
while ($row = $stmt->fetch(PDO::FETCH_NUM)) { /* ... */ }