Login   Register  
PHP Classes
elePHPant
Icontem

anyDB

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us

  Author  
Picture of L
Name: L <e-mail contact>
Packages: 13 Browse all classes by L Browse all classes by
Country: Germany Germany - PHP jobs in Germany
Age: 38
All time rank: 466 in Germany Germany
Week rank: 304 Down9 in Germany Germany Down


  Detailed description   Download .zip .tar.gz  
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

  Classes of L  >  anyDB  >  Download .zip .tar.gz  >  Support forum Support forum (4)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: anyDB
Base name: anydb
Description: DB class for MYSQL, POSTGRES, SQLITE, PHPLIB, ODBC
Version: -
PHP version: -
License: GNU Lesser General Public License (LGPL)
All time users: 8092 users
All time rank: 174
Week users: 2 users
Week rank: 1303 Down
 
  Groups   Freshmeat project   Rate classes User ratings  
  Applications   Related links   Files Files  

  Groups  
Group folder image Databases Database management, accessing and searching View top rated classes


  Freshmeat project  
Project record: anydb
Popularity score: 95.58
Vitality score: 2.92

  User ratings  
Ratings
Utility
Consistency
Documentation
Examples
Tests
Videos
Overall
Rank
All time:
Good (82.6%)
Good (90.2%)
Good (85.9%)
Sufficient (78.3%)
-
-
Sufficient (66.7%)
371
Month:
There are not enough user ratings to display for this class.

  Applications that use this class  
Link Description
FileDB Package for storing files in a database
IPTracker Package for storing the vistor's ip and related data
Add link image If you know an application of this package, send a message to the author to add a link here.

  Related links  
Link Description
Rate me Rate this class @ Hotscripts
sourceforge.net project page

  Files folder image Files  
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

  Files  /  Files folder image addon  
File Role Description
  Plain text file DBHelper.php Class utility class
  Plain text file Exporter.php Class utility class to export db content
  Plain text file PageWidget.php Class utility class
  Plain text file QueryHelper.php Class utility class

  Files  /  Files folder image base  
File Role Description
  Plain text file AbstractDB.php Class abstract wrapper class
  Plain text file BasicDB.php Class basic implementation
  Plain text file UtilityClass.php Class abstract base class

  Files  /  Files folder image dbs  
File Role Description
  Plain text file ADOdbDB.php Class Implementation for ADOdb
  Plain text file MetabaseDB.php Class Implementation for METABASE
  Plain text file MysqlDB.php Class Implementation for native php mysql functions
  Plain text file OdbcDB.php Class database layer for ODBC
  Plain text file PearDB.php Class Implementation for PEAR
  Plain text file PostgresDB.php Class Implementation for native php postgres functions
  Plain text file SQLite.php Class layer for SQLite

  Files  /  Files folder image docs  
File Role Description
  Accessible without login HTML file readme.html Doc. short overview

  Files  /  Files folder image examples  
File Role Description
Files folder imagetable_data (2 files)
  Plain text file connect.inc.php Conf. include file for connecting
  Plain text file createPageView.php Example example
  Plain text file disconnect.inc.php Example include to disconnect
  Plain text file dumpAll.php Example example
  Plain text file dumpColumn.php Example example
  Plain text file dumpDropdown.php Example examples
  Plain text file dumpNext.php Example example
  Plain text file exportToCsv.php Example export data in csv format
  Plain text file exportToSql.php Example dumps data as sql queries
  Plain text file getAll.php Example example
  Plain text file getAllExec.php Example exmample
  Plain text file getColumn.php Example example
  Plain text file getNext.php Example example
  Plain text file getNextBoth.php Example example
  Plain text file getNextNumeric.php Example example
  Plain text file getTables.php Example display all tables in current db
  Plain text file getValue.php Example get a single value
  Plain text file insert.php Example example

  Files  /  examples  /  Files folder image table_data  
File Role Description
  Plain text file users.dbx Conf. dbx database definition
  Plain text file users.mysql Conf. mysql database definition

  Files  /  Files folder image test  
File Role Description
  Plain text file test.inc.php Example example include
  Plain text file test1.php Example tests all db functions

Download all files: anydb.tar.gz anydb.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.