dscqrkvr9562034621 2014-04-22 06:35
浏览 113
已采纳

PHP MySQL警告:mysqli_fetch_array()期望参数1为mysqli_result [duplicate]

This is my PHP code :

<html>
    <head>  
        <title>SQL DB Management</title>
    </head>
    <body>
        <h1>MySqlAdmin</h1>
        <table>
            <tr>
                <th><!--Heading 1--></th>
                <th><!--Heading 2--></th>
                <th><!--Leave it blank--></th>
            </tr>
        <?php
            $db_host = "mysql.freehostingnoads.net";
            $db_username = "";
            $db_password = "";
            $db_name = "";
            $db_table = "";
            $db = mysqli_connect($db_host, $db_username, $db_password, $db_name);
            if (mysqli_connect_errno()){die("Failed to connect to MySQL: " . mysql_connect_error());}
            $content = mysqli_query($db,"SELECT * FROM " . $db_table);

            while($line = mysqli_fetch_array( $content )){
                echo("<tr>");
                echo("<td>" . $line['c1'] . "</td>");
                echo("<td>" . $line['c2'] . "</td>");
                #delete button
                echo("<td><form action='del.php' method='GET'><input type='text' name='c1' value='" . $line['c1'] . "' /><input type='text' name='c2' value='" . $line['c2'] . "' /><input type='button' value='DEL' /></form></td>");
                echo("</tr>");
            }
        ?>
    </body>
</html>

And simply skip reading the <head>, this is the warning I received:

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /home/u273577101/public_html/index.php on line 23

I have searched but cannot find the answer. What's the problem here?
There is no connection error, I guess. It doesn't seem to give me any error message about connecting.

</div>
  • 写回答

3条回答 默认 最新

  • dpje52239 2014-04-22 06:46
    关注

    Sorry, that was not the problem.

    The problem is that I assigned the value "table" for $db_table and it might be a key word.

    Thank you for your help.

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

报告相同问题?

悬赏问题

  • ¥15 不是,这到底错哪儿了😭
  • ¥15 2020长安杯与连接网探
  • ¥15 关于#matlab#的问题:在模糊控制器中选出线路信息,在simulink中根据线路信息生成速度时间目标曲线(初速度为20m/s,15秒后减为0的速度时间图像)我想问线路信息是什么
  • ¥15 banner广告展示设置多少时间不怎么会消耗用户价值
  • ¥16 mybatis的代理对象无法通过@Autowired装填
  • ¥15 可见光定位matlab仿真
  • ¥15 arduino 四自由度机械臂
  • ¥15 wordpress 产品图片 GIF 没法显示
  • ¥15 求三国群英传pl国战时间的修改方法
  • ¥15 matlab代码代写,需写出详细代码,代价私