doujiu6976 2015-05-29 05:39
浏览 68
已采纳

尝试使用php设置一个可变长度下拉菜单并从mysql中提取值

<?php 
    $exList = "select * from $exerciseTable";
    if($stmt = $conn->prepare($exList))
    {
        $stmt->execute();

        $stmt->bind_result($id,$name);

        while ($stmt->fetch())
        {

            echo "<option value=$id>$name</option>";
        }
    }


?>

I'm trying to make a dropdown list that pulls values from a mySql table that can be added to in another location. When I add values to the list it increases the number of options for the drop down menu, However no text is displayed it is just empty slots.

  • 写回答

3条回答 默认 最新

  • dp152153 2015-05-29 05:43
    关注

    You have to explicitly specify the columns that need to be selected id, name and later on bound, because * selects all columns, so there is no way MySQLi to know to which columns to bind id and name.

    $exList = "select id, name from $exerciseTable";
    

    Then it will work.

    For more information of the usage of binding results, you can check the documentation.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥15 maple软件,用solve求反函数出现rootof,怎么办?
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题
  • ¥15 state显示变量是字符串形式,但是仍然红色,无法引用,并显示类型不匹配
  • ¥20 求一个html代码,有偿
  • ¥100 关于使用MATLAB中copularnd函数的问题
  • ¥20 在虚拟机的pycharm上
  • ¥15 jupyterthemes 设置完毕后没有效果
  • ¥15 matlab图像高斯低通滤波
  • ¥15 针对曲面部件的制孔路径规划,大家有什么思路吗