Home arrow MySQL arrow Page 4 - How To Create A PHP Front-End To Your MySQL Database Using DaDaBIK
MYSQL

How To Create A PHP Front-End To Your MySQL Database Using DaDaBIK


Sure, all PHP developers have used PHPMyAdmin, but have you heard of DaDaBIK? In this article Eugenio talks about DaDaBIK and shows us how to use it to create a front-end for a MySQL database with it in under 5 minutes.

Author Info:
By: Eugenio Tacchini
Rating: 5 stars5 stars5 stars5 stars5 stars / 57
September 06, 2002
TABLE OF CONTENTS:
  1. · How To Create A PHP Front-End To Your MySQL Database Using DaDaBIK
  2. · Database Table Creation
  3. · Database Table Creation (contd.)
  4. · Customizing DaDaBIK
  5. · Conclusion

print this article
SEARCH DEVARTICLES

How To Create A PHP Front-End To Your MySQL Database Using DaDaBIK - Customizing DaDaBIK
(Page 4 of 5 )

DaDaBIK provides us with a lot of possibilities to customize the interface. One of the most useful is the ability to choose from different HTML input types for each field in the form. In fact, you aren’t limited to only single-line text boxes when editing field values –- you can choose to use textarea, password, select and checkbox fields. All you have to do is select the right field type from the internal table manager.

Let me explain with an example: imagine that we want to use a <textarea> field for the field notes_cust and a pull-down menu for the field job_cust; in particular the menu must contain 5 pre-set options: Teacher, Programmer, Musician, Student and Entrepreneur. Here's how to set it in the Internal table manager:

For notes_cust we have to change the field type from text to textarea:

Changing the field type for the notes_cust field

For job_cust we have to choice select_single as the field type, and fill in the box "Option to include" with all of possible options separated by the ~ sign, like this:

~~Teacher~Programmer~Musician~Student~Entrepreneur~

Note that I've put two ~ at the beginning of the string. This allows to have also a blank option.

Setting the options to display in the pull-down menu

Here's how our search interface looks after the changes mentioned above have been made:

Our newly updated search form

Advanced features
A lot of advanced features are also available and we'll see them in a future article about DaDaBIK, but let me just introduce the most important of them for now:

It is possible to:
  • use multiple tables
  • define which fields are required in the insert operation
  • define the possible content of a field (e.g. a web field must be filled with a valid URL)
  • decide if a field must be checked for possible duplications during inserts
  • get the possible values of a select field from a different table, also using a custom SQL statement (foreign key feature)
  • generate a unique ID for each insert
  • define the operations allowed for each table
  • change the position of the fields in the form

blog comments powered by Disqus
MYSQL ARTICLES

- MySQL and BLOBs
- Two Lessons in ASP and MySQL
- Lord Of The Strings Part 2
- Lord Of The Strings Part 1
- Importing Data into MySQL with Navicat
- Building a Sustainable Web Site
- Creating An Online Photo Album with PHP and ...
- Creating An Online Photo Album with PHP and ...
- PhpED 3.2 – More Features Than You Can Poke ...
- Creating An Online Photo Album with PHP and ...
- Creating An Online Photo Album with PHP and ...
- Security and Sessions in PHP
- Setup Your Personal Reminder System Using PHP
- Create a IP-Country Database Using PERL and ...
- Developing a Dynamic Document Search in PHP ...

Watch our Tech Videos 
Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 
Support 

Developer Shed Affiliates

 




© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials