How do I generate a random time interval and add it to a mysql datetime using php?
I have many rows in mysql table with datetime's in the format of:
2008-12-08 04:16:51 etc
I'd like to generate a random time interval of anywhere between 30 seconds, and 3 days and add them to the time above.
a) how do I generate a random time between 30 and 3 days?
b) how do I add this time to the date time format above?
I imagine i need to do a loop to pull out all the info, do the math in php, and then update the row...
$new_date = date('Y-m-d h:i:s', strtotime('2008-12-08 04:16:51 +'.rand(30, 60 * 60 * 24 * 3).' seconds'));
- A Linux, Apache, MySQL, PHP (LAMP) stack is a combination of open source software that is typically installed together to enable a server to host dynamic […]
- MySQL is an the most popular open-source database management system, in most of hosting company its has been bundle by LAMP(Linux, Apache, MySQL, PHP/Python/Perl) stack. Another alternative […]
- MySQL is the world’s most popular open-source database. Despite its powerful features, MySQL is simple to set up and easy to use. Below are some instructions […]