使用mysqli从MySQL列中的下拉列表 [英] Dropdown List from MySQL Column using mysqli

问题描述

我有一个名为Users的MySQL表，其中有Name和NameID列.

I have a MySQL table named Users with columns Name and NameID.

喜欢...
姓名|名称ID
布拉德| bd
汤姆| ts

Like...
Name | NameID
Brad | bd
Tom | ts

我正在尝试提取所有Name值，并使用mysqli使它们填充下拉列表.我遇到了问题，希望这里有人可以提供帮助.

I'm trying to pull the all the Name values and have them populate a dropdown list using mysqli. I'm running into problems and hoping someone here can help.

我是mysqli的新手，所以在这里有些挣扎.这是代码.

I'm new to mysqli, so struggling a bit here. Here's the code..

connect.php ...

connect.php...

<?php

$dbname = 'mydabase';
$dbuser = 'myuser';
$dbpass = 'mypass';

?>

在index.php中...

In index.php...

<?php
include ("connect.php");

$db = new mysqli('localhost', $dbuser, $dbpass, $dbnam);
if (!$db) {
  exit('Connect Error (' . mysqli_connect_errno() . ') '
       . mysqli_connect_error());
} 
?>

    <div class="label">Select Name:</div>

    <select name="names">
    <option value = "">---Select---</option>
    <?php
    $queryusers = "SELECT `Name` FROM `Users` ";
    $db = mysqli_query($queryusers);
    while ( $d=mysqli_fetch_assoc($db)) {
      echo "<option value='{".$d['Name']."}'></option>";
    }
    ?>
      </select>  

推荐答案

未填充所选内容的原因是因为mysqli_query没有提供连接.

The reason your select doesn't get populated is because the mysqli_query doesn't get a connection supplied.

更改:

$db = mysqli_query($queryusers);

进入:

$db = mysqli_query($db, $queryusers);

还要在之间添加名称(否则您将获得一个没有文本的列表):

Also add the name between (else you get a list with no text):

while ( $d=mysqli_fetch_assoc($db)) {
  echo "<option value='{".$d['Name']."}'>".$d['Name']."</option>";
}

希望这对您有所帮助！

这篇关于使用mysqli从MySQL列中的下拉列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！