<?php
// Using Query Builder
$name = DB::table('users')->where('id', 1)->value('name');
$name = DB::table('users')->select('name')->value('name');
$name = DB::table('users')->value('name');
// Using Eloquent models
$name = \App\User::where('id', 1)->first()->value('name');
$name = \App\User::first()->value('name');
// Using Raw Query
$name = DB::select('select name from users limit 1')[0]->name;
$name = DB::select('select * from users limit 1')[0]->name;
$name = DB::select('select * from users order by id desc')[0]->name;
?>
Related Snippets