date function doesnt insert into the database

[kleb]

i have been trying to insert date with when users post there comment but when i echo the date() with the comments..it just display 0000.00.00.00 just like that and when i checked my DB it was like that too..please what can i do.this is my code

Thankd in advance

<?php
include"header.php";
if(isset($_POST['submit']))
{
$postdate=mktime(0,0,0,date("m"),date("d")+1,date("y"));
$comment=mysql_real_escape_string($_POST['comment']);
if($comment!=='')
{
$ins="INSERT INTO post(post_content,post_date)VALUES('$comment','$postdate')";
mysql_query($ins) or die(mysql_error());
}
else
{
echo"You can not post an empty page";
}
}

[Drongo_III]

Shoot me down if this is an overly simplistic suggestion...but could you not just use 'Time stamp' as one of your mysql  table columns? This would then save you having to do all the date processing to create the date.

 

 

 

i have been trying to insert date with when users post there comment but when i echo the date() with the comments..it just display 0000.00.00.00 just like that and when i checked my DB it was like that too..please what can i do.this is my code

Thankd in advance

<?php
include"header.php";
if(isset($_POST['submit']))
{
$postdate=mktime(0,0,0,date("m"),date("d")+1,date("y"));
$comment=mysql_real_escape_string($_POST['comment']);
if($comment!=='')
{
$ins="INSERT INTO post(post_content,post_date)VALUES('$comment','$postdate')";
mysql_query($ins) or die(mysql_error());
}
else
{
echo"You can not post an empty page";
}
}

[melloorr]

why not just put:

$postdate = date("m/d/y/ H:i");

[Drongo_III]

or

 

$today = date("F j, Y, g:i a");        
echo $today;

 

But personally i would leave it to the database to do it. If you can pass something to database to process you probably should. Just my opinion.

[kleb]

i have tried most of the options here but with no thesame result...

[kleb]

how do i use the time stamp..do i write it together as in TIMESTAMP?

 

[Drongo_III]

You can do a time stamp just by going into your database on php myadmin. Then add a column to the table and in the drop down for 'type' (that's the dropdown with VARCHAR, INT etc.) there is an option for DATE and TIME.  You can select various variations on the date and time from the drop down. Then everytime a record is added to the database it will automatically add the current date and time to that field. So you don't have to do it.

 

You can then retreive the date and time as you would any other database value.

 

 

 

how do i use the time stamp..do i write it together as in TIMESTAMP?

[kleb]

still showing this 0000-00-00 00:00:00 even when i changed it to TIMESTAMP

[Drongo_III]

Hmm ok. Go into myadmin and click on structure then click to modify the column for time stamp.

 

In there there's a drop down for DEFAULT with a dropdown. Select CURRENT_TIMESTAMP from the drop down. Hopefully that'll fix it

 

[Pikachu2000]

In order for the timestamp to update, an UPDATE operation has to be run on the record. Simply changing the data type won't update all the timestamps.

[kleb]

Hi drongo i truely appreciate your effort..but it still thesame thing infact everything is set its even on UPDATE when i checked it..please what do i do?

[Pikachu2000]

In order for the timestamp to update, an UPDATE operation has to be run on the record. Simply changing the data type won't update all the timestamps.

[melloorr]

If the date and time is being sent to the database (they are not displaying properly) then there is no reason why this should not work:

 

<?php
include"header.php";
if(isset($_POST['submit']))
{
$postdate = date("m/d/y/ H:i");
$comment=mysql_real_escape_string($_POST['comment']);
if($comment!=='')
{
$ins="INSERT INTO post(post_content,post_date)VALUES('$comment','$postdate')";
mysql_query($ins) or die(mysql_error());
}
else
{
echo"You can not post an empty page";
}
}
?>

[Pikachu2000]

There is a reason that won't work. The format of a TIMESTAMP field is not M/D/Y h:m, it's YYYY-MM-DD HH:MM:SS.

[melloorr]

There is a reason that won't work. The format of a TIMESTAMP field is not M/D/Y h:m, it's YYYY-MM-DD HH:MM:SS.

 

Wouldn't it just be easier to create a new column in the table called 'date' or something and use date() to set it? I use it and it works without fault.

[Pikachu2000]

Dates should be stored in the database's native format, which for MySQL is YYYY-MM-DD HH:MM:SS. Doing so allows you to make use of the many date/time functions built in to MySQL.

[melloorr]

So how would I go about setting it in my script? Or is there a tool in phpMyAdmin?

[melloorr]

Never mind, I have done it, I think. Would this do?

 

                    $dateTime = new DateTime("now", new DateTimeZone('GMT'));
                    $date =  $dateTime->format("Y-m-d H:i:s");

[Pikachu2000]

Do you mean to insert it into the database?

 

INSERT INTO table ( datetime_field ) VALUES ( NOW() )

[kleb]

i hv done that already and its not working

[kleb]

hi Mellor God bless you a million times..it worked..wow am so happy now it shows the date instead of the 000.00.00.00 it showed before..but the date is not correct

[kleb]

:D :D :D :D :D i thank you all for all your concern May the good lord richly bless you all.

thanks

[melloorr]

hi Mellor God bless you a million times..it worked..wow am so happy now it shows the date instead of the 000.00.00.00 it showed before..but the date is not correct

 

No problem. Is it because I set it to GMT? It is correct for me, but you could change it to what is right for you

[kleb]

pls how will i change it to west african time

[melloorr]

pls how will i change it to west african time

 

('GMT+1')