mgsmus hocam 2. sorumu çözümledim. İlk sorum için paylaştığınız linki inceledim orada belirtilen koda göre örnek kodlar inceledim kullanımı hakkında video izledim ama nasıl kullanacağımı çözemedim. Aşağıdaki şekilde yazılmış bir örnek buldum ve buna göre tablo ismimi ve kolonlarımı sorguda düzenledim. Aşağıdaki sorguyu controllera mı yazmalıyım ? ve blade.php de nasıl veri tabanındaki bilgiyi çekerek sorgulama yapabilirim.(html kodunda) nasıl yazmalıyım yani ? Teşekkürler.
$searchResults = DB::table('products')
->where(function($query) use ($yil, $marka, $model, $km, $vites, $aracdurumu, $price) {
if($yil)
$query->where('yil', $yil);
if($marka)
$query->where('marka', $marka);
if($model)
$query->where('model', $model);
if($km)
$query->where('km', $km);
if($vites)
$query->where('vites', $vites);
if($aracdurumu)
$query->where('aracdurumu', $aracdurumu);
if($price)
$query->where('price', $price);
})
->get();
Cars.blade.php
@extends('layout')
@section('Araçlar', 'active')
@section('extra-css')
@endsection
@section('content')
<section class="content">
<div class="container">
<div class="inner-page row">
<div class="clearfix"></div>
<div class="row">
<div class="inventory-wide-sidebar-left">
<div class=" col-md-9 col-lg-push-3 col-md-push-3">
<div class="car_listings sidebar margin-top-20 clearfix">
@forelse ($products as $product)
<div class="inventory margin-bottom-20 clearfix scroll_effect fadeIn" >
<a class="inventory" href="{{ route('shop.show', $product->slug) }}">
<div class="title">{{ $product->name }}</div>
<img src="{{ productImage($product->image) }}" class="preview" alt="preview">
<table class="options-primary">
<tr>
<td class="option primary">Model:</td>
<td class="spec">{{ $product->model }}</td>
</tr>
<tr>
<td class="option primary">Yıl:</td>
<td class="spec">{{ $product->yil }}</td>
</tr>
<tr>
<td class="option primary">Vites:</td>
<td class="spec">{{ $product->vites }}</td>
</tr>
<tr>
<td class="option primary">Renk:</td>
<td class="spec">{{ $product->renk }}</td>
</tr>
</table>
<table class="options-secondary">
<tr>
<td class="option secondary">Kasa Tipi:</td>
<td class="spec">{{ $product->kasa_tipi }}</td>
</tr>
<tr>
<td class="option secondary">Motor Gücü:</td>
<td class="spec">{{ $product->motor_gucu }}</td>
</tr>
<tr>
<td class="option secondary">Motor Hacmi:</td>
<td class="spec">{{ $product->motor_hacmi }}</td>
</tr>
<tr>
<td class="option secondary">Motor Çekis G.:</td>
<td class="spec">{{ $product->motor_cekis_gucu }}</td>
</tr>
<tr>
<td class="option secondary">Plaka / Uyruk:</td>
<td class="spec">{{ $product->plaka_uyruk }}</td>
</tr>
</table>
<div class="price"><b>Fiyat:</b><br>
<div class="figure">{{ $product->presentPrice() }}<br>
</div>
<div class="tax text-right">Artı Satış Vergisi</div>
</div>
<div class="view-details gradient_button"><i class='fa fa-plus-circle'></i> Araç Detaylarını Göster </div>
<div class="clearfix"></div>
</a>
<div class="view-video gradient_button" data-youtube-id="{{ $product->arac_youtube_link }}"><i class="fa fa-video-camera"></i> Video Görüntüle</div>
</div>
@empty
<div style="text-align: left; font-size: 30px;" class="fa fa-exclamation-circle exclamation margin-right-100">Hiçbir Öğe Bulumamadı !!!</div>
@endforelse
<div class="clearfix"></div>
<div class="col-lg-12 col-md-12 col-sm-12 col-xs-12 pagination_container">
<ul class="pagination margin-bottom-none margin-top-25 bottom_pagination md-margin-bottom-none xs-margin-bottom-60 sm-margin-bottom-60">
<li class="disabled"><a href="#"><i class="fa fa-angle-left"></i></a></li>
<li><a href="#">1</a></li>
<li><a href="#">2</a></li>
<li><a href="#">3</a></li>
<li><a href="#">4</a></li>
<li><a href="#">5</a></li>
<li><a href="#"><i class="fa fa-angle-right"></i></a></li>
</ul>
</div>
</div>
</div>
</div>
<div class=" col-md-3 col-lg-pull-9 col-md-pull-9 left-sidebar">
<div class="left_inventory">
<h3 class="margin-bottom-25">ENVANTERİMİZİ ARA</h3>
<form class="clearfix select-form padding-bottom-50">
<div class="my-dropdown min-years-dropdown max-dropdown">
<select name="year" class="css-dropdowns filters-select" tabindex="1" >
<option value=".yilagore">Yıla Göre Ara</option>
<option value="">2006</option>
</select>
</div>
<div class="my-dropdown min-years-dropdown max-dropdown">
<select name="make" class="css-dropdowns" tabindex="1" >
<option value="">Markaya Göre Ara</option>
<option></option>
</select>
</div>
<div class="my-dropdown min-years-dropdown max-dropdown">
<select name="model" class="css-dropdowns" tabindex="1" >
<option value="">Modele Göre Ara</option>
<option>Lorem</option>
<option>ipsum</option>
<option>dolor</option>
<option>sit</option>
<option>amet</option>
</select>
</div>
<div class="my-dropdown min-years-dropdown max-dropdown">
<select name="mileage" class="css-dropdowns" tabindex="1" >
<option value="">KM Göre Ara</option>
<option>0</option>
<option>< 10,000</option>
<option>< 20,000</option>
<option>< 30,000</option>
<option>< 40,000</option>
<option>< 50,000</option>
<option>< 60,000</option>
<option>< 70,000</option>
<option>< 80,000</option>
<option>< 90,000</option>
<option>< 100,000</option>
<option>< 120,000</option>
<option>< 150,000</option>
</select>
</div>
<div class="my-dropdown min-years-dropdown max-dropdown">
<select name="transmission" class="css-dropdowns" tabindex="1" >
<option value="">Vites Türüne Göre Ara</option>
<option>Automatic</option>
<option>Manual</option>
</select>
</div>
<div class="my-dropdown min-years-dropdown max-dropdown">
<select name="condition" class="css-dropdowns" tabindex="1" >
<option value="">Araç Durumuna Göre Ara</option>
<option>New</option>
<option>Used</option>
</select>
</div>
<div class="my-dropdown min-years-dropdown max-dropdown">
<select name="price" class="css-dropdowns" tabindex="1" >
<option value="">Fiyata Göre Ara</option>
<option>< $1,000</option>
<option>< $10,000</option>
<option>< $20,000</option>
<option>< $30,000</option>
<option>< $40,000</option>
<option>< $50,000</option>
<option>< $60,000</option>
<option>< $70,000</option>
<option>< $80,000</option>
<option>< $90,000</option>
<option>< $100,000</option>
</select>
</div>
<input type="reset" value="Reset Search Filters" class="pull-left btn-inventory margin-bottom-none md-button" />
</form>
<div class="side-content row">
<div class="list col-md-12 col-sm-3 padding-bottom-50">
<h3 class="margin-bottom-25">MODEL</h3>
<ul>
@foreach($categories as $category)
<li class="{{ setActiveCategory($category->slug) }}">
<a href="{{ route('cars.index', ['category' => $category->slug]) }}">
<span>{{ $category->name }}</span>
</a>
</li>
@endforeach
</ul>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<!--container ends-->
</section>
<div id="youtube_video">
<iframe width="560" height="315" src="#" allowfullscreen style="width: 560px; height: 315px; border: 0;"></iframe>
</div>
<!--content ends-->
<div class="clearfix"></div>
<div class="back_to_top"> <img src="images/arrow-up.png" alt="scroll up" /> </div>
<!-- Bootstrap core JavaScript --> <script src="js/retina.js"></script>
<script src="js/main.js"></script>
<script type="text/javascript" src="js/jquery.fancybox.js"></script>
<script src="js/modernizr.custom.js"></script> <script defer src="js/jquery.flexslider.js"></script>
<script src="js/jquery.bxslider.js" type="text/javascript"></script>
<script src="js/jquery.selectbox-0.2.js" type="text/javascript"></script>
<script type="text/javascript" src="js/jquery.mousewheel.js"></script>
<script type="text/javascript" src="js/jquery.easing.js"></script>
@endsection
@section('extra-js')
@endsection
CarsController.php
<?php
namespace App\Http\Controllers;
use App\Product;
use App\Category;
use Illuminate\Http\Request;
class CarsController extends Controller
{
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$pagination = 9;
$categories = Category::all();
if (request()->category) {
$products = Product::with('categories')->whereHas('categories', function ($query) {
$query->where('slug', request()->category);
});
$categoryName = optional($categories->where('slug', request()->category)->first())->name;
} else {
$products = Product::where('featured', true);
$categoryName = 'Featured';
}
if (request()->sort == 'low_high') {
$products = $products->orderBy('price')->paginate($pagination);
} elseif (request()->sort == 'high_low') {
$products = $products->orderBy('price', 'desc')->paginate($pagination);
} else {
$products = $products->paginate($pagination);
}
return view('cars')->with([
'products' => $products,
'categories' => $categories,
'categoryName' => $categoryName,
]);
}
/**
* Display the specified resource.
*
* @param string $slug
* @return \Illuminate\Http\Response
*/
public function show($slug)
{
$product = Product::where('slug', $slug)->firstOrFail();
$mightAlsoLike = Product::where('slug', '!=', $slug)->mightAlsoLike()->get();
return view('product')->with([
'product' => $product,
'mightAlsoLike' => $mightAlsoLike,
]);
}
public function search(Request $request)
{
$request->validate([
'query' => 'required|min:3',
]);
$query = $request->input('query');
->paginate(10);
$products = Product::search($query)->paginate(10);
return view('search-results')->with('products', $products);
}
public function searchAlgolia(Request $request)
{
return view('search-results-algolia');
}
}
