PHP/MySQL Database/sqlite seek
sqlite_seek.php
<source lang="html4strict">
<?php
$sqldb = sqlite_open("mydatabase.db"); $results = sqlite_query($sqldb, "SELECT empid, name FROM employee"); $random = rand(0,sqlite_num_rows($results)-1); sqlite_seek($results, $random); list($empid, $name) = sqlite_current($results); echo "Randomly chosen employee of the month: $name (Employee ID: $empid)"; sqlite_close($sqldb);
?>
</source>
Using the sqlite_seek() Function
<source lang="html4strict">
<?php
function random_row($result) { $t_rows = sqlite_num_rows($result); if($t_rows > 0) { sqlite_seek($result, rand(0, ($t_rows-1))); return sqlite_current($result); } else { return false; } } $sqlite = sqlite_open(":memory:"); sqlite_query($sqlite, "CREATE TABLE test(value INTEGER PRIMARY KEY)"); sqlite_unbuffered_query($sqlite, "INSERT INTO test VALUES(NULL)"); $result = sqlite_query($sqlite, "SELECT * FROM test"); var_dump(random_row($result));
?>
</source>