Login   Register  
PHP Classes
elePHPant
Icontem

MySQL Transact

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

  Author  
Picture of Sérgio Moura Fé
Name: Sérgio Moura Fé <e-mail contact>
Packages: 1 Browse all classes by Sérgio Moura Fé Browse all classes by
Country: Brazil Brazil - PHP jobs in Brazil
Age: 51
All time rank: 1451104 in Brazil Brazil
Week rank: 1400 Up103 in Brazil Brazil Up
Innovation award
Innovation award
Nominee: 1x


  Detailed description   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 .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: 1675 users
All time rank: 2079
Week users: 1 user
Week rank: 2020 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  
Ratings
Utility
Consistency
Documentation
Examples
Tests
Videos
Overall
Rank
All time:
Not sure (50.0%)
Not sure (50.0%)
-
Sufficient (65.0%)
-
-
Insufficient (36.5%)
2139
Month:
Not yet rated by the users

  Applications that use this class  
No application links were specified for this class.
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 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.