Laravel Table Issue-CodePudding

I have two tables 1.users 2.screenshots

what i'm doing - I'm fatching data from screenshots table on the basis of userid & the userid is coming from users table

what's the issue - when i'm retrieving unique id of a users table but getting only one user id, but there are 3 users in the database

My Controller Code

    $data = ['LoggedUserInfo'=>Admin::where('id','=', session('LoggedUser'))->first()];
    $da = \DB::table('users');
    $ll = null;
    $ll2 = null;

    foreach ($data as $ll) {
        $ll = $ll->admin_id;
    }
    
    $ff = $da->where('admin_id', '=', $ll)->get();
    foreach ($ff as $llo2) {
        $ll2 = $llo2->uniqueid;
    }
    $sc = \DB::table('screenshots');
    $km = $sc->where('userid','=', $ll2);
    $kk = $km->paginate(15);

The output of $ll2 is 58641475 the first user uniqueid

My screenshots database

Users database

You can also give me suggestions for better logic

CodePudding user response：

That's because you only take the last user :

$ll2 = null;

foreach ($ff as $llo2) {
    $ll2 = $llo2->uniqueid;
}

$ll2 will replace the previous result.

You need to make it an array, if you want screenshots of all users :

$ll2 = [];

foreach ($ff as $llo2) {
    $ll2[] = $llo2->id; // Not uniqueid or?
}

$sc = \DB::table('screenshots');
$km = $sc->whereIn('userid', $ll2);
$kk = $km->paginate(15);