Tuesday, November 29, 2022

Update Query In Laravel With PDO or Sentinel

Laravel 7.2 routing with route group auth guard check with prefix

Update Query In Laravel With PDO or Sentinel


Hello to all, welcome to In this post, I will tell you, Update Query In Laravel With PDO or Sentinel. I am doing with laravel first time in my website. Laravel is one of the top php mvc framework.
PDO is oops based and more securable then mysql and mysqli.

Here are the Update Query In Laravel With PDO or Sentinel and you can add this into your laravel controller files:

update query in laravel:with pdo:

public function update(Request $request)
parse_str($request->formdata, $data);
$QUERY = $this->PDO->prepare(“UPDATE user SET firstname = :firstname,
lastName = :lastName
WHERE objectId = :objectId”);
$QUERY->bindParam(“firstname”, $data[‘firstname’],\PDO::PARAM_STR);
$QUERY->bindParam(“lastName”, $data[‘lastname’],\PDO::PARAM_STR);
$QUERY->bindParam(“objectId”, $data[‘id’],\PDO::PARAM_STR);
return response()->json([
‘message’ => ‘success’


basic laravel with Sentinel:

public function updateUserDetails(Request $request, $id)
$this->validate($request, [
‘first_name’ => ‘required|min:2’,
‘last_name’ => ‘required|min:2’
$user = Sentinel::findById($id);
$updates = [
‘first_name’ => $request->first_name,
‘last_name’ => $request->last_name,
$user = Sentinel::update($user, $updates);
return redirect(‘/super/users’);

There are so many code tricks in laravel and i will let you know all. Please do comment if you any query related to this post. Thank you.

the authortherichpost
Hello to all. Welcome to Myself Ajay Malhotra and I am freelance full stack developer. I love coding. I know WordPress, Core php, Angularjs, Angular 8, Angular 9, Angular 10, Angular 11, Angular12, Angular 13, Angular 14, Angular 15, Bootstrap 5, Nodejs, Laravel, Codeigniter, Shopify, Squarespace, jQuery, Google Map Api, Vuejs, Reactjs, Big commerce etc.

1 Comment

  • easy date time in laravel with carbon
    in blade
    {{ \Carbon\Carbon::now()->toDateTimeString() }}
    in controler
    use Carbon\Carbon;

    public function postClosedDate(Request $request)
    parse_str($request->formdata, $data);

    $closed_date = DB::table(‘closed_dates’)->insert([
    ‘name’ => $data[‘name’]),
    ‘created_at’ => Carbon::now()->toDateTimeString()

    if($closed_date) {
    return response()->json([
    ‘message’ => ‘success’
    } else {
    return response()->json([
    ‘message’ => ‘error’

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.