PHP EDIT form. Previous dropdown data not populating

Question

I have a simple order form with name (text), date (date), and then 2 sets of dropdowns. Each set contains a dropdown for flange and one for quantity. Basically the set repeats a couple times giving the user the ability to select a flange and then quantity with each set.

The forms sends all of the data (name, date, dropdown values, quantitys etc) to the database. I have created an edit page. When I go to edit an order all the data populates (including the quantity dropdowns) except for the flange dropdowns. They are just default blank.Is there a way to have the flange dropdown populate to the previously selected values?

<div style="display:block;">
          <label for="itemID">1:</label>
          <select id="itemID" name="itemID" required value="<?php echo $row['itemID']; ?>">
                    <option value="1">Flange 1 @ $100</option>
                    <option value="2">Flange 2 @ $100</option>
                    <option value="3">Flange 3 @ $50</option>
                    <option value="4">Flange 4 @ $50</option>
                    <option value="5">Flange 5 @ $50</option>
        </select>
  <label for="quantity"></label>
  <input type="number" id="quantity" name="quantity"  min ='1' max='50' style="width: 3em" required  value="<?php echo $row['quantity']; ?>">
  </div>
  <div style="display:block;">
          <label for="itemID2">1:</label>
          <select id="itemID2" name="itemID2" required value="<?php echo $row['itemID2']; ?>">
                    <option value="1">Flange 1 @ $100</option>
                    <option value="2">Flange 2 @ $100</option>
                    <option value="3">Flange 3 @ $50</option>
                    <option value="4">Flange 4 @ $50</option>
                    <option value="5">Flange 5 @ $50</option>
         </select>
  <label for="quantity2"></label>
  <input type="number" id="quantity2" name="quantity2"  min ='1' max='50' style="width: 3em" required  value="<?php echo $row['quantity2']; ?>">
  </div>
...

Does this answer your question? How to set selected value of HTML select box with PHP — Don't Panic
– Don't Panic, Commented Sep 18, 2022 at 9:39
Welcome to SO. Please try searching before posting - there are many answers to your question here already: stackoverflow.com/questions/32837873/…, stackoverflow.com/questions/1336353/…, stackoverflow.com/questions/34737676/…, stackoverflow.com/questions/32837873/…, stackoverflow.com/questions/38651772/… ... — Don't Panic
– Don't Panic, Commented Sep 18, 2022 at 9:42

Rohit Gupta · Accepted Answer · 2022-09-17 22:44:39Z

0

You have to set the selected attribute in the option that is currently selected. Like this

<?php
$value1 = $row['itemID'];
?>
  <label for="itemID">1:</label>
  <select id="itemID" name="itemID" required>
    <option value="1" <?php if ($value1=="1") {echo "selected";}?>>Flange 1 @ $100</option>
    <option value="2" <?php if ($value1=="2") {echo "selected";}?>>Flange 2 @ $100</option>
    <option value="3" <?php if ($value1=="3") {echo "selected";}?>>Flange 3 @ $50</option>
    <option value="4" <?php if ($value1=="4") {echo "selected";}?>>Flange 4 @ $50</option>
    <option value="5" <?php if ($value1=="5") {echo "selected";}?>>Flange 5 @ $50</option>
  </select>

And repeat for the 2nd lot.

edited Sep 17, 2022 at 22:44

answered Sep 17, 2022 at 11:36

Rohit Gupta

4,27723 gold badges36 silver badges48 bronze badges

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

5 Comments

No knowledge Over a year ago

Thank you that looks to make sense although I entered the code as is and the page crashes. Am i missing anything else?

Rohit Gupta Over a year ago

Has this got a valid value.$row['itemID']

No knowledge Over a year ago

Yes, all other page functions work. I can place an order from the order page and data gets sent to the database itemID as "1", "2" etc.

Rohit Gupta Over a year ago

Oops, the semicolon was in the wrong place. Fixed above.

Rohit Gupta Over a year ago

The protocol is to tick it as the right answer

Collectives™ on Stack Overflow

PHP EDIT form. Previous dropdown data not populating

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related