rowLock

Information regarding whether row and column locking support is only available by reading the driver source code. This needs updating

Not all databases support row locking, some implementations of this function enable column locking. See the driver guide for more details

Syntax

bool rowLock (
     string $csvTableList,
     optional string $whereStatement='',
     optional string $columnToLock
     )

Description

The function rowLock() creates a row, and possible column lock for the duration of a transaction. The function returns true or false depending on the success of the row lock. If a transaction has not already been started, one is begun.

Usage

$db->startTrans();
$db->rowLock($table,"rowid=$id");
$db->execute($SQL1);
$db->execute($SQL2);
$db->completeTrans();