PHP 5.6.0 released

sqlite_busy_timeout

SQLiteDatabase::busyTimeout

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

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

Descrierea

void sqlite_busy_timeout ( resource $dbhandle , int $milliseconds )

Stil obiect-orientat (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.

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

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($dbhandle10000); // set timeout to 10 seconds
sqlite_busy_timeout($dbhandle0); // disable busy handler
?>

Example #2 Stil obiect-orientat

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

Vedeți de asemenea

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

add a note add a note

User Contributed Notes 1 note

up
0
php at cdauth dot de
7 years ago
The PDO equivalent of this function would be PDO::setAttribute(PDO::ATTR_TIMEOUT);
To Top