MySQL-PHP get and echo NOW() value?

mysqld
default-time-zone='timezone'
SETGLOBAL time_zone =timezone;

<?php
$query = "SELECT NOW() as `now`";
$result = $mysqli->query($query);
$row = $result->fetch_array();
$now = $row['now'];
echo "$now\n";
?>

Reference:
https://dev.mysql.com/doc/refman/8.0/en/time-zone-support.html
https://stackoverflow.com/questions/16094232/mysql-php-get-and-echo-now-value

Article ID: 35
Created On: Mon, Sep 28, 2020 at 1:26 AM
Last Updated On: Mon, Sep 28, 2020 at 1:26 AM
Authored by: Saeed Nobakht [[email protected]]

Online URL: https://www.navel.ir/article/mysql-php-get-and-echo-now-value-35.html