# Tìm kiếm nhiều trường trong một bảng, search many tables (ok)

C:\xampp\htdocs\api\app\Http\Controllers\Api\V1\HomeController.php

```
<?php
namespace App\Http\Controllers\Api\V1;
use Illuminate\Http\Request;
use App\Models\CategoryPost;
use App\Models\Post;
class HomeController extends Controller {
  /**
   * Display a listing of the resource.
   *
   * @return \Illuminate\Http\Response
   */
  public function index() {
    $categories = CategoryPost::all();
    $posts = Post::with('category')->get();
    $posts_randon = Post::all()->random(6);
    $posts_views = Post::orderBy('views','DESC')->take('6')->get();
    return view("pages.main")->with(compact('categories','posts','posts_randon','posts_views'));
  }
  /**
   * Show the form for creating a new resource.
   *
   * @return \Illuminate\Http\Response
   */
  public function create() {
    //
  }
  /**
   * Store a newly created resource in storage.
   *
   * @param  \Illuminate\Http\Request  $request
   * @return \Illuminate\Http\Response
   */
  public function store(Request $request) {
    //
  }
  /**
   * Display the specified resource.
   *
   * @param  int  $id
   * @return \Illuminate\Http\Response
   */
  public function show($id) {
    echo '<pre>';
      var_export($id);
    echo '</pre>';
    die("gggg");
  }
  /**
   * Display the specified resource.
   *
   * @param  int  $id
   * @return \Illuminate\Http\Response
   */
  public function tim_kiem() {
    $keyword = $_GET['keyword'];
    $category_posts = Post::with("category")->where('title','LIKE','%'.$keyword.'%')->orWhere('short_desc','LIKE','%'.$keyword.'%')->get();
    $categories = CategoryPost::all();
    $posts = Post::with('category')->get();
    $posts_randon = Post::all()->random(6);
    $posts_views = Post::orderBy('views','DESC')->take('6')->get();
    return view("pages.search")->with(compact('categories','category_posts','posts','posts_randon','posts_views'));
  }
  /**
   * Show the form for editing the specified resource.
   *
   * @param  int  $id
   * @return \Illuminate\Http\Response
   */
  public function edit($id) {
    //
  }
  /**
   * Update the specified resource in storage.
   *
   * @param  \Illuminate\Http\Request  $request
   * @param  int  $id
   * @return \Illuminate\Http\Response
   */
  public function update(Request $request, $id) {
    //
  }
  /**
   * Remove the specified resource from storage.
   *
   * @param  int  $id
   * @return \Illuminate\Http\Response
   */
  public function destroy($id) {
    //
  }
}
```

C:\xampp\htdocs\api\resources\views\pages\search.blade.php

```
@extends('../layout')
@section('banner')
  @include('pages.banner')
@endsection

@section('main')
<div class="about">
  <div class="container">
    <div class="about-main">
      <div class="col-md-8 about-left">
        <div class="about-one">
          <p>Find The Most</p>
          <h3>Coffee of the month</h3>
        </div>
        <div class="about-tre">
          <div class="a-1">
            <div class="row">
              @foreach($category_posts as $post)
                <div class="row" style="margin: 10px 0;">
                  <div class="col-md-6 abt-left">
                    <a href="{{ url('bai-viet/' . $post->id) }}">
                      <img src="{{ url('images/' . $post->image) }}" alt="Image" />
                    </a>
                  </div>
                  <div class="col-md-6 abt-left">
                    <h6>{{ $post->category->title }}</h6>
                    <h3><a href="{{ url('bai-viet/'.$post->id) }}">{{ $post->title }}</a></h3>
                    <p>{{ $post->short_desc }}</p>
                    <label>{{ $post->post_date }}</label>
                  </div>
                </div>
              @endforeach
            </div>
          </div>
        </div>
      </div>
      <div class="col-md-4 about-right heading">
        <div class="abt-2">
          <h3>Bài viết xem nhiều</h3>
          @foreach($posts_views as $pviews)
            <div class="might-grid">
              <div class="grid-might">
                <a href="{{ url('bai-viet/' . $pviews->id) }}">
                  <img src="{{ url('images/' . $pviews->image) }}" class="img-responsive" alt="">
                </a>
              </div>
              <div class="might-top">
                <h4><a href="{{ url('bai-viet/' . $pviews->id) }}">{{ $pviews->title }}</a></h4>
                <p>{{ substr($pviews->short_desc, 0, 100) }}</p>
              </div>
              <div class="clearfix"></div>
            </div>
          @endforeach
        </div>
        <div class="abt-2">
          <h3>Bài viết ngẫu nhiên</h3>
          <ul>
            @foreach($posts_randon as $prandon)
              <li><a href="{{ url('bai-viet/' . $prandon->id) }}">{{ $prandon->title }}</a></li>
            @endforeach
          </ul>
        </div>
        <div class="abt-2">
          <h3>NEWS LETTER</h3>
          <div class="news">
            <form>
              <input type="text" value="Email" onfocus="this.value = '';" onblur="if (this.value == '') {this.value = 'Email';}" />
              <input type="submit" value="Subscribe">
            </form>
          </div>
        </div>
      </div>
      <div class="clearfix"></div>
    </div>
  </div>
</div>
@endsection
```

C:\xampp\htdocs\api\resources\views\layout.blade.php

```
<!DOCTYPE html>
<html lang="{{ str_replace('_', '-', app()->getLocale()) }}">
  <head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title>Test</title>
    <!-- Fonts -->
    <link href="https://fonts.googleapis.com/css2?family=Nunito:wght@400;600;700&display=swap" rel="stylesheet">
    <link rel="stylesheet" type="text/css" href="{{ asset('css/bootstrap.css') }}">
    <link rel="stylesheet" type="text/css" href="{{ asset('css/chocolat.css') }}">
    <link rel="stylesheet" type="text/css" href="{{ asset('css/style.css') }}">
    <script src="{{ asset('js/jquery.min.js')}}"></script>
    <script type="text/javascript" src="{{ asset('js/move-top.js')}}"></script>
    <script type="text/javascript" src="{{ asset('js/easing.js')}}"></script>
    <script type="text/javascript">
      jQuery(document).ready(function($) {
        $(".scroll").click(function(event) {
          event.preventDefault();
          $('html,body').animate({ scrollTop: $(this.hash).offset().top }, 1000);
        });
      });
    </script>
  </head>
  <body class="antialiased">
    <div class="relative flex items-top justify-center min-h-screen bg-gray-100 dark:bg-gray-900 sm:items-center py-4 sm:pt-0"> @if (Route::has('login')) <div class="hidden fixed top-0 right-0 px-6 py-4 sm:block"> @auth <a href="{{ url('/home') }}" class="text-sm text-gray-700 dark:text-gray-500 underline">Home</a> @else <a href="{{ route('login') }}" class="text-sm text-gray-700 dark:text-gray-500 underline">Log in</a> @if (Route::has('register')) <a href="{{ route('register') }}" class="ml-4 text-sm text-gray-700 dark:text-gray-500 underline">Register</a> @endif @endauth </div> @endif </div>
    <!--header-top-starts-->
    <div class="header-top">
      <div class="container">
        <div class="head-main">
          <a href="index.html"><img src="{{ url('images/logo-1.png') }}" alt="" /></a>
        </div>
      </div>
    </div>
    <!--header-top-end-->
    <!--start-header-->
    <div class="header">
      <div class="container">
        <div class="head">
          <div class="navigation">
            <span class="menu"></span>
            <ul class="navig">
              <li><a href="{{ url('/') }}" class="active">Home</a></li>
              @foreach ($categories as $category)
               <li><a href="{{ route('danh-muc.show',[$category->id]) }}">{{ $category->title }}</a></li> 
              @endforeach
              <li><a href="contact.html">Về chúng tôi</a></li>
            </ul>
          </div>
          <div class="header-right">
            <div class="search-bar">
              <form action="{{ url('tim-kiem') }}" method="get">
                @csrf
                <input type="text" placeholder="Nhập từ khóa" name="keyword">
                <input type="submit" value="">
              </form>
            </div>
            <ul>
              <li><a href="#"><span class="fb"> </span></a></li>
              <li><a href="#"><span class="twit"> </span></a></li>
              <li><a href="#"><span class="pin"> </span></a></li>
              <li><a href="#"><span class="rss"> </span></a></li>
              <li><a href="#"><span class="drbl"> </span></a></li>
            </ul>
          </div>
          <div class="clearfix"></div>
        </div>
      </div>
    </div>
    <!-- script-for-menu -->
    <!-- script-for-menu -->
    <script> 
      $("span.menu").click(function(){
        $(" ul.navig").slideToggle("slow" , function(){});
      });
    </script>
    <!-- script-for-menu -->
    <!--banner-starts-->
    @yield('banner')
    <!--banner-end-->
    <!--main-starts-->
    @yield('main')
    <!--main-end-->
    <!--slide-starts-->
    <div class="slide">
      <div class="container">
        <div class="fle-xsel">
          <ul id="flexiselDemo3">
            <li>
              <a href="#">
                <div class="banner-1">
                  <img src="{{ url('images/s-1.jpg') }}" class="img-responsive" alt="">
                </div>
              </a>
            </li>
            <li>
              <a href="#">
                <div class="banner-1">
                  <img src="{{ url('images/s-2.jpg') }}" class="img-responsive" alt="">
                </div>
              </a>
            </li>
            <li>
              <a href="#">
                <div class="banner-1">
                  <img src="{{ url('images/s-3.jpg') }}" class="img-responsive" alt="">
                </div>
              </a>
            </li>
            <li>
              <a href="#">
                <div class="banner-1">
                  <img src="{{ url('images/s-4.jpg') }}" class="img-responsive" alt="">
                </div>
              </a>
            </li>
            <li>
              <a href="#">
                <div class="banner-1">
                  <img src="{{ url('images/s-5.jpg') }}" class="img-responsive" alt="">
                </div>
              </a>
            </li>
            <li>
              <a href="#">
                <div class="banner-1">
                  <img src="{{ url('images/s-6.jpg') }}" class="img-responsive" alt="">
                </div>
              </a>
            </li>
          </ul>
          <script type="text/javascript">
            $(window).load(function() {
              $("#flexiselDemo3").flexisel({
                visibleItems: 5,
                animationSpeed: 1000,
                autoPlay: true,
                autoPlaySpeed: 3000,
                pauseOnHover: true,
                enableResponsiveBreakpoints: true,
                responsiveBreakpoints: {
                  portrait: {
                    changePoint: 480,
                    visibleItems: 2
                  },
                  landscape: {
                    changePoint: 640,
                    visibleItems: 3
                  },
                  tablet: {
                    changePoint: 768,
                    visibleItems: 3
                  }
                }
              });
            });
          </script>
          <script type="text/javascript" src="{{ asset('js/jquery.flexisel.js')}}"></script>
          <div class="clearfix"> </div>
        </div>
      </div>
    </div>
    <!--slide-end-->
    <!--footer-starts-->
    <div class="footer">
      <div class="container">
        <div class="footer-text">
          <p>© 2015 Coffee Break. All Rights Reserved | Design by <a href="http://w3layouts.com/" target="_blank">W3layouts</a> </p>
        </div>
      </div>
    </div>
  </body>
</html>
```

C:\xampp\htdocs\api\routes\web.php

```
<?php
use Illuminate\Support\Facades\Route;

/*
|--------------------------------------------------------------------------
| Web Routes
|--------------------------------------------------------------------------
|
| Here is where you can register web routes for your application. These
| routes are loaded by the RouteServiceProvider within a group which
| contains the "web" middleware group. Now create something great!
|
 */
// Route::get('/', function () {
//     return view('pages.main');
// });
Route::get('/', [App\Http\Controllers\Api\V1\HomeController::class, 'index']);
// Route::get('/bai-viet/{id}', function () {
//     return view('pages.single');
// });
Route::get('/bai-viet/{id}', [App\Http\Controllers\Api\V1\BaivietController::class, 'show']);
Auth::routes();
Route::get('/home', [App\Http\Controllers\Api\V1\HomeController::class, 'index'])->name('home');
Route::get('/tim-kiem', [App\Http\Controllers\Api\V1\HomeController::class, 'tim_kiem']);
```

{% file src="https://1957079826-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MCBeDUD-PK_RF-YgJRe%2Fuploads%2FVAYgtiuBZ36uidYgrolu%2Fapi.sql?alt=media&token=48690abf-d140-4f05-9aef-c81503831a2f" %}
