PHP: Update a date value?

Question

What is the easiest way to update a date?

In my database I have a field called mydate that is setup as a timestamp datatype. (It as to be this datatype).

My dates are listed as either:

2013-07-25 00:00:00

or

0000-00-00 00:00:00

Meaning they either have a data or just zeroes, but never empty.

Edit: Thank you all! I sort of combined all that you said and made it work.

Now lets say I wanted to increase any give date with 10 days how would I accomplish that?

The first one, July 25th 2013 would become 2013-08-04 00:00:00 and the other would become 2013-06-18 00:00:00 (at the time of posting it's June the 8th).

How to?

Something along these lines:

if(mydate_from_db > present_date){
mydate_from_db = mydate_from_db + day('10')
}
else{
mydate_from_db = present_date + day('10')
}

Update mysql with mydate where relevant.

Luke Cousins · Accepted Answer · 2013-06-08 11:36:17Z

2

With PHP you can do something like:

if($mydate_from_db > $present_date){
    $mydate_from_db = strtotime($mydate_from_db, '+ 10 days');
} else {
    $mydate_from_db = strtotime($present_date, '+ 10 days');
}

Or you can do it with mysql like:

UPDATE yourtable SET mydate = IF(mydate = '0000-00-00 00:00:00', '2013-06-18 00:00:00', DATE_ADD(mydate, INTERVAL 10 DAY));

answered Jun 8, 2013 at 11:36

Luke Cousins

2,1661 gold badge20 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

dev-null-dweller · Accepted Answer · 2013-06-08 11:32:51Z

1

You can do it in MySql directly:

UPDATE 
    my_table 
SET 
    my_date = my_date + INTERVAL 10 DAY 
WHERE 
    DATE(my_date) >= '2013-06-01'

answered Jun 8, 2013 at 11:32

dev-null-dweller

29.5k3 gold badges68 silver badges87 bronze badges

Comments

Bharu · Accepted Answer · 2013-06-08 11:47:41Z

0

 if(mydate_from_db > present_date)
  {
    $date = strtotime(mydate_from_db );
    $date = strtotime("+10 day", $date);
    echo date('M d, Y', $date);
   }
 else
  {
 $date=date();
 $date = strtotime("+10 day", $date);
 echo date('M d, Y', $date);
 }

answered Jun 8, 2013 at 11:47

Bharu

1911 gold badge3 silver badges19 bronze badges

Collectives™ on Stack Overflow

PHP: Update a date value?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related