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
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’
]);
}
}