Laravel eloquent count total of participants that belongs to departments of one specific event
My current query can count the number of participants that belongs to each department:
eloquent
How do I wrap Laravel eloquent conditions to create the following query
I have a simple results table that looks like the following –
Laravel Query get row based on 2 dependent column
Help me to query this.
I have a Laravel app where have a table that has 3 columns (quartal, year, value).
Ambiguous field in sql query
i’m getting the following error when trying to filter a query by ID:
update multi rows in laravel by eloquent
Suppose we have one dataBase that have one table called fathers; and another table called children.
Find records which has all ids in pivot table in another table Laravel
In my laravel project I have tables shown as below.
Laravel query data based on a column
I have a table basicinfo with a column dateOfEnrollment of type date. I want to query all the records that are enrolled for more than 4 years. How can I do that ?
Laravel Multiple Joins with Counts (Not Eloquent)
I’m going to convert this Eloquent query to DB query in Laravel.
Insert query works fine on my local but doesn’t execute on my live database (Laravel/MySQL)
I have a very simple function that loops through an array and inserts some data into a results table – this works perfectly fine on my local using the very same code. On my local setup (Mac) using Laravel Valet & an MySQL database it hits the function Result::create($data) and inserts this data in the database. However on the live/remote site it never hits the Result::create() within the insertUniqueMatches for some reason.
trying to search in a table or in its relation in laravel
I need to search for the code in the appointment table OR the patient name which is the appointment’s relation. here is the code I reached so far but it is not working: