I have an SQL query that allows to organize 6 items in descending order based on their creation date, I want to display these items two by two in a carousel, but i don't know how.. Is there a way to make it?
class HomeController extends Controller
{
public function index()
{
$projets = Projet::orderBy('created_at', 'desc')->take(6)->get();
return View('home')->with('projets', $projets);
}
}
My Carousel Code
<section class="projects pt-5">
<div class="container">
<div class="row justify-content-center">
<div class="col-lg-7 text-center">
<div class="section-header">
<h2 class="section-title" style="text-transform: capitalize;">Projets récents</h2>
<span class="title-border"></span>
</div>
</div>
</div>
<div class="row justify-content-center pb-4">
<div id="myCarousel" class="carousel slide" data-ride="carousel" data-interval="2000">
<ol class="carousel-indicators">
<li data-target="#myCarousel" data-slide-to="0" class="active"></li>
<li data-target="#myCarousel" data-slide-to="1"></li>
<li data-target="#myCarousel" data-slide-to="2"></li>
</ol>
<div class="carousel-inner">
<div class="carousel-item active">
<div class="row">
@for ($i = 0; $i < 2; $i++)
<div class="col-lg-6">
@include('layouts.projet')
</div>
@endfor
</div>
</div>
<div class="carousel-item">
<div class="row">
@for ($i = 0; $i < 2; $i++)
<div class="col-lg-6">
@include('layouts.projet')
</div>
@endfor
</div>
</div>
<div class="carousel-item">
<div class="row">
@for ($i = 0; $i < 2; $i++)
<div class="col-lg-6">
@include('layouts.projet')
</div>
@endfor
</div>
</div>
</div>
</div>
</div>
<div class="text-center pt-5">
<a href="{{ route('projets') }}" class="viewprojects-btn">Voir tous les projets <i
class="fas fa-arrow-right"></i></a>
</div>
</div>
</section>
desired result : enter image description here