Drop down menu from sql database

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
crims4nangel
Forum Newbie
Posts: 3
Joined: Sat Jun 27, 2009 1:43 pm

Drop down menu from sql database

Post by crims4nangel »

I am working on a drop down menu for my site. What I'm looking for it to do is simply pull record info (state) and make that the selected state in the pull down menu, so when they modify their info, it won't keep changing back to my default i set.
Here's the code...sorry i don't know how to put it into a php form, but here's what i got.

Code: Select all

     State:<td><select NAME="state2" default="Florida">
          <option value="Alabama">Alabama
          <option value="Alaska">Alaska
          <option value="Arizona">Arizona
          <option value="Arkansas">Arkansas
          <option value="California">California
          <option value="Colorado">Colorado
          <option value="Connecticut">Connecticut
          <option value="Delaware">Delaware
          <option value="Florida">Florida
          <option value="Georgia">Georgia
          <option value="Hawaii">Hawaii
          <option value="Idaho">Idaho
          <option value="Illinois">Illinois
          <option value="Indiana">Indiana
          <option value="Iowa">Iowa
          <option value="Kansas">Kansas
          <option value="Kentucky">Kentucky
          <option value="Louisiana">Louisiana
          <option value="Maine">Maine
          <option value="Maryland">Maryland
          <option value="Massachusetts">Massachusetts
          <option value="Michigan" selected>Michigan
          <option value="Minnesota">Minnesota
          <option value="Mississippi">Mississippi
          <option value="Missouri">Missouri
          <option value="Montana">Montana
          <option value="Nebraska">Nebraska
          <option value="Nevada">Nevada
          <option value="New Hampshire">New Hampshire
          <option value="New Jersey">New Jersey
          <option value="New Mexico">New Mexico
          <option value="New York">New York
          <option value="North Carolina">North Carolina
          <option value="North Dakota">North Dakota
          <option value="Ohio">Ohio
          <option value="Oklahoma">Oklahoma
          <option value="Oregon">Oregon
          <option value="Pennsylvania">Pennsylvania
          <option value="Rhode Island">Rhode Island
          <option value="South Carolina">South Carolina
          <option value="South Dakota">South Dakota
          <option value="Tennessee">Tennessee
          <option value="Texas">Texas
          <option value="Utah">Utah
          <option value="Vermont">Vermont
          <option value="Virginia">Virginia
          <option value="Washington">Washington
          <option value="Washington D.C.">Washington D.C.
          <option value="West Virginia">West Virginia
          <option value="Wisconsin">Wisconsin
          <option value="Wyoming">Wyoming
      </SELECT>
crims4nangel
Forum Newbie
Posts: 3
Joined: Sat Jun 27, 2009 1:43 pm

Re: Drop down menu from sql database

Post by crims4nangel »

Sorry for the double post, but no one has any ideas?
User avatar
McInfo
DevNet Resident
Posts: 1532
Joined: Wed Apr 01, 2009 1:31 pm

Re: Drop down menu from sql database

Post by McInfo »

Code: Select all

<?php
$states = array
(   'Alabama'       , 'Alaska'      , 'Arizona'         , 'Arkansas'      , 'California'
,   'Colorado'      , 'Connecticut' , 'Delaware'        , 'Florida'       , 'Georgia'
,   'Hawaii'        , 'Idaho'       , 'Illinois'        , 'Indiana'       , 'Iowa'
,   'Kansas'        , 'Kentucky'    , 'Louisiana'       , 'Maine'         , 'Maryland'
,   'Massachusetts' , 'Michigan'    , 'Minnesota'       , 'Mississippi'   , 'Missouri'
,   'Montana'       , 'Nebraska'    , 'Nevada'          , 'New Hampshire' , 'New Jersey'
,   'New Mexico'    , 'New York'    , 'North Carolina'  , 'North Dakota'  , 'Ohio'
,   'Oklahoma'      , 'Oregon'      , 'Pennsylvania'    , 'Rhode Island'  , 'South Carolina'
,   'South Dakota'  , 'Tennessee'   , 'Texas'           , 'Utah'          , 'Vermont'
,   'Virginia'      , 'Washington'  , 'Washington D.C.' , 'West Virginia' , 'Wisconsin'
,   'Wyoming'
);
$selected_state = 'Florida';
?>
<select name="state">
<?php
foreach ($states as $state) {
    $selected = ($selected_state == $state) ? ' selected="selected"' : '';
    printf('<option value="%1$s"%2$s>%1$s</option>', $state, $selected);
}
?>
</select>
Do you store the full name of the state in the database? If not, you need something slightly different.

Edit: This post was recovered from search engine cache.
Last edited by McInfo on Wed Jun 16, 2010 12:51 pm, edited 1 time in total.
User avatar
a94060
Forum Regular
Posts: 543
Joined: Fri Feb 10, 2006 4:53 pm

Re: Drop down menu from sql database

Post by a94060 »

to create it from a database, you would simply fetch the query as an array.

Code: Select all

mysql_fetch_array()
User avatar
McInfo
DevNet Resident
Posts: 1532
Joined: Wed Apr 01, 2009 1:31 pm

Re: Drop down menu from sql database

Post by McInfo »

I was under the impression that the question was about how to retrieve the current settings for a user (including the user's state) and display a select box with the user's state selected, not about how to retrieve a list of states from the database.

The list of states is not likely to change often, so it's fine to leave it hard-coded in the script. However, if there are multiple scripts that need to access the list, it might be beneficial to put it in a database.

Edit: This post was recovered from search engine cache.
Last edited by McInfo on Wed Jun 16, 2010 12:52 pm, edited 1 time in total.
crims4nangel
Forum Newbie
Posts: 3
Joined: Sat Jun 27, 2009 1:43 pm

Re: Drop down menu from sql database

Post by crims4nangel »

whole name is stored in database.
Testing...damn, forgot this was still up...but the states works, you're awesome...
I decided to try and implement this for a birthday system, month and day working, but year won't, any ideas?

Fixed: screwed up in the sql
Last edited by crims4nangel on Mon Jun 29, 2009 11:53 am, edited 1 time in total.
User avatar
a94060
Forum Regular
Posts: 543
Joined: Fri Feb 10, 2006 4:53 pm

Re: Drop down menu from sql database

Post by a94060 »

you could use a while loop to generate the drop down list.

Code: Select all

 
$start_year=1900;
 
while($start_year<2009) {
 
//print option box
 
$start_year++;
}
 
Post Reply