Create PHP timestamp to insert into mysql databse

Question

How do I create this using PHP, for the current timestamp, ready to insert into a mysql database timestamp field:

2015-06-27 12:58:10

I want to insert a created_timestamp field basically...

I don't want to use the database's "on update current timestamp" feature because I want this to be a permanent fixed record.

Have you done any research or put any effort into your question? — Rizier123, Jun 27 '15 at 13:04
@Rizier123 yes but I'm terrible with timestamps and such functions. — Amy Neville, Jun 27 '15 at 13:07
@AmyNeville But I think you know how to use google. So: `PHP date` <- That's it first php.net manual page and you got it all there. — Rizier123, Jun 27 '15 at 13:10
@Rizier123 if I knew I was looking for the date function then yes... — Amy Neville, Jun 27 '15 at 13:22

score 3 · Accepted Answer · answered Jun 27 '15 at 13:03

3

Use PHP's date() function

date("Y-m-d H:i:s")

answered Jun 27 '15 at 13:03

Cohan

1 Answers1