Skip to main content

get all unique row with having one column which is not primary key distinct

get all unique row with having one column which is not primary key distinct in laravel:

      $datas= Modelname::select()->groupBy('field_name')->get();
now,
you will get the error something like non aggrigated bla bla.. so for this you need is ..
just go to database.php file inside config folder and

find 'strict' and make it false
'strict' => false,


now you are done ... you will get the required datas correctly



Comments

Popular posts from this blog

Convert Html PAge to PDF using Canvas

Link :https://www.quora.com/How-we-export-html-page-as-pdf-using-pure-javascript app.js ( function (){ var form = $ ( '. printme ' ), cache_width = form . width (), a4 =[ 595.28 , 841.89 ]; // for a4 size paper width and height $ ( '#create_pdf' ). on ( 'click' , function (){ $ ( 'body' ). scrollTop ( 0 ); createPDF (); }); //create pdf function createPDF (){ getCanvas (). then ( function (canvas){ var img = canvas. toDataURL ( "image/png" ), doc = new jsPDF ({ unit : 'px' , format : 'a4' }); doc . addImage ( img , 'JPEG' , 20 , 20 ); doc . save ( 'FinalPrint.pdf' ); form . width ( cache_width ); }); } // create canvas object function getCanvas (){ form . width (( a4 [ 0 ]* 1.33333 ) ...

key press function to perform system function

document.onkeyup = function(e) {   if (e.which == 77) {     alert("M key was pressed");   } else if (e.ctrlKey && e.which == 66) {     alert("Ctrl + B shortcut combination was pressed");   } else if (e.ctrlKey && e.altKey && e.which == 89) {     alert("Ctrl + Alt + Y shortcut combination was pressed");   } else if (e.ctrlKey && e.altKey && e.shiftKey && e.which == 85) {     alert("Ctrl + Alt + Shift + U shortcut combination was pressed");   } }; < script > $ ( document ). ready ( function () { $ ( '[data-toggle="tooltip"]' ). tooltip (); $ ( document ). keyup ( function ( e ) { var name = e . key ; // console.log(e.which); // if(e.shiftKey && e.which == 80) // { // } // alert(name); switch ( e . key ){ ...

Installing Admin LTE in Laravel

step 1:  Reference---  https://hdtuto.com/article/laravel-56-adminlte-bootstrap-theme-installation-example Step 2 : after completion first reference view this link:    https://github.com/JeroenNoten/Laravel-AdminLTE step 3:  For more additional information view this link:   https://github.com/jeroennoten/Laravel-AdminLTE#2-updating Now you are done statically : https://adminlte.io/blog/integrate-adminlte-with-laravel Steps: 1:  composer require jeroennoten/laravel-adminlte 2: 'providers' => [ .... JeroenNoten\LaravelAdminLte\ServiceProvider::class, ], 3: php artisan vendor:publish --provider="JeroenNoten\LaravelAdminLte\ServiceProvider" --tag=assets 5: php artisan vendor:publish --provider="JeroenNoten\LaravelAdminLte\ServiceProvider" --tag=config 6: php artisan vendor:publish --provider="JeroenNoten\LaravelAdminLte\ServiceProvider" --tag=views 7: for admin pannel php artisan ...