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.

Version 1.2 (17 Jun 2008 - 1.03 KB) 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

Version 1.1 (13 Feb 2007 - 1.77 KB) 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

Version 1.0 (27 Oct 2006 - 782 Bytes) Initial release

I accept the terms and conditions

1,037 total downloads