如何设置的选定选项(How to set the selected option of )

如何设置的选定选项(How to set the selected option of )

我正在尝试让我的选择选项在下拉列表中显示我的数据库中的所选类别。 当我按下提交按钮时，我只能显示它。

<?php (isset($_POST["kategori"])) ? $kategori = $_POST["kategori"] : $kategori=1; $sql = "SELECT * FROM kategori" $result = mysqli_query($db, $sql); while($produkt = mysqli_fetch_array($result)) { ?> <option <?php if ($kategori == $produkt['kategori_id'] ) echo 'selected'; ?> value="<? echo $produkt['kategori_id']; ?>"> <? echo $produkt['kategori_navn']; ?></option> <?php } ?>

显然我从POST中获得了价值，这就是为什么它在我点击提交时首先显示该类别的原因。

我需要使用产品的产品ID从我的数据库中进行选择，并使用它的id来标记设置的类别。

我无法弄清楚如何做到这一点。

I'm trying to get my select option to show the selected category from my DB in the dropdown. I can only get it to show it, when i hit my submit button.

<?php (isset($_POST["kategori"])) ? $kategori = $_POST["kategori"] : $kategori=1; $sql = "SELECT * FROM kategori" $result = mysqli_query($db, $sql); while($produkt = mysqli_fetch_array($result)) { ?> <option <?php if ($kategori == $produkt['kategori_id'] ) echo 'selected'; ?> value="<? echo $produkt['kategori_id']; ?>"> <? echo $produkt['kategori_navn']; ?></option> <?php } ?>

Apparently I’m getting the value from POST, and that’s why it first shows the category when I hit submit.

I need to make a select from my database with the product ID of the product, and use it’s id to mark which category is set.

And I can’t figure out how to do that.

最满意答案

尝试一下

$sql = "SELECT * FROM kategori" $result = mysqli_query($db, $sql); while($produkt = mysqli_fetch_array($result)) { if ( $kategori == $produkt['kategori_id'] ) : ?> <option selected="selected" value="<?=$produkt['kategori_id']; ?>"><?=$produkt['kategori_navn']; ?></option> <?php else: ?> <option value="<?=$produkt['kategori_id']; ?>"><?=$produkt['kategori_navn']; ?></option> <?php endif; ?> <?php } ?>

其中$kategori是变量，具有先前选择的选项值。

Try it

$sql = "SELECT * FROM kategori" $result = mysqli_query($db, $sql); while($produkt = mysqli_fetch_array($result)) { if ( $kategori == $produkt['kategori_id'] ) : ?> <option selected="selected" value="<?=$produkt['kategori_id']; ?>"><?=$produkt['kategori_navn']; ?></option> <?php else: ?> <option value="<?=$produkt['kategori_id']; ?>"><?=$produkt['kategori_navn']; ?></option> <?php endif; ?> <?php } ?>

Where $kategori is variable which has the previously selected option value.