PHP Classes
Icontem

Class: anyDB


  Search   All class groups All class groups   Latest entries Latest entries   Top 10 charts Top 10 charts   Newsletter Newsletter   Blog Blog   Forums Forums   Help FAQ Help FAQ  
  Login   Register  
Recommend this page to a friend!
      Classes of Lennart Groetzbach  >  anyDB  >  Download  >  Support forum Support forum  >  RSS 1.0 feed RSS 2.0 feed Latest changes  >  Stumble It! Stumble It!  >  Bookmark in del.icio.us Bookmark in del.icio.us  
  Supplied by   Group folder image Groups   Detailed description   Freshmeat project  
  Rate classes User ratings   Applications   Related links   Files Files  
  • Supplied by:

    Picture of Lennart Groetzbach
    Name: Lennart Groetzbach <e-mail contact>
    Published packages: 13
    Country: Germany Germany - PHP jobs in Germany
    Home page: http://www.lennartgroetzbach.de/
    Age: 34
    All time rank: 27
    Week rank: 134

    Browse this author's classes

  • Groups:

    Group folder image Databases Database management, accessing and searching View top rated classes
  • Detailed description:

    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
  • Freshmeat project:

    Project record: anydb
    Popularity score: 466.25 (0.76%)
    Popularity rank: 7,874 (PHP Classes: 53)
    Vitality score: 10.37 (0.00%)
    Rating: 8.40 (Votes: 2) Please rate this class in Freshmeat
  • User ratings:

    Ratings
    Utility
    Consistency
    Documentation
    Examples
    Tests
    Videos
    Overall
    Rank
    All time:
    Good (82.1%)
    Good (90.5%)
    Good (86.9%)
    Sufficient (77.4%)
    -
    -
    Sufficient (66.5%)
    261
    Month:
    Not yet rated by the users
  • 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:

    File Role Description
    Files folder image addon
      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
    Plain text file anyDB.php Class class for instancating instances of AbstractDB
    Files folder image base
      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
    Accessible without login Plain text file changes.txt Class changes for version 1.2
    Files folder image dbs
      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 folder image docs
      Accessible without login HTML file readme.html Doc. short overview
    Files folder image examples
      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 folder image examples/table_data
      Plain text file users.dbx Conf. dbx database definition
      Plain text file users.mysql Conf. mysql database definition
    Accessible without login Plain text file interface.txt Doc. interface description
    Files folder image test
      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.

 
  Advertise on this site Advertise on this site   Site map Site map   Statistics Statistics   Site tips Site tips   Privacy policy Privacy policy   Contact Contact  

For more information send a message to :
info at phpclasses dot org.
Copyright (c) Icontem 1999-2008 PHP Classes - PHP Class Scripts
  PHP Book Reviews - Reviews of books and other products