<?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;
?>
• | Database: Raw SQL Select Query |
• | Query Builder: Get value of an aggregated field |
• | Database: Insert, Update, Delete |
• | Database: Using PDO |
• | Query Builder: Get max value of a field |
• | Form Tag |