Bring in select html the record that was saved in the database

Question

Bring in select html the record that was saved in the database

Asked 5 years, 3 months ago

Viewed 30 times

-1

Good morning Can anyone tell me how to bring into a Select component of html the records that are in PHP ? In fact, I know how to bring, but how can I bring only what was saved in the bank and even select others. Below is the code as I am doing. I need to bring the doctor who was registered but at the same time select other if I wish to change...

what is displayed on the screen as it is now?

– Tales Peres

2019/03/13 at 14:37
He’s bringing all the records...

– Rogério dos Santos

2019/03/13 at 14:42
Of course he has to bring everyone, but he does not bring selected what is saved in the bank..

– Rogério dos Santos

2019/03/13 at 14:42
that $tb_medico_id_medico["tb_medico_id_medico"] would be that this saved in the bank?

– Tales Peres

2019/03/13 at 14:44
Yes, it is the one saved in the bank...tb_medico_id_medico is the table field

– Rogério dos Santos

2019/03/13 at 14:46
Please click on [Edit] and put the code as text. Putting it as an image is not ideal, understand the reasons reading the FAQ.

– hkotsubo

2019/03/13 at 15:25
Possible duplicate of Bring data in Select with PHP

– LipESprY

2019/03/13 at 15:35

Show 2 more comments

1 answer

Browser other questions tagged php html mysql

You are not signed in. Login or sign up in order to post.

by Tales Peres • **246** points · Answer 1 · 2019-03-13T14:51:07+00:00

You can do it this way, where it checks the id and if it matches he displays a selected:

<?php

if(count($resultMedicoAll))
{
    foreach($resultMedicoAll as $res) { ?>
        <option value="<?=$res["id_medico"]?>" <?=($tb_medico_id_medico["tb_medico_id_medico"] == $res["id_medico"] ? "selected" : '')?>> <?=$res["nm_medico"]?> </option> 
<?php }
}

?>