[RESOLVED] December 31 1969?? (time help please)

skeetskeet

I'm working on a blog script, and this page is suppose to show individual entries and a comments form. The comments show up, but are dated December 31 1969.

<?php

mysql_connect ('localhost', 'skeet*', '*****') ;
mysql_select_db ('skeet*');

$sql = "SELECT * FROM php_blog WHERE id=$id";

$result = mysql_query($sql) or
print ("Can't select entries from table php_blog.<br />" . $sql . "<br />" . mysql_error());

while ($row = mysql_fetch_array($result))
{
$date = date("l F d Y",$row["timestamp"]);
$title = $row["title"];
$entry = $row["entry"];

print "<b>$title</b><br><br>";
print "$entry<br><br>";
print "Posted on $date<br><br>";
}

mysql_connect ('localhost', 'skeet*', '*****') ;
mysql_select_db ('skeet*');

$sql = "SELECT * FROM php_blog_comments WHERE entry='$id' ORDER BY timestamp";
$result = mysql_query ($sql) or
print ("Can't select comments from table php_blog_comments.<br />" . $sql . "<br />" . mysql_error());
while($row = mysql_fetch_array($result))
{
$timestamp = date("l F d Y",$row["timestamp"]);
printf("<hr><br>");
printf("%s<br><br>\n",$row["comment"]);
printf("Served by <a href=\"%s\" target=\"_blank\">%s</a> @ %s<br>\n", $row["url"], $row["name"], $timestamp);
printf("<hr><br>");
}

print"<form method=\"post\" action=\"process.php\">\n";

print"<input type=\"hidden\" name=\"entry\" value=\"$id\">\n";
print"<input type=\"hidden\" name=\"date\" value=\"$timestamp\">\n";

print"name: <input type=\"text\" name=\"name\" size=\"25\" value=\"\"><br>\n";
print"email: <input type=\"text\" name=\"email\" size=\"25\" value=\"\"><br>\n";
print"url: <input type=\"text\" name=\"url\" size=\"25\" value=\"http://\"><br>\n";
print"comment:<br><textarea cols=\"25\" rows=\"5\" name=\"comment\"></textarea><br>\n";

print"<input type=\"submit\" name=\"submit_comment\" value=\"comment\">\n";

print"</form>\n";

?>

Any help would be appreciated.

mrhappiness

what's the content of $row['timestamp']?
what's the column type of column timestamp?

http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html might help

skeetskeet

I have no clue 🙁 (I must have newb. written all over me now)
I'm following this tut: http://codegrrl.com/tutorials/cat_build_a_blog.php

skeetskeet

Can someone just show me a way to make the date show up properly?

Weedpacket

I haven't read the tutorial (I shouldn't even be here right now - no time) but my guess is that the timestamp is a timestamp field. Look in MySQL's documentation about its DATE_FORMAT function.

LoganK

FYI, next time, be aware that PHP code can go within their own [ PHP ] [/ PHP ] tags. PHP code is not a [ QUOTE ] [/ QUOTE ]!!! 😃

About your issue: like what the other's said, what is the value of the timestamp? You know that it has to be an integer in seconds since January 1st, 1970 at 12:00:00, right? Unix epoch?

Have a look at [man]mktime()[/man] and [man]strtotime[/man].

skeetskeet

LoganK wrote:
FYI, next time, be aware that PHP code can go within their own [ PHP ] [/ PHP ] tags. PHP code is not a [ QUOTE ] [/ QUOTE ]!!! 😃

About your issue: like what the other's said, what is the value of the timestamp? You know that it has to be an integer in seconds since January 1st, 1970 at 12:00:00, right? Unix epoch?

Have a look at [man]mktime()[/man] and [man]strtotime[/man].

My php code is in quotes. I don't think there's anything wrong with that. Is there some magical rule that all php shouldn't be quoted? 🙂 or is it your personal preference? Well, I'm new and don't want to offend so for now on my posts with my php will remain without quotes.

Here's what I've tried....but hasn't worked.

$timestamp2=strtotime("now");
print"<form method=\"post\" action=\"process.php\">\n";

print"<input type=\"hidden\" name=\"entry\" value=\"$id\">\n";
print"<input type=\"hidden\" name=\"date\" value=\"$timestamp2\">\n";

print"name: <input type=\"text\" name=\"name\" size=\"25\" value=\"\"><br>\n";
print"email: <input type=\"text\" name=\"email\" size=\"25\" value=\"\"><br>\n";
print"url: <input type=\"text\" name=\"url\" size=\"25\" value=\"http://\"><br>\n";
print"comment:<br><textarea cols=\"25\" rows=\"5\" name=\"comment\"></textarea><br>\n";

print"<input type=\"submit\" name=\"submit_comment\" value=\"comment\">\n";

print"</form>\n";

Any ideas?

kburger

skeetskeet, if you wrap your posted PHP code in [ PHP ] [ /PHP ] tags it will make it much easier for the rest of us to read and be able to help you.

The code itself looks fine, although it does seem to me to be a little strange to have a timestamp for when the form is requested rather than when the form is posted. But syntactically it's correct. I think it must be a database issue. I'm guessing your 'timestamp' field must not be INT, or at least not an INT field large enough to handle integers like 1121920018, for example. That's a UNIX timestamp of approximately right now.

This

echo date("l F d Y", 1121920018);

will result in

Thursday July 21 2005

(and do you see the difference in [ PHP ] vs [ CODE ] tags?)

Can you tell us what the datatype is for your 'timestamp' field, and give us some examples of the values in a few rows?

EDIT: BTW this

echo date("l F d Y", "crap");

results in

Wednesday December 31 1969

LoganK

Ok, skeetskeet, so what can be learned from kburger's post?

Putting PHP code within the [ PHP ] tags makes it a lot easier to read (because it color-highlights the code, and allows whitespace).
Apparently, any invalid timestamp will result in the date you're talking about. So your timestamp is invalid. Try mktime(7, 21, 05, 12, 0, 0);, and then use that as the timestamp, and let's see what you get.

Edit: kburger, what made you bump that age-old poll? 😉

kburger

Actually, I didn't realize at the time how old it was. Weedpacket put a link to that thread in another thread I was subscribed to. It looked interesting, so I decided to check it out. The poll was at the top and I couldn't resist. I never realized all the flak I'd get for it. 😃

LoganK

Well, let that be a lesson to ya next time! 😃

skeetskeet

LoganK wrote:
Ok, skeetskeet, so what can be learned from kburger's post?

Putting PHP code within the [ PHP ] tags makes it a lot easier to read (because it color-highlights the code, and allows whitespace).

Apparently, any invalid timestamp will result in the date you're talking about. So your timestamp is invalid. Try mktime(7, 21, 05, 12, 0, 0);, and then use that as the timestamp, and let's see what you get.

Edit: kburger, what made you bump that age-old poll? 😉

What can be learned from going off topic on a thread started by someone else?

1.) It's not fair to the thread starter to have to go through posts that aren't relevant to the topic started.

2.) Every member has the capability to use a pm. Try it.

3.) And this one is very important, it makes it seem as though the thread has been solved or is unimportant which pushes the thread further back.

You've been here longer than me and still do not use board etiquette. Do you always make a habit to go off topic on threads?

For those of you that have taken the time to give me useful adivce, thank you. I've fixed the error, and everything works now. If anyone is curious in knowing what I did to fix this, send me a pm because I'm not going to bump this thread up anymore. It's resolved.

Weedpacket

It's considered good etiquette to post the solution on the boards, so that in the future, if anyone who has a similar problem looks for a solution and finds this thread, will be able to see the solution as well and determine if it applies to them.

Having the solutions publically available (instead of through private messaging) is the payoff/reward for having the forums in the first place. It's not like the people who help here are in it for the money.

Of course, if you want to be PM'd at random times for the next several years.....