Date not working

[liamloveslearning]

Hi everyone, I have this snippet of code which i need to add 7 days too

 

<?php echo $row_last_picture_date['startdate']; ?>

the above code outputs 28/05/2010

     

      Im trying to add 7 days using the code below but it outputs 07/01/1970, can anydbody see why?

 

     

      
   <?php $today = $row_last_picture_date['startdate'];
            $est = strtotime('+7 day', strtotime($today));
            print date('d/m/Y', $est); ?>

[ChaosKnight]

Try this:

$picturedate = $row_last_picture_date['startdate'];
$date = date(“Y m d”,strtotime(“+7 days”,$picturedate));

[liamloveslearning]

Doesnt seem to work, strange

[liamloveslearning]

The current code I have works to an extent, it adds 7 days, but it adds it to the current date and not my DB date

 

<?php
$curdate = $row_last_picture_date['user_picture_date'];
$plus7 = date("Y-m-d",mktime(0,0,0,date("m"),date("d")+7,date("Y")));

echo $plus7;
?>" />

[liamloveslearning]

How can I add my variable to this value?

I see its just adding 7 days to the current date now,

 

$plus7 = date("Y-m-d",mktime(0,0,0,date("m"),date("d")+7,date("Y")));

[liamloveslearning]

Ive just tried this, i think it makes sense but its still incorrect! can anybody see why?

 

<?php $today = $row_last_picture_date['user_picture_date'];
$est = strtotime('+7 day', strtotime($today));
print date('d/m/Y', $est); ?>

[ChaosKnight]

Have you tried this?:

<?php
  $today = $row_last_picture_date['user_picture_date'];
  $est = date(“d/m/Y”,strtotime(“+7 days”,$today));
  print date('d/m/Y', $est);
?>

The code you had a problem with adds 7 days to the date in the db, do you want code that adds 7 days to the current date?

[liamloveslearning]

Just tried it and it prints out 01/01/1970, Its not even adding 7 days now

[ChaosKnight]

What about this:

function addDate($date,$day)//add days
{
  $sum = strtotime(date("Y-m-d", strtotime("$date")) . " +$day days");
  $dateTo=date('Y-m-d',$sum);
  return $dateTo;
}

then you can call it like this:

$est = addDate($today,7);

[liamloveslearning]

Got it working! it was my Table data type was set incorrectly! Thanks for your help tho, Is it possible to set a default table value as current date? eg <?php echo date(); ?>

[ChaosKnight]

In your SQL? If that's the case, then you can set the table type as a timestamp and the default value as 0000-00-00 for yyyy-mm-dd, you can also do the time 0000-00-00 00:00:00

[liamloveslearning]

Thanks ChaosKnight!