douxian5963 2019-04-14 18:28
浏览 369


I am trying to get and display two values from the database, 'cat_name', and 'cat_description' and display those in a table. A far as I can tell the code is fine. I am pretty new to PHP and have little experience with it.

I have tried going through many questions, and tried many possible answers. I cant really tell how many attempts I have tried to fix this issue.

    $query = $con->prepare("SELECT cat_id, cat_name, cat_description FROM categories");

    $result = $query->fetchAll(PDO::FETCH_ASSOC);
        //something went wrong, display the error
        echo 'Error'; 
        if($result == 0)
            echo 'No categories defined yet.';
            echo '<table border ="1">
                    <th>Last Topic</th>


            while($row = mysqli_fetch_array($result)){
            echo '<tr>';
            echo '<td class="leftpart">';
                echo '<h3><a href="category.php?id">' . $row['cat_name'] . '</a></h3>' . $row['cat_description'];
            echo '</td>';
            echo '<td class="rightpart">';
                echo '<a href="topic.php?id=">Topic subject</a> at 10-10';
            echo '</td>';
            echo '</tr>';


I am supposed to expect a table showing two columns one showing Categories (hyperlinked) with a small description of the category taking from the database. And another column for topics within that category but have not been able to get that far as of yet.

Expected outcome:

Expected outcome

When I run this code all I seem to achieve is an error.

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, array given

  • 写回答

1条回答 默认 最新

  • doxd96148 2019-04-14 18:42

    Once you have run

    $result = $query->fetchAll(PDO::FETCH_ASSOC);

    $result will be an array of the records from the query, so when you get to

    while($row = mysqli_fetch_array($result)){

    you already have the data so $result is not a result set, but an array of data. So instead you can replace this line with...

    foreach ( $result as $row ) {
    本回答被题主选为最佳回答 , 对您是否有帮助呢?



    • ¥20 arcgis制做交通拥堵时变图
    • ¥15 AD20 PCB板步线 这个要怎么步啊
    • ¥50 关于《奇迹世界》1.5版本,数据修改
    • ¥15 请问这个问题如何解决(关键词-File)
    • ¥50 visual studio 2022和EasyX图形化界面
    • ¥15 找一下报错原因,纠正一下
    • ¥50 Cox回归模型Nomogram图制作报错
    • ¥20 SQL如何查询多级用户的数据
    • ¥15 给车牌识别代码加一个识别轮廓长宽比的代码
    • ¥30 商品价格预测的transformer模型优化