Please wait while we load your page...


PHP Manual :: sqlite_busy_timeout

sqlite_array_query || sqlite_changes || SQLite Functions || PHP Manual

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

sqlite_busy_timeout -- SQLiteDatabase::busyTimeoutSet busy timeout duration, or disable busy handlers


void sqlite_busy_timeout ( resource $dbhandle , int $milliseconds )

Object oriented style (method):

public void SQLiteDatabase::busyTimeout ( int $milliseconds )

Set the maximum time, in milliseconds, that SQLite will wait for a dbhandle to become ready for use.



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


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


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

Return Values

No value is returned.


Example #1 Procedural style

sqlite_busy_timeout($dbhandle10000); // set timeout to 10 seconds
sqlite_busy_timeout($dbhandle0); // disable busy handler

Example #2 Object oriented style

= 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

sqlite_array_query || sqlite_changes || SQLite Functions || PHP Manual
Live Chat Not Available