How to set server time?
Posted: 27. December 2010 12:02
Hi,
this is the php code that i used to insert data to sql database
$Fname = $_POST["Fname"];
$Lname = $_POST["Lname"];
$gender = $_POST["gender"];
$sql="INSERT INTO $tbl_name(firstname, lastname, gender, datetime)VALUES('$Fname', '$Lname','$gender', NOW() )";
when i submit data to database, the datetime data will be auto insert into datetime field. However, the date time is not same with my country time.
eg, data insert into database is (2010-12-25 15:21:36) , but it should be (2010-12-25 23:22:36)
after that, i realized that the datetime value is based on server time
How to change the server time of xampp 1.7.3
Appreciate your help ....thanks...
this is the php code that i used to insert data to sql database
$Fname = $_POST["Fname"];
$Lname = $_POST["Lname"];
$gender = $_POST["gender"];
$sql="INSERT INTO $tbl_name(firstname, lastname, gender, datetime)VALUES('$Fname', '$Lname','$gender', NOW() )";
when i submit data to database, the datetime data will be auto insert into datetime field. However, the date time is not same with my country time.
eg, data insert into database is (2010-12-25 15:21:36) , but it should be (2010-12-25 23:22:36)
after that, i realized that the datetime value is based on server time
How to change the server time of xampp 1.7.3
Appreciate your help ....thanks...