The PDO equivalent of this function would be PDO::setAttribute(PDO::ATTR_TIMEOUT);
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
Descrierea
sqlite_busy_timeout
( resource
$dbhandle
, int $milliseconds
) : voidStil obiect-orientat (method):
public SQLiteDatabase::busyTimeout
( int
$milliseconds
) : void
Set the maximum time, in milliseconds, that SQLite will wait for a
dbhandle to become ready for use.
Parametri
-
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 to
0, busy handlers will be disabled and SQLite will return immediately with aSQLITE_BUSYstatus 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.
Notă:
There are one thousand (1000) milliseconds in one second.
Valorile întoarse
Nu este întoarsă nici o valoare.
Exemple
Example #1 Stil procedural
<?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 Stil obiect-orientat
<?php
$dbhandle = new SQLiteDatabase('sqlitedb');
$dbhandle->busyTimeout(10000); // 10 seconds
$dbhandle->busyTimeout(0); // disable
?>
add a note
User Contributed Notes 1 note
php at cdauth dot de ¶
17 years ago
