CascadiaPHP 2024


(PHP 4, PHP 5)

mysql_fetch_rowGet a result row as an enumerated array


Questa enstensione deprecata da PHP 5.5.0, e sarà rimossa in futuro. Al suo posto, usare l'estensione MySQLi o PDO_MySQL. Vedere anche la guida MySQL: scelta dell'API e le FAQ relative per ulteriori informazioni. Le alternative a questa funzione includono:


mysql_fetch_row(resource $result): array

Returns a numerical array that corresponds to the fetched row and moves the internal data pointer ahead.

Elenco dei parametri


The risultato resource che che viene calcolato. Questo risultato deriva dal una chiamata a mysql_query().

Valori restituiti

Returns an numerical array of strings that corresponds to the fetched row, or false if there are no more rows.

mysql_fetch_row() fetches one row of data from the result associated with the specified result identifier. The row is returned as an array. Each result column is stored in an array offset, starting at offset 0.


Example #1 Fetching one row with mysql_fetch_row()

= mysql_query("SELECT id,email FROM people WHERE id = '42'");
if (!
$result) {
'Could not run query: ' . mysql_error();
$row = mysql_fetch_row($result);

$row[0]; // 42
echo $row[1]; // the email value


Nota: Questa funzione imposta i campio NULL al valore PHP null.

Vedere anche:

add a note

User Contributed Notes 4 notes

michael and then an at sign
21 years ago
to print an array, simply use print_r(array name)

like this:
$myrow = mysql_fetch_row($result);
echo "<pre>";
echo "</pre>";

this will output the array in a readable form, with the index, too. Don't forget the 'pre' tags or the output will be on a single line.
a at simongrant dot org
22 years ago
Maybe worth pointing out that all the fields returned by this (and other?) calls are returned with type string. This had me puzzled for quite some time.
pepik at gmail dot cz
11 years ago
require 'prhlavicka.php';
pis_hlavicku('Vypis článků');

$kom = new server();
$sql=$kom->query("SELECT autor,nazev,obsah FROM `Clanky_Sadek`");
while (
$data = mysql_fetch_row($sql)){
'<br />--AUTOR--<br />'.$data[0].'<br />__NÁZEV ČLÁNKU__<br />'.$data[1].'<br />..OBSAH ČLÁNKU..<br />'.$data[2]; }

'Paticka.html'; ?>
larkitetto at gmail dot com
16 years ago
sry :) note now fixed:

//example: $db has >= 1 tabs
echo var_dump($ris);
//echoes only array(1). solution:
while($ris=mysql_fetch_row($esi)) echo $ris[0];
$ris=array("1st_tab"); ... $ris=array("n_tab");$ris=false;*/
while ($ris[]=mysql_fetch_row($esi));
//debug:$ris=array(array("1st_tab"), ... array("n_tab"));
echo $ris[n][0];//echo:"n_tab"
echo $ris[0][n];//echo:array | null

hope it helps
To Top