Tools

Monday, 21 May 2012

PHP DB2 Admin

E-mail Print PDF

This project PHPDB2Admin is intended to develop web interface for managing IBM DB2 database. With the help of PHP and the ODBC (Open Data Base Connectivity) and PECL(PHP Extinction Community Library ) connectivity libraries we deliver this project. It facilitates interaction with database by two different connections ODBC(Open Data Base Connectivity) and PECL(PHP Extinction Community Library ) .


Currently this project facilitate following functionalities:
  • Create , copy, drop, rename and alter tables, indexes, views.
  • Perform table maintenance.
  • Delete, add, and edit fields of Tables and Indexes.
  • Execute any SQL statement and batch queries.
  • Manage keys on fields.
  • Create (*) and read dumps of tables.
  • Export and Import data to CSV, XML, and EXCEL.
  • Search globally in a database or its subset.
  • Support InnoDB tables and foreign keys.

PHPDB2Admin also generates the queries and the php compatible query string which is directly used in PHP coding.By using this tool you can also execute the traditional queries. 
PHPDB2Admin is built completely in php. PHP environment is must to run this tool.PHPDB2admin alpha version is available in US-English very soon we come with different languages to provide better service to programmers.