Inserting date

[kiwisi]

as a total noob - I'm having trouble inserting dates using php and myswl.

 

Basically, I want to have the current date and time auto inserted when a new record is added to my table.

 

I've formatted the date field (articledate) to TIMESTAMP (or should it be datetime...)

 

The following code is retrieved from another table so am just wondering how to alter the insert for the date...

$query = "insert into gadgets

set

articletitle = '".$mysqli->real_escape_string($_POST['articletitle'])."',

articledescription = '".$mysqli->real_escape_string($_POST['articledescription'])."',

articledate = '".$mysqli->real_escape_string($_POST['articledate'])."',

myimages  = '".$mysqli->real_escape_string($_POST['myimages'])."'";

Clear as mud?

 

 

[Barand]

TIMESTAMP will automatically record the date added. Did you specify the default?

$sql =  "CREATE TABLE date_sample (
    id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    date_added TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    name VARCHAR(25)
)";

#$db->query($sql);

$sql = "INSERT INTO date_sample (name) VALUES
('Peter'),('Paul'),('Mary')";

$db->query($sql);

mysql> SELECT * FROM date_sample;
+----+---------------------+-------+
| id | date_added          | name  |
+----+---------------------+-------+
|  1 | 2014-01-16 20:57:22 | Peter |
|  2 | 2014-01-16 20:57:22 | Paul  |
|  3 | 2014-01-16 20:57:22 | Mary  |
+----+---------------------+-------+

If you want to record the datetime of updates also, use

DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

[kiwisi]

Beauty - thanks mate. Thats cleared it up.