(PHP 5 < 5.4.0, PECL sqlite >= 1.0.0)
sqlite_has_more — Finds whether or not more rows are available
$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.
dcchut at gmail dot com (2009-02-01 16:39:47)
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 (2008-04-06 11:08:16)
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);
?>