Using the sqlite_seek() Function : sqlite_seek « MySQL Database « PHP

1. PHP
2. MySQL Database
3. sqlite_seek

Using the sqlite_seek() Function

 
<?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));

?>
  
  

Related examples in the same category