• 0

PHP + MySQL - Transactions


Question

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

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.