PHP Classes

MySQL Transact: Execute multiple MySQL queries in a transaction

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStar 36%Total: 1,753 All time: 2,242 This week: 488Up
Version License Categories
mysqltransact 1.0Unspecified (ask ...Databases
Description 

Author

Sérgio Moura Fé

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.

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
Picture of Sérgio Moura Fé
Name: Sérgio Moura Fé <contact>
Classes: 1 package by
Country: Brazil Brazil
Innovation award
Innovation award
Nominee: 1x

 

  Files folder image Files (2)  
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

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloadmysqltransact-2005-07-24.zip 1KB
Downloadmysqltransact-2005-07-24.tar.gz 1KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:1,753
This week:0
All time:2,242
This week:488Up
User Ratings User Comments (1)
 All time
Utility:50%StarStarStar
Consistency:50%StarStarStar
Documentation:-
Examples:65%StarStarStarStar
Tests:-
Videos:-
Overall:36%StarStar
Rank:4100
  

  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.