Styjun

Solve equation using Mathematica

Create two random teams from a list of players

How can flights operated by the same company have such different prices when marketed by another?

Word for soundtrack music which is part of the action of the movie

Raindrops in Python

How can you tell the version of Ubuntu on a system in a .sh (bash) script?

Using Python in a Bash Script

Easy way to get process from window

What Marvel character has this 'W' symbol?

Coworker mumbles to herself when working, how to ask her to stop?

How to foreshadow to avoid a 'deus ex machina'-construction

Would people understand me speaking German all over Europe?

How did astronauts using rovers tell direction without compasses on the Moon?

What clothes would flying-people wear?

Typesetting numbers above, below, left, and right of a symbol

How to innovate in OR

Unknown indication below upper stave

Can drawing a weapon be part of ANY kind of move action or just moving?

Patio gate not at right angle to the house

Can I attune a Circlet of Human Perfection to my animated skeletons to allow them to blend in and speak?

Why tantalum for the Hayabusa bullets?

What is the highest achievable score in Catan

Should students have access to past exams or an exam bank?

Why are we moving in circles with a tandem kayak?

How to fix laravel relationship query where clause?

Laravel 4 Query Builder: LEFT JOIN … AND … queryHow to Create Multiple Where Clause Query Using Laravel Eloquent?Laravel query multiple eloquent relationshipsLaravel 4 belongsToMany Relationship Returns EmptyDescending model relationship laravelLoad laravel model where relationship has conditionLaravel: How to write a join count query on belongsToMany relationships?Laravel query builder orderBy not orderingtoSql() on Eloquent Relationship returning `where id = null`Laravel: Proper Querying Many to Many Relationships

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I am trying to get data from the 'files' table through the 'computer_files' pivot table but the query puts an 'is null' into the query and therefore it doesn't return with the data. However, if I change the is null to an ID and run it as an SQL command it does give the data back.

I have tried going through the laravel docs but it didn't help. What I don't want to do is to use raw queries.

This is the files relationship function:

public function files()
 return $this->belongsToMany('AppFile', 'computer_files', 'computer_id', 'file_id');

This is what I do to get the data and currently gives back an empty collection:

$computer = Computer::where('computer_id', session('computer_id'))->first();
pr($computer->files);
die;

Also the 'toSql()' gives this:

select * from `files` inner join `computer_files` on `files`.`id` = `computer_files`.`file_id` where `computer_files`.`computer_id` is null

I expect to see an ID in the query instead of 'is null' so then it will give back the results that I need.

laravel eloquent relationship

share|improve this question

asked Mar 26 at 21:40

M4ST3RXM4ST3RX

1377 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I would guess your session('computer_id') is null.
  
  – GTCrais
  Mar 26 at 21:43
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  already checked on that and it is not because that is being set when you login and if i set it to a number it is still the same. also if it would be null then the '$computer' would be null and therefore the files variable would fail.
  
  – M4ST3RX
  Mar 26 at 21:58
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  computer_id is the primary key in the computers table, right? Have you set protected $primaryKey = 'computer_id'; in the Computer model?
  
  – Jonas Staudenmeir
  Mar 26 at 22:19
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  yes that is the primary key and i did not set it. but as soon as I did the query changed to where `computer_files`.`computer_id` = ?. Thanks
  
  – M4ST3RX
  Mar 26 at 22:33
  

  
  
  
  

add a comment | 

0

I am trying to get data from the 'files' table through the 'computer_files' pivot table but the query puts an 'is null' into the query and therefore it doesn't return with the data. However, if I change the is null to an ID and run it as an SQL command it does give the data back.

I have tried going through the laravel docs but it didn't help. What I don't want to do is to use raw queries.

This is the files relationship function:

public function files()
 return $this->belongsToMany('AppFile', 'computer_files', 'computer_id', 'file_id');

This is what I do to get the data and currently gives back an empty collection:

$computer = Computer::where('computer_id', session('computer_id'))->first();
pr($computer->files);
die;

Also the 'toSql()' gives this:

select * from `files` inner join `computer_files` on `files`.`id` = `computer_files`.`file_id` where `computer_files`.`computer_id` is null

I expect to see an ID in the query instead of 'is null' so then it will give back the results that I need.

laravel eloquent relationship

share|improve this question

asked Mar 26 at 21:40

M4ST3RXM4ST3RX

1377 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I would guess your session('computer_id') is null.
  
  – GTCrais
  Mar 26 at 21:43
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  already checked on that and it is not because that is being set when you login and if i set it to a number it is still the same. also if it would be null then the '$computer' would be null and therefore the files variable would fail.
  
  – M4ST3RX
  Mar 26 at 21:58
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  computer_id is the primary key in the computers table, right? Have you set protected $primaryKey = 'computer_id'; in the Computer model?
  
  – Jonas Staudenmeir
  Mar 26 at 22:19
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  yes that is the primary key and i did not set it. but as soon as I did the query changed to where `computer_files`.`computer_id` = ?. Thanks
  
  – M4ST3RX
  Mar 26 at 22:33
  

  
  
  
  

add a comment | 

I am trying to get data from the 'files' table through the 'computer_files' pivot table but the query puts an 'is null' into the query and therefore it doesn't return with the data. However, if I change the is null to an ID and run it as an SQL command it does give the data back.

I have tried going through the laravel docs but it didn't help. What I don't want to do is to use raw queries.

This is the files relationship function:

public function files()
 return $this->belongsToMany('AppFile', 'computer_files', 'computer_id', 'file_id');

This is what I do to get the data and currently gives back an empty collection:

$computer = Computer::where('computer_id', session('computer_id'))->first();
pr($computer->files);
die;

Also the 'toSql()' gives this:

select * from `files` inner join `computer_files` on `files`.`id` = `computer_files`.`file_id` where `computer_files`.`computer_id` is null

I expect to see an ID in the query instead of 'is null' so then it will give back the results that I need.

laravel eloquent relationship

share|improve this question

asked Mar 26 at 21:40

M4ST3RXM4ST3RX

1377 bronze badges

public function files()
 return $this->belongsToMany('AppFile', 'computer_files', 'computer_id', 'file_id');

$computer = Computer::where('computer_id', session('computer_id'))->first();
pr($computer->files);
die;

select * from `files` inner join `computer_files` on `files`.`id` = `computer_files`.`file_id` where `computer_files`.`computer_id` is null

share|improve this question

asked Mar 26 at 21:40

M4ST3RXM4ST3RX

1377 bronze badges

share|improve this question

asked Mar 26 at 21:40

M4ST3RXM4ST3RX

1377 bronze badges

asked Mar 26 at 21:40

M4ST3RXM4ST3RX

1377 bronze badges

asked Mar 26 at 21:40

M4ST3RXM4ST3RX

1377 bronze badges