unix time format

seby

hi.

i am making a news script and having a little problem.

the database has the time stamp in unix format, when a user makes a comment i want to display "New" and nothing after a day has past that the comment was posted...

this doesn't work but this is what i tried:

   $today = mktime(); 
      if($row[3] == $today) {
	   $posted = "New!";
   } else {
	   $posted = "";
   }

$row[3] is the time stamp in unix format from the database, how do i match it if it's today? say I want to display "New" for just 12 hours, and then it disappears after 12 hours. how would i do this?

thanks.

common_ground

I think unix time is time in seconds from some date in the 1970's so you'd need to do something like

$today = mktime();
$hrs_before_old = 24;
$today = mktime();
if($row[3] + $hrs_before_old 60 60 > $today)
{
$posted = "New!";
} else {
$posted = "";
}

seby

it doesn't work, any ideas?

ereptur

Why not just use time().

Such as:

if ($row[3] == time())
print "New!";

m1anh

Try this, I have changed some variables to test it

Regards
Ian

<?php

$postingdate = mktime (0,0,0,1,11,2003);

if($postingdate > mktime (0,0,0,date("m") ,date("d")-1,date("Y"))):
$posted = "New!";
else:
$posted = ">24 Hours Old";
endif;

echo "$posted";

?>
</html>
</body>

common_ground

yes I meant time() rather than
$today = mktime();
$today = $time();

seby

err, none of this seems to work. it seems more complicated then it really should.

$row[3] has the time stamp in unix format, and i do not understand this format..

this is driving me up the wall, any more suggestions?

I get no errors with any of the code above, but its not displaying "NEW" like it should if the comment was posted today.

m1anh

Sorry, forgot about the time.
This is 100% Working to the second.
24H after the posting, displays >24 hours, you can remove this.

Regards
Ian

<?php

$postingdate = mktime (1,38,0,1,12,2003);

/ Replace $postingdate with you $row[3] /
/ Try changing the posting date H,M,S,Months,Days,Years /
/ I have tried this on my server and it works, are you sure $row[3] contains a unix date\time int Stamp. /
/ It does not look very nice, but it is the best i can do, i have only being coding PHP 1 week /
/ This works for me /

if($postingdate > mktime (date("H"),date("i"),date("s"),date("m") ,date("d")-1,date("Y"))):
$posted = "New!";
else:
$posted = ">24 Hours Old";
endif;

echo "<br>Server Date & Time: ", date("Y-m-d H:i:s");
echo "<br>Posting Date & Time: ", date("Y-m-d H:i:s",$postingdate);
echo "<br>$posted";

?>
</html>
</body>

Weedpacket

Originally posted by seby

$row[3] has the time stamp in unix format, and i do not understand this format..

Very simple it is; it is the number of seconds that have elapsed since the start of January 1, 1970.

if($row[3]>=strtotime('12 hours ago'))
{ // NEW!
}
else
{ // Not new
}

seby

wow you are good. it worked!

so much power with such little code 😉

thank you so much.

Weedpacket

Originally posted by seby
wow you are good. it worked!

so much power with such little code 😉

thank you so much.

It's only little because the code behind strtotime() is over two thousand lines of C; so I can't claim that much credit!