SQLite 函数
在线手册：中文 英文
PHP手册

sqlite_has_more

(PHP 5 < 5.4.0, PECL sqlite >= 1.0.0)

sqlite_has_more — Finds whether or not more rows are available

说明

bool sqlite_has_more ( resource $result )

Finds whether more rows are available from the given result set.

参数

result

The SQLite result resource.

返回值

Returns TRUE if there are more rows available from the result handle, or FALSE otherwise.

参见

SQLite 函数
在线手册：中文 英文
PHP手册
PHP手册 - N: Finds whether or not more rows are available

用户评论:

dcchut at gmail dot com (02-Feb-2009 12:39)

dragosmocrii at gmail dot com:

It is slightly more efficient to use the COUNT function. (And when I say slightly I mean whisker small slightly.)

<?php
// $db is a SQLite database connection

if (sqlite_single_query($db, 'SELECT COUNT(*) FROM records WHERE amount_owing > 500')) {
    // There are records where the amount owing exceeds $500, do some action.
} else {
    // No money for you!
}

?>

dragosmocrii at gmail dot com (06-Apr-2008 07:08)

I use this function to check if an element exists in the database.

<?php
$cat=$_REQUEST['cat'];
$db=sqlite_open('./sqlite_database.db',0666,$err) or die();
$query='select * from catsub where cat=\''.$cat.'\'';
$result=sqlite_has_more(sqlite_query($db,$query));
if($result===true ) echo 'Exists'; else echo 'Doesnt Exist';
sqlite_close($db);
?>