DaDaBIK – Database Interface Creator | ZimudaSyslance: Corporate Collaboration

DaDaBIK – Database Interface Creator

Posted on 26. Oct, 2010 by syslance in Muat Turun, Sumber Terbuka

DaDaBIK is a free PHP application that allows you to easily create a highly customizable front-end for a database in order to search, insert, update and delete records; all you need to do is specifying a few configuration parameters.

Starting from version 4.0 alpha DaDaBIK uses the ADOdb Database Abstraction Library in order to support as many DBMS as possible, at the moment it has been tested on MySQL, PostgreSQL, Oracle and MS SQL Server.

The strength of DaDaBIK lies in its ability to be customized. For each field of a table you can choose:

if the field should be included or not in the search/insert/update form and results table
its label (what will appear in the form near the input field)
its content format (e.g. numeric, alphabetic, e-mail, url……)
the input type (e.g. select, date, text, rich text editor, password……)
the possible values, also driven from another table (foreign key support)
and more…

DaDaBIK also allows you to handle multiple tables. Other features include file uploading, master/details view, export to CSV, checking for possible duplication during an insert, authentication and authorization restrictions on view/update/delete, e-mail notices, table aliases.

The graphic layout of DaDaBIK is customizable to help you to embed its forms in your own site.

DaDaBIK differs from other applications like PHPMyAdmin since it doesn’t enable the complete administration of a database, but rather to easily create a simple and customizable Web application that manages a group of tables by allowing search/insert/update/delete operations. DaDaBIK’s target user is not the DB administrator but rather the final user.

DaDaBIK is available in Italian, English, Dutch, German, Spanish, French, Portuguese, Croatian, Polish, Catalan, Estonian, Rumanian, Hungarian, Swedish, Slovak and Finnish.

Installation:
If you’re about to use DaDaBIK for the first time, you might want to take a look at www.dadabik.org as well, since there’s a documentation online giving you more insight. Anyways, the setup is quite easy:

Download DaDaBik Revised-trunk.r2.tar
Extract the files, and upload the dadabik folder to your server.
Edit the file includes/config.php and enter your DB settings according to your setup.
Open up the URL yourdomain.com/pathtodadabik/install.php.
DaDaBIK will now set up some internal tables and you’re done.
DaDaBIKs default username is root and the password is letizia

Notes:
It’s important that you have created the database, you entered in the config.php file first. (for example using phpmyadmin).
If you want to, you can use a pre-made MySQL table structure with some dummy entries that I have included in the zip: just copy and paste the contents of dadabik-example-db.sql into the SQL window of the new database in phpmyadmin.

Once you’re done with the basic installation, head over to the admin.php which gives you all the admin options you need to include/remove secific tables and set human readable aliases for the tables.

The last step to perfect interfaces is to click the Interface configurator link on that admin page.
The configurator gives you all the options to customize the appearance, set default values, define which fields are mandatory, etc. etc.

Simple System

http://www.dadabik.org/dadabik_4.3_beta_demo.zip