php - php中Mysql数据库行值获取问题

Question

我正在尝试通过选择查询获取数据库中存在的数据。但出了点问题，并且数据已正确获取。我没有得到它。让我知道我做错了什么。如果你能告诉我这里需要做什么，这将会很有帮助。我已经正确访问了行。但它仍然没有获取数据。

<div class="c-cart-menu">
    <div class="c-cart-menu-title">
        <p class="c-cart-menu-float-l c-font-sbold">2 item(s)</p>
        <p class="c-cart-menu-float-r c-theme-font c-font-sbold">$79.00</p>
    </div>
    <ul class="c-cart-menu-items">
        <li>
            <?php
                if(isset($_POST["view"]))
                {
                    include("connect.php");
                    if($_POST["view"] != '')
                        $update_query = "UPDATE notification SET noti_status=1 WHERE noti_status=0"; 

                    mysqli_query($connect, $update_query);
                    $query = "SELECT * FROM notification ORDER BY noti_id DESC LIMIT 5";
                    $result = mysqli_query($connect, $query);
                    $output = '';
                    if(mysqli_num_rows($result) > 0)
                    {
                        while($row = mysqli_fetch_array($result))
                        {
                            $output .= '

                            <div class="c-cart-menu-close">
                                <a href="#" class="c-theme-link"></a>
                            </div>
                            <img src="assets/base/img/content/shop2/12.jpg" />
                            <div class="c-cart-menu-content">
                                <p>
                                    '.$row["noti_header"].'
                                </p>

                                <a href="#" class="c-item-name c-font-sbold"><p>
                                    '.$row["noti_content"].'
                                </p></a>
                            </div>
                            </li>
                            ';
                        }
                    }
                    else
                    {
                        $output .= '<li><a href="#" class="c-font-sbold">No 
              Notification Found</a></li>';
                    }

                    $query_1 = "SELECT * FROM notification WHERE noti_status=0";
                    $result_1 = mysqli_query($connect, $query_1);
                    $count = mysqli_num_rows($result_1);
                    $data = array(
                        'notification'   => $output,
                        'unseen_notification' => $count
                    );
                    echo json_encode($data);
                } 
            ?>
    </ul>

    <div class="c-cart-menu-footer">
        <a href="shop-cart.html" class="btn btn-md c-btn c-btn-square c-
          btn-grey-3 c-font-white c-font-bold c-center c-font-
          uppercase">View Cart</a>
        <a href="shop-checkout.html" class="btn btn-md c-btn c-btn-square 
         c-theme-btn c-font-white c-font-bold c-center c-font-
         uppercase">Checkout</a>
    </div>
</div>


Connect.php

  <?php 
 //connect.php;
  $connect = mysqli_connect("localhost", "root", "", "demo");
  if($connect === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
  }

Answer 1

Use a proper IDE like NetBeans,Sublime Text for writing php codes.These IDE will show the error ,warning indications.In your case,you missed one closing bracket.Use the below code.

<?php

$query = "SELECT * FROM notification ORDER BY noti_id DESC LIMIT 5";
                                $result = mysqli_query($connect, $query);
                                $output = '';
                    if(mysqli_num_rows($result) > 0)
                      {
                          while($row = mysqli_fetch_array($result))
                       {
                        $output .= '

                            <div class="c-cart-menu-close">
                                <a href="#" class="c-theme-link"></a>
                            </div>
                        <img src="assets/base/img/content/shop2/12.jpg" />
                            <div class="c-cart-menu-content">
                                <p>
                                    '.$row["noti_header"].'
                                </p>

                          <a href="#" class="c-item-name c-font-sbold"><p>
                                   '.$row["noti_content"].'
                                </p></a>
                            </div>
                        </li>
                        ';
                         }}
                         else
                             {
              $output .= '<li><a href="#" class="c-font-sbold">No 
              Notification Found</a></li>';
                              }
               $query_1 = "SELECT * FROM notification WHERE noti_status=0";
                         $result_1 = mysqli_query($connect, $query_1);
                            $count = mysqli_num_rows($result_1);
                                 $data = array(
                                 'notification'   => $output,
                                 'unseen_notification' => $count
                                      );
                                 echo json_encode($data);

                       ?>
                    </ul>

                    <div class="c-cart-menu-footer">
         <a href="shop-cart.html" class="btn btn-md c-btn c-btn-square c-
          btn-grey-3 c-font-white c-font-bold c-center c-font-
          uppercase">View Cart</a>
         <a href="shop-checkout.html" class="btn btn-md c-btn c-btn-square 
         c-theme-btn c-font-white c-font-bold c-center c-font-
         uppercase">Checkout</a>
                    </div>
                </div>