PHP Classes

File: MySql/Transaction.php

Recommend this page to a friend!
  Classes of Kabir Hossain   PHP CodeIgniter Tips Tricks   MySql/Transaction.php   Download  
File: MySql/Transaction.php
Role: Auxiliary script
Content type: text/plain
Description: Configuration script
Class: PHP CodeIgniter Tips Tricks
Collection of tips and examples to use CodeIgniter
Author: By
Last change:
Date: 1 month ago
Size: 596 bytes
 

Contents

Class file image Download
MySQL Transaction:
mysql_query("START TRANSACTION"); //mysql_query("BEGIN");
      $a1 = mysql_query("INSERT INTO customer(name) VALUES('KABIR')");
      $a2 = mysql_query("INSERT INTO customer(name) VALUES('Hossain')");
if($a1 and $a2){
    mysql_query("COMMIT");
}else {
    mysql_query("ROLLBACK");
}


CodeIgniterTransaction:
$this->db->trans_start();
$this->db->query("INSERT INTO customer(name) VALUES('KABIR')");
$this->db->query("INSERT INTO customer(name) VALUES('Hossain')");
$this->db->trans_complete();
if($this->db->trans_status=== TRUE)
    echo ?Success?;
else
    echo ?Failed?;