by
Seifu
(Senior Supporter)
in Code
asked
Nov 22, 2021
This is my code, it's running fine on the local server i.e., clock_out time is updated in the DB but while running this code on an online server, clock_out shows 00:00:00. <?php session_start(); $name = $_SESSION['name']; $clocked_in = $_SESSION['clock_in']; date_default_timezone_set('Asia/Kolkata'); $clock_out = date("h:i:sa"); $duration = $_POST['duration']; $con = mysqli_connect("localhost", "abc", "password", "signup"); $query = "update clock set clock_out = '$clock_out', duration = '$duration' where name = '$name' AND clock_in = '$clocked_in'"; mysqli_query($con, $query); mysqli_close($con); ?>