O'Reilly logo

PHP 5 Power Programming by Derick Rethans, Stig Sæther Bakken, Andi Gutmans

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

6.5. Summary

This chapter introduced two new database extensions in PHP 5: mysqli and sqlite. It also presents PEAR DB, which is the most popular database abstraction layer for PHP. In this chapter, you learned:

  • Some of the strengths and weaknesses of mysql versus sqlite

  • When it makes sense to use a database abstraction layer

  • How to connect to databases using mysqli, sqlite, or DB

  • Executing queries and fetching results with mysqli, sqlite, or DB

  • Executing prepared queries with mysqli and DB

  • The difference between buffered and unbuffered queries

  • Various ways of fetching data from queries

  • Database error handling

  • Using triggers and user-defined functions with sqlite

  • How to create portable database code with DB

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required