Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > body text

php 实现自动监听Mysql数据库表的某一字段值当该值改变时触发数据库更新操作,该如何解决

WBOY
Release： 2016-06-13 13:45:07
Original
1492 people have browsed it

php 实现自动监听Mysql数据库表的某一字段值当该值改变时触发数据库更新操作
php 实现自动监听Mysql数据库表的某一字段值当该值改变时触发数据库更新操作。比如用户输入密码错误锁定用户账户，3小时后，自动解锁

------解决方案--------------------
那多简单
1.用户输入错误
2.php 更新数据库字段 block 写入当前时间


用户下次登录 ->验证密码正确->判断 是否 block 如果是 取得 时间 是否和当前时间超过 3小时 如果是 unblock 重置 block 时间为默认

当然你也可以先检查帐号是否block.



Related labels：
Block gt mysql php
source：php.cn
Previous article： 织梦cms 怎么实现指定频道只有指定会员才可以进入 小弟分不多 Next article： 把下面代码加到PHP有有关问题，请PHP高手帮小弟我看看。（有人说要有转义符的）
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Why does the tooltip still work after removing the link? Only when I remove the link do I see the div tag with the tooltip. How are the two related...
From 2024-04-05 09:51:08
0
1
1419
Difficulty positioning divs I want to position a div relative to other elements on the page. This is the initial CSS: ...
From 2024-04-04 12:14:58
0
1
380
Why doesn't my Jquery slider display correctly? I'm trying to implement the SlickSlider library in my WordPress custom theme to display an...
From 2024-04-03 10:43:26
0
1
397
Why do verticalalign:textbottom and verticalalign:bottom have the same effect? The position of the line box baseline is affected by all elements in the line. .short-box{...
From 2024-04-02 09:45:45
0
1
347
Toggle text area to switch between HTML code and preview I want to use textarea to switch between HTML code and preview html. When the HTML is clic...
From 2024-03-31 11:52:47
0
1
348
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template