No database entries when iterate array from database Laravel

General Tech Bugs & Fixes 2 years ago

1 2 0 0 0 tuteeHUB earn credit +10 pts

5 Star Rating 1 Rating

Posted on 31 Aug 2022, this text provides information on Bugs & Fixes related to General Tech. Please note that while accuracy is prioritized, the data presented might not be entirely correct or up-to-date. This information is offered for general knowledge and informational purposes only, and should not be considered as a substitute for professional advice.

Take Quiz To Earn Credits!

Turn Your Knowledge into Earnings.

tuteehub_quiz

Answers (2)

Post Answer
profilepic.png
manpreet Tuteehub forum best answer Best Answer 2 years ago
protected function show()
{
    $users = User::all();
    $letters = Letter::with('user');
     $userLetter = $letters->where(['user_id' => 2])->count();
     //Here function work right. Shows that we have 10 users
    foreach ($users as $user) {
        $userLetter = $letters->where(['user_id' => $user->id])->first();
        if($userLetter){
            //Here it shows that only the first user exists, returns null for the rest users.
        }
    }
}

We get an error when we sort the array with foreach. No record is found in the database except the first. For other entries, return null. outside foreach no errors.

1 views
0 shares

profilepic.png
manpreet 2 years ago

Just move your object inside the loop like below.

    protected function show()
    {
        $users = User::all();
         $userLetter = $letters->where(['user_id' => 2])->count();
         //Here function work right. Shows that we have 10 users
        foreach ($users as $user) {
            $userLetter = Letter::with('user')->where(['user_id' => $user->id])->first();
            if($userLetter){

            }
        }
     }

1 views   0 shares

No matter what stage you're at in your education or career, TuteeHub will help you reach the next level that you're aiming for. Simply,Choose a subject/topic and get started in self-paced practice sessions to improve your knowledge and scores.