This is a bit of my access19BE1inc.php It adds 1 to attendance on login. There is a TIMESTAMP. I want the time to be my time here in China. At the moment, I get a time 15 hours behind my time here.
// attendance will not increase with multiple logins. Before next week, reset has_been_incremented to zero $sql = 'UPDATE 19BEattendance SET attendance = attendance + 1, has_been_incremented = has_been_incremented + 1, time = LOCALTIME() WHERE number = ' . $_POST['password'] . ' AND has_been_incremented != 1 ;'; $pdo->exec($sql);
I tried putting these (not both at once) just after SET and just before attendance = in the above code:
time_zone = +15:00, and time_zone = ‘+15:00’,
but I just get a php failure.
What should I be putting? How to make my timestamp Beijing time?