[RESOLVED] Can't figure out date problem...

[emeraldcat]

Ok... I've stared at this for too long.

No matter what I've tried, my dates are entered into my database as 14 zeros. :eek: The field is a timestamp field, so I don't think that's what's wrong...

I've tried:

$today=getdate();

I've tried inserting the variable $today with and without single quotes around it.

I tried using mktime() with getdate():

function process_form(){
session_start();
$loginname=trim(strip_tags($_POST['username']));
$pswd=trim(strip_tags($_POST['password']));
$pass=md5($pswd);
$profile=trim(strip_tags($_POST['profile']));
$tstamp = mktime(0,0,0,$m,$d,$y);
$tdate = getdate($tstamp);
$_SESSION['username']=$loginname;
global $db;

$db->query('INSERT INTO customers (firstname, lastname, username, pswd, date, type, profile)
			VALUES (?,?,?,?,?,?,?)',
			array($_POST['firstname'],$_POST['lastname'], $_POST['username'], $pass, $tdate, 'empe', $profile));

echo "<br>Thank you! Your data has been entered.\n";
}

But no matter what I try, I just can't seem to get an actual DATE in my database!

Any thoughts? None of the posts I've seen on dates seem to have the answer for me.

Thanks,
eCat

[_theworks]

Umm im no expert but after looking at the manual id say its because

$today = getdate();

put the date intro an array.

try using somthing along the lines of

$today = date("d-m-Y");

hope this helps

[rincewind456]

Or you could use NOW() in your SQL statement which will record the time the field was entered.

[emeraldcat]

Thank you, _theworks. Sometimes I can't make heads or tails of the manual descriptions! That makes sense though.

Question for rincewind456:

I can understand how to use now() in a query to GET info, but how do I use it to INSERT info? Do I need to attach it to a variable first? Like,

$tdate=now();

$db->query('INSERT INTO customers (firstname, lastname, username, pswd, tdate, type, profile)	VALUES (?,?,?,?,?,?,?)',
array($_POST['firstname'],$_POST['lastname'], $_POST['username'], $pass, $tdate, 'empe', $profile));

[rincewind456]

Lose the

$tdate=now();

and change your query string to

$db->query('INSERT INTO customers (firstname, lastname, username, pswd, tdate, type, profile)VALUES (?,?,?,?,?,?,?)',
array($_POST['firstname'],$_POST['lastname'], $_POST['username'], $pass, NOW(), 'empe', $profile));

[emeraldcat]

Ok! Well, I tried now() the way I thought it should work (and the way you had it - in the query itself as NOW()) and it didn't... it said it was an undefined function both ways.

However,

$today = date("d-m-Y"); 

kinda worked! Except it gave me the date 2011-12-20... unless I've been working at this problem for longer than I thought, does that mean my server's date is wrong? 😕

[rincewind456]

If you use NOW() without any quotes it should work at least it does with MySQL 4.0.12,

$today = date("d-m-Y");

should give you 12-12-2005, which isn't what you want for the DB as that stores it as year, month, day, so

$today = date("Y-m-d");

Would be a better choice.

[emeraldcat]

That worked like a charm! Thanks, rincewind456!

And to you as well, _theworks. I learned all kinds of new things in this post.

What a great resource! 😃

Thanks,
eCat