Beginning PHP and MySQL: From Novice to Professional

© Frank M. Kromann 2018

Frank M. KromannBeginning PHP and MySQLhttps://doi.org/10.1007/978-1-4302-6044-8_34

34. Transactions

Frank M. Kromann¹ 

(1)

Aliso Viejo, CA, USA

 

This chapter introduces MySQL’s transactional capabilities and demonstrates how transactions are executed both via a MySQL client and from within a PHP script. By its conclusion, you’ll possess a general understanding of transactions, how they’re implemented by MySQL, and how to incorporate them into your PHP applications.

What’s a Transaction?

A transaction is an ordered group of database operations that are treated as a single unit. A transaction is deemed successful if all operations in the group succeed, and it is deemed unsuccessful if even a single operation fails. If all operations ...