ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:reference:connection:rowlock

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();
v5/reference/connection/rowlock.txt · Last modified: 2016/01/17 02:18 by mnewnham