7-Views - Developers Blog

Disable ONLY_FULL_GROUP_BY

Posted by
October 11, 2022

If you want to disable this from Ubuntu 18+ please follow following details. Go To Command Prompt cd /etc/mysql/conf.d sudo nano disable_strict_mode.cnf and add following Snippet [mysqld] sql_mode=STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION save and then restart and mysql. it will work.  

read more

How to install PhpStorm On Ubuntu

Posted by
March 23, 2022

Installation: I tried to install PhpStorm in ubuntu using the snap, but the issue with this is its using older version. here is the another way to install PhpStorm latest version in ubuntu using simple steps. Download the stable release from here. It will download the file inside the “Downloads” Directory. Step1: Go to Download […]

read more

How To Debug Queries In Laravel

Posted by
January 31, 2021

We can do this by #1 Simple Query Debugging $results = User::where(function($q) use ($request) { $q->orWhere(‘name’, ‘like’, ‘%7-Views%’); $q->orWhere(’email’, ‘=’, ‘info@7-views.com’); })->toSql(); The above method does not include query bindings. #2 Listening For Query Events \DB::listen(function($sql, $bindings, $time) { dump($sql); dump($bindings); dump($time); }); This method returns queries with timings and bindings.        

read more