©
This document uses PHP Chinese website manual Release
(PHP 5 < 5.4.0, PECL sqlite >= 1.0.1)
sqlite_fetch_single -- SQLiteResult::fetchSingle -- SQLiteUnbuffered::fetchSingle — Fetches the first column of a result set as a string
$result
[, bool $decode_binary
= true
] )面向对象风格 (method):
$decode_binary
= true
] )$decode_binary
= true
] )sqlite_fetch_single() is identical to sqlite_fetch_array() except that it returns the value of the first column of the rowset.
This is the most optimal way to retrieve data when you are only interested in the values from a single column of data.
result
The SQLite result resource. This parameter is not required when using the object-oriented method.
decode_binary
当
decode_binary
参数设置为 TRUE
(默认值)时,PHP 会解码那些由
sqlite_escape_string()
编码后的二进制数据。通常应保留此值为其默认值,除非要与其他使用 SQLlite 的应用程序建立的数据交互。
Returns the first column value, as a string.
Example #1 A sqlite_fetch_single() example
<?php
if ( $dbhandle = sqlite_open ( 'mysqlitedb' , 0666 , $sqliteerror )) {
$sql = "SELECT id FROM sometable WHERE id = 42" ;
$res = sqlite_query ( $dbhandle , $sql );
if ( sqlite_num_rows ( $res ) > 0 ) {
echo sqlite_fetch_single ( $res ); // 42
}
sqlite_close ( $dbhandle );
}
?>
[#1] visavi dot net at mail dot ru (Vantuz) [2009-08-08 04:26:14]
With the help of sqlite_fetch_single, you can quickly and easily calculate the number of elements in the table
<?php
// create new database (OO interface)
$db = new SQLiteDatabase('database.db', 0666);
// create table inbox and paste data
$db->queryExec("
CREATE TABLE inbox (
inbox_id INTEGER NOT NULL PRIMARY KEY,
inbox_send varchar(20) NOT NULL,
inbox_text TEXT NOT NULL,
inbox_time INTEGER UNSIGNED NOT NULL,
inbox_user varchar(20) NOT NULL
);");
$ins_query = "
INSERT INTO inbox (inbox_send, inbox_text, inbox_time, inbox_user) VALUES ('Ilia1', 'Message1', '".time()."', 'my_name');
INSERT INTO inbox (inbox_send, inbox_text, inbox_time, inbox_user) VALUES ('Ilia2', 'Message2', '".time()."', 'user');
INSERT INTO inbox (inbox_send, inbox_text, inbox_time, inbox_user) VALUES ('Ilia2', 'Message3', '".time()."', 'my_name');
";
$db->queryExec($ins_query);
//view all posts by my_name
$total = $db->singleQuery("SELECT count(*) FROM inbox WHERE inbox_user='my_name';");
echo $total;
// the result will be the number 2
?>
[#2] jmarbas at hotmail dot com [2005-07-23 17:45:02]
It isnt specified in the above description for this function, but yes this function will not only return the first column, but it will also return the first value (ie from the first row in the result set) of that column. Also the result set pointer is involved here in that if you use sqlite_fetch_single in a loop, it will return each value in the first column sequentially and advance the result set pointer each time.
i.e. the first loop iteration it returns the first value in the first column. the second loop iteration it returns the second value in the first column. the third loop iteration the third value and so on.
$handle = sqlite_open("database_file_name") or die("Could not open database");
//generate query string
$query = "select distinct field1 from database_name";
//execute query
$result = sqlite_query($handle,$query)
//if a row exists
if(sqlite_num_rows($result)>0){
echo "<table cellpadding=\"10\" border=\"1\">";
//check for more rows
while(sqlite_has_more($result)){
//get first field from each row
//print values
$row=sqlite_fetch_single($result);
echo "<tr>";
echo "<td>".$row."</td>";
echo "</tr>";
}
echo "</table>";
}
//close database file
sqlite_close($handle);
[#3] roga at yoopee dot de [2004-07-11 13:02:01]
Be careful with the use of sqlite_fetch_single() in a while-loop:
<?php
$result = sqlite_query($db_handle, 'SELECT foo FROM bar;');
while ($row = sqlite_fetch_single($result)) {
}
?>
This may not work as expected because the loop will stop if any of the foos has a false value (e.g. zero).
Use sqlite_has_more() instead:
<?php
$result = sqlite_query($db_handle, 'SELECT foo FROM bar;');
while (sqlite_has_more($result)) {
$row = sqlite_fetch_single($result);
}
?>