Uncaught Error: Call to undefined function NOW()

Mohd Sina

What I did in my code was this:

$date = NOW();

So I want date variable to store the current data and timing.

But when I run the program, I get this error message:

Uncaught Error: Call to undefined function NOW()

So why is that?

Mickaël Leger

Use $date = date();, NOW() is for MySQL.

Read the documentation for more information about date().

Here is an example (from this documentation) :

$today = date("F j, Y, g:i a");                   // March 10, 2001, 5:16 pm
$today = date("m.d.y");                           // 03.10.01
$today = date("j, n, Y");                         // 10, 3, 2001
$today = date("Ymd");                             // 20010310
$today = date('h-i-s, j-m-y, it is w Day');       // 05-16-18, 10-03-01, 1631 1618 6 Satpm01
$today = date('\i\t \i\s \t\h\e jS \d\a\y.');     // It is the 10th day (10ème jour du mois).
$today = date("D M j G:i:s T Y");                 // Sat Mar 10 17:16:18 MST 2001
$today = date('H:m:s \m \e\s\t\ \l\e\ \m\o\i\s'); // 17:03:18 m est le mois
$today = date("H:i:s");                           // 17:16:18
$today = date("Y-m-d H:i:s");                     // 2001-03-10 17:16:18 (le format DATETIME de MySQL)

To get the current date in datetime format, you can do :

$date = new Datetime();

Read the documentation for more information about datetime.

If you are in MySQL, you can use NOW() like this for example :

$sql = "INSERT INTO mytable (current_date) VALUE (NOW())";

And again, here is the documentation if you want to know more about NOW().

Hope it helps !

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

Uncaught Error: Call to undefined function

Uncaught Error: Call to undefined function bindValue() in

Uncaught Error: Call to undefined function each()

Fatal error: Uncaught Error: Call to undefined function mysql_connect()

Fatal error: Uncaught Error: Call to undefined function - have to use $this

Fatal error: Uncaught Error: Call to undefined function bcadd()

Fatal error: Uncaught Error: Call to undefined function get_option()

Fatal error: Uncaught Error: Call to undefined function mysql_close()

Fatal error: Uncaught Error: Call to undefined function mysqli_connect()

curl_init() error Uncaught Error: Call to undefined function

Fatal error: Uncaught Error: Call to undefined function header() - Beginner question

Fatal error: Uncaught Error: Call to undefined function get_header()

PHP 7.4.1 Uncaught Error: Call to undefined function mysqli_connect()

Uncaught Error: Call to undefined function mysql_select_db()

Uncaught Error: Call to undefined function stats_cdf_t()

Uncaught Error: Call to undefined function mysql_connect() - WordPress Setup

Uncaught Error: Call to undefined function GuzzleHttp\default_user_agent()

Uncaught Error: Call to undefined function get_file_html()

Uncaught Error: Call to undefined function mysql_connect()

Uncaught Error: Call to undefined function mysql_escape_string()

Uncaught Error: Call to undefined function mysqli_result() does not work

Uncaught Error: Call to undefined function getUserInformation() - PHP MySQLi

Uncaught Error: Call to undefined function sqlsrv_connect()

Uncaught Error: Call to undefined function sql_regcase()

Uncaught Error: Call to a member function

Fatal error: Uncaught Error: Call to undefined function redirect() PHP logout session

Fatal error: Uncaught Error: Call to undefined function wp_get_current_user()

Fatal error: Uncaught Error: Call to undefined function curl_version() - Localhost Dev

Fatal error: Uncaught Error: Call to undefined function mb_detect_encoding()