SQL-PHP datetime

Question

I'm integrating an RSS feed unto my website and i need to create a table:

CREATE TABLE `stories` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `when` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
)

i know how to insert id, title, description but i do not know how to insert the time of the post (user submits them). I used the script given here.

mysql_query("insert into stories (title,description) VALUES ('$_POST[title]','$_POST[description]') ");

Your current script is vulernable to SQL Injection php.net/manual/en/security.database.sql-injection.php — Shad
– Shad, Commented Oct 30, 2011 at 1:44

davidethell · Accepted Answer · 2011-10-30 01:41:29Z

4

For when use the date function:

date('Y-m-d h:i:s')

By default the date function uses the current date/time if you don't supply one as the second argument.

answered Oct 30, 2011 at 1:41

davidethell

12.1k6 gold badges47 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL-PHP datetime

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related