Set busy timeout duration, or disable busy handlers (original) (raw)

sqlite_busy_timeout

SQLiteDatabase::busyTimeout

(PHP 5 < 5.4.0, PECL sqlite >= 1.0.0)

sqlite_busy_timeout -- SQLiteDatabase::busyTimeout — Set busy timeout duration, or disable busy handlers

Description

sqlite_busy_timeout ( resource $dbhandle , int $milliseconds ) : void

public SQLiteDatabase::busyTimeout ( int $milliseconds ) : void

Parameters

dbhandle

The SQLite Database resource; returned from sqlite_open() when used procedurally. This parameter is not required when using the object-oriented method.

milliseconds

The number of milliseconds. When set to0, 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.

Note:

There are one thousand (1000) milliseconds in one second.

Return Values

No value is returned.

Examples

Example #1 Procedural style

<?php $dbhandle = sqlite_open('sqlitedb'); sqlite_busy_timeout($dbhandle, 10000); // set timeout to 10 seconds sqlite_busy_timeout($dbhandle, 0); // disable busy handler ?>

Example #2 Object oriented style

<?php $dbhandle = new SQLiteDatabase('sqlitedb'); $dbhandle->busyTimeout(10000); // 10 seconds $dbhandle->busyTimeout(0); // disable ?>

See Also

• sqlite_open() - Opens an SQLite database and create the database if it does not exist