How To Set Header In maatwebsite/excel Export In Laravel

Today, we are share with you how to set header in excelsheet when you are export excel in laravel. mostlly all developer use maatwebsite/excel package in laravel application for excel import/export. so, we are here use this package for demo tutorial. [ADDCODE] Set header in excel during export data from database by dynamic way is this most common task in most of laravel application. but many new laravel developer did't know proper how to set header in excel. so, simply follow this step.....

Continue reading By : Laravelcode January 16, 2018 Category 15384 views

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 6294 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 4578 views