My Database
bluepalmtrees.com

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])
• int count()
• void execute(string $sql)
• string result(string $field)
• string [field] (Access field values directly)
• 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.3 (29 Sep 2010 - 995 Bytes)

Improved deleting of resources
Added a function to get the record count for both database types
Added magic get function to retrieve field results more easily
 

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
 

Show More

I accept the terms and conditions