<?php 

require_once("./system/dbConn.php");
connect(); 
session_start();
if (isset($_SESSION['userid'])){
    $userid=$_SESSION['userid'];
}
$userid=0;
// $uid=$_GET["uid"];
$vid=$_GET["vid"];
$page=$_GET["page"];
// echo $page;
// $totalrows=$num0;
$pagerows=5;
// $totalpages=ceil($totalrows/$pagerows);
$start=($page-1)*$pagerows;
// $content=$_POST["content"];
// $date=date("YmdHis");

// $sql="select * from comments where vid=$vid";
// $result=mysql_query($sql);
?>
<tr>
        <th>序号</th>
        <th>评论内容</th>
        <th>评论人</th>
        <th>评论时间</th>
    </tr>
<?php
    

 $sqlcomment="select * from comments where vid=$vid order by cid desc";
$sql1=$sqlcomment." limit $start,$pagerows";
//$result=mysql_query($sql);
$result1=mysql_query($sql1);




        $resultcomment=mysql_query($sqlcomment);
$i=1;

while ($rowcomment=mysql_fetch_assoc($result1)) {
    $uid=$rowcomment["uid"];
    $sqluser="select * from users where uid=$uid";
    $resultuser=mysql_query($sqluser);
    $rowuser=mysql_fetch_assoc($resultuser);

    $cid=$rowcomment['cid'];
    $sqlCount="select * from thumbsupscomment where cid=$cid";
	$resultCount=mysql_query($sqlCount);
	$numsCount=mysql_num_rows($resultCount);

	$sqlTh4="select * from thumbsupscomment where uid=$userid and cid=$cid";
	$resultTh4=mysql_query($sqlTh4);
// $rowTh2=mysql_fetch_assoc($resultTh2);
	$numTh4=mysql_num_rows($resultTh4);

 ?>
    <tr>
        <td><?php echo $i ?></td>
        <td><?php echo $rowcomment["content"]; ?></td>
        <td><?php echo $rowuser["uname"]; ?></td>
        <td><?php echo $rowcomment["cdate"];if ($numTh4<=0) {
			echo '<button id="sub'.$i.'" class="btn btn-default" style="width: 100px;float: right;"><p id="'.$i.'" hidden="">'.$cid.'</p><p id="pp'.$i.'"><i class="glyphicon glyphicon-heart-empty" ></i>点赞 '.$numsCount.'</p></button>';
		}else{
			echo '<button id="sub'.$i.'" class="btn btn-default" style="width: 100px;float: right;"><p id="'.$i.'" hidden="">'.$cid.'</p><p id="pp'.$i.'"><i class="glyphicon glyphicon-heart" ></i>已点赞 '.$numsCount.'</p></button>';
		}?></td>
    </tr>
    <?php $i+=1;} ?>