How make a combobox with php and mysql?

Question

I trying make a combobox with php and mysql but i cant find a solution. How I can fix this code?

$conn = new mysqli($servername, $username, $password, $db);
$result = mysqli_query($conn, "SELECT * FROM exemple") or die (mysqli_error($conn));
?>
<form action="" method="post">
  <h1>Combo</h1>
    <select name="cbx" id="cbx">
    <?php while($ri = mysql_fetch_array($result)) { ?>
      <option value="<?php echo $ri['exemp'] ?>">
        <?php echo $ri['exemp2'] ?>
      </option>
    </select>
    <?php } ?>
</form>

what is $result ?! please post all the code related to your issue. — Mohammad
– Mohammad, Commented Mar 28, 2019 at 15:24
Hi, @Kalil Alves, since you are new here, I recommend you reading "How to create a Minimal, Complete, and Verifiable example". You will get better feedback by following those tips. — accdias
– accdias, Commented Mar 28, 2019 at 15:29

Nik · Accepted Answer · 2019-03-28 15:33:19Z

1

Simply, close while loop before </select> tag:

<form action="" method="post">
  <h1>Combo</h1>
  <select name="cbx" id="cbx">
    <?php while ($ri = mysql_fetch_array($result)) { ?>
    <option value="<?php echo $ri['exemp'] ?>"><?php echo $ri['exemp2'] ?></option>
    <?php } ?>
  </select>
</form>

edited Mar 28, 2019 at 15:33

answered Mar 28, 2019 at 15:25

Nik

3,2652 gold badges27 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

How make a combobox with php and mysql?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related