©
                    本文档使用
                    php中文网手册 发布
                
(PHP 5 >= 5.3.0)
SQLite3::querySingle — Executes a query and returns a single result
$query 
   [,  bool $entire_row  = false 
  ] )Executes a query and returns a single result.
query The SQL query to execute.
entire_row 
       By default,  querySingle()  returns the value of the
       first column returned by the query. If
       entire_row is  TRUE , then it returns an array
       of the entire first row.
      
   Returns the value of the first column of results or an array of the entire
   first row (if entire_row is  TRUE ).
  
   If the query is valid but no results are returned, then  NULL  will be
   returned if entire_row is  FALSE , otherwise an
   empty array is returned.
  
   Invalid or failing queries will return  FALSE .
  
Example #1 SQLite3::querySingle() example
  <?php
$db  = new  SQLite3 ( 'mysqlitedb.db' );
 var_dump ( $db -> querySingle ( 'SELECT username FROM user WHERE userid=1' ));
 print_r ( $db -> querySingle ( 'SELECT username, email FROM user WHERE userid=1' ,  true ));
 ?>   以上例程的输出类似于:
string(5) "Scott"
Array
(
    [username] => Scott
    [email] => scott@example.com
)