duanbixia7738
2015-03-10 23:40 浏览 43
已采纳

php页面没有显示任何内容[关闭]

im trying to create a drop down many and populate the options from fields in a database that i have. So far i have got the following code:

<?php
session_start();
include_once("config.php");

$query = "SELECT Category FROM books";
$result = mysqli_query ($mysqli, $query);

echo "<select name=dropdown value=''>Dropdown</option>";
while($row = mysqli_fetch_array($result))
{
    echo "<option value=$row[Category]>$row[Category]</option>";
}

echo "</select>";
?>
</div>
</body>
</html>

However when i try to view the page nothing seems to happen. My page remains blank and all i see is the color that i gave to the body in the css file.

Was wondering if anyone knew wh this was happening and if they can sort it out?

Thanks!

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享
  • 邀请回答

1条回答 默认 最新

  • 已采纳
    douping5226 douping5226 2015-03-11 00:08

    Assuming you are getting results from your query. Can find out by print_r($result). Think you are getting death screen because of quotes and missing opening for first option in dropdown.

    echo '<select name="dropdown" value=""><option value="">Dropdown</option>';
        while($row = mysqli_fetch_array($result))
        {
            echo '<option value="' . $row['Category'] . '">' . $row['Category'] . '"</option>';
        }
    
        echo "</select>";
    
    点赞 评论 复制链接分享

相关推荐