true));
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
$query = "SELECT time,active,content,timezone FROM log WHERE user_id = ? ";
$stmt = $dbh->prepare($query);
$stmt->execute(array($_COOKIE["uid"]));
echo "";
while($row = $stmt->fetch(PDO::FETCH_ASSOC)){
echo "";
foreach ($row as $key => $value) {
# code...
switch ($key) {
case 'active':
# code...
$output = isset($active_type[$value])? $active_type[$value] : $value;
break;
case 'time':
# code...
$output = gmdate("Y-m-d H:i:s",($value+$row["timezone"])/1000);
break;
case 'timezone':
# code...
$output = round($value/1000/60/60,2) ;
break;
default:
# code...
$output = $value;
break;
}
echo "| $output | ";
}
echo "
";
}
echo "
";
}
else{
echo "尚未登录";
}
?>