Home arrow PHP arrow Page 10 - PHP Application Development With ADODB (part 1)

Coming Soon, To A Screen Near You - PHP

PHP comes with a different API for different database types -whcih usually means a code rewrite every time your databaseadministrator decides to experiment with something new. But fear not -help is at hand, in the unlikely form of ADODB, a powerful databaseabstraction library for PHP applications.

  1. PHP Application Development With ADODB (part 1)
  2. A Little Insulation
  3. The Bookworm Turns
  4. Anatomy Class
  5. Different Strokes
  6. Getting It All
  7. Playing The Field
  8. Strange Relationships
  9. Hitting The Limit
  10. Coming Soon, To A Screen Near You
By: icarus, (c) Melonfire
Rating: starstarstarstarstar / 8
July 24, 2002

print this article


And that's about it for this introductory tutorial. Over the preceding pages, I demonstrated the basics of the ADODB database abstraction library, explaining how it could be used to insulate your code from the impact of a database change and thereby add portability to your PHP application. I showed you the different methods the ADODB library provides to iterate over a resultset, and to convert a resultset into native PHP arrays suitable for further processing. Finally, I demonstrated a number of useful utility functions, most notably functions related to counting rows and columns, retrieving database, table and field information, and escaping special characters prior to inserting them into a database.

All this, of course, constitutes just the tip of the ADODB iceberg - there's a lot more to this library than meets the eye. Tune in next week for the advanced course, when I'll be exploring things like transactions, cached queries, data typing and dynamic menus. Until then...be good!

Note: All examples in this article have been tested on Linux/i586 with PHP 4.2.0, Apache 1.3.12 and ADODB 2.2.0. Examples are illustrative only, and are not meant for a production environment. Melonfire provides no warranties or support for the source code described in this article. YMMV!

>>> More PHP Articles          >>> More By icarus, (c) Melonfire

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort


- Hackers Compromise PHP Sites to Launch Attac...
- Red Hat, Zend Form OpenShift PaaS Alliance
- PHP IDE News
- BCD, Zend Extend PHP Partnership
- PHP FAQ Highlight
- PHP Creator Didn't Set Out to Create a Langu...
- PHP Trends Revealed in Zend Study
- PHP: Best Methods for Running Scheduled Jobs
- PHP Array Functions: array_change_key_case
- PHP array_combine Function
- PHP array_chunk Function
- PHP Closures as View Helpers: Lazy-Loading F...
- Using PHP Closures as View Helpers
- PHP File and Operating System Program Execut...
- PHP: Effects of Wrapping Code in Class Const...

Developer Shed Affiliates


Dev Shed Tutorial Topics: