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条)

报告相同问题?

悬赏问题

  • ¥30 这是哪个作者做的宝宝起名网站
  • ¥60 版本过低apk如何修改可以兼容新的安卓系统
  • ¥25 由IPR导致的DRIVER_POWER_STATE_FAILURE蓝屏
  • ¥50 有数据,怎么建立模型求影响全要素生产率的因素
  • ¥50 有数据,怎么用matlab求全要素生产率
  • ¥15 TI的insta-spin例程
  • ¥15 完成下列问题完成下列问题
  • ¥15 C#算法问题, 不知道怎么处理这个数据的转换
  • ¥15 YoloV5 第三方库的版本对照问题
  • ¥15 请完成下列相关问题!