how to not display duplicated data?

Question

i want to show the categorie list without showing duplicated ones

my controller code :

public function showActualite(){

    $actualites=DB::table('actualites')->distinct('categorie')->orderBy('created_at', 'DESC')->paginate(6);
    return view ('AllActualite',['actualites' => $actualites]);
}

My view :

@foreach ($actualites as $act)

      <span style="text-transform: capitalize;" > <a href="/actualites/{{$act->categorie}}"> {{$act->categorie}} </a></span>

     <span style="text-transform: capitalize;">  </span>
    @endforeach
    </div>
    <div class="row">

        @foreach($actualites as $act)
      <div class="col-lg-6">
        <div class="box wow fadeInLeft">
          <div class="icon"><i class="fa fa-newspaper-o"></i></div>
          <h4 class="title"><a href="/actualites/consulter/{{$act->id}}">{{$act->categorie}}</a></h4>
          <p class="description">{{$act->titre}}</p>


        </div>
      </div>

      @endforeach

you will need to describe your tables and how they are connected to actualites and what type is the field categorie. — mrhn, May 26 '19 at 09:44

score 1 · Answer 1 · answered May 26 '19 at 11:25

I believe your code should work, but in general i would not use DB logic. A more Laravel version of this would be. Latest is a syntax sugar for the same order by logic. See of this solves the problem.

$actualites = Actualites::query()->distinct('categorie')->latest()->paginate(6);

score 0 · Answer 2 · answered May 26 '19 at 12:32

0

All your answer can be found in this post

$actualites= Actuality::distinct()->get(['categorie']);

Eloquent is used.

answered May 26 '19 at 12:32

TeachMe

535
1
5
16

how to not display duplicated data?

2 Answers2