Creating drop-down menus
| From: | Ramiro Barrantes | Date: | Mon, 16 Jul 2012 20:16:59 +0000 |
| Subject: | Creating drop-down menus | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-318488@lists.php.net to get a copy of this message | ||
Hello,
I am making an application using PHP/Javascript/mysql and had a question.
Sometimes I need to use javascript to fill a drop down box based on the value of a previous drop
down box. However, the information to fill the latter is stored in mysql and can be a lot, what I
have been doing is that, using PHP, I create hidden fields with all the possible information that
might be needed to fill the second drop down.
For example, the user chooses a bank from a drop down, and then a list of clients is displayed on
the following drop down. I use PHP to read all clients from all the banks and put that as hidden
fields on the html page. It is very cumbersome.
I do not want to read the database (which changes dynamically) from javascript directly due to
confidentiality and because a lot of care has been taken to create the appropriate queries with
checks and protect misuse of the information using PHP.
My questions are:
1) Do people just normally use hidden fields to store possible information to fill the drop downs?
2) any suggestions?
Thanks in advance,
Ramiro