How do I change the time zone on the server and in the Database?

Website Building
#1

Good afternoon! I was able to change the date on my site using the string “date_default_timezone_set (‘Europe / Moscow’);” Now the site shows the correct time, but when I register the user, the database shows another time zone of -4 hours. What should I do to make phpmyadmin create a user from +4 hours?

#2

You cannot change the server date, however you can insert the correct date using PHP :slight_smile:

#3

How? I change time zone with help date_default_timezone_set (‘Europe / Samara’);
But the database leaves its time -4.
Code

<?php 

ULogin(1);
date_default_timezone_set('Europe/Samara');
if ($_POST['enter'] and $_POST['text']) {
$_POST['text'] = FormChars($_POST['text']);
mysqli_query($CONNECT, "INSERT INTO `chat`  VALUES ('', '$_POST[text]', '$_SESSION[USER_LOGIN]', NOW())");
exit(header('location: /chat'));
}

Head('Чат');

?>

#4

Instead of NOW() replace it with

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

So the code would be

<?php 

ULogin(1);
date_default_timezone_set('Europe/Samara');
if ($_POST['enter'] and $_POST['text']) {
$_POST['text'] = FormChars($_POST['text']);
mysqli_query($CONNECT, "INSERT INTO `chat`  VALUES ('', '$_POST[text]', '$_SESSION[USER_LOGIN]', ".date("Y-m-d G:i:s").")");
exit(header('location: /chat'));
}

Head('Чат');
#6

This code not working. site crash

#7

Any errors shown? :slight_smile:

#8

The entry does not appear in the database

#9

Try this?

<?php 

ULogin(1);
date_default_timezone_set('Europe/Samara');
$date = date("Y-m-d G:i:s");
if ($_POST['enter'] and $_POST['text']) {
$_POST['text'] = FormChars($_POST['text']);
mysqli_query($CONNECT, "INSERT INTO `chat`  VALUES ('', '$_POST[text]', '$_SESSION[USER_LOGIN]', '$date')");
exit(header('location: /chat'));
}

Head('Чат');
1 Like
#10

Yes! This working! Thanks!

1 Like
#11

My pleasure to help :blush:
If you have any other issues, do not hesitate to open a new topic :slight_smile:

#12