文字

SQLite3::querySingle

(PHP 5 >= 5.3.0)

SQLite3::querySingleExecutes a query and returns a single result

说明

public mixed SQLite3::querySingle ( string $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
)
上一篇: 下一篇: