Answers for "select from multiple tables eloquent"

PHP
2

join multiple tables in laravel eloquent

$users = User::join('posts', 'posts.user_id', '=', 'users.id')
            ->where('users.status', 'active')
            ->where('posts.status','active')
            ->get(['users.*', 'posts.descrption']);
Posted by: Guest on September-16-2021
0

can we use 2 select in a query laravel

$myTable = MyTable->select('firstField');

if ($somethingTrue) {
    $myTable->addSelect('secondField');
}

if ($somethingElseTrue) {
    $myTable->addSelect('thirdField');
}

$myTable->get();
Posted by: Guest on December-11-2021

Code answers related to "select from multiple tables eloquent"

Browse Popular Code Answers by Language