Edit Report a Bug

    pg_fetch_row

    (PHP 4, PHP 5, PHP 7)

    pg_fetch_row — Get a row as an enumerated array

    Description

    pg_fetch_row ( resource $result [, int $row ] ) : array

    pg_fetch_row() fetches one row of data from the result associated with the specified result resource.

    Note: This function sets NULL fields to the PHP NULL value.

    Parameters

    result

    PostgreSQL query result resource, returned by pg_query(), pg_query_params() or pg_execute() (among others).

    row

    Row number in result to fetch. Rows are numbered from 0 upwards. If omitted or NULL, the next row is fetched.

    Return Values

    An array, indexed from 0 upwards, with each value represented as a string. Database NULL values are returned as NULL.

    FALSE is returned if row exceeds the number of rows in the set, there are no more rows, or on any other error.

    Examples

    Example #1 pg_fetch_row() example

    <?php

    $conn     = pg_pconnect("dbname=publisher");
    if (!    $conn) {
      echo     "An error occurred.\n";
      exit;
    }

    $result = pg_query($conn, "SELECT author, email FROM authors");
    if (!    $result) {
      echo     "An error occurred.\n";
      exit;
    }

    while (    $row = pg_fetch_row($result)) {
      echo     "Author: $row[0]  E-mail: $row[1]";
      echo     "<br />\n";
    }
     
    ?>

    See Also

    add a note add a note

    User Contributed Notes 7 notes

    up
    2
    pletiplot at seznam dot cz
    12 years ago
    Note, that when you retrieve some PG boolean value, you get 't' or 'f' characters which are not compatible with PHP bool.
    up
    2
    post at zeller-johannes dot de
    14 years ago
    I wondered whether array values of PostgreSQL are converted to PHP arrays by this functions. This is not the case, they are stored in the returned array as a string in the form "{value1 delimiter value2 delimiter value3}" (See http://www.postgresql.org/docs/8.0/interactive/arrays.html#AEN5389).
    up
    0
    darw75 at swbell dot net
    17 years ago
    a way to do this with 2 loops to insert data into a table...

    $num = pg_numrows($result);
    $col_num = pg_numfields($result);

    for ($i=0; $i<$num; $i++) {
      $line  = pg_fetch_array($result, $i, PGSQL_ASSOC);
      print "\t<tr bgcolor=#dddddd>\n";
        for ($j=0; $j<$col_num; $j++){
        list($col_name, $col_value) =each($line);
        print "\t\t<TD ALIGN=RIGHT><FONT SIZE=1 FACE='Geneva'>$col_value</FONT></TD>\n";
        }
      echo "<br>";
      }
    up
    -1
    eddie at eddiemonge dot com
    9 years ago
    pg_fetch_row is faster than pg_fetch_assoc when doing a query with * as the select parameter. Otherwise, with declared columns, the two are similar in speed.
    up
    -2
    Matthew Wheeler
    15 years ago
    Note that the internal row counter is incremented BEFORE the row is retrieved. This causes an off by one error if you try to do:

    pg_result_seek($resid,0);
    pg_fetch_row($resid);

    you will get back the SECOND result not the FIRST.
    up
    -3
    maxnamara at yahoo dot com
    14 years ago
    Get downlines, put them into arrays.

    function get_downlines($my_code){
        global $link;

        $sql = "select user_id, name from tb_user where parentcode = $my_code";
        $res = pg_query($link,$sql);
        if(!$res){
            echo "Error: ".$sql;exit();
        }
        $num_fields = pg_num_fields($res);
        $info_rows = 0;

        $num_rows = pg_num_rows($res);
        while($arr = pg_fetch_row($res)){

               $info_offset  = 1;
             $info_columns  = 0;

            while ($info_offset <= $num_fields) {
                     $info_elements[$info_rows][$info_columns] = $arr[$info_columns];
                     $info_offset++; $info_columns++;
            }
            $info_rows++;           
        }
    return $info_elements;
    }
    up
    -5
    imantr at cbn dot net dot id
    16 years ago
    I use the following code to assigning query result to an array.

    while ($row = pg_fetch_row($result)) $newArray[] = $row[0];

    print_r($newArray);
    add a note add a note
    To Top