Answers for "query builder select laravel"

PHP
2

laravel query builder select

use IlluminateSupportFacadesDB;

$users = DB::table('users')
            ->select('name', 'email as user_email')
            ->get();
Posted by: Guest on August-14-2021
0

Laravel query builder toSql

$query = DB::table('table')->whereIn('some_field', [1,2,30]);

$sql = $query->toSql();

$bindings = $query->getBindings();
Posted by: Guest on May-16-2021
2

query builder laravel

use IlluminateDatabaseEloquentBuilder;

public function scopeFakePersons(Builder $query): Builder
{
  return $query->where('is_fake', 1);
}
Posted by: Guest on January-20-2021
0

laravel query when

$role = $request->input('role');

$users = DB::table('users')
                ->when($role, function ($query, $role) {
                    return $query->where('role_id', $role);
                })
                ->get();
Posted by: Guest on September-14-2020

Code answers related to "query builder select laravel"

Browse Popular Code Answers by Language