dpw30157 2017-04-04 15:36
浏览 35

在MySQL中存储PHP DateTime间隔

I'm trying to schedule maintenance notifications based on the date last completed + a date time interval selected by the user. I tried using strtotime but found it unreliable with leap years, short months, etc. The original drop down list was based on this array.

    $this->freq_ops = array(
        '1 weekdays' => 'Every day',
        '2 weekdays' => '2 days',
        '3 weekdays' => '3 days',
        '1 weeks' => 'Every week',
        '2 weeks' => '2 weeks',
        '3 weeks' => '3 weeks',
        '1 months' => 'Every month',
        '2 months' => '2 months',
        '3 months' => '3 months',
        '6 months' => '6 months',
        '9 months' => '9 months',
        '1 years' => 'Every year',
        '3 years' => '3 years',
        '5 years' => '5 years');

Now I'm trying to use DateTime objects. What's the ideal method to store a date time interval in MySQL and still show a friendly (or somewhat friendly) text string representation in the interface?

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 素材场景中光线烘焙后灯光失效
    • ¥15 请教一下各位,为什么我这个没有实现模拟点击
    • ¥15 执行 virtuoso 命令后,界面没有,cadence 启动不起来
    • ¥50 comfyui下连接animatediff节点生成视频质量非常差的原因
    • ¥20 有关区间dp的问题求解
    • ¥15 多电路系统共用电源的串扰问题
    • ¥15 slam rangenet++配置
    • ¥15 有没有研究水声通信方面的帮我改俩matlab代码
    • ¥15 ubuntu子系统密码忘记
    • ¥15 保护模式-系统加载-段寄存器