doujiu8826 2013-05-15 12:56
浏览 38

2分钟后自动删除mysql表数据

the query is not executed i don't know why

here is my try

i use this code to delete login attempts record and ip from the tabel after 2 min to allow user to try login again

if another soultion is better than this please submit it

<!DOCTYPE HTML>
<html>
<head>
    <meta http-equiv="content-type" content="text/html" />
    <meta name="author" content="gencyolcu" />

    <title>Untitled 1</title>
</head>
<style>
.fall
{
    background-color: aliceblue;
    color: darkkhaki;
    width: 400px;
    height: 200px;
    margin-top: 200px;
    padding: 200px;
    margin-left: 200px;
}
#txt
{
    font-family: fantasy;
    font-size: xx-large;
    font-style: italic;
}
</style>
<body>

<div class="fall">
 <p id="txt">You have exceeded the allowed  login times try again 
</p>
</div>
<?php
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("register_form", $con);


mysql_query("DELETE FROM login_attempts WHERE time < NOW() - INTERVAL 2 minutes");

mysql_close($con);
?>
</body>
</html>
  • 写回答

2条回答 默认 最新

  • douguanyun2169 2013-05-15 13:04
    关注

    Try this (MINUTE instead of MINUTES):

    sql_query("DELETE FROM login_attempts WHERE time < NOW() -  INTERVAL 2 MINUTE");
    
    评论

报告相同问题?

悬赏问题

  • ¥15 关于#hadoop#的问题
  • ¥15 (标签-Python|关键词-socket)
  • ¥15 keil里为什么main.c定义的函数在it.c调用不了
  • ¥50 切换TabTip键盘的输入法
  • ¥15 可否在不同线程中调用封装数据库操作的类
  • ¥15 微带串馈天线阵列每个阵元宽度计算
  • ¥15 keil的map文件中Image component sizes各项意思
  • ¥20 求个正点原子stm32f407开发版的贪吃蛇游戏
  • ¥15 划分vlan后,链路不通了?
  • ¥20 求各位懂行的人,注册表能不能看到usb使用得具体信息,干了什么,传输了什么数据