[SOLVED] Register inputs current date/time?

[thefollower]

Is there a command so that when the user registers itll post the exact date/time that it occured?

[chocopi]

Do something like this:

 

$date = date("d-m-Y H:i:sa",time());
echo $date;

[trq]

date().

[thefollower]

right i put:

 

$ip = $_SERVER["REMOTE_ADDR"];

$Gender = $_POST['Gender'];

$Date = $Date("d-m-Y H:i:sa",time());

 

 

ip and gender work but not $Date, have i got the structure correct?

[chocopi]

get rid of the dollar sign

 

$Date = $Date("d-m-Y H:i:sa",time());

 

to

 

$Date = Date("d-m-Y H:i:sa",time());

 

This will echo 20-08-2007 16:28:46pm

[thefollower]

Ok will give it a try now

 

 

my DB says :

 

 

0000-00-00 00:00:00

 

 

do you want me to show you the reg code as to how i input it?

[chocopi]

Please

[thefollower]

//connect and all that nonsense

$Username = mysql_real_escape_string($_POST['Username']);
$Password = mysql_real_escape_string($_POST['Password']);
$Password2 = mysql_real_escape_string($_POST['Password2']);
$Email = mysql_real_escape_string($_POST['EmailRegistration']);
$Country = mysql_real_escape_string($_POST['CountryChoice']);
$ip = $_SERVER["REMOTE_ADDR"];
$Gender = $_POST['Gender'];
$Date = Date("d-m-Y H:i:sa",time());

//check if username etc is valid

 

then i have:

$query = "INSERT INTO `userregistration` (Username,Password,Email,Country,IP,Gender,RegisterDate)
				Values ('$Username', '$Password', '$Email', '$Country', '$ip', '$Gender', '$Date')";
	mysql_query($query) or die(mysql_error());

 

 

 

these are the only 2 parts i have changed the rest of the code is all validation.

Also if that looks ok ^ could it be my actual field?

 

This is what i have in my table for userregistration:

 

Field Name: RegisterDate

Type : TimeStamp

Attributes : On Update Current Time Stamp

Not Null

Default : CURRENT_TIMESTAMP is ticked on.

 

 

thats it.

[chocopi]

oh sorry i gave you the wrong syntax

 

it should be

 

$date = date("Y-m-d H:i:a",time());

 

I think that should work

 

~ Chocopi

[thefollower]

still comes in as :

 

0000-00-00 00:00:00

[chocopi]

$date = date('YmdHia');

 

Sorry I was thinking of something different

 

EDIT ^^^

[thefollower]

damn it still says:

0000-00-00 00:00:00

[chocopi]

have you checked my edit above

[thefollower]

yeh

[chocopi]

well thats the code I use, so I am stumped

[thefollower]

can you show me yours if you dont mind ? i can compare it then

[lemmin]

This should work.

 

date("Y-m-d H:i:s")

[itsmeArry]

use this

 

$Date = date("d-m-Y H:i:s",time());

[thefollower]

0000-00-00 00:00:00

 

 

still shows in my table

[chocopi]

I think the problem has got something to do with your table, seeing as the code you are being given should work. So check you have the right tablename, fieldname etc

[itsmeArry]

use this

$Date = date("Y-m-d H:i:s",time());

[thefollower]

use this

$Date = date("Y-m-d H:i:s",time());

 

 

works ^ thankyou what did you change?

[itsmeArry]

just  changed this

 

d-m-Y

 

to

 

Y-m-d

[chocopi]

oh sorry i gave you the wrong syntax

 

it should be

 

$date = date("Y-m-d H:i:a");

 

I think that should work

 

~ Chocopi

 

Bugger I posted that one earlier, but accidently deleted s instead of a