In this chapter, we have seen how to work with unbuffered queries and to get the row count for a result set. We have also looked at an application where database-specific SQL could not be avoided, as this would require a workaround that might be unsuitable. However, this chapter should be helpful for someone who is developing a complex web application that uses databases.
In the next chapter, we will discuss the advanced features of PDO, including persistent connections and other driver-specific options. We will also discuss transactions and examine some more methods of the PDO
and PDOStatement
classes.