PHP to MySQL date entry

[robinstott]

I am really struggling with something that should be simple.

I have a form which asks for a date entry. This date entry is assigned to variable and then formatted suitable for MySQL entry.

But the resulting date in MySQL is incorrect.
I have even tried assigning directly.

e.g.
$date = '2001-04-18'

$db_connect->query("INSERT INTO $sql_usertable (date) VALUES ('$date')");

The result from MySQL is 2018-04-20.

If I perform the following:-
$db_connect->query("INSERT INTO $sql_usertable (date) VALUES ('2001-04-18')");

It works fine.

Any suggestions would be helpful!
Thanks in advance
Robin.

[jc94062]

$date = '2001-04-18'
Should give a parse error...

$date = '2001-04-18';
or
$date = "2001-04-18";

is the correct way to define a variable.

Also, if your trying to put in the date, try this code, it'll assign the date from your host to the variable $date.

$month = date ("F");
$daynumber = date ("d");
$daysuffix = date ("S");
$year = date ("Y");
$date = ("$daynumber$daysuffix $month $year");

Gives it in the format 18th April 2001 (for today) Theres many other formats available, just look up date at www.php.net.