I want to retrieve all places where parent_place_id = 999 in the attractions table. What relationships would I set up and what would this query look like? I've tried using the "Has Many Through" relationship, but I'm not sure if…
I have route: Route::resource('posts', PostController::class); Within URL (1): domain.com/posts will show all posts. Within URL (2): domain.com/posts?status=trashed will show all soft deleted posts. How I want to create a beautiful URL which replace the URL (2)? Such as domain.com/posts/status/trashed, or…
enter image description here After transferring our application to the server. The application loaded accordingly. When we tried to login to the app, we received this kind of error. PHP version is 8.2.11 and Laravel 10.29.0. Is there something that…
I'm trying to eliminate duplicates from a table but the query I'm using deletes the entire database and not the duplicates, can you tell me why and what I can do? Thank you very much in advance to the whole…
I'm trying to make a custom table widget in filament for showing best selling products. When I do sum(quantity) as total_quantity, it gives me Column not found error. Here's my entire code and the error message : public function table(Table…
I am working on a laravel project, i am trying to load my datatable, i wanna i have a column used for sending a post request, here is my script: var datatable = $('#table').on('xhr.dt', function(e, settings, json, xhr) { $("#loadingAnimation").hide();…
When I add the following ajax to my laravel blade file the page stops rendering. If ajax part is removed the page renders perfectly fine <input type="text" name="voucher_no" id="voucher_no" class="form-control"> <input type="text" name="year" id="year" value="{{ date('Y') }}"> <button type="button" id="convertFinal"…
I need to add validation for a dynamic array whose elements can be strings or subsequent arrays containing strings, but I can't find a way to save this rule. My current validation: $data = $request->validate([ 'answers' => ['required', 'array'], 'answers.*'…
I am working on Social networking application with at least 0.2M users. On the application user can share anything from third parties as well as user can upload own media as post. There are different types of privacy user privacy…
I am writing a laravel code in which I need a nested loop in the blade. Here is my controller public function show(string $id) { $transaction = Transaction::findOrFail($id); $subject_ids = DB::connection('transfer') ->table('subjects') ->join('transactions_subjects', 'transactions_subjects.subject_id', '=', 'subjects.id') ->where('transactions_subjects.transaction_id', '=', $transaction->id) ->distinct()…