Update drop down from SQL database using PHP

Question

I know this should be simple but I just can't seem to get my head around it.

I have a list of continents in a sql database that I get back using PHP DBO and display in a drop down list. What I then want to do is get the users preferred continent from the sql database and select that one in the list. E.g if the list contains World, Africa, Europe, N America and S America but the users favorite is 'Europe' I want that one selected. $getContinent is the users preference.

while ($row = $continent_results->fetch(PDO::FETCH_ASSOC)) {

    if ($getContinent != ''){
        echo '<option value="' . $getContinent . '" selected="selected" >' . $row['CONTINENT_NAME'] . '</option>';
    }else{
        echo '<option value=' . $row['CONTINENT_ID'] . '>' . $row['CONTINENT_NAME'] . '</option>';
    }
}

I would be most grateful if someone could set me straight as I have found some examples on the internet but have been unable to get them to work :)

luckystars · Accepted Answer · 2013-01-27 20:08:43Z

2

Your code should be like this

while ($row = $continent_results->fetch(PDO::FETCH_ASSOC)) {

//just check if the option id is equal to the chosen value

    if ($getContinent != '' && $getContinent==$row['CONTINENT_ID'] ){


        echo '<option value="' . $getContinent . '" selected="selected" >' . $row['CONTINENT_NAME'] . '</option>';

    }else{
        echo '<option value=' . $row['CONTINENT_ID'] . '>' . $row['CONTINENT_NAME'] . '</option>';
    }
}

Its simple, as you guessed :D

answered Jan 27, 2013 at 20:08

luckystars

1,75412 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

James Over a year ago

Dam I was close! Thanks for your help that's what I wanted! I could not find any examples using DBO. Will mark you correct in 60 seconds lol :)

Alberto Ponte · Accepted Answer · 2013-01-27 20:05:36Z

0

You would use something like this:

while ($row = $continent_results->fetch(PDO::FETCH_ASSOC)) {
    echo '<option value="' . $row['CONTINENT_ID'] . '">' . $row['CONTINENT_NAME'] . '</option>';
}

I hope that helps!

--al

answered Jan 27, 2013 at 20:05

Alberto Ponte

4793 silver badges7 bronze badges

1 Comment

James Over a year ago

Thanks for the help, but that would only give me a list from the db which I know how to do. How would I then update the displayed list to show the users choice?

peterm · Accepted Answer · 2013-01-27 20:11:49Z

0

You can use ternary operator

while ($row = $continent_results->fetch(PDO::FETCH_ASSOC)) {
    echo '<option value="' . $row['CONTINENT_ID'] . 
         ($getContinent == $row['CONTINENT_NAME']) ? '" selected="selected"' : '"' . '>' . 
         $row['CONTINENT_NAME'] . '</option>';
}

answered Jan 27, 2013 at 20:11

peterm

93k16 gold badges157 silver badges162 bronze badges

Collectives™ on Stack Overflow

Update drop down from SQL database using PHP

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related