问语法错误或访问冲突: 1064您的SQL语法中有错误；检查与您的MariaDB服务器版本对应的手册。

EN

public function userClockIn(Request $r) { 
$result = []; 
$result['status'] = false; 
$result['message'] = "something error";

$users = User::where('staff_id', $r->staff_id)->first();

// retrieve current data
$currentData = $users->toArray();

// store current data in historical data table
$historicalData = new HistoricalData();
$historicalData->fill($currentData);
$historicalData->save();

$mytime = Carbon::now();
$time = $mytime->format('H:i:s');
$date = $mytime->format('Y-m-d');

$users->date_checkIn = $date;
$users->time_checkIn = $time;
$users->location_checkIn = $r->location_checkIn;

$users->save();

$result['data'] = $users;
$result['status'] = true;
$result['message'] = "suksess add data";

return response()->json($result);
}