I have a PHP script that calls a stored procedure - basically a registration form that sends the details to a mySql stored proc that generates a few IDs and populates a few tables. I am doing this via PDO.
I want to make this transactional - so it either populates all the tables, or it does nothing.
I thought I'd accomplish this within the stored proc, by adding START TRANSACTION and COMMIT - but no. So I also did the same by starting the transaction before the process call, and committing after - also no.
Question
+Dick Montage Subscriber²
I have a PHP script that calls a stored procedure - basically a registration form that sends the details to a mySql stored proc that generates a few IDs and populates a few tables. I am doing this via PDO.
I want to make this transactional - so it either populates all the tables, or it does nothing.
I thought I'd accomplish this within the stored proc, by adding START TRANSACTION and COMMIT - but no. So I also did the same by starting the transaction before the process call, and committing after - also no.
Help? Can post code if needed...
Link to comment
Share on other sites
1 answer to this question
Recommended Posts