Login   Register  
PHP Classes
elePHPant
Icontem

Class: MySQL Transact

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Sérgio Moura Fé  >  MySQL Transact  >  Download .tar.gz .zip  >  Support forum Support forum (3)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: MySQL Transact
Support forum Support forum
Base name: mysqltransact
Description: Execute multiple MySQL queries in a transaction
Related classes: , , ,
Version: -
PHP version: -
License: Unspecified (ask the author)
All time users: 1597 users
All time rank: 2052
Week users: 0 users
Week rank: 2467
Picture of Sérgio Moura Fé
Author: Sérgio Moura Fé <e-mail contact>
Packages: 1 Browse this author's classes Browse this author's classes
Country: Brazil Brazil - PHP jobs in Brazil
Age: 50
All time rank: 139498 in Brazil Brazil
Week rank: 2242 Down171 in Brazil Brazil Down
Innovation award
Innovation award
Nominee: 1x


  Detailed description  
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.

 

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

  Rate classes User ratings   Applications   Files Files  

  Innovation Award  
PHP Programming Innovation award nominee
July 2005
Number 3
 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%)
2069
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
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.