Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '`staff_id` = ? limit 1' at line 1

I am trying to store historical data from front-end(flutter) through the API. Below are the laravel controller. However, when I ran it on postman, an error comes out Column not found: 1054 Unknown column 'images' in 'field list' . I think it is retrieving the whole column of users. From the column, I only what staff_id, date_checkIn, time_checkIn, and location_checkIn. How do I fix this ?

I tried User::where('staff_id', 'date_checkIn', 'time_checkIn', 'location_checkIn')->first()->toArray(); . but then it says Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'staff_id = ? limit 1' at line 1 (SQL: select * from users where location_checkIn staff_id = date_checkIn limit 1) in file .....

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);

}