maxdb_fetch_row

maxdb_result::fetch_row

(PECL maxdb >= 1.0)

maxdb_fetch_row -- maxdb_result::fetch_row — Get a result row as an enumerated array

说明

过程化风格

maxdb_fetch_row ( resource $result ) : mixed

面向对象风格

maxdb_result::fetch_row ( void ) : mixed

Returns an array that corresponds to the fetched row, or NULL if there are no more rows.

maxdb_fetch_row() fetches one row of data from the result set represented by result and returns it as an enumerated array, where each column is stored in an array offset starting from 0 (zero). Each subsequent call to the maxdb_fetch_row() function will return the next row within the result set, or FALSE if there are no more rows.

返回值

maxdb_fetch_row() returns an array that corresponds to the fetched row or NULL if there are no more rows in result set.

Note: 此函数将 NULL 字段设置为 PHP NULL 值。

范例

Example #1 面向对象风格

<?php
$maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB");

/* check connection */
if (maxdb_connect_errno()) {
   printf("Connect failed: %s\n", maxdb_connect_error());
   exit();
}

$query = "SELECT name, state FROM hotel.city ORDER by zip";

if ($result = $maxdb->query($query)) {

   /* fetch enumerated array */
   while ($row = $result->fetch_row()) {
       printf ("%s (%s)\n", $row[0], $row[1]);
   }

   /* free result set */
   $result->close();
}

/* close connection */
$maxdb->close();
?>

Example #2 过程化风格

<?php
$link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");

/* check connection */
if (maxdb_connect_errno()) {
   printf("Connect failed: %s\n", maxdb_connect_error());
   exit();
}

$query = "SELECT name, state FROM hotel.city ORDER by zip";

if ($result = maxdb_query($link, $query)) {

   /* fetch enumerated array */
   while ($row = maxdb_fetch_row($result)) {
       printf ("%s (%s)\n", $row[0], $row[1]);
   }

   /* free result set */
   maxdb_free_result($result);
}

/* close connection */
maxdb_close($link);
?>

以上例程的输出类似于：

New York (NY)
New York (NY)
Long Island (NY)
Albany (NY)
Washington (DC)
Washington (DC)
Washington (DC)
Silver Spring (MD)
Daytona Beach (FL)
Deerfield Beach (FL)
Clearwater (FL)
Cincinnati (OH)
Detroit (MI)
Rosemont (IL)
Chicago (IL)
Chicago (IL)
New Orleans (LA)
Dallas (TX)
Los Angeles (CA)
Hollywood (CA)
Long Beach (CA)
Palm Springs (CA)
Irvine (CA)
Santa Clara (CA)
Portland (OR)

参见

相关文章
php ibm db2 函数 returns an array indexed by column position representing a row in a result setphp frontbase 函数 get a result row as an enumerated arrayphp ingres 函数 fetch a row of result into an arrayphp ingres 函数 fetch a row of result into an associative arrayphp ingres 函数 fetch a row of result into an enumerated arrayphp maxdb 函数 adjusts the result pointer to an arbitary row in the resultphp maxdb 函数 fetch a result row as an associative a numeric array or bothphp maxdb 函数 fetch a result row as an associative arrayphp maxdb 函数 returns an array of resources representing the fields in a result setphp maxdb 函数 returns the lengths of the columns of the current row in the result setphp maxdb 函数 returns the current row of a result set as an objectphp maxdb 函数 get a result row as an enumerated arrayphp msql 函数 get row as enumerated arrayphp mssql 函数 fetch a result row as an associative array a numeric array or bothphp mssql 函数 returns an associative array of the current row in the resultphp sqlite 函数 fetches the current row from a result set as an arrayphp sqlite 函数 fetches the next row from a result set as an arrayphp sybase 函数 fetch a result row as an associative arrayphp sybase 函数 get a result row as an enumerated arrayphp mysqli result get a result row as an enumerated array
关注编程学问公众号