Add 1 hour on mysql timestamp in php

Question

In my Mysql table I have a timestamp field. In my php page I show the record ($row[data]) in this way

echo date("d-m-Y H:i:s", strtotime($row['data']));

Now in my php I'd like to add 1 hour on my date. How can I do this? Thanks

Answer 1

echo date("d-m-Y H:i:s", strtotime($row['data'])+3600);

note that you can't compare resulting dates in "d-m-Y" format.

either compare strtotime results or initial dates. or format your results into proper format first.

Answer 2

You could do this straight away in MySQL:

SELECT `date` + INTERVAL 1 HOUR AS `date`
FROM ...

Answer 3

         echo date("d-m-Y H:i:s", strtotime($row['data'].' +1 hour'));