Select option selected

Question

I need to leave the select option selected according to the field saved in mysql. The form is to edit so it displays the fields available with foreach.

Ex:

 <select name="segurado"  >
    <option value=""></option>
    <?php foreach ($result as $rs) { ?>
        <option value="<?php echo $rs["nome"]; ?>"><?php echo $rs["nome"]; ?></option>
    <?php } ?>
</select> 

This way select shows the table fields handled but I want to leave the record field selected for selected edition.

---

Maybe I didn’t get it right: I recover the field saved in mysql and I can put it in the select label but this is not the solution. But this shows that the variable to compare is correct, or whatever was recorded in the table when registering. As I want to edit the record, I need this recorded and recovered field to be set as Selected in options, which in turn is being fed by foreach and creating the elements in the same way as in the register. Below is an example of how I fill out the option:

                            $sql = "SELECT * FROM seguradoras ORDER BY nome";
                            try {
                                $stmt = $DB->prepare($sql);
                                $stmt->execute();
                                $results = $stmt->fetchAll();
                            } catch (Exception $ex) {
                                echo($ex->getMessage());
                            }

With it filled in, I want it to show the variable that comes from the bank in the case $residential->insurance

Improved galley ?

Answer 1

Well, by changing the code and replacing the variables I finally got the result I wanted:

<?php foreach ($results as $rs) { ?>
    <option value="<?php echo $rs["nome"]; ?>" <?php if ($residencial->seguradora == $rs["nome"] ) { echo "selected";}  ?>  ><?php echo $rs["nome"]; ?></option>
<?php } ?>

Thank you all very much and a strong hug !

Answer 2

When meeting the condition you want to select put the <option selected>

<select name="segurado"  >
    <option value=""></option>
    <?php foreach ($result as $rs) { ?>
        <option value="<?php echo $rs["nome"]; ?>" <?php if($rs["minha_opcao_selecionada"] === true ){ echo "selected"}  ?>  ><?php echo $rs["nome"]; ?></option>
    <?php } ?>
</select>

Answer 3

Assuming you fill your form with entries in the table you could have a specific field for this type select with on or off or by checking the same example item:

<?php
    // sua lógica de acesso ao banco...
?>
<select name="segurado">
    <option value=""></option>
    <?php 
        foreach ($result as $rs) {
            // caso use um campo especifico
            if ( $rs['select'] === 'on' ) {
                echo '<option value="' . $rs['nome'] . '" selected="true">' . $rs['nome'] .'</option>';
            } else {
                echo '<option value="' . $rs['nome'] . '">' . $rs['nome'] .'</option>';
            }
            // ou pelo item mesmo
            if ( $rs['nome_do_item'] ) {
                echo '<option value="' . $rs['nome'] . '" selected="true">' . $rs['nome'] .'</option>';
            } else {
                echo '<option value="' . $rs['nome'] . '">' . $rs['nome'] .'</option>';
            }
        }
    ?>
</select> 

Answer 4

If you want a compact option here’s a:

<select name="segurado">
    <option value=""></option>
    <?php foreach ($result as $rs): ?>
        <option value="<?=$rs['nome']?>" <?= ($rs['select'] == 'on') ?  'selected' : '' ?> ><?= $rs['nome'] ?></option>
    <?php endforeach; ?>
</select>