How To Fix GroupBy Not Working In Laravel

Recently we are working with laravel application and in my one of the system laravel groupBy not working and it show following error. we are search lots of in google and finaly we are find best solution how to fix it very easy way. Error Message Look Like [ADDCODE] Error message!! #1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'opaper.notifications.id' which is not functionally dependent on columns in GROUP BY clause; this i.....

Continue reading By : Laravelcode September 1, 2017 Category 254 views

Laravel 5.4 - Get comma separated values in sql

Some time you get recird from comma separated values in sql. for example you craete one users module and this user know multiple language like english, france, hindi, italian etc..., so, some time to get only that type records whcih user know english. So we have hew one language table like that language table +----+---------+ | id | name | +----+---------+ | 1 | english | +----+---------+ | 2 | hindi | +----+---------+ And we have one another table in th.....

Continue reading By : Laravelcode June 26, 2017 Category 450 views