PHP: selected row from dropdown after get method

Question

I need help with selected row after get method... I have table in mysql where fill dropdown rows and I really dont know how to put option value with $_get method... If user want to change some fields(edit it), previous row which is selected and saved needs to be selected... This is code:

<label for="" style="width:100px" id="a1" >Tarifa: </label>

<?php 
$result = $db->query("select sifra, porez from porezi");
echo "<select onchange='dropdownn();' style='width:100px' id='tarifa' name='tarifa_porez' class='input-sm form-control'>";

while ($row = $result->fetch_assoc()) {

    unset($sifra, $porez);
    $sifra = $row['sifra'];
    $porez = $row['porez']; 
    echo '<option value="'.$porez.'">    '.$porez.' %</option>';
}
echo "</select>";
?>

So, this is select, but I need help to read from table which one value is selected and select it on edit link (with $_get).

Thanks guys !

Welcome to SO. Please read What topics can I ask about and How to ask a good question And the perfect question And how to create a Minimal, Complete and Verifiable example SO is not a free Coding or Code Conversion or Debugging or Tutorial or Library Finding service Here at SO we fix your attempts, we do not code things for you — RiggsFolly
– RiggsFolly, Commented Jan 3, 2017 at 12:18

Pupil · Accepted Answer · 2017-01-03 12:32:11Z

1

All you have to do is use selected attribute of <option>

So, your modified code:

//.. Your code...
$tarifa_porez = ! empty($_GET['tarifa_porez']) ? $_GET['tarifa_porez'] : null;
while ($row = $result->fetch_assoc()) {
    unset($sifra, $porez);
    $sifra = $row['sifra'];
    $porez = $row['porez'];
    $selected = ($tarifa_porez == $porez) ? 'selected="selected"' : '';
    echo '<option value="'.$porez.'" ' . $selected . '>    '.$porez.' %</option>';
}
echo "</select>";
?>

Note: I have used ternary operator to reduce number of lines. Please read it here.

answered Jan 3, 2017 at 12:32

Pupil

24k6 gold badges50 silver badges71 bronze badges

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

Collectives™ on Stack Overflow

PHP: selected row from dropdown after get method

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related