php - PHP x时间过去隐藏mysql值
问题描述
我想看看该值是否超过当前时间,乘以图片中的 st-ads-time 3600 数字,我该怎么做?
我的代码:
<?php
$advertisement_query = mysql_query("SELECT * FROM andesite_advertisement ORDER BY advertisement_id DESC");
$num_log = mysql_num_rows($advertisement_query);
if ($num_log > 0) {
while ($ads_row = mysql_fetch_array($advertisement_query)) {
$ads_ase = $ads_row['advertisement_base'];
$is_buyed_query = mysql_query("SELECT * FROM andesite_adsrice WHERE adsrice_adsase = '$ads_ase' AND adsrice_username = '$user_nickname'");
while ($is_row = mysql_fetch_array($is_buyed_query)) {
$timeA = $is_row['adsrice_time'];
$timeB = date("d.m.Y H:i");
$timeDiff = strtotime($timeB) - strtotime($timeA);
if ($timeDiff > $ads_time) {
echo '
<tr id="'.$ads_row['advertisement_base'].'">
<td>'.$ads_row['advertisement_id'].'</td>
<td>'.$ads_row['advertisement_title'].'</td>
<td><a class="btn btn-success btn-success flat btn-xs" href="Surf/'.$ads_row['advertisement_base'].'" target="_blank"><i class="fa fa-eye"></i> '.ls_view.'</a></td>
</tr>
';
}
}
}
} else {
echo '
<tr>
<td>'.ls_nothata.'</td>
<td>'.ls_nothata.'</td>
<td>'.ls_nothata.'</td>
</tr>
';
}
?>
解决方案
该查询仅显示那些匹配的广告,advertisement_base
并且仅在当前时间在它们之后adsrise_time
但在adsrise_time
加st-ads-time
小时之前。
<?php
$query = "SELECT * FROM andesite_advertisement ORDER BY advertisement_id DESC";
$advertisement_query = mysql_query($query);
$num_log = mysql_num_rows($advertisement_query);
if ($num_log > 0)
{
while ($ads_row = mysql_fetch_array($advertisement_query))
{
$ads_ase = $ads_row['advertisement_base'];
$query = "SELECT * FROM andesite_adsrice
WHERE adsrice_adsase = '$ads_ase'
AND adsrice_username = '$user_nickname'
AND NOW() BETWEEN adsrise_time AND ADDTIME(adsrise_time, INTERVAL
(SELECT setting_value
FROM settings
WHERE setting_name = 'st-ads-time'
))";
$is_buyed_query = mysql_query($query);
while ($is_row = mysql_fetch_array($is_buyed_query))
{
echo '<tr id="'.$ads_row['advertisement_base'].'">
<td>'.$ads_row['advertisement_id'].'</td>
<td>'.$ads_row['advertisement_title'].'</td>
<td>
<a class="btn btn-success btn-success flat btn-xs" href="Surf/' . $ads_row['advertisement_base'] . '" target="_blank">
<i class="fa fa-eye"></i> '.ls_view.'
</a>
</td>
</tr>';
}
}
}
}
else
{
echo '
<tr>
<td>'.ls_nothata.'</td>
<td>'.ls_nothata.'</td>
<td>'.ls_nothata.'</td>
</tr>
';
}
?>
推荐阅读
- python - Python SKLearn 拟合值错误输入
- android - 如何从firebase获取数据作为非实时数据库?
- android - Android Kotlin“未知场景名称:transitionManager”第 41 章 pg 308
- javascript - 如何自动化 ElectronJS 应用程序
- python - 为什么我的 Selenium 代码可以在 Python Shell 中运行,但不能在文件中运行?
- python - 在 Python2.7 中比较 Timestamp 和 datetime64 时的奇怪行为
- android-emulator - 在Android Emulator中没有连接互联网,当通过热点通过手机上网时
- python - 在每一步解码后重新编码上下文向量?
- bash - 替换所有文件中的字符串
- r - ggplot aes fill 无缘无故无法工作