Default value in HTML select tag with PHP

Question

is there a way to choose the initial value of a select tag from what the database really holds for that attribute?

EX: A table containing these records

ID  NAME  JOB
--  ----  ---
22  John  ENG
23  Alex  DOC
24  Peter SEC

if I wanted to edit one of these records while having a select to hold these 3 different Jobs, is there a way to select the initial value of this tag to be ENG if I wanted to edit John's record and be DOC if I chose to edit Alex's record?

NOTE: Guys I know that way that this post provides but I was asking for a way that I doesn't need to change the php code if I slightly changed the lower schemas :)

Please provide the source code that you tried yet.

cubitouch
– cubitouch

2014-01-08 19:36:03 +00:00
Commented Jan 8, 2014 at 19:36 — cubitouch
– cubitouch, Commented Jan 8, 2014 at 19:36
Yes. stackoverflow.com/questions/17076292/…

ChrisW
– ChrisW

2014-01-08 19:38:44 +00:00
Commented Jan 8, 2014 at 19:38 — ChrisW
– ChrisW, Commented Jan 8, 2014 at 19:38

Sam · Accepted Answer · 2014-01-08 19:41:21Z

0

To get you started, say you pass the query parameter name (script.php?name=John):

<select name="job">
    <?php
    $query = "SELECT * FROM jobs";
    foreach(execute($query) as $row) { // pseudo-code
    ?>
        <option<?php if(isset($_GET['name']) && $_GET['name'] == $row['NAME']) echo ' selected="selected"'; ?>>
          <?=$row['JOB'];?>
        </option>
    <?php
    }
    ?>
</select>

Obviously this contains a lot of psuedo-code for the execution of the SQL, but if you loop through every row to populate the options for your select you can check to see if the query param $_GET['name'] equals the current job's NAME.

answered Jan 8, 2014 at 19:41

Sam

20.5k2 gold badges48 silver badges71 bronze badges

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

2 Comments

Martin Samson Over a year ago

It might be a good idea to move the SQL out of the templating code (even if this is a simple example, better in the long run )

Sam Over a year ago

Definitely is @MartinSamson, since the OP didn't give any example code I had nothing to work off. I just wanted to throw out a quick example for the user to get started.

Collectives™ on Stack Overflow

Default value in HTML select tag with PHP

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related