cubrid_fetch_row

Description

The cubrid_fetch_row() function is used to return a numerical array that corresponds to the fetched row and moves the internal data pointer ahead, or FALSE if there are no more rows.

Syntax

array cubrid_fetch_row ( resource $result )

• result : Result that comes from a call to cubrid_execute()

Return Value

• Success: Return an numeric array.
• Failure or the end is reached : FALSE

Example

<?php

$conn = cubrid_connect("localhost", 33000, "demodb");

$req = cubrid_execute($conn, "SELECT name,area,seats,address FROM stadium WHERE nation_code='GRE' AND seats > 10000");

printf("%-40s %-10s %-6s %-20s\n", "name", "area", "seats", "address");

while ($row = cubrid_fetch_row($req)) {

    printf("%-40s %-10s %-6s %-20s\n", $row[0], $row[1], $row[2], $row[3]);

}

cubrid_close_request($req);

cubrid_disconnect($conn);

?>

The above example will output:

name                                 area         seats         address

Panathinaiko Stadium                 86300.00     50000         Athens, Greece

Olympic Stadium                      54700.00     13000         Athens, Greece

Olympic Indoor Hall                  34100.00     18800         Athens, Greece

Olympic Hall                         52400.00     21000         Athens, Greece

Olympic Aquatic Centre               42500.00     11500         Athens, Greece

Markopoulo Olympic Equestrian Centre 64000.00     15000         Markopoulo, Athens, Greece

Faliro Coastal Zone Olympic Complex  34650.00     12171         Faliro, Athens, Greece

Athens Olympic Stadium               120400.00    71030         Maroussi, Athens, Greece

Ano Liossia                          34000.00     12000         Ano Liosia, Athens, Greece