분류 php

sqlite_seek() 함수

컨텐츠 정보

  • 조회 888 (작성일 )

본문

코드 : 

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



php