Apache Friends Support Forum

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...

have you set date.timezone in der php.ini correct?

thanks 4 reply...

im beginner of xampp. So, i not sure whether i set it correct or not.......

may i know how do check or set date.timezone in der php.ini ?

for you information, im from Malaysia.......

In your XAMPP Backend is a link to a phpinfo() function.
In this report search for "Default timezone" and "date.timezone"