분류
php
sqlite_seek() 함수
본문
코드 :
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));
- 이전글html5.2버전 dialog 엘리먼트 18.01.17
- 다음글sqlite_query() 함수 18.01.16