How can I only display values that has the same column value laravel 5

Question

I have a jobs table

focus on the schoolname column, what I want is that, I can only display all the values with the same column name, for example, I only want to display all the jobs that are related to [email protected].

[email protected] is also the value for Auth::user()->name,

I have a blade in which it displays all the jobs, controller:

public function index()
{
    $jobs = job::all();
    return view('home',compact('jobs'));
}

blade:

<div class='col-lg-8 col-lg-offset-2'>
    <center><h1>Jobs</h1></center>
<ul class="list-group">
    @foreach ($jobs as $job)
  <li class="list-group-item d-flex justify-content-between align-items-center">
    <a href="{{'/home/'.$job->id}}">
    <b>{{$job->jobposition}}</b></a>
    <span class="pull-right">{{$job->created_at->diffForHumans()}}</span>
    <p>{{$job->jobdesc}}</p>

</li>
  @endforeach
</ul>
</div>

I want to display all the jobs that are created by the same person Auth::user()->name

I am new to this and I know this is an easy thing, so please forgive me and thank you for answering

use where() condition

Devsi Odedra
– Devsi Odedra

2018-05-14 12:26:11 +00:00
Commented May 14, 2018 at 12:26 — Devsi Odedra
– Devsi Odedra, Commented May 14, 2018 at 12:26

Luis felipe De jesus Munoz · Accepted Answer · 2018-05-14 12:25:56Z

2

$jobs = job::where('schoolname', Auth::user()->name)->all();

answered May 14, 2018 at 12:25

Luis felipe De jesus Munoz

8,0133 gold badges38 silver badges54 bronze badges

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

Collectives™ on Stack Overflow

How can I only display values that has the same column value laravel 5

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