Laravel 10 in my case no solution I use PDO mysqli
------------------------------------------------------
public function change(Request $request, string $id)
{
try {
$mysqli = DB::connection()->getPdo();
$FirstName = $mysqli->quote($request->input('FirstName'));
$LastName = $mysqli->quote($request->input('LastName'));
$NIC = $mysqli->quote($request->input('NIC'));
$IDCard = $mysqli->quote($request->input('IDCard'));
$FirstNameEn = $mysqli->quote($request->input('FirstNameEn'));
$LastNameEn = $mysqli->quote($request->input('LastNameEn'));
$EntrepriseNameAR = $mysqli->quote($request->input('EntrepriseNameAR'));
$EntrepriseNameEN = $mysqli->quote($request->input('EntrepriseNameEN'));
$IDEntreprise = $mysqli->quote($request->input('IDEntreprise'));
$DateStart = $mysqli->quote($request->input('DateStart'));
$DateEnd = $mysqli->quote($request->input('DateEnd'));
$Activity = $mysqli->quote($request->input('Activity'));
$Category = $mysqli->quote($request->input('Category'));
$query = "UPDATE drivercard
SET
FirstName = $FirstName,
LastName = $LastName,
FirstNameEn = $FirstNameEn,
LastNameEn = $LastNameEn,
EntrepriseNameAR= $EntrepriseNameAR,
EntrepriseNameEN= $EntrepriseNameEN,
NIC = $NIC,
IDCard = $IDCard,
IDEntreprise = $IDEntreprise,
DateStart = $DateStart,
DateEnd = $DateEnd,
Activity = $Activity,
Category = $Category
WHERE Id =$id";
$result = $mysqli->exec($query);
if ($result !== false) {
return response()->json(['StatusCode' => '1000'], 200);
} else {
return response()->json(['message' => 'Error updating record']);
}
$mysqli = null;
} catch (\Exception $e) {
\Illuminate\Support\Facades\Log::error($e->getMessage());
return response()->json(['error' => 'Internal Server Error'], 500);
}
}