I have made a blogging application in Laravel 8. I am currently working on adding comment replies via jQuery (v3.5.0) AJAX. In comment-form.blade.php I have: <div class="form-wrapper"> <div class="alert-box-ajax alert-box alert-box--success"> Your comment is pending </div> <div class="alert-box-ajax alert-box alert-box--error">…
I am developing dynamic query builder for the admin users and for the same I am implementing POST API request to store all conditions together in database. I am stuck with the validation of POST json. I tried different ways…
I have 2 tables one is category that has subcategories and I want to fetch the records and put in a single array. I have implemented this code: public function searchItem(){ $categories = ServiceCategory::with('subCategories')->get(); $categoryArray = []; foreach ($categories as…
This code displays the respondent infected with the diseases and date ranges from the selected dropdowns, I want to display the household where that respondent belongs to and the purok which the household belongs to. But when I tried to…
I have a query $result = DB::select("SELECT * FROM table_name WHERE id=$id"); I want to get one object, but it returns an array of objects. I added ->first() to my code as follows: $result = DB::select("SELECT * FROM table_name WHERE…
I have a web store application where from the home page you can click an input field, press find and it should show you the list of orders that are there based on the search query. When I press find…
I have a table with these columns: event_time (date) event_data (json) player_account char() I'm trying to get all three fields from my query and groupBy by "player_account" field. The problem is doing this query: DB::connection('aa')-table('bb') ->where('event_time', ">", $date) ->select('event_time', 'event_data',…
Okay so I'm kinda new to laravel and I'm trying to use Spatie for roles and permission but this error happened, even though I've written the class name in kernel.php here : <?php namespace AppHttp; use IlluminateFoundationHttpKernel as HttpKernel; class…
I have a SQL query like this: SELECT year FROM ( SELECT my_custom_function_for_get_year(week_start::date) AS year FROM ( SELECT date_trunc('week', week_start) AS week_start FROM generate_series('2023-01-01'::date, '2023-12-31'::date, interval '1 week') gs(week_start) ) as select1, (SELECT id FROM mytable) as select2 ) as…
I have an app where I am trying to store recipes. Now, a recipe will have several details, and I want to be able to save them all at the same time with the parent recipe. My models have the…