[RESOLVED] How to send "type" "date"?

Jazzy_Girl

Hello,

Here's how my query looks just adding one field only to the database. How to add the current date to the type "date" field in the database, to this, so the current date is sent along with this as well?

I already have the database type field set up as "date."
Just don't know how to send the current date to it with an insert query or something.

$somefieldaddingalready = $_POST['somefield'] ;  

$sql="INSERT INTO tablename (somefield)
VALUES ('" . $_POST['somefield'] . "')";

Please let me know, thanks very much.

tomhath

MySql has a built-in function that returns the current date. I can't test this but it should be close:

$sql="INSERT INTO tablename (somefield, datefield)
VALUES ('" . $_POST['somefield'] . "', NOW() )";

Jazzy_Girl

Thanks Now() pointed me to this CURDATE( ).

So I tried this after several google searches but I know its wrong. The google searches were all over the place and nothing consistent. But I found this great link, but nothing on how to insert properly. http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html How is the current date sent to the database? Thanks.

$_POST['date']='CURDATE( )';
$somefieldaddingalready = $_POST['somefield'] ;   

$sql="INSERT INTO tablename (date,somefield) 
VALUES ('" . $_POST['somefield']. "', '" . $_POST['date'] ."')";

What this did was send all these words and paranthesis CURDATE() to the field "somefield" but it didn't send the actual date.

I also tried this but it didn't work.

$somefieldaddingalready = $_POST['somefield'] ;   

$sql="INSERT INTO tablename (somefield, date(CURDATE( )) 
VALUES ('" . $_POST['somefield']. "', '" . $_POST['date'] ."')";

bradgrafelman

If the "date" column is supposed to hold the current date, the query would be...

$sql="INSERT INTO tablename (somefield, date) 
VALUES ('" . $_POST['somefield'] . "', CURDATE())";

Also, don't forget to sanitize user supplied data (ex. with [man]mysql_real_escape_string/man) before using it in a query, else you're leaving yourself vulnerable to SQL injection attacks.

Jazzy_Girl

Gosh, thought I tried that, must have been slightly off. But you both did it!!! Thanks soooooooooooooo much~!

bradgrafelman

Don't forget to mark this thread resolved.