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

Question

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!

Answer 1

Use datetime diff.

$birthday = new DateTime('1985-09-15');
$now = new DateTime();
$age = $birthday->diff($now);
echo $age->format('%Y years old');