SQLite3Result
在线手册:中文  英文

SQLite3Result::fetchArray

(PHP 5 >= 5.3.0)

SQLite3Result::fetchArray Fetches a result row as an associative or numerically indexed array or both

说明

public array SQLite3Result::fetchArray ([ int $mode = SQLITE3_BOTH ] )

Fetches a result row as an associative or numerically indexed array or both. By default, fetches as both.

参数

mode

Controls how the next row will be returned to the caller. This value must be one of either SQLITE3_ASSOC, SQLITE3_NUM, or SQLITE3_BOTH.

  • SQLITE3_ASSOC: returns an array indexed by column name as returned in the corresponding result set

  • SQLITE3_NUM: returns an array indexed by column number as returned in the corresponding result set, starting at column 0

  • SQLITE3_BOTH: returns an array indexed by both column name and number as returned in the corresponding result set, starting at column 0

返回值

Returns a result row as an associatively or numerically indexed array or both. Alternately will return FALSE if there are no more rows.


SQLite3Result
在线手册:中文  英文

用户评论:

alan at synergymx dot com (2010-09-14 16:56:28)

To loop through a record set: 

<?php
        $db 
= new SQLite3('auth.sqlite');

        
$sql "SELECT user_id, username, opt_status FROM tbl_user";

        
$result $db->query($sql);//->fetchArray(SQLITE3_ASSOC);

        
$row = array();

        
$i 0;

         while(
$res $result->fetchArray(SQLITE3_ASSOC)){

             if(!isset(
$res['user_id'])) continue;

              
$row[$i]['user_id'] = $res['user_id'];
              
$row[$i]['username'] = $res['username'];
              
$row[$i]['opt_status'] = $res['opt_status'];

              
$i++;

          }

          
print_r($row);
?>

易百教程