Php and Mysqli with transaction

Question

i have a problem with transaction, because if I try to enter a wrong query, the system should not enter either.

Instead the system inserts the first query, and the second is not, and does not enter the Rollback

This is my code:

$conn = connect();

try {
     /* set autocommit to off */
     $conn->autocommit(FALSE);

    /* MY QUERY */
    $conn->query("INSERT INTO `transazioni` (`id`, `nome`, `numero`) VALUES (NULL, 'luca', '12')");
    $conn->query("I--NSERT INTO `transazioni` (`id`, `nome`, `numero`) VALUES (NULL, 'paolo', '12')");

   /* commit transaction */
   $conn->commit();

    } catch (Exception $e) {
      // faccio rollback
      $conn->rollback();
      echo "enter in rollback";
}

How can i fix it ?

Thanks Andrea

score 0 · Answer 1 · edited May 23 '17 at 12:14

0

Your problem is caused by mysql engine. MyISAM doesn't support transactions, you have to change to InnoDB.

Also note that your catch block woudn't work unless you configure mysqli for that explicitly.

edited May 23 '17 at 12:14

Community

1
1

answered Aug 14 '15 at 10:21

Your Common Sense

156,878
40
214
345

can i tranform my db to InnoDB and don't lost any data ? – user2663914 Aug 14 '15 at 11:02
I checked now, I'm using innodb! – user2663914 Aug 14 '15 at 11:48

Php and Mysqli with transaction

1 Answers1