{"id":553,"date":"2008-10-25T09:34:44","date_gmt":"2008-10-25T13:34:44","guid":{"rendered":"http:\/\/www.dr-chuck.com\/wordpress\/?p=553"},"modified":"2011-12-17T12:28:08","modified_gmt":"2011-12-17T16:28:08","slug":"comparing-dates-in-php-coming-from-mysql","status":"publish","type":"post","link":"https:\/\/www.dr-chuck.com\/csev-blog\/2008\/10\/comparing-dates-in-php-coming-from-mysql\/","title":{"rendered":"Comparing dates in PHP coming from MySql"},"content":{"rendered":"<p>\nJust a little nugget:<\/p>\n<pre>\nif (strtotime($php_row->end_date) &lt; time()) {\n$php_bgcolor = $php_record_row_expired_bgcolor;\n}\n<\/pre>\n<p>\nMy version:<\/p>\n<pre>\nprint \"Updated at:\".$track->data(updated_at).\"\\n\";\nprint \"File:\".strtotime($track->data(updated_at)).\"\\n\";\nprint \"now:\".time().\"\\n\";\n$diff = time() - strtotime($track->data(updated_at));\nprint \"Diff:\".$diff;\n$count = $track->data(count);\nif ( ! isset($count) ) $count = 0;\n\/\/ De-bounce\nif ( $diff > 5 ) {\n$count = $count + 1;\n$track->setall( array( \"count\" => $count  ) ) ;\n$track->update();\n}\n<\/pre>\n<p>\nFrom: http:\/\/www.issociate.de\/board\/goto\/926394\/Comparing_PHP_Dates_with_MySQL_Dates.html<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Just a little nugget: if (strtotime($php_row->end_date) &lt; time()) { $php_bgcolor = $php_record_row_expired_bgcolor; } My version: print &#8220;Updated at:&#8221;.$track->data(updated_at).&#8221;\\n&#8221;; print &#8220;File:&#8221;.strtotime($track->data(updated_at)).&#8221;\\n&#8221;; print &#8220;now:&#8221;.time().&#8221;\\n&#8221;; $diff = time() &#8211; strtotime($track->data(updated_at)); print &#8220;Diff:&#8221;.$diff; $count = $track->data(count); if ( ! isset($count) ) $count = 0; \/\/ De-bounce if ( $diff > 5 ) { $count = $count + 1; $track->setall( [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-553","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/posts\/553","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/comments?post=553"}],"version-history":[{"count":1,"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/posts\/553\/revisions"}],"predecessor-version":[{"id":2670,"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/posts\/553\/revisions\/2670"}],"wp:attachment":[{"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/media?parent=553"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/categories?post=553"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/tags?post=553"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}