My Database
bluepalmtrees.com
» About My Database

My Database will allow Access and MySQL databases to be utilized through a common interface, interchangeably. The following functions are provided to accomplish database needs:

· void query(string $sql [, int $limit])
· void execute(string $sql)
· string result(string $field)
· void next()
· void move(int $count)
· bool eof()
· void set_debug(bool $flag)

A standard SQL structure is used, such that the same code can be used even when switching between database types, the specific translations are done internally: Square brackets ([ ]) should encapsulate field and table names, and Single quotes (') should be escaped with a slash (\').

Note: version 1.2+ requires PHP5 or greater and is not backwards compatible.

» Download

Removed multiple internal record sets (the object should be copied instead)
Added auto shutdown, so close does not have to be called (helps with errors and exceptions)
Changed debug feature from a define to a method, so debug can be enabled for a particular script, or even one query
Added record set limit feature for queries to help with performance
Auto database type detection
Updated to PHP5 to help enforce correct usage

Added auto-parsing and translation such that the same query works for both database types
Added ability to contain multiple queries within a single object by key
Added a clear function to release resources
Backwards compatible with previous version

Initial release

1,037 total downloads