How make drop-down in php have the option DB value as selected in html template

Question

I have a drop-down in html which is being rendered from php template. I can edit drop-down choice which takes usernames from DB, but how make it "selected" (what I have choose before) before editing?

Code for the template is below.

        $result = $conn->query("select username from users");
    echo "<html>";
    echo "<body>";
    echo "<select name='workers' >";
    while ($row = $result->fetch_assoc()) {
                  unset($username);
                  $username = $row['username'];
    echo '<option value=" '.$username.'"  >'.$username.'</option>';}
    echo "</select>";
    echo "</body>";
    echo "</html>";
    ?>

Please help!

Possible duplicate of PHP loop within a loop, option selected? — Vishnu Bhadoriya
– Vishnu Bhadoriya, Commented Feb 14, 2018 at 11:42

Nawin · Accepted Answer · 2018-02-14 11:26:21Z

0

You need to give to name to select tag and get that as that name like :

<?php
       $conn = new mysqli($servername, $username, $password, $dbname) or die ('Cannot connect to db');

            $result = $conn->query("select username from users");
        echo "<html>";
        echo "<body>";
        echo "<select name='drpdown'>";
        while ($row = $result->fetch_assoc()) {
            unset($username);
            $username = $row['username'];
            echo '<option value=" '.$username.'"  >'.$username.'</option>';
        }
        echo "</select>";
        echo "</body>";
        echo "</html>";
    ?>

get the post variable like :

print_r($_POST['drpdown']);

answered Feb 14, 2018 at 11:26

Nawin

1,6922 gold badges14 silver badges26 bronze badges

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

Collectives™ on Stack Overflow

How make drop-down in php have the option DB value as selected in html template

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related