Member Avatar for griffith

PHP UNIX_TIMESTAMP Help!?
How do we make a function where after 5 minutes, there is an update query.

  • 2 Contributors
  • 4 Replies
  • 75 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by Chosen13
Member Avatar for Chosen13

I did this. Ok, so what you do is make a table called website or something, and give it a unix timestamp. Then whenever time() < $websitetable, run the query, than in the same if statement update the column update_time to equal strtotime("+5 minutes"). That way, it will update it every 5 minutes.

Member Avatar for griffith

time function?

how do we set a time, cause I dont want to display a time cause it's not the correct time

Member Avatar for griffith

Also, could you give me an example of the above statement you showed? thanks

Member Avatar for Chosen13

Sure, I'd be glad too!

<?php
if(time() < $websitearray['update_time']) {
      mysql_query("YOUR QUERY HERE");
      mysql_query("UPDATE website SET update_time = '".strtotime("+5 minutes")."'");
}
?>

Just implement that right into your code. Enjoy ^_^

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.