PHP 手冊
前一頁 |  | 下一頁

# sqlite_busy_timeout

(PHP 5)

sqlite_busy_timeout

(no version information, might be only in CVS)

SQLiteDatabase->busyTimeout -- Set busy timeout duration, or disable busy handlers

## Description

void sqlite_busy_timeout ( resource dbhandle, int milliseconds )

Object oriented style (method):

class SQLiteDatabase {
void busyTimeout ( int milliseconds )
}

Set the maximum time that sqlite will wait for a dbhandle to become ready for use to milliseconds. If milliseconds is 0, busy handlers will be disabled and sqlite will return immediately with a SQLITE_BUSY status code if another process/thread has the database locked for an update.

PHP sets the default busy timeout to be 60 seconds when the database is opened.

範例 1. sqlite_busy_timeout() example

`<?php $dbhandle = sqlite_open('sqlitedb'); sqlite_busy_timeout($dbhandle, 10000); // set timeout to 10 seconds sqlite_busy_timeout($dbhandle, 0); // disable busy handler /* OO Example */ $dbhandle = new SQLiteDatabase('sqlitedb'); $dbhandle->busyTimeout(10000); // 10 seconds $dbhandle->busyTimeout(0); // disable ?>`

> 注: There are one thousand (1000) milliseconds in one second.

See also sqlite_open().

前一頁 | 內容 | 下一頁
sqlite_array_query | 上一層 | sqlite_changes