Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

PHP - How to count 60 days from the add date

Tags:

php

datetime

Let me know :)

$add_date = date ("Y-m-d H:m:s"); 
$expiry_date = 'how?';

How to insert into db the $expiry_date for 60 days. mysql format is datetime

like image 977
wow Avatar asked Nov 03 '09 18:11

wow


3 Answers

Use strtotime():

$start_date = date('Y-m-d H:m:s');
$end_date = date('Y-m-d H:m:s', strtotime("+60 days"));

or more simply:

$end_date = date('Y-m-d H:m:s', time() + 86400 * 60);
like image 141
cletus Avatar answered Sep 20 '22 13:09

cletus


A method avoiding time conversions:

$time = date('Y-m-d H:m:s', time()+3600*24*60)

EDIT
However, it may be less readable and the time saved is probably irrelevant. Plus cletus just edited a similar method into his answer

like image 27
Yacoby Avatar answered Sep 22 '22 13:09

Yacoby


If you are using PHP >= 5.2 I strongly suggest you use the new DateTime object. For example like below:

$add_date = date("Y-m-d H:m:s"); 
$expiry_date = new DateTime($add_date);
$expiry_date ->modify("+60 days");
echo $expiry_date ->format("Y-m-d H:m:s");

Live Demo

like image 43
Faisal Avatar answered Sep 20 '22 13:09

Faisal