Get Data in "if" condition laravel

Question

So basic I have two tables "Accounts" and "Characters" that are linked by a single ID Each "Account" has 3 "Characters" So I want to display the 3 characters that are linked to the main "Account"

this is my HomeController

    {

       $data = DB::table('characters')
            ->join('accounts', 'accounts.cUid', '=','characters.pUniqueID')->get();
        return view('home', compact('data'));
    }

this is my Home.Blade

@foreach($data as $per)
            @if( $per->pUniqueID == Auth::user()->cUid )
....
....
         @else
       <script>window.location.href = '{{url("/characters")}}'; </script>
   @endif
@endforeach

use a var_dump($data); before your loop @foreach, and post a revelant part of what is displayed, you can use var_dump($per) inside loop to see what you got on each $per — Eric
– Eric, Commented Oct 25, 2019 at 14:49

Jean Marcos · Accepted Answer · 2019-10-25 15:25:22Z

1

Configure the relationships in your model:

Accounts.php

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Accounts extends Model
{
    public function characters()
    {
        return $this->hasMany('App\Characters');
    }
}

So, in your query:

$data = Accounts::with("characters")->get();

return view('home', compact('data'));

And in your template:

@foreach($data as $per)
    @if($per->pUniqueID == Auth::user()->cUid)
        @foreach($per->characters as $character)
            {{$character->id}} //or any other character attribute
        @endforeach
    @else
       <script>window.location.href = '{{url("/characters")}}'; </script>
    @endif
@endforeach

answered Oct 25, 2019 at 15:25

Jean Marcos

1,1771 gold badge12 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Get Data in "if" condition laravel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related