Mysql Database & drop-down List

Question

I want to create a database entry screen with minimal programming. So far phpmyadmin as a tool does the job except that it does not offer options such as drop-down lists on fields whose values are populated from another table. Is there any secure tool out there that offers simple operations like that (preferably written in php and customizable).

Thanks

your question is quite unclear what you want. do you want to develop a ui for CRUD operation? If you are familiar with Codeigntier framework you can use grocery crud [here](http://www.grocerycrud.com/) — Muhammad Raheel, Aug 26 '13 at 07:20
Thanks, from what I've seen so far CRUD might be a good solution to consider. — Masood Hosseini, Aug 26 '13 at 08:06
phpMyAdmin will provide you dropdown if you have defined relations within your database. — Michal Čihař, Aug 26 '13 at 08:35

score 6 · Answer 1 · answered Aug 26 '13 at 08:50

if you mean foreign keys, you can do as below :

Convert both tables into innodb, if they are not already.
View the structure of the table which will have a foreign key. Make the referencing field an INDEX.
Now come back to structure view and click Relation view.

you can see more details in Here

score 5 · Answer 2 · answered Aug 26 '13 at 10:34

5

Even if the tables are not InnoDB, phpMyAdmin permits you to define the relations via Relation view, provided you have installed the phpMyAdmin configuration storage. See http://docs.phpmyadmin.net/en/latest/setup.html#phpmyadmin-configuration-storage.

answered Aug 26 '13 at 10:34

Marc Delisle

8,879
3
29
29

Mysql Database & drop-down List

2 Answers2