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 python的qt5界面
    • ¥15 无线电能传输系统MATLAB仿真问题
    • ¥50 如何用脚本实现输入法的热键设置
    • ¥20 我想使用一些网络协议或者部分协议也行,主要想实现类似于traceroute的一定步长内的路由拓扑功能
    • ¥30 深度学习,前后端连接
    • ¥15 孟德尔随机化结果不一致
    • ¥15 apm2.8飞控罗盘bad health,加速度计校准失败
    • ¥15 求解O-S方程的特征值问题给出边界层布拉休斯平行流的中性曲线
    • ¥15 谁有desed数据集呀
    • ¥20 手写数字识别运行c仿真时,程序报错错误代码sim211-100