douxi6903 2011-10-08 10:48
浏览 36
已采纳

根据日期自动执行操作。 Php / Mysql

i am doing a library project for my college. in that, i have table called 'tbl_reserve' for store reservations. Structure is

Table Structure There are two date fields to store reservation date and expiry date. 'reserve_status' shows is it 'Reserved/Expired'.

is there is any way to automatic change the value of 'reserve_status' field after expiry date.

i am using PHP and MySQL.

  • 写回答

3条回答 默认 最新

  • duanmuyao0463 2011-10-08 10:51
    关注

    You can for example run a process at some fixed interval to check if the reservation has expired this can be done with Cronjob for example.

    Another way is to check for expiry every time the table is accessed for whatever reason.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥15 我这模型写的不对吗?为什么lingo解出来的下面影子价格这一溜少一个变量
  • ¥50 树莓派安卓APK系统签名
  • ¥15 maple软件,用solve求反函数出现rootof,怎么办?
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题
  • ¥20 求一个html代码,有偿
  • ¥100 关于使用MATLAB中copularnd函数的问题
  • ¥20 在虚拟机的pycharm上
  • ¥15 jupyterthemes 设置完毕后没有效果
  • ¥15 matlab图像高斯低通滤波