How to transaction MySQLi OOP

Asked Jun 17 '17 at 11:51

Active Jun 17 '17 at 12:10

Viewed 300 times

Trying to make a transaction, so only if all the queries will succeed, they are executed. I did a lot of them in procedural, but first time in OOP style. I've seen PHP + MySQL transactions examples, and How to start and end transaction in mysqli?, no result.

So I have this table:

CREATE TABLE `foo` (
  `id` int(11) NOT NULL,
  `bar` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

And this two queries:

$connection->autocommit(FALSE);
$connection->query("INSERT INTO foo (bar) VALUES ('1')");
$connection->query("INSERT INTO foo (bar) VALUES ('a')");
if($connection->commit()){
    echo "Commit";
} else {
    echo "Rollback";
}

As bar is INT, the first query will succeed, and the second fail. But although I am using a transaction and the second query fails, the first one is executed, and I don't understand why.

What I am doing wrong?

edited Jun 17 '17 at 11:59

asked Jun 17 '17 at 11:51

`bar int(11)` So it demands an integer... – Praveen Kumar Jun 17 '17 at 11:53
@PraveenKumar question is not about what it demands. – u_mulder Jun 17 '17 at 11:54
Yes, I am asking about why the transaction commits when the second query if failing. I am doing something wrong, but what? – Jun 17 '17 at 11:59
@Nanook Please read http://php.net/manual/en/mysqli.commit.php – Praveen Kumar Jun 17 '17 at 12:08
@Praveeen Kumar, but that's exactly what I am doing. I can't find any difference… – Jun 17 '17 at 12:14
In fact, I just copied the example in php.net/manual/en/mysqli.commit.php , and same result. – Jun 17 '17 at 12:16

How to transaction MySQLi OOP

0 Answers0