Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Thousands of items in multiple dropdown menus

A client has given me a task to do that I've not done before, and so I'm looking for the best way to do it. They have a form they want users to fill in, but for one field, they want an option of thousands to be placed into three dropdown menus.

For example:

enter image description here

So a user will only be able to choose a Venue once they've chosen a City, only a City once they'd chosen a State. (A nice way to break up the thousands of options.)

I suppose I could this quite easily using POSTBACKs and a simple database, but I imagine that doing something with AJAX and a simple database would be the slicker solution.

Are there any other ways that this problem might be tackled? If not, does anyone have any links to tutorials or code snippets I could grab? Secondly, how long do you think it would take you to implement such a system?

I've never done this before so I'm hoping to avoid as many unforeseen pitfalls as possible. Thanks.

like image 522
Chuck Le Butt Avatar asked May 19 '11 19:05

Chuck Le Butt


People also ask

How do I select multiple values in a drop-down list?

To select multiple options in a drop-down list, use the multiple properties. It allows you to select more than one option while pressing CTRL key.

How many multiple options can be selected in dropdown?

When you create a drop-down list, you can only make one selection. If you select another item, the first one is replaced with the new selection.


1 Answers

How about a simple jQuery Autocomplete solution?

like image 113
naivists Avatar answered Oct 09 '22 00:10

naivists