©
Ce document utilise Manuel du site Web PHP chinois Libérer
(PHP 5 < 5.4.0, PECL sqlite >= 1.0.0)
sqlite_busy_timeout -- SQLiteDatabase::busyTimeout — Set busy timeout duration, or disable busy handlers
$dbhandle
, int $milliseconds
)面向对象风格 (method):
$milliseconds
)
Set the maximum time, in milliseconds, that SQLite will wait for a
dbhandle
to become ready for use.
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 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.
没有返回值。
Example #1 过程化风格
<?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 面向对象风格
<?php
$dbhandle = new SQLiteDatabase ( 'sqlitedb' );
$dbhandle -> busyTimeout ( 10000 ); // 10 seconds
$dbhandle -> busyTimeout ( 0 ); // disable
?>
[#1] php at cdauth dot de [2007-04-06 10:46:37]
The PDO equivalent of this function would be PDO::setAttribute(PDO::ATTR_TIMEOUT);