<?php
 
  $debug = true;
  //variable to commit transaction
 
  $commit = "commit";
 
  $errors = array();
 
  /* fetch data from form input */
 
  extract ($_POST);
 
  /* connect to server */
 
 if(!$db = mysql_connect("localhost", "root", ""))
 
   {
 $errors[] = mysql_error();
 
      }
 
 /* select database */
 
  if(!mysql_select_db("webauth", $db))
 
      {
 
      $errors[] = mysql_error();
 
      }
 
//begin transaction
 
      if(!mysql_query("begin"))
 
      {
 
      $errors[] = mysql_error();
 
      }
 
 
 
      /* fields' names in the database */
 
      $result = "INSERT INTO buy (id,type,price,desc,email,apartment,roomno,qty)";
 
 
 
      /* variable name as declared as above to be entered to the field */
 
      $result .= "VALUES ('$id','$type','$price','$desc','$email','$apartment','$roomno','$qty')";
 
 
 
      if(!mysql_query($result, $db))
 
      {
 
      $commit = "rollback";
 
      $errors[] = mysql_error();
 
      }
 
     // $commit = "rollback"; //uncomment to automatically rollback the transaction
 
 
 
      if($commit == "commit")
 
      {
 
      mysql_query($commit);
 
      echo "successful";
 
      echo "<br>";
 
      echo "<a href=order.php>Home</a>";
 
      mysql_close($db);
 
      }
 
      else
 
      {
 
      echo "there was an error in your transaction, transction rolled back: ";
 
      if($debug == true)
 
      {
 
      foreach($errors as $value)
 
      {
 
      echo "<p>" . $value . "</p>";
 
      }
 
      }
 
      mysql_query($commit);
 
      mysql_close($db);
 
      }
 
      /* variable name as declared as above to be entered to the field */
 
      /* fields' names in the database */
 
      /* execute the query */
 
 
      ?>