Query Builder


/.env 
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=test
DB_USERNAME=testuser
DB_PASSWORD=pwd

Connect Database 
use DB;
..

Select All - Loop 
$students = DB::table('students')->get();
echo $students[0]->name;
foreach ($students as $student) {
    echo $student->name;
}

Get Select SQL 
echo DB::table('students')->toSql()
// SELECT * FROM `students`

Select Columns 
$students = DB::table('students')->pluck('name');
foreach ($students as $student) {
    echo $student; 
}
// Executes: SELECT name FROM students

Join 
$users = DB::table('users')
    ->join('contacts', 'users.id', '=', 'contacts.user_id')
    ->join('orders', 'users.id', '=', 'orders.user_id')
    ->select('users.*', 'contacts.phone', 'orders.price')
    ->get();

Where 
$user = DB::table('students')->where('name', 'John')->get();

Like 
$users = DB::table('students')
    ->where('name', 'like', 'T%')
    ->get();
    // WHERE `name` LIKE 'T%atch%'