Post on 31-Jan-2020
点击logo获取更多信息
GET YOUR
INFORMATION
睡觉时间
<?php
$sql = "SELECT * FROM shuijiao WHERE S=-1 order by date desc LIMIT 1";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while($row=$result->fetch_assoc())
{ //if ($row['S']==-1)
echo $row['date'];echo "
";}
}
?>
早起时间
<?php
$sql = "SELECT * FROM shuijiao WHERE S=1 order by date desc LIMIT 1";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// 输出数据
while($row=$result->fetch_assoc())
{ //if ($row['S']==1)
echo $row['date'];echo "
";}
}
?>
睡眠时长
<?php
$sql = "SELECT * FROM shuijiao order by date desc LIMIT 1";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// 输出数据
while($row=$result->fetch_assoc())
{ echo $row['during']."s";echo "
";
}}
$conn->close();
?>