Select values from SQL db and display in dropdown, submit form

Question

The values from the db are displaying in the dropdown and I've gotten it to work with text values that weren't pulled from the db, but when I try it with values from the db and click 'Submit' the page reloads and nothing happens.

My code:

<form action="test.php" method="post">
<br />
<label for="name">Choose a name</label><br />

 <select name="selected_value">
 $query = "SELECT * FROM items WHERE user_id = $user_id";
 $select_items = mysqli_query($connection, $query);
 confirmQuery($select_items);
 while($row = mysqli_fetch_assoc($select_items)) {
 $item_id = $row['item_id'];
 $item_name = $row['item_name'];
 echo "<option value='$item_name'>{$item_name}</option>";

 </select>
 <button type="submit" name="submit_form">Submit</button>
 </form>


 if(isset($_POST['submit_form'])){
 $selected_value = $_POST['selected_value'];
 echo $selected_value;
 }

Kobbe · Accepted Answer · 2016-02-29 22:45:44Z

1

Don't you have this the wrong way around?

$_POST['selected_value'] = $selected_value;

should be

$selected_value = $_POST['selected_value'];

answered Feb 29, 2016 at 22:45

Kobbe

3161 silver badge14 bronze badges

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

2 Comments

brad Over a year ago

Yes; that was wrong and has been updated. But the problem still exists after rearranging this

Kobbe Over a year ago

Alright, try this: echo "<option value='$item_name'>{$item_name}</option>"; should be echo "<option value='$item_name'>" . $item_name . "</option>";

Collectives™ on Stack Overflow

Select values from SQL db and display in dropdown, submit form

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related