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 "尚未登录";
}
?>