处理日期

Question

Here's what I need to do:

1. I want to insert a date into a datetime MySQL field 30 days from from the current date
2. When I pull that specific record, I want to be able to check whether that date has passed yet or not (i.e. expiration date)

Answer 1

For your insert:

$thirty_days_from_today = date('Y-m-d H:i:s', time() + 60*60*24*30);

Checking expiration dates:

if(strtotime($row['expiration_date']) < time()) {
    // expired
}