dtb81443 2016-09-26 11:22
浏览 223
已采纳

PHP代码在HTML中不起作用

As all have commented I have changed my code. Now the thing is when I am running my below php code as separate file its running like charm:

<?php
require("phpsqlajax_dbinfo.php");

$conn = new mysqli($hostname, $username, $password, $database);

$sql = "SELECT username FROM users";
$result = mysql_query($sql);

echo "<select name='username'>";
while ($row = mysql_fetch_array($result)) {
    echo "<option value='" . $row['username'] . "'>" . $row['username'] . "</option>";
}
echo "</select>";

?>

Like this: enter image description here

But when I am trying to include this into html code its not working:

<!DOCTYPE html>
<html>
<head>
  <title>FusionCharts Column 2D Sample</title>
</head>
<body>
    <div>
   <?php
require("phpsqlajax_dbinfo.php");

$conn = new mysqli($hostname, $username, $password, $database);

$sql = "SELECT username FROM users";
$result = mysql_query($sql);

echo "<select name='username'>";
while ($row = mysql_fetch_array($result)) {
    echo "<option value='" . $row['username'] . "'>" . $row['username'] . "</option>";
}
echo "</select>";

?>

</div>
  <div id="chart-container">LOADING....</div>
  <script src="js/jquery-2.2.4.js"></script>
  <script src="js/fusioncharts.js"></script>
  <script src="js/fusioncharts.charts.js"></script>
  <script src="js/themes/fusioncharts.theme.zune.js"></script>
  <script src="js/userChart.js"></script>
</body>
</html>

Its giving empty drop box: enter image description here

  • 写回答

1条回答 默认 最新

  • doupafu6980 2016-09-26 11:35
    关注

    Remove select inside select and don't mix mysqli_* with mysql_*.Do like below:-

    <div>
   <select>
        <?php
        require("phpsqlajax_dbinfo.php");

        $conn = new mysqli($hostname, $username, $password, $database);

        if ($conn->connect_error) {
          die("Connection failed: " . $conn->connect_error);
        }
        $query = "SELECT username FROM users";
        $result = $conn->query($query);

        ?>
        <?php
        while ($line = $result->fetch_assoc()) {
        ?>
        <option value="<?php echo $line['username'];?>"> <?php echo $line['username'];?> </option>

        <?php
        }
        ?>
    </select>

</div>

    Note:-

    file extension must be .php not .html.

    Don't use (deprecated + removed) mysql_* library. Use mysqli_* or PDO

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题？

悬赏问题

  • ¥35 平滑拟合曲线该如何生成
  • ¥100 c语言，请帮蒟蒻写一个题的范例作参考
  • ¥15 名为“Product”的列已属于此 DataTable
  • ¥15 安卓adb backup备份应用数据失败
  • ¥15 eclipse运行项目时遇到的问题
  • ¥15 关于#c##的问题：最近需要用CAT工具Trados进行一些开发
  • ¥15 南大pa1 小游戏没有界面，并且报了如下错误，尝试过换显卡驱动，但是好像不行
  • ¥15 自己瞎改改，结果现在又运行不了了
  • ¥15 链式存储应该如何解决
  • ¥50 成都蓉城足球俱乐部小程序抢票