Laravel hasMany return null












0















I have model Category: 



class Category extends Model

{

    protected $fillable = ['title', 'description', 'keywords', 'slug'];



    public function getRouteKeyName()

    {

        return 'slug';

    }



    public function products()

    {

        return $this->hasMany(Product::class);

    }

}


And have model product:



class Product extends Model

{



    protected $guarded = ;



    public function category()

    {

        return $this->belongsTo(Category::class);

    }

}


In table products I have product with column category_id. But return null. Why? I can't get products in current category with $category->products, because always empty. How I can fix this?



In model product relation category working, but on model category not working..



On table products I have cascade: 



$table->foreign('category_id')

    ->references('id')->on('categories')

    ->onDelete('cascade');





php laravel







share|improve this question

























  • Can you show the migration of the category table please ?

    – Steve Chamaillard
    Nov 14 '18 at 22:07











  • Can you show the code where you are trying to access the $category->products relation?

    – Peter
    Nov 15 '18 at 2:09











  • Check that your 'category_id' in the products table is unsigned. eg. $table->integer('category_id')->unsigned();

    – CUGreen
    Nov 15 '18 at 3:29
















0















I have model Category: 



class Category extends Model

{

    protected $fillable = ['title', 'description', 'keywords', 'slug'];



    public function getRouteKeyName()

    {

        return 'slug';

    }



    public function products()

    {

        return $this->hasMany(Product::class);

    }

}


And have model product:



class Product extends Model

{



    protected $guarded = ;



    public function category()

    {

        return $this->belongsTo(Category::class);

    }

}


In table products I have product with column category_id. But return null. Why? I can't get products in current category with $category->products, because always empty. How I can fix this?



In model product relation category working, but on model category not working..



On table products I have cascade: 



$table->foreign('category_id')

    ->references('id')->on('categories')

    ->onDelete('cascade');





php laravel







share|improve this question

























  • Can you show the migration of the category table please ?

    – Steve Chamaillard
    Nov 14 '18 at 22:07











  • Can you show the code where you are trying to access the $category->products relation?

    – Peter
    Nov 15 '18 at 2:09











  • Check that your 'category_id' in the products table is unsigned. eg. $table->integer('category_id')->unsigned();

    – CUGreen
    Nov 15 '18 at 3:29














0












0








0








I have model Category: 



class Category extends Model

{

    protected $fillable = ['title', 'description', 'keywords', 'slug'];



    public function getRouteKeyName()

    {

        return 'slug';

    }



    public function products()

    {

        return $this->hasMany(Product::class);

    }

}


And have model product:



class Product extends Model

{



    protected $guarded = ;



    public function category()

    {

        return $this->belongsTo(Category::class);

    }

}


In table products I have product with column category_id. But return null. Why? I can't get products in current category with $category->products, because always empty. How I can fix this?



In model product relation category working, but on model category not working..



On table products I have cascade: 



$table->foreign('category_id')

    ->references('id')->on('categories')

    ->onDelete('cascade');





php laravel







share|improve this question
















I have model Category: 



class Category extends Model

{

    protected $fillable = ['title', 'description', 'keywords', 'slug'];



    public function getRouteKeyName()

    {

        return 'slug';

    }



    public function products()

    {

        return $this->hasMany(Product::class);

    }

}


And have model product:



class Product extends Model

{



    protected $guarded = ;



    public function category()

    {

        return $this->belongsTo(Category::class);

    }

}


In table products I have product with column category_id. But return null. Why? I can't get products in current category with $category->products, because always empty. How I can fix this?



In model product relation category working, but on model category not working..



On table products I have cascade: 



$table->foreign('category_id')

    ->references('id')->on('categories')

    ->onDelete('cascade');





php laravel




php laravel






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 15 '18 at 4:37









Peter

8841213




8841213










asked Nov 14 '18 at 21:55









DumitruDumitru

342112




342112













  • Can you show the migration of the category table please ?

    – Steve Chamaillard
    Nov 14 '18 at 22:07











  • Can you show the code where you are trying to access the $category->products relation?

    – Peter
    Nov 15 '18 at 2:09











  • Check that your 'category_id' in the products table is unsigned. eg. $table->integer('category_id')->unsigned();

    – CUGreen
    Nov 15 '18 at 3:29



















  • Can you show the migration of the category table please ?

    – Steve Chamaillard
    Nov 14 '18 at 22:07











  • Can you show the code where you are trying to access the $category->products relation?

    – Peter
    Nov 15 '18 at 2:09











  • Check that your 'category_id' in the products table is unsigned. eg. $table->integer('category_id')->unsigned();

    – CUGreen
    Nov 15 '18 at 3:29

















Can you show the migration of the category table please ?

– Steve Chamaillard
Nov 14 '18 at 22:07





Can you show the migration of the category table please ?

– Steve Chamaillard
Nov 14 '18 at 22:07













Can you show the code where you are trying to access the $category->products relation?

– Peter
Nov 15 '18 at 2:09





Can you show the code where you are trying to access the $category->products relation?

– Peter
Nov 15 '18 at 2:09













Check that your 'category_id' in the products table is unsigned. eg. $table->integer('category_id')->unsigned();

– CUGreen
Nov 15 '18 at 3:29





Check that your 'category_id' in the products table is unsigned. eg. $table->integer('category_id')->unsigned();

– CUGreen
Nov 15 '18 at 3:29












3 Answers
3






active

oldest

votes


















1














Validate your definition



return $this->hasMany('AppProduct', 'category_id');


You have error here because attach on catergories but it will be on products



$table->foreign('category_id')

    ->references('id')->on('products')

    ->onDelete('cascade');


https://laravel.com/docs/5.6/eloquent-relationships#querying-relations






share|improve this answer


























  • please add more details to your answer

    – Supun Praneeth
    Nov 15 '18 at 5:44











  • His mean you should try this for Category model return $this->hasMany(Product::class, category_id);

    – Truong Dang
    Nov 15 '18 at 5:55











  • What exactly I mean one category have many products with foreign key category_Id but mistake you have it is on adding foreign key on categories

    – Ismoil Shifoev
    Nov 15 '18 at 6:35



















4














Please do following changes





  1. Make change in product migration file (in products table)



     $table->integer('category_id')->unsigned();
    
 $table->foreign('category_id')->references('category_id')->on('categories');



  2. Then change in Category model



    public function products()
    
{
    
    return $this->hasMany('AppProduct','category_id');
    
}



3.Then get all categories with products list



use AppCategory   

             // include category model where you want to call this function

Category::with('products')->get();





share|improve this answer































    1














    Everything is right, just make changes in the products migration
    change this code



    $table->foreign('category_id')->references('id')
    
->on('categories')->onDelete('cascade');


    to



    $table->foreign('category_id')->references('id')
    
->on('products'->onDelete('cascade');





    share|improve this answer























      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%2f53309309%2flaravel-hasmany-return-null%23new-answer', 'question_page');
      }
      );

      Post as a guest















      Required, but never shown

























      3 Answers
      3






      active

      oldest

      votes








      3 Answers
      3






      active

      oldest

      votes









      active

      oldest

      votes






      active

      oldest

      votes









      1














      Validate your definition



      return $this->hasMany('AppProduct', 'category_id');


      You have error here because attach on catergories but it will be on products



      $table->foreign('category_id')
      
    ->references('id')->on('products')
      
    ->onDelete('cascade');


      https://laravel.com/docs/5.6/eloquent-relationships#querying-relations






      share|improve this answer


























      • please add more details to your answer

        – Supun Praneeth
        Nov 15 '18 at 5:44











      • His mean you should try this for Category model return $this->hasMany(Product::class, category_id);

        – Truong Dang
        Nov 15 '18 at 5:55











      • What exactly I mean one category have many products with foreign key category_Id but mistake you have it is on adding foreign key on categories

        – Ismoil Shifoev
        Nov 15 '18 at 6:35
















      1














      Validate your definition



      return $this->hasMany('AppProduct', 'category_id');


      You have error here because attach on catergories but it will be on products



      $table->foreign('category_id')
      
    ->references('id')->on('products')
      
    ->onDelete('cascade');


      https://laravel.com/docs/5.6/eloquent-relationships#querying-relations






      share|improve this answer


























      • please add more details to your answer

        – Supun Praneeth
        Nov 15 '18 at 5:44











      • His mean you should try this for Category model return $this->hasMany(Product::class, category_id);

        – Truong Dang
        Nov 15 '18 at 5:55











      • What exactly I mean one category have many products with foreign key category_Id but mistake you have it is on adding foreign key on categories

        – Ismoil Shifoev
        Nov 15 '18 at 6:35














      1












      1








      1







      Validate your definition



      return $this->hasMany('AppProduct', 'category_id');


      You have error here because attach on catergories but it will be on products



      $table->foreign('category_id')
      
    ->references('id')->on('products')
      
    ->onDelete('cascade');


      https://laravel.com/docs/5.6/eloquent-relationships#querying-relations






      share|improve this answer















      Validate your definition



      return $this->hasMany('AppProduct', 'category_id');


      You have error here because attach on catergories but it will be on products



      $table->foreign('category_id')
      
    ->references('id')->on('products')
      
    ->onDelete('cascade');


      https://laravel.com/docs/5.6/eloquent-relationships#querying-relations







      share|improve this answer














      share|improve this answer



      share|improve this answer








      edited Nov 15 '18 at 7:46









      Ross Wilson

      16.4k22741




      16.4k22741










      answered Nov 15 '18 at 5:41









      Ismoil ShifoevIsmoil Shifoev

      1,271813




      1,271813













      • please add more details to your answer

        – Supun Praneeth
        Nov 15 '18 at 5:44











      • His mean you should try this for Category model return $this->hasMany(Product::class, category_id);

        – Truong Dang
        Nov 15 '18 at 5:55











      • What exactly I mean one category have many products with foreign key category_Id but mistake you have it is on adding foreign key on categories

        – Ismoil Shifoev
        Nov 15 '18 at 6:35



















      • please add more details to your answer

        – Supun Praneeth
        Nov 15 '18 at 5:44











      • His mean you should try this for Category model return $this->hasMany(Product::class, category_id);

        – Truong Dang
        Nov 15 '18 at 5:55











      • What exactly I mean one category have many products with foreign key category_Id but mistake you have it is on adding foreign key on categories

        – Ismoil Shifoev
        Nov 15 '18 at 6:35

















      please add more details to your answer

      – Supun Praneeth
      Nov 15 '18 at 5:44





      please add more details to your answer

      – Supun Praneeth
      Nov 15 '18 at 5:44













      His mean you should try this for Category model return $this->hasMany(Product::class, category_id);

      – Truong Dang
      Nov 15 '18 at 5:55





      His mean you should try this for Category model return $this->hasMany(Product::class, category_id);

      – Truong Dang
      Nov 15 '18 at 5:55













      What exactly I mean one category have many products with foreign key category_Id but mistake you have it is on adding foreign key on categories

      – Ismoil Shifoev
      Nov 15 '18 at 6:35





      What exactly I mean one category have many products with foreign key category_Id but mistake you have it is on adding foreign key on categories

      – Ismoil Shifoev
      Nov 15 '18 at 6:35













      4














      Please do following changes





      1. Make change in product migration file (in products table)



         $table->integer('category_id')->unsigned();
        
 $table->foreign('category_id')->references('category_id')->on('categories');



      2. Then change in Category model



        public function products()
        
{
        
    return $this->hasMany('AppProduct','category_id');
        
}



      3.Then get all categories with products list



      use AppCategory   
      
             // include category model where you want to call this function
      
Category::with('products')->get();





      share|improve this answer




























        4














        Please do following changes





        1. Make change in product migration file (in products table)



           $table->integer('category_id')->unsigned();
          
 $table->foreign('category_id')->references('category_id')->on('categories');



        2. Then change in Category model



          public function products()
          
{
          
    return $this->hasMany('AppProduct','category_id');
          
}



        3.Then get all categories with products list



        use AppCategory   
        
             // include category model where you want to call this function
        
Category::with('products')->get();





        share|improve this answer


























          4












          4








          4







          Please do following changes





          1. Make change in product migration file (in products table)



             $table->integer('category_id')->unsigned();
            
 $table->foreign('category_id')->references('category_id')->on('categories');



          2. Then change in Category model



            public function products()
            
{
            
    return $this->hasMany('AppProduct','category_id');
            
}



          3.Then get all categories with products list



          use AppCategory   
          
             // include category model where you want to call this function
          
Category::with('products')->get();





          share|improve this answer













          Please do following changes





          1. Make change in product migration file (in products table)



             $table->integer('category_id')->unsigned();
            
 $table->foreign('category_id')->references('category_id')->on('categories');



          2. Then change in Category model



            public function products()
            
{
            
    return $this->hasMany('AppProduct','category_id');
            
}



          3.Then get all categories with products list



          use AppCategory   
          
             // include category model where you want to call this function
          
Category::with('products')->get();






          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Nov 15 '18 at 9:45









          amba patelamba patel

          635213




          635213























              1














              Everything is right, just make changes in the products migration
              change this code



              $table->foreign('category_id')->references('id')
              
->on('categories')->onDelete('cascade');


              to



              $table->foreign('category_id')->references('id')
              
->on('products'->onDelete('cascade');





              share|improve this answer




























                1














                Everything is right, just make changes in the products migration
                change this code



                $table->foreign('category_id')->references('id')
                
->on('categories')->onDelete('cascade');


                to



                $table->foreign('category_id')->references('id')
                
->on('products'->onDelete('cascade');





                share|improve this answer


























                  1












                  1








                  1







                  Everything is right, just make changes in the products migration
                  change this code



                  $table->foreign('category_id')->references('id')
                  
->on('categories')->onDelete('cascade');


                  to



                  $table->foreign('category_id')->references('id')
                  
->on('products'->onDelete('cascade');





                  share|improve this answer













                  Everything is right, just make changes in the products migration
                  change this code



                  $table->foreign('category_id')->references('id')
                  
->on('categories')->onDelete('cascade');


                  to



                  $table->foreign('category_id')->references('id')
                  
->on('products'->onDelete('cascade');






                  share|improve this answer












                  share|improve this answer



                  share|improve this answer










                  answered Nov 15 '18 at 8:38









                  Zeeshan TanveerZeeshan Tanveer

                  313




                  313






























                      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.




                      draft saved


                      draft discarded














                      StackExchange.ready(
                      function () {
                      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53309309%2flaravel-hasmany-return-null%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

                      List item for chat from Array inside array React Native

                      Image
                      0 This is my code for Chat Box, the window where I have "In" and "Out" messages are appearing. import React, { Component } from "react"; import { StyleSheet, Text, View, TouchableOpacity, TextInput, FlatList, Platform, AsyncStorage } from "react-native"; import Tutor from "../image/krutika.jpg"; import { Container, Header, Left, Input, Body, Right, Thumbnail, Button } from "native-base"; import FontAwesome from "react-native-vector-icons/FontAwesome"; import Ionicons from "react-native-vector-icons/Ionicons"; import Icon1 from "react-native-vector-icons/FontAwesome"; import axios from "axios"; export default class ChatBox extends Component { st...
                      Read more

                      Thiostrepton

                      Image
                      Thiostrepton [1] Names Other names Alaninamide, Bryamycin, Thiactin Identifiers CAS Number 1393-48-2   Y 3D model (JSmol) Interactive image ChEMBL ChEMBL468719   N ECHA InfoCard 100.014.304 PubChem CID 16130278 InChI InChI=1S/C72H85N19O18S5/c1-14-26(3)47-63(105)78-30(7)57(99)75-28(5)56(98)76-31(8)58(100)91-72-19-18-40(66-85-43(22-111-66)59(101)77-29(6)55(97)74-27(4)54(73)96)81-52(72)42-21-112-67(83-42)49(34(11)109-69(107)41-20-37(32(9)92)36-16-17-39(79-47)51(95)50(36)80-41)89-60(102)44-24-113-68(86-44)53(71(13,108)35(12)94)90-62(104)45-23-110-65(84-45)38(15-2)82-64(106)48(33(10)93)88-61(103)46-25-114-70(72)87-46/h15-17,20-22,24-26,30-35,39,45,47-49,51-53,79,92-95,108H,4-6,14,18-19,23H2,1-3,7-13H3,(H2,73,96)(H,74,97)(H,75,99)(H,76,98)(H,77,101)(H,78,105)(H,82,106)(H,88,103)(H,89,102)(H,90,104)(H,91,100)/b38-15-/t26-,30-,31-,32-,33+,34+,35+,39+,45+,47-,48-,49-,51-,52+,53+,71+,72+/m0/s1 Key: NSFFHOGKXHRQEW-AIHSUZKVSA-N ...
                      Read more

                      Caerphilly

                      Image
                      This article is about the town of Caerphilly. For the cheese of the same name, see Caerphilly cheese. For other uses, see Caerphilly (disambiguation). Caerphilly Welsh: Caerffili Caerphilly Castle Caerphilly Location within Caerphilly Population 30,388  OS grid reference ST1586 Principal area Caerphilly Ceremonial county Gwent Country Wales Sovereign state United Kingdom Post town CAERPHILLY Postcode district CF83 Dialling code 029 Police Gwent Fire South Wales Ambulance Welsh EU Parliament Wales UK Parliament Caerphilly Welsh Assembly Caerphilly List of places UK Wales Caerphilly 51°34′41″N 3°13′05″W  /  51.578°N 3.218°W  / 51.578; -3.218 Coordinates: 51°34′41″N 3°13′05″W  /  51.578°N 3.218°W  / 51.578; -3.218 Caerphilly ( / k aɪər ˈ f ɪ l i / ; Welsh: Caerffili , Welsh pronunciation:  [ˌkɑːɨrˈfɪlɪ] ) is a town and community in South Wales, at the southern end of the Rhymney Valley....
                      Read more