- skip to content

# Database Abstraction Layer

### User Tools

- Login

### Site Tools

- Recent changes
- Media Manager
- Sitemap

### Sidebar

##### Resources

- Reference Manual
- User Guide
- The Data Dictionary
- ADOdb-xmlschema
- ADOdb Active Record
- Performance Monitoring
- Date/Time Library
- Session Management Library
- Unsupported Addons
- Coding Standards

##### Supported Databases

- Access
- ADO
- CSV
- Firebird
- Frontbase
- IBM DB2
- Informix
- Interbase
- LDAP
- Microsoft SQL Server
- MySQL
- Netezza
- ODBC
- ODBTP
- Oracle
- PDO
- Postgresql
- SAP ADS
- SAP ASE
- SAP Maxdb
- SAP Sqlanywhere
- Sqlite
- Sybase
- Plain Text
- Visual Foxpro

##### Other

- Feature Comparison Matrix
- Connection Matrix
- Include File Guide

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/16 17:18 by mnewnham

### Page Tools

- Show pagesource
- Old revisions
- Backlinks
- Rename Page
- Back to top