Laravel Product Categories Filter












0














i am using Laravel 5.7 and in a page i want to filter only one category. how can i do that? here i am posting the code i am currently using, but i want only one category from database. this code shows all the categories.



<div class="new_arrivals_sorting">
<ul class="arrivals_grid_sorting clearfix button-group filters-button group">
<li class="grid_sorting_button
button d-flex flex-column
justify-content-center
align-items-center active is-checked"
data-filter="*">
all
</li>
@foreach($categoryMenu as $menu)
<li class="grid_sorting_button
button d-flex flex-column
justify-content-center align-items-center"
data-filter=".{{ $menu->id }}">
{{ $menu->category_name }}
</li>
@endforeach
</ul>
</div>









share|improve this question





























    0














    i am using Laravel 5.7 and in a page i want to filter only one category. how can i do that? here i am posting the code i am currently using, but i want only one category from database. this code shows all the categories.



    <div class="new_arrivals_sorting">
    <ul class="arrivals_grid_sorting clearfix button-group filters-button group">
    <li class="grid_sorting_button
    button d-flex flex-column
    justify-content-center
    align-items-center active is-checked"
    data-filter="*">
    all
    </li>
    @foreach($categoryMenu as $menu)
    <li class="grid_sorting_button
    button d-flex flex-column
    justify-content-center align-items-center"
    data-filter=".{{ $menu->id }}">
    {{ $menu->category_name }}
    </li>
    @endforeach
    </ul>
    </div>









    share|improve this question



























      0












      0








      0







      i am using Laravel 5.7 and in a page i want to filter only one category. how can i do that? here i am posting the code i am currently using, but i want only one category from database. this code shows all the categories.



      <div class="new_arrivals_sorting">
      <ul class="arrivals_grid_sorting clearfix button-group filters-button group">
      <li class="grid_sorting_button
      button d-flex flex-column
      justify-content-center
      align-items-center active is-checked"
      data-filter="*">
      all
      </li>
      @foreach($categoryMenu as $menu)
      <li class="grid_sorting_button
      button d-flex flex-column
      justify-content-center align-items-center"
      data-filter=".{{ $menu->id }}">
      {{ $menu->category_name }}
      </li>
      @endforeach
      </ul>
      </div>









      share|improve this question















      i am using Laravel 5.7 and in a page i want to filter only one category. how can i do that? here i am posting the code i am currently using, but i want only one category from database. this code shows all the categories.



      <div class="new_arrivals_sorting">
      <ul class="arrivals_grid_sorting clearfix button-group filters-button group">
      <li class="grid_sorting_button
      button d-flex flex-column
      justify-content-center
      align-items-center active is-checked"
      data-filter="*">
      all
      </li>
      @foreach($categoryMenu as $menu)
      <li class="grid_sorting_button
      button d-flex flex-column
      justify-content-center align-items-center"
      data-filter=".{{ $menu->id }}">
      {{ $menu->category_name }}
      </li>
      @endforeach
      </ul>
      </div>






      php database laravel web filter






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Nov 20 '18 at 0:39







      Hefaz

















      asked Nov 19 '18 at 18:51









      HefazHefaz

      5711




      5711
























          1 Answer
          1






          active

          oldest

          votes


















          0














          If you want to show only specific categories you should also not retrieve the categories you do not want to see from the database at all. Imagine if you had 100 products and only 5 had the category you wanted to see. If you filter on the view/html then you have to get 100 records from the database even though you are only using 5! It's much better to only get 5 if you only need 5. I would say the filtering needs to be done in the database query. If you post your current query I will try update the answer to include that.






          share|improve this answer





















          • The code above produces a view for all six categories i have ( a view like buttons) and when i click one category it shows the related products. where in current status it shows me all the products. i am looking for a way to retrieve specific category when i click on it. i mean i should have one link to click on and it should show me the related products. i do not want @foreach there.
            – Hefaz
            Nov 19 '18 at 19:25












          • I think if you want to show a view for products of a specific category you should do the filtering in your database query so that only products with the category you want will show up.
            – Josh Woodcock
            Nov 20 '18 at 20:05










          • But i am currently doing it in the view, but the problem is that i get all categories. and when i click a filter button then i receive the category. but i do not want all those buttons, i only want a specific category which i have defined in my view.
            – Hefaz
            Nov 21 '18 at 0:54











          Your Answer






          StackExchange.ifUsing("editor", function () {
          StackExchange.using("externalEditor", function () {
          StackExchange.using("snippets", function () {
          StackExchange.snippets.init();
          });
          });
          }, "code-snippets");

          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "1"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53380936%2flaravel-product-categories-filter%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          1 Answer
          1






          active

          oldest

          votes








          1 Answer
          1






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes









          0














          If you want to show only specific categories you should also not retrieve the categories you do not want to see from the database at all. Imagine if you had 100 products and only 5 had the category you wanted to see. If you filter on the view/html then you have to get 100 records from the database even though you are only using 5! It's much better to only get 5 if you only need 5. I would say the filtering needs to be done in the database query. If you post your current query I will try update the answer to include that.






          share|improve this answer





















          • The code above produces a view for all six categories i have ( a view like buttons) and when i click one category it shows the related products. where in current status it shows me all the products. i am looking for a way to retrieve specific category when i click on it. i mean i should have one link to click on and it should show me the related products. i do not want @foreach there.
            – Hefaz
            Nov 19 '18 at 19:25












          • I think if you want to show a view for products of a specific category you should do the filtering in your database query so that only products with the category you want will show up.
            – Josh Woodcock
            Nov 20 '18 at 20:05










          • But i am currently doing it in the view, but the problem is that i get all categories. and when i click a filter button then i receive the category. but i do not want all those buttons, i only want a specific category which i have defined in my view.
            – Hefaz
            Nov 21 '18 at 0:54
















          0














          If you want to show only specific categories you should also not retrieve the categories you do not want to see from the database at all. Imagine if you had 100 products and only 5 had the category you wanted to see. If you filter on the view/html then you have to get 100 records from the database even though you are only using 5! It's much better to only get 5 if you only need 5. I would say the filtering needs to be done in the database query. If you post your current query I will try update the answer to include that.






          share|improve this answer





















          • The code above produces a view for all six categories i have ( a view like buttons) and when i click one category it shows the related products. where in current status it shows me all the products. i am looking for a way to retrieve specific category when i click on it. i mean i should have one link to click on and it should show me the related products. i do not want @foreach there.
            – Hefaz
            Nov 19 '18 at 19:25












          • I think if you want to show a view for products of a specific category you should do the filtering in your database query so that only products with the category you want will show up.
            – Josh Woodcock
            Nov 20 '18 at 20:05










          • But i am currently doing it in the view, but the problem is that i get all categories. and when i click a filter button then i receive the category. but i do not want all those buttons, i only want a specific category which i have defined in my view.
            – Hefaz
            Nov 21 '18 at 0:54














          0












          0








          0






          If you want to show only specific categories you should also not retrieve the categories you do not want to see from the database at all. Imagine if you had 100 products and only 5 had the category you wanted to see. If you filter on the view/html then you have to get 100 records from the database even though you are only using 5! It's much better to only get 5 if you only need 5. I would say the filtering needs to be done in the database query. If you post your current query I will try update the answer to include that.






          share|improve this answer












          If you want to show only specific categories you should also not retrieve the categories you do not want to see from the database at all. Imagine if you had 100 products and only 5 had the category you wanted to see. If you filter on the view/html then you have to get 100 records from the database even though you are only using 5! It's much better to only get 5 if you only need 5. I would say the filtering needs to be done in the database query. If you post your current query I will try update the answer to include that.







          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Nov 19 '18 at 19:00









          Josh WoodcockJosh Woodcock

          1,5801016




          1,5801016












          • The code above produces a view for all six categories i have ( a view like buttons) and when i click one category it shows the related products. where in current status it shows me all the products. i am looking for a way to retrieve specific category when i click on it. i mean i should have one link to click on and it should show me the related products. i do not want @foreach there.
            – Hefaz
            Nov 19 '18 at 19:25












          • I think if you want to show a view for products of a specific category you should do the filtering in your database query so that only products with the category you want will show up.
            – Josh Woodcock
            Nov 20 '18 at 20:05










          • But i am currently doing it in the view, but the problem is that i get all categories. and when i click a filter button then i receive the category. but i do not want all those buttons, i only want a specific category which i have defined in my view.
            – Hefaz
            Nov 21 '18 at 0:54


















          • The code above produces a view for all six categories i have ( a view like buttons) and when i click one category it shows the related products. where in current status it shows me all the products. i am looking for a way to retrieve specific category when i click on it. i mean i should have one link to click on and it should show me the related products. i do not want @foreach there.
            – Hefaz
            Nov 19 '18 at 19:25












          • I think if you want to show a view for products of a specific category you should do the filtering in your database query so that only products with the category you want will show up.
            – Josh Woodcock
            Nov 20 '18 at 20:05










          • But i am currently doing it in the view, but the problem is that i get all categories. and when i click a filter button then i receive the category. but i do not want all those buttons, i only want a specific category which i have defined in my view.
            – Hefaz
            Nov 21 '18 at 0:54
















          The code above produces a view for all six categories i have ( a view like buttons) and when i click one category it shows the related products. where in current status it shows me all the products. i am looking for a way to retrieve specific category when i click on it. i mean i should have one link to click on and it should show me the related products. i do not want @foreach there.
          – Hefaz
          Nov 19 '18 at 19:25






          The code above produces a view for all six categories i have ( a view like buttons) and when i click one category it shows the related products. where in current status it shows me all the products. i am looking for a way to retrieve specific category when i click on it. i mean i should have one link to click on and it should show me the related products. i do not want @foreach there.
          – Hefaz
          Nov 19 '18 at 19:25














          I think if you want to show a view for products of a specific category you should do the filtering in your database query so that only products with the category you want will show up.
          – Josh Woodcock
          Nov 20 '18 at 20:05




          I think if you want to show a view for products of a specific category you should do the filtering in your database query so that only products with the category you want will show up.
          – Josh Woodcock
          Nov 20 '18 at 20:05












          But i am currently doing it in the view, but the problem is that i get all categories. and when i click a filter button then i receive the category. but i do not want all those buttons, i only want a specific category which i have defined in my view.
          – Hefaz
          Nov 21 '18 at 0:54




          But i am currently doing it in the view, but the problem is that i get all categories. and when i click a filter button then i receive the category. but i do not want all those buttons, i only want a specific category which i have defined in my view.
          – Hefaz
          Nov 21 '18 at 0:54


















          draft saved

          draft discarded




















































          Thanks for contributing an answer to Stack Overflow!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.





          Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


          Please pay close attention to the following guidance:


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53380936%2flaravel-product-categories-filter%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          MongoDB - Not Authorized To Execute Command

          How to fix TextFormField cause rebuild widget in Flutter

          in spring boot 2.1 many test slices are not allowed anymore due to multiple @BootstrapWith