donglong2856 2017-01-12 04:05
浏览 84

从数据库中获取值作为HTML中的选项,但不显示

As I stated on the title, I want to fetch data from the database and make them a value for option in HTML. But it shows nothing. In my database, I have 20 data, the option has 20 values tho, but it's all blank. Can you show me where I get it wrong?

<?php
    $query = "SELECT name_program FROM vote.program";
    $result = mysql_query($query);
?>
<div class="form-group">
   <label>Program</label>
        <select class="form-control">
            <option selected disabled>-- Select Program --</option>
            <?php
               while ($row = mysql_fetch_array($result)){
                   echo '<option value='.$row['name_program'].'</option>';
               }                                    
            ?>
        </select>
</div>
  • 写回答

2条回答 默认 最新

  • duangan7834 2017-01-12 04:14
    关注

    You have written option wrong way, it should be like

    echo '<option value="'.$row['name_program'].'">'.$row['name_program'].'</option>';
    

    Like @icecub stated, you should avoid using mysql_* function, you should look at pdo or mysqli.

    评论

报告相同问题?

悬赏问题

  • ¥15 微信小程序协议怎么写
  • ¥15 c语言怎么用printf(“\b \b”)与getch()实现黑框里写入与删除?
  • ¥20 怎么用dlib库的算法识别小麦病虫害
  • ¥15 华为ensp模拟器中S5700交换机在配置过程中老是反复重启
  • ¥15 java写代码遇到问题,求帮助
  • ¥15 uniapp uview http 如何实现统一的请求异常信息提示?
  • ¥15 有了解d3和topogram.js库的吗?有偿请教
  • ¥100 任意维数的K均值聚类
  • ¥15 stamps做sbas-insar,时序沉降图怎么画
  • ¥15 买了个传感器,根据商家发的代码和步骤使用但是代码报错了不会改,有没有人可以看看