Now that we have familiarized ourselves with the basic features of PDO and used them to build a data-driven web applications, let’s see some advanced functionality. In this chapter, we will look at getting and setting connection attributes (such as column names, case conversion, and the name of the underlying PDO driver) as well as connecting to a database by specifying a connection configuration filename or an option in the php.ini
file. We will also discuss transactions.
We will modify our library application to display the name of the database driver in the footer of every page. In addition to this simple change, we will extend the application to keep track of how many copies of a single book we have and to keep track of those people who have borrowed a book. We will use transactions for this functionality.
We have briefly covered setting connection attributes in Chapter 3 when we saw how to use exceptions as a means...