PHP Database Interface

PHP Database Interface is an easy to use PHP database interface.
Download

PHP Database Interface Ranking & Summary

Advertisement

  • Rating:
  • License:
  • BSD License
  • Price:
  • FREE
  • Publisher Name:
  • Diilbert
  • Publisher web site:

PHP Database Interface Tags


PHP Database Interface Description

PHP Database Interface is an easy to use PHP database interface. PHP Database Interface is an easy to use PHP database interface meant to give applications universal support across many databases, including several flat file formats.InstallationThese are just a few notes installation notes regarding DBi and using it with your project txtSQL support requires the following files from the release archive (currently 3.0 Beta is Supported) : txtSQL.class.php, txtSQL.parser.php & txtSQL.core.php To be placed in the 3rdparty/txtsql/ directory or the location of your choice fileSQL support requires the the following file from the release archive (currently 1.0 RC4 is Supported) : fileSQL.php To be placed in the 3rdparty/fql/ directory of the location of your choice Test data and a demo script is available in the demo/ directorySimple Example// The filesystem root path to DBi needs to be defined before the include define('PHP_DBI_ROOT', 'C:/program files/apache group/apache2/htdocs2/modules/dbi/'); define('PHP_DBI_FQL', PHP_DBI_ROOT.'3rdparty/fql/fileSQL.php'); //Required for FQL Support define('PHP_DBI_TXTSQL', PHP_DBI_ROOT.'3rdparty/txtsql/'); //Required for txtSQL Support include_once("../dbi.php"); $interface = dbi::factoryControllerConstruction(); //create a new dbi object // open a connection to the database (this will example will work with any // of the interfaced databases $interface->open_connection_now_persistent("fql&".PHP_DBI_ROOT."3rdparty/fql/data&demo"); //Select the entire contents of 'test2' table and store the first row $inteface->ExecuteQueryAndReturnRow?(array('select' => '*', 'from' => 'test2')); $results = $interface->fetchRowThenGetAnotherrow(); //Display the first row of results print "First Row: "; print_r($results); print "< br >"; $interface->disconnect_fromDatabase(); // Closes connection to the databaseWhat's New in This Release:· The tableInfo function was added to return the schema.· LIMIT was added to select functions for supporting databases.· LIMIT emulation is available to all database types.· Support for the Firebird database was added.


PHP Database Interface Related Software