dongliu4320 2015-07-16 18:16
浏览 38
已采纳

通过MySQL / PHP在CRUD网格中实现age属性

I am familiar with MySQL, but not PHP and CRUD grids.

Let's say I have a CRUD grid up and running. I have an id, name, email, and date of birth. I want to create an age attribute that is based on the date attribute (so it updates based on the current date).

As a MySQL statement this is not too hard. I have the statement for doing so:

SELECT `name`, `dateOfBirth`, CURRENT_DATE,
TIMESTAMPDIFF(YEAR, `dateOfBirth`, CURRENT_DATE) AS age
FROM customers;

My question is how you'd implement this into a CRUD grid. Do I need to make a bespoke column or is that not necessary? Any advice or help much appreciated!

  • 写回答

1条回答 默认 最新

  • duanliang1019 2015-07-16 19:23
    关注

    Use datetime diff.

    $birthday = new DateTime('1985-09-15');
    $now = new DateTime();
    $age = $birthday->diff($now);
    echo $age->format('%Y years old');
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
编辑
预览

报告相同问题?