anyDB 1.0

This abstract wrapper class provides easy and simple class methods to access the most important db function. It implements the functionality for databases like MYSQL, POSTGRESQL or SQLITE.

anyDB provides a wrapper for PEAR, PHPLIB, ADOdb and METABASE and enables you to switch between these db abstraction layers with only changing a single line of code. You gain the possibility to develop similar code for more than 15 different databases.

Detailed documentation for all the complete interface exists. A ligtweight interface supports the most common tasks in an easy and efficent way, such as sending queries and fetching result sets or single variables.

Additional classes provide tools for accessing database data, dumping information in html tables, exporting db content to CSV-files or as SQL statements or presenting database content pagewise (e.g. for search results).

Functions:
function Constructor($libraryPath, $dbType, $preferredResType = ASSOCIATIVE_ARRAY)
function connect($host, $db, $user, $password)
function disconnect()
function query($query)
function getNext($resultType = PREDEFINED_VALUE)
function getAll($resultType = PREDEFINED_VALUE)
function getValue()
function getColumn($resultType = PREDEFINED_VALUE)
function execute($query, $resultType = PREDEFINED_VALUE)
function free()
function numRows()
function affectedRows()
function getIdentifier()
function getTables()
function escapeStr()

String:
string $host
string $database
string $user
string $password
integer $prefResType
string $lastQuery
string $error
string $db
string $result

License type: LGPL - GNU Lesser General Public License
Date added: 9 years, 19 days ago | Last updated: 9 years, 19 days ago

More popular Database Tool

This is actually one of the most advanced image hosting script. The imagetize key features: SEO, Ads Ready, Admin

Listing Files

anydb
examples
table_data
  • users.mysql
  • 340 Bytes
  • 10/03/2005 03:22:12
  • users.dbx
  • 290 Bytes
  • 10/03/2005 03:22:12
Hot Scripts
Sponsors