Laravel

php artisan config:cache

$users = DB::table('users')
                 ->select(DB::raw('count(*) as user_count, status'))
                 ->where('status', '<>', 1)
                 ->groupBy('status')
                 ->get();


Model::select(DB::raw('query'))
     ->whereNull('deleted_at')
     ->orderBy('id')
     ->get();

$users = DB::table('users')->whereIn('id', array(1, 2, 3))->get();

Vehicle::find(3)->value('register_number');

->select('users.id AS user_id', 'users.name',
DB::raw('(CASE WHEN users.status = 0 
THEN "active" WHEN users.status = 1 
THEN "not active" 
ELSE "pending" END) AS 
status_user'))
->orderBy('shares.created_at', 'desc') 

// ...
$q->where(function ($query) {
    $query->where('gender', 'Male')
        ->where('age', '>=', 18);
})->orWhere(function($query) {
    $query->where('gender', 'Female')
        ->where('age', '>=', 65);	
})

$orders = DB::table('orders')
                ->select('department', DB::raw('SUM(price) as total_sales'))
                ->groupBy('department')
                ->havingRaw('SUM(price) > ?', [2500])
                ->get();

$query = Payment::query();
foreach ($input as $column => $values) {
    $query->whereIn($column, $values);
}
$zip = $query->first()->VendorZIP;

app('App\Http\Controllers\PrintReportController')->getPrintReport();

use App\Http\Controllers\OtherController;

class TestController extends Controller
{
    public function index()
    {
        //Calling a method that is from the OtherController
        $result = (new OtherController)->method();
    }
}

2) Second way

app('App\Http\Controllers\OtherController')->method();

Both way you can get another controller function.

$myRequest = new Request();
$myRequest->request->add(['foo' => 'bar']);
var_dump($myRequest->foo);

php artisan config:clear

<?php

namespace App\Console\Commands;

use App\Models\User;
use App\Support\DripEmailer;
use Illuminate\Console\Command;

class SendEmails extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'mail:send {user}';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'Send a marketing email to a user';

    /**
     * Create a new command instance.
     *
     * @return void
     */
    public function __construct()
    {
        parent::__construct();
    }

    /**
     * Execute the console command.
     *
     * @param  \App\Support\DripEmailer  $drip
     * @return mixed
     */
    public function handle(DripEmailer $drip)
    {
        $drip->send(User::find($this->argument('user')));
    }
}

# Created by https://www.gitignore.io/api/laravel

### Laravel ###
vendor/
node_modules/
npm-debug.log

# Laravel 4 specific
bootstrap/compiled.php
app/storage/

# Laravel 5 & Lumen specific
public/storage
public/hot
storage/*.key
.env.*.php
.env.php
.env
Homestead.yaml
Homestead.json

# Rocketeer PHP task runner and deployment package. https://github.com/rocketeers/rocketeer
.rocketeer/

$request = new \Illuminate\Http\Request();

$request->replace(['foo' => 'bar']);

dd($request->foo);

User::chunk(100, function ($users) {
  foreach ($users as $user) {
    $some_value = ($user->some_field > 0) ? 1 : 0;
    // might be more logic here
    $user->update(['some_other_field' => $some_value]);
  }
});

$insert_data = collect();

foreach ($json['value'] as $value) {
    $posting_date = Carbon::parse($value['Posting_Date']);

    $posting_date = $posting_date->format('Y-m-d');

    $insert_data->push([
        'item_no'                   => $value['Item_No'],
        'entry_no'                  => $value['Entry_No'], 
        'document_no'               => $value['Document_No'],
        'posting_date'              => $posting_date,
        ....
    ]);
}

foreach ($insert_data->chunk(500) as $chunk)
{
   \DB::table('items_details')->insert($chunk->toArray());
}

$query = DB::table('node');

if ($published == true)
    $query->where('published', '=', 1);

if (isset($year))
    $query->where('year', '>', $year);

$result = $query->get();

User::orderBy('id')->chunk(100, function ($users) {
    foreach ($users as $user) {

        // write your email send code here
    }
});

php artisan make:migration create_users_table --create=users

php artisan make:migration add_votes_to_users_table --table=users

try {
    MFUser::create(array(
        'user_reference' => $this->userReference,
        'first_name' => $this->firstName,
        'last_name' => $this->lastName,
        'user_type_id' => $this->userTypeId,
        'email' => $this->email,
        'password' => $this->password
    ));
} catch (\Illuminate\Database\QueryException $exception) {
    // You can check get the details of the error using `errorInfo`:
    $errorInfo = $exception->errorInfo;

    // Return the response to the client..
}

$user = User::select("users.*","items.id as itemId","jobs.id as jobId")

            ->join("items","items.user_id","=","users.id")

            ->join("jobs",function($join){

                $join->on("jobs.user_id","=","users.id")

                    ->on("jobs.item_id","=","items.id");

            })

            ->get();

print_r($user);

php artisan cache:clear - Flush the application cache

php artisan config:cache - Create a cache file for faster configuration loading. This is for configuration cache. This command will clear the configuration cache before it creates. More details

php artisan config:clear - Remove the configuration cache file

if(count(array_filter($array)) == 0)
{
	// All values are empty
	...
}

if ($user->wasRecentlyCreated) {
    // user just created in the database; it didn't exist before.
} else {
    // user already existed and was pulled from database.
}

URL::to('/');

MAIL_MAILER=smtp
MAIL_HOST=smtp.gmail.com
MAIL_PORT=587
MAIL_USERNAME="username@gmail.com"
MAIL_PASSWORD="password"
MAIL_ENCRYPTION=tls
MAIL_FROM_ADDRESS="username@gmail.com"
MAIL_FROM_NAME="${APP_NAME}"

$id = DB::table('users')->insertGetId([
    'email' => 'john@example.com',
    'votes' => 0
]);

public function scopeWhereLike($query, $column, $value)
{
    return $query->where($column, 'like', '%'.$value.'%');
}

public function scopeOrWhereLike($query, $column, $value)
{
    return $query->orWhere($column, 'like', '%'.$value.'%');
}

// Set cell A1 with a string value
$spreadsheet->getActiveSheet()->setCellValue('A1', 'PhpSpreadsheet');

// Set cell A2 with a numeric value
$spreadsheet->getActiveSheet()->setCellValue('A2', 12345.6789);

// Set cell A3 with a boolean value
$spreadsheet->getActiveSheet()->setCellValue('A3', TRUE);

// Set cell A4 with a formula
$spreadsheet->getActiveSheet()->setCellValue(
    'A4',
    '=IF(A3, CONCATENATE(A1, " ", A2), CONCATENATE(A2, " ", A1))'
);

use Illuminate\Support\Facades\DB;
public function updateChunk(){
DB::table('users')->where('active', false)
    ->chunkById(100, function (＄users) {
        foreach (＄users as ＄user) {
            DB::table('users')
                ->where('id', ＄user->id)
                ->update(['active' => true]);
        }
    });
}

Artisan::call('test:clean');

public function index() {
    $arr = [1,3,5,7,9];
    $collection = collect($arr);
    dd($collection);
}

Route::get('/', function () { 
     $visits = Redis::incr('visits'); 
     return $visits; 
});

// Creating an object
$object = new stdClass();

// Property added to the object
$object->property = 'Property_value';

$q->where( function ( $q2 ) use ( $stext ) {
	$q2->where( 'title', 'ilike', "%$stext%" ) );
	$q2->orWhere('desc', 'ilike', "%$stext%" ) );
});

php artisan db:seed --class=AdminSeeder --force

($gigData->three_packages == 1 ? 'checked' : $gigData->packages_details == null) ? 'checked' : ''

DB::table('users')->orderBy('id')->chunk(100, function (＄users) {
    foreach (＄users as ＄user) {
        //
    }
}); 

$result = DB::unprepared("LOCK TABLE table1 READ, table1 WRITE, table2 READ, table3 READ;"  
    .  $query_multi_stmt 
    .  " UNLOCK TABLES;");

if ($result > 0 ){  //...if rows affected
           //...do something
}