如何添加月份到这个日期我得到

Question

$date = explode("/",$_POST['datum1']); // format is dd/mm/yyyy then use the below

$date_customer = $date[0];

let suppose i enter 4-1-2011, it will insert only 4 in the database by using insert query but now i want to add one month to it. mean if i enter 4th jan it inserts this, but wat wil be the code for inserting 4th Feb. date, 4th March and so on from the same input that is 4th jan ??

Answer 1

To add a month, you can use strtotime function something like this:

$mydate = date('Y-m-d', strtotime('+1 month', $yourDate));

Or you can use MySQL's ADDDATE function directly in your query like this:

ADDDATE(yourDateField, 1 Month)