Login   Register  
PHP Classes
elePHPant
Icontem

MySQL Transact: Execute multiple MySQL queries in a transaction

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us

  Author Author  
Picture of Sérgio Moura Fé
Name: Sérgio Moura Fé <contact>
Classes: 1 package by
Country: Brazil Brazil
Age: 52
All time rank: 1502107 in Brazil Brazil
Week rank: 577 Up49 in Brazil Brazil Up
Innovation award
Innovation award
Nominee: 1x


  Detailed description   Download Download .zip .tar.gz  
This is a simple class can queue several MySQL database queries and execute them all at once in a single transaction.

The class provides means to add SQL queries to a queue. Once all SQL statements are added, the class can start a transaction, execute each statement and finishes the transaction either commiting it if all statements succeed or executing a rollback in case one of the statements failed.

  Classes of Sérgio Moura Fé  >  MySQL Transact  >  Download Download .zip .tar.gz  >  Support forum Support forum (3)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: MySQL Transact
Base name: mysqltransact
Description: Execute multiple MySQL queries in a transaction
Version: -
PHP version: -
License: Unspecified (ask the author)
All time users: 1732 users
All time rank: 2084
Week users: 3 users
Week rank: 577 Up
 
  Groups   Rate classes User ratings   Applications   Files Files  

  Groups  
Group folder image Databases Database management, accessing and searching View top rated classes


  Innovation Award  
PHP Programming Innovation award nominee
July 2005
Number 3


Prize: One copy of the Zend Studio
A database transaction is a set of queries that are perform atomically, i.e. cannot be split. Either all queries succeed and the changes are committed or are all canceled rolling back any changes.

This class simplifies the processing of MySQL database transactions by queuing all database statements that are all executed at once.

The class takes care or initiating the and finalizing the transaction, executing the necessary commit or rollback statements depending on whether the transaction succeeded or failed.


Manuel Lemos

  User ratings  
RatingsUtility Consistency Documentation Examples Tests Videos Overall Rank
All time: Not sure (50%) Not sure (50%) - Sufficient (65%) - - Insufficient (36%) 2230
Month: Not yet rated by the users

  Applications that use this package  
No pages of applications that use this class were specified.
Add link image If you know an application of this package, send a message to the author to add a link here.
  Files folder image Files  
File Role Description
Plain text file class.mysqltransact.php Class MySQL Transaction class and example.php
Accessible without login Plain text file example.php Example Use example of class.mysqltransaction.php

Download Download all files: mysqltransact.tar.gz mysqltransact.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.