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.
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:
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: