dongtan5558 2015-12-31 16:37
浏览 42

PHP显示系统

This code is supposted Show all of the Table Reg_Log. The code can show but... if the table is empty, the code show a message saying "You have no purchases.".

but someting is wrong...

        $Check_Reg = $_SESSION['user']['username'];

    if(!empty($Check_Reg))
        {

        $dbh = new PDO("mysql:host={$host};dbname={$dbname};charset=utf8", $username, $password);           
        $search = $dbh->prepare("SELECT ID_Article, Data_Compra, Price, Cred_Depois FROM reg_log ORDER BY Data_Compra DESC");           
        $search->execute();         
        $checkUser = $search->fetchAll();

             foreach($checkUser as $u)
              {
              echo "<table>";
              echo "<tr>";
              echo "<th><b>Article ID</b></th>";
              echo "<th><b>Price</b></th>";
              echo "<th><b>Savings</b></th>";
              echo "<th><b>Data & Hora</b></th>";

              echo "</tr>";
              echo "<br /><tr><td>" . $u['ID_Article'] . "</td><td>". $u['Price'] . "</td><td>" . $u['Cred_Depois'] . "</td><td>" . $u['Data_Compra'] . "</td></tr> " ;
              echo "</table>";


        $dbh = null; //close db
        }    

        } else {     
                $emptyField = False;    
            echo "You have no purchases.";

    }
  • 写回答

1条回答 默认 最新

  • dongmi4734 2015-12-31 16:54
    关注

    Because $_SESSION['user']['username'] is empty, the table isn't even read.

    评论

报告相同问题?

悬赏问题

  • ¥15 帮我写一个c++工程
  • ¥30 Eclipse官网打不开,官网首页进不去,显示无法访问此页面,求解决方法
  • ¥15 关于smbclient 库的使用
  • ¥15 微信小程序协议怎么写
  • ¥15 c语言怎么用printf(“\b \b”)与getch()实现黑框里写入与删除?
  • ¥20 怎么用dlib库的算法识别小麦病虫害
  • ¥15 华为ensp模拟器中S5700交换机在配置过程中老是反复重启
  • ¥15 java写代码遇到问题,求帮助
  • ¥15 uniapp uview http 如何实现统一的请求异常信息提示?
  • ¥15 有了解d3和topogram.js库的吗?有偿请教