How to insert data into Msqli database using current date

Question

How I can enter the data into the database using the current date of Brazil and not the hour of USA?

Code:

     $result_cad_user = "INSERT INTO adms_usuarios (nome, email, usuario, senha, $campo_foto adms_niveis_acesso_id, adms_sits_usuario_id, created  ) VALUES (
    '" . $dados_validos['nome'] . "',
    '" . $dados_validos['email'] . "',
    '" . $dados_validos['usuario'] . "',
    '" . $dados_validos['senha'] . "',
    $valor_foto
    '" . $dados_validos['adms_niveis_acesso_id'] . "',
    '" . $dados_validos['adms_sits_usuario_id'] . "',
    NOW())";

Answer 1

Hi, I enter the creation date in my tables as follows:

.date('Y-m-d').

And when I want to display the date I use:

   $data_formatada = date("d/m/Y", strtotime($data_cadastro));

// Modifies the time zone to be used. Available since PHP 5.1

date_default_timezone_set('UTC');

You can understand better here

Answer 2

What you need to do is update the configuration of Timezone1 of Mysql. This way you can and will have the time according to the country/region you want. Below I show some ways.

Change during connection

Mysqli:

<?php

$conn = new mysqli('localhost', 'user', 'password', 'database');

if ($conn->connect_error) die ("Check error");

$conn->query("SET GLOBAL time_zone = '-03:00';");
/* ou */
$conn->query("SET time_zone = '-03:00';");

PDO:

<?php

$conn = new PDO('mysql:dbname=database;host=localhost', 'user', 'password');

$conn->query("SET GLOBAL time_zone = '-03:00';");
/* ou */
$conn->query("SET time_zone = '-03:00';");

Filing cabinet my.cnf:

In this file, you can use the settings below

default-time-zone='-03:00'

---

In the PHP:

An alternative is to use the PHP to convert dates. There are some options like: timezone and DateTime, for example.

Example with Datetime:

<?php

$date = new DateTime();
$date->setTimezone(new DateTimeZone('America/Sao_Paulo'));

$conn->query("INSERT INTO table (`name`, `date`) VALUES ('Nome', '{$date->format('Y-m-d H:i:s')}') ");

^{Example: https://ideone.com/IicXqf}

Example with date_default_timezone_set:

<?php

date_default_timezone_set('America/Sao_Paulo');

$date = date('Y-m-d H:i:s');
$conn->query("INSERT INTO table (`name`, `date`) VALUES ('Nome', '{$date}') ");

^{Example: https://ideone.com/PTC2Lx}