Mysql/PHP/Transactions

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
markwenham
Forum Newbie
Posts: 13
Joined: Fri Aug 16, 2002 11:33 pm

Mysql/PHP/Transactions

Post by markwenham »

After much web research I find I am still confused as to how to apply mysql transactions through PHP. For example what PHP syntax would be used to issue a "begin work" or "commit" command?

Any info or links?

Thanks, Mark
DeGauss
Forum Contributor
Posts: 105
Joined: Tue Oct 22, 2002 9:44 am
Location: Gainesville, FL

Post by DeGauss »

Are you asking how to use mysql through PHP?

Or are you talking about using credit cards through php & mysql?
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

Definitely a database question (so I'm moving it) as for the answer, not sure (never used transactions myself) but wouldn't you just use mysql_query() to run the SQL statements as with any other thing that you wanted to do with the MySQL database through PHP?

Mac
User avatar
mydimension
Moderator
Posts: 531
Joined: Tue Apr 23, 2002 6:00 pm
Location: Lowell, MA USA
Contact:

Post by mydimension »

yep, you would send the commands through mysql_query() and if you need a refresher: http://www.mysql.com/doc/en/Transactional_Commands.html
Post Reply