Categories

Thursday, October 3, 2024
#919814419350 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

therichpost
the authortherichpost
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 14, Angular 15, Angular 16, Angular 17, 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.