Php pdo display enum values in dropdown

Question

i am trying below code to display list of enum values in select dropdown box. but its displaying only dropdown box, but values are not displaying....

tablename = tbl_users, column name = userStatus

<select>
<?
    $stmt = $user_home->runQuery('SHOW COLUMNS FROM '.tbl_users.' WHERE field="'.userStatus.'"');
       while($data = $stmt->fetch()) {
            foreach(explode("','",substr($row[1],6,-2)) as $option) {
                print("<option>$option</option>");
            }
        }
?>
<select>

Note : I really tried lot before posting question here & i am new to php coding, still learning....

your example code having problem, you get $data from $data = $stmt->fetch() and use $row in loop, how can I help with with a wrong question information? — Jared Chu
– Jared Chu, Commented Nov 10, 2016 at 7:11

Javi Ps · Accepted Answer · 2019-03-21 12:25:06Z

2

To display list of enum values in select dropdown:

<select name="select">
<?php
  $sql = 'SHOW COLUMNS FROM table_name WHERE field="field_name"';
  $row = $dbh->query($sql)->fetch(PDO::FETCH_ASSOC);
  foreach(explode("','",substr($row['Type'],6,-2)) as $option) {
   print("<option value='$option'>$option</option>");
  }
?>
</select>

edited Mar 21, 2019 at 12:25

answered Sep 28, 2017 at 17:26

Javi Ps

3094 silver badges11 bronze badges

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

Comments

Dhiren Vasoya · Accepted Answer · 2016-11-10 07:25:24Z

-2

For display enum value as dropdown you can do something like this.

<?php $status = array('Y'=>'Approve','N'=>'unapprove');  ?>
<select>
<?php foreach($status as $key=>$state) { ?>
<option value="<?php echo $key;?>"><?php echo $state;?></option>
<?php } ?>
</select>

answered Nov 10, 2016 at 7:25

Dhiren Vasoya

6727 silver badges20 bronze badges

4 Comments

Your Common Sense Over a year ago

this answer is a fraud. it doesn't answer the question asked.

Dhiren Vasoya Over a year ago

@YourCommonSense I am show the way to display enum value as dropdown at any place, then tell me why it fraud?

Your Common Sense Over a year ago

because the question was specifically about enum field stored in database

Dhiren Vasoya Over a year ago

yes, but the enum value is always fixed, so we can used that value as key in array and Display label which we want in dropdown.

Collectives™ on Stack Overflow

Php pdo display enum values in dropdown

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related