Inserting Current Date Into Database

[iNko]

Got this code:

<label>Current date :</label>
<input name="current_date" type="date"/>


if(isset($_POST['submitted'])){
$error = FALSE;


if (empty($_POST['current_date'])) {
$error [] = 1;
} else {
$current_date= $_POST['current_date'];
}


if (!$error) {
$sqlinsert = "INSERT INTO Date (current_date)
VALUES ('$current_date')";
mysql_query($sqlinsert);
} else {

}
}

 

How do i make it so it automatically isert current date into the database?

[jazzman1]

Show us other fields from the form and explain in clear English what do you want to do with this...

[Pikachu2000]

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_curdate

[iNko]

found an answer

<input name="current_date" type="text" value="<?php echo date("Y-m-d"); ?>" readonly="readonly"/>

writes currnet date to the text field, and when i press submit it writes it to the database..

[PFMaBiSmAd]

Getting the date value through the form means that anyone can change it to anything (the readonly attribute WON'T actually stop anyone), so you must validate it and escape it before putting it into your query statement to prevent sql injection.

 

The value you put into your query should a value that is derived only on the server. See Pika's reply above on how you can do this directly in your query.