PHP Classes

anyDB: DB class for MYSQL, POSTGRES, SQLITE, PHPLIB, ODBC

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 66%Total: 8,331 All time: 201 This week: 57Up
Version License Categories
anydb 1.0GNU Lesser Genera...Databases
Description 

Author

If you believe that database abstraction is a good think, but you don't want to
join the religous fights about the best one out there, then we have a common
interest.

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. It 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).

/////////////////////////////////////////////////////////////
// Interface of version 1.0:

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 $host
string $database
string $user
string $password

integer $prefResType
string $lastQuery
string $error
string $db
string $result

Picture of L
Name: L <contact>
Classes: 13 packages by
Country: Germany Germany

 

  Files folder image Files (40)  
File Role Description
Files folder imageaddon (4 files)
Files folder imagebase (3 files)
Files folder imagedbs (7 files)
Files folder imagedocs (1 file)
Files folder imageexamples (18 files, 1 directory)
Files folder imagetest (2 files)
Plain text file anyDB.php Class class for instancating instances of AbstractDB
Accessible without login Plain text file changes.txt Class changes for version 1.2
Accessible without login Plain text file interface.txt Doc. interface description

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:8,331
This week:0
All time:201
This week:57Up
 User Ratings  
 
 All time
Utility:82%StarStarStarStarStar
Consistency:89%StarStarStarStarStar
Documentation:84%StarStarStarStarStar
Examples:77%StarStarStarStar
Tests:-
Videos:-
Overall:66%StarStarStarStar
Rank:571