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

说明

void sqlite_busy_timeout ( resource $dbhandle , int $milliseconds )

面向对象风格 (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.

参数

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
 ?>

参见

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

用户评论:

[#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);