How to make php variable the current date

Question

When user uploads content it enters php varable $date into value of one of the colums on a table. How would you make the php variable the current date, time is not needed just date.

I tried to do this as a string but it shows "CURDATE();" instead of the actual current date

$date="CURDATE();";

$date=CURDATE(); ... you wrapped the curdate() function in quotes...remove those. as other said $date = date('Y-m-d'); is better. Curdate() is also a mysql function. — Brian, Jun 08 '15 at 17:56
Hello Brian, I tried this method as well and I get Fatal error: Call to undefined function CURDATE() in /home/jeffdbeats2/public_html/soundplum/add.php on line 19 — Jeff, Jun 08 '15 at 17:59
@jeff Welcome, would like to suggest you to google before asking question, Answer is very common! :) — kamal pal, Jun 08 '15 at 18:00
`CURDATE()` mysql function. you can not use it directly in php. — Anant Kumar Singh, Jun 08 '15 at 18:02
It's good that you got answer. but you can vote-up and mark answer that seems more accurate and given you first.thanks. it will help future users to get reference from your problem. thanks again — Anant Kumar Singh, Jun 08 '15 at 18:04
possible duplicate of [Get current date and time in PHP](http://stackoverflow.com/questions/470617/get-current-date-and-time-in-php) — Mogsdad, Jun 08 '15 at 18:07

score 1 · Answer 1 · answered Jun 08 '15 at 17:57

1

$date = date('Y-m-d');

This is documented very well here: http://php.net/manual/en/function.date.php

Please, at least try to find a solution yourself next time, this is a very basic thing and is easily found by google.

answered Jun 08 '15 at 17:57

Janis Vepris

587
3
13

score 0 · Answer 2 · edited Jun 08 '15 at 18:00

0

You can use php date() function. You can use CURDATE() in mysql query.

$date = date("Y-m-d");

edited Jun 08 '15 at 18:00

Anant Kumar Singh

68,309
10
50
94

answered Jun 08 '15 at 17:56

pinkal vansia

9,980
5
47
62

How to make php variable the current date

2 Answers2