<?php
  //檢查 cookie 中的 passed 變數是否等於 TRUE 
  $passed = $_COOKIE{"passed"};
  
  //如果 cookie 中的 passed 變數不等於 TRUE
  //表示尚未登入網站，將使用者導向首頁 index.html
  if ($passed != "TRUE")
  {
    header("location:register.html");
    exit();
  }
  
  //如果 cookie 中的 passed 變數等於 TRUE
  //表示已經登入網站，取得使用者資料  
  else
  {
    require_once("dbtools.inc.php");
    
    $id = $_COOKIE{"id"};
    
    //建立資料連接
    $link = create_connection();
        
    //執行 SELECT 陳述式取得使用者資料
    $sql = "SELECT * FROM register Where id = $id";
    $result = execute_sql($link, "book4105", $sql);

    $row = mysqli_fetch_assoc($result);
    $reaccount = $row["account"];

  } 
?>

<!doctype html>
<html>
  <head>
    <title>商品評價</title>
    <meta charset="utf-8">

    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>二手交易網站</title>
    <meta name="keywords" content="" />
    <meta name="description" content="" />

    <link href="default.css" rel="stylesheet" type="text/css" media="all" />
    <link href="fonts.css" rel="stylesheet" type="text/css" media="all" />
  </head>
  <body>
    <div id="header-wrapper">
    <div id="logo">
    <h1><a href="#">二手交易網站</a></h1>
    </div>
    <div id="triangle-up"></div>
    </div>
    </div>
    <div id="menu-wrapper">
    <div id="menu">
    <ul>
    <li class="current_page_item"><a href="index2.html" accesskey="1" title="">首頁</a></li>
    <li><a href="Categories2.php" accesskey="2" title="" >我要找書</a></li>
    <li><a href="main.php" accesskey="3" title="">會員中心</a></li>
    <li><a href="book.html" accesskey="5" title="">刊登商品</a></li>
    </ul>
    </div>
    </div>

    <p align="right">
      <!--<a href="board-input.php"><font color="#666666" size="3">問與答</font></a>-->
      <a href="自己的商品.php"><font color="#666666" size="3">查看上架商品</font></a>
      <a href="login2.html"><font color="#666666" size="3">註冊</font></a>
      <a href="logout.php" onClick="return(confirm('你確定要登出嗎？'))"><font color="#666666" size="3">登出</font></a>
    </p>

    <div id="wrapper">
    <div id="featured-wrapper">   
    <?php 
          $pdo=new PDO('mysql:host=localhost;dbname=book4105;charset=utf8', 
        'sennheiser', 'sennheiserie800');
          $link = create_connection();
          $sql = "SELECT * FROM books Where account = $id";
          $result = execute_sql($link, "book4105", $sql);
       
          //計算總記錄數
          $total_records = mysqli_num_rows($result);
                  
          //列出所有產品資料
          for ($i = 0; $i < $total_records; $i++)
          {
            //取得產品資料
            $row = mysqli_fetch_assoc($result);                 
            //顯示產品各欄位的資料   
            if($row["assess"] !=""){       
            echo "<p>"."評價：". $row["assess"] . "</p>";
            echo "<p>"."留言者：" . $reaccount . "</p>"; 
            }          
          }

                  
          //釋放資源及關閉資料連接
          mysqli_free_result($result);
          mysqli_close($link);

          /*$sql = "SELECT * FROM books Where account = $id";
          $result = execute_sql($link, "book4105", $sql);
          $total_records = mysqli_num_rows($result);
           for ($i = 0; $i < $total_records; $i++){
            $row = mysqli_fetch_assoc($result);
            
              echo '<p>'."留言者：".$reaccount.'</p>';
              echo '<p>'."評價：".$row['assess'].'</p>';
              echo '<p>'."評價時間：".$row['con_time'].'</p>';
              echo "</br>";
            }
          }*/
     
    ?>
          
  </body>
</html>