How can I detect if a MYSQL query fails, and run a second MYSQL query when this happens? (PHP)

Question

I'm capturing information from a single PHP form to be recorded in two tables...

What I want is to have both records written or none at all (i.e., if one goes through and the other fails, remove the one that went through)

I wanted to know if there was a way I can detect a failure (possibly using 'or die'?) of the second query, and use this as a trigger to delete the record entered in the first query (or if there is a better method of achieving this)

thanks.

score 1 · Answer 1 · answered May 17 '11 at 15:04

1

Look into database transactions.

answered May 17 '11 at 15:04

Crashspeeder

4,291
2
16
21

score 1 · Answer 2 · answered May 17 '11 at 15:05

1

use transaction

answered May 17 '11 at 15:05

Toto

89,455
62
89
125

score 0 · Answer 3 · answered May 17 '11 at 15:06

0

Just save the result in a variable and check it with "if"

$result = mysql_query( 'your query...' );
if( $result ) {
     echo 'Everything went fine';
} else {
     mysql_query( 'do other stuff' );
}

answered May 17 '11 at 15:06

T.Koehn

59
2

score 0 · Accepted Answer · edited May 23 '17 at 10:28

0

Take a look at this SO question about transactions.

Also note that to use transactions, your database storage engine needs to support them, you can´t use transactions if your table uses the MyISAM storage engine, you will need something like InnoDB.

edited May 23 '17 at 10:28

Community

1
1

answered May 17 '11 at 15:11

jeroen

91,079
21
114
132

How can I detect if a MYSQL query fails, and run a second MYSQL query when this happens? (PHP)

4 Answers4