Categories

Tuesday, December 7, 2021
therichposts@gmail.com
LaravelPDO

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 therichpost.com. 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);
$QUERY->execute();
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. Therichpost.com

Ajay Malhotra
the authorAjay Malhotra
Hello to all. Welcome to therichpost.com. Myself Ajay Malhotra and I am freelance full stack developer. I love coding. I know WordPress, Core php, Angularjs, Angular 2, Angular 6, Angular 7, Angular 8, Angular 9, Angular 10, Angular 11, Angular12, Angular 13, 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.