eloquent select code example

Example 1: laravel eloquent get only field name

//Eloquent: Get specific columns (not all the row). Pluck returns an array.
Model::where('id', 1)->pluck('name', 'surname');
// If you only want to get the result value:
Model::where('id', 1)->value('name');

Example 2: laravel model particular column

Table::select('column1', 'column2')
            ->where('checker', 'value')
            ->get();

Example 3: laravel sql query

use Illuminate\Support\Facades\DB;

$users = DB::select('select * from users');

foreach ($users as $user) {
    echo $user->name;
}

Example 4: join in laravel eloquent

$customer = DB::table('customers')
                ->join('shops', 'customers.shop_id', '=', 'shops.shop_id')
                ->where('customer_contact', $contact_no)
                ->get();

Example 5: eloquent get only some columns

Table::select('name','surname')->where('id', 1)->get();

Example 6: laravel db::query update

DB::table('user')->where('email', $userEmail)->update(array('member_type' => $plan));