Laravel Snippets

Some Laravel Snippets.

simple mail test

run php artisan tinker

Mail::raw('Hello World!', function($msg) {$msg->to('[email protected]')->subject('Test Email'); });

find duplicate records

DB::table('users')
  ->select('id', 'email', DB::raw('COUNT(email)'))
  ->whereNull('deleted_at')
  ->havingRaw('COUNT(email) > 1')
  ->groupBy('email')
  ->get()
  ->toArray();