Page 1 of 1

Drop down menu from sql database

Posted: Sat Jun 27, 2009 2:12 pm
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>

Re: Drop down menu from sql database

Posted: Sun Jun 28, 2009 10:56 am
by crims4nangel
Sorry for the double post, but no one has any ideas?

Re: Drop down menu from sql database

Posted: Sun Jun 28, 2009 11:51 am
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.

Re: Drop down menu from sql database

Posted: Sun Jun 28, 2009 5:17 pm
by a94060
to create it from a database, you would simply fetch the query as an array.

Code: Select all

mysql_fetch_array()

Re: Drop down menu from sql database

Posted: Sun Jun 28, 2009 5:23 pm
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.

Re: Drop down menu from sql database

Posted: Mon Jun 29, 2009 11:40 am
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

Re: Drop down menu from sql database

Posted: Mon Jun 29, 2009 11:49 am
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++;
}