Laravel bulk update with bindings
I want to make a bulk update to my users table. I am not updating multiple rows to the same field value - each field value could be different as it will be supplied from user input. I want to…
SUM of a column using WHERE clause in Laravel 9
I am trying to use multiple Count and Sum commands in a single query. However what is happening is when i use the following: SUM(amount AND type = "dispute") as charge It actually counts the amount of records and does…
How to use the "withCount" method in Laravel to count related models?
I'm working on a Laravel project and I have two models: "Post" and "Comment". Each post can have multiple comments. I'm trying to use the "withCount" method in Laravel to get the number of comments for each post. Here's what…
Laravel FormRequest Before Validation
I was looking for a way to validate some logic before the formRequest validation but i couldn't find anything. Does it have some similar hook like after() within the withValidator method or maybe the constructor? MyController: class MyController extends Controller…
Laravel/Eloquent – how to find models where a related model with certain values doesn't exist?
In Laravel, I have a model called FeatureRequest that can be voted on, thus creating a FeatureVote in a separate database table. A single FeatureRequest can have many FeatureVotes. I want to execute a query that: Excludes users' own feature…
How to lnstall vinkla/hashids to Laravel 9 project – Php versions
I ran composer require vinkla/hashids but got the following error. Your requirements could not be resolved to an installable set of packages. - symfony/console v6.2.3 requires php >=8.1 -> your php version (8.0.25) does not satisfy that requirement. - spatie/laravel-ignition…
how to give the src to image tag in jquery success function in loop?
This is my success function of jQuery. Everything is fine but I don't know how to give url to the image tag. I am doing it like this but it is not showing image. success: function (data) { if (data.data.length…
Laravel controller exception handling
I have implemented the method below inside a Laravel controller. function update(Request $req) { try { $resp = new stdClass(); $resp->b->a = 1; } catch ( Exception $ex) { return response('An error has occured.' . $ex->getMessage(), 400); } } The…
Php – Why am I getting error CSRF Token mismatch only on my first load after login in my Laravel 8 application?
I've got a form that has some fields that their values are loaded in by an ajax call to a controller after the first input is filled. I have added the token as an input to my form with "@csrf"…
Conditional currency decimals formatting with NumberFormatter – Laravel
Is there a way to format currency conditionally depending on number of decimals? For example : CHF 1'200.00 becomes CHF 1'200.- CHF 1'200.2 becomes CHF 1'200.20 CHF 1'200.20 becomes CHF 1'200.20 MIN_FRACTION_DIGITS attribute will set it all to .00, which…