Results 1 to 6 of 6

Thread: ?!!?!!? Help with a complex Drop Down, Please

  1. #1
    Join Date
    Aug 2011

    Question ?!!?!!? Help with a complex Drop Down, Please

    Hello All, I'm absolutely stunned by my clients request and require the assistance of more savvy developers on this.

    My client wants a Search box that contains to fields - [1] Business [2] City.
    When you click on the "Business" field a drop down menu appears with all the options available with check boxes, you then choose the business/es you are interested in. Then you move on to the cities and select the desired cities to search the selected business/es. When satisfied you hit enter and a complete list matching your Business/es and Cities selections appears in a formatted page.

    Would anyone know of anything similar out there that I can learn from, or can someone give me a list/map of how I should get started and what to do?

    Here's a link of a moc-up I did to show what I'm talking about - http://www.marcusgroup.com/test/imag...hSelection.jpg

    Thanks, so, so, so much in advance everyone.

  2. #2
    Join Date
    Mar 2007
    Are you familiar with jQuery? This seems like it would be a big help in this problem. You could put all your options in a div and then when the user clicks on the field you would call .toggle() the div. Check this out:

    or even this too to have animation:

  3. #3
    Join Date
    Aug 2011
    Awesome, I know JQuery but didnt know about the toggles. Honestly my main concern is after you choose one element from each drop down, and you hit search, how to make it so a clean list of both elements comes up or loads a new page with the list. In-other-words, you choose Auto Mechanic (Business) and then NYC (City) and hit search, you would get a list of all mechanics enlisted with my website.

    thanks for the reply btw.


  4. #4
    Join Date
    Mar 2007
    Is the search results page already built or that is what you're trying to build as part of this? If you already have a search results page you can just set the action of the search form to that page and have it react to the GET/POST variables created by the form.

    If you don't have the search results page you might want to create a separate post in the database section here referencing what you're using like mySQL/php or whatever system you're on. That'll give you a better chance- once a post gets a few responses people figure it's already been answered and the interest in it kinda dies.

  5. #5
    Join Date
    Aug 2011
    No database yet. All I have so far are the animated drop downs. I won't have the actual information for some time as my client is still acquiring more businesses.

    Just so I understand this a lil' better - After you choose the Biz and City and you hit Enter where do we go from there? My understanding is - it would go searching in a database with All Businesses and their respective cities, which then would read the users choices and sort it in a list format in a new page (only displaying the users choices). Am I at least close to what the process would be?

    I am also assuming mySQL would have to be used for the database, correct?

    Last edited by Sribeiro; 09-07-2011 at 02:39 PM.

  6. #6
    Join Date
    Mar 2007
    Yep that's the flow you'd be looking to create. On the page that uses php to connect to the mysql database you may also want to write in some validation to make sure the information you're getting from the user is the information that is in the drop down. You don't for example, want someone to use firebug to inject a value in a hidden field or something that contains database commands for the database to delete itself.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center



X vBulletin 4.2.2 Debug Information

  • Page Generation 0.17693 seconds
  • Memory Usage 2,889KB
  • Queries Executed 15 (?)
More Information
Template Usage (32):
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (6)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (1)navbar_moderation
  • (1)navbar_noticebit
  • (1)navbar_tabs
  • (2)option
  • (6)postbit
  • (6)postbit_onlinestatus
  • (6)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (26):
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/functions_navigation.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./includes/functions_facebook.php
  • ./includes/functions_calendar.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_notice.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php 

Hooks Called (70):
  • init_startup
  • friendlyurl_resolve_class
  • init_startup_session_setup_start
  • database_pre_fetch_array
  • database_post_fetch_array
  • init_startup_session_setup_complete
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • load_show_variables
  • load_forum_show_variables
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • strip_bbcode
  • friendlyurl_clean_fragment
  • friendlyurl_geturl
  • forumjump
  • cache_templates
  • cache_templates_process
  • template_register_var
  • template_render_output
  • fetch_template_start
  • fetch_template_complete
  • parse_templates
  • fetch_musername
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • build_navigation_data
  • build_navigation_array
  • check_navigation_permission
  • process_navigation_links_start
  • process_navigation_links_complete
  • set_navigation_menu_element
  • build_navigation_menudata
  • build_navigation_listdata
  • build_navigation_list
  • set_navigation_tab_main
  • set_navigation_tab_fallback
  • navigation_tab_complete
  • fb_like_button
  • showthread_complete
  • page_templates