Eloquent ORM relationship always return null in laravel
0
I have 3 Models:
MonHoc Model:
class MonHoc extends Model{
protected $table='monhoc' ;
protected $fillable = [
'mamh', 'phuongthucgiangday', 'tenmh','tinchitichluy','tinchihocphi','hockydenghi',
];
public function monTienQuyet(){
return $this->hasMany('AppMonTQ','montq_id','id');
}
public function monTuyChon(){
return $this->hasMany('AppMonTC','montc_id','id');
}
}
MonTC model:
class MonTC extends Model{
protected $table='monhoc_tuychon' ;
protected $fillable = [
'monhoc_id', 'montc_id',
];
public function monhoc(){
return $this->belongsTo('AppMonHoc','monhoc_id');
}
}
MonTQ model:
class MonTQ extends Model{
protected $table='montienquyet' ;
protected $fillable = [
'monhoc_id', 'montq_id',
];
public function monhoc(){
return $this->belongsTo('AppMonHoc','monhoc_id');
}
}
but when I use MonHoc model in controller:
public function test(MonHoc $monhoc){
$mon=$monhoc->monTienQuyet->toSql();
dd($mon);
}
it show SQL
select * from `montienquyet` where `montienquyet`.`montq_id` is null and `montienquyet`.`montq_id` is not null
It show null in MySQL because the where clause is the opposite. I don't know why the model export this SQL!
Please help!
laravel laravel-5 eloquent
edited Nov 22 '18 at 8:14
kit
1,1063816
asked Nov 22 '18 at 4:02
the manh Nguyenthe manh Nguyen
4912
add a comment |
0
I have 3 Models:
MonHoc Model:
class MonHoc extends Model{
protected $table='monhoc' ;
protected $fillable = [
'mamh', 'phuongthucgiangday', 'tenmh','tinchitichluy','tinchihocphi','hockydenghi',
];
public function monTienQuyet(){
return $this->hasMany('AppMonTQ','montq_id','id');
}
public function monTuyChon(){
return $this->hasMany('AppMonTC','montc_id','id');
}
}
MonTC model:
class MonTC extends Model{
protected $table='monhoc_tuychon' ;
protected $fillable = [
'monhoc_id', 'montc_id',
];
public function monhoc(){
return $this->belongsTo('AppMonHoc','monhoc_id');
}
}
MonTQ model:
class MonTQ extends Model{
protected $table='montienquyet' ;
protected $fillable = [
'monhoc_id', 'montq_id',
];
public function monhoc(){
return $this->belongsTo('AppMonHoc','monhoc_id');
}
}
but when I use MonHoc model in controller:
public function test(MonHoc $monhoc){
$mon=$monhoc->monTienQuyet->toSql();
dd($mon);
}
it show SQL
select * from `montienquyet` where `montienquyet`.`montq_id` is null and `montienquyet`.`montq_id` is not null
It show null in MySQL because the where clause is the opposite. I don't know why the model export this SQL!
Please help!
laravel laravel-5 eloquent
edited Nov 22 '18 at 8:14
kit
1,1063816
asked Nov 22 '18 at 4:02
the manh Nguyenthe manh Nguyen
4912
add a comment |
0
0
0
I have 3 Models:
MonHoc Model:
class MonHoc extends Model{
protected $table='monhoc' ;
protected $fillable = [
'mamh', 'phuongthucgiangday', 'tenmh','tinchitichluy','tinchihocphi','hockydenghi',
];
public function monTienQuyet(){
return $this->hasMany('AppMonTQ','montq_id','id');
}
public function monTuyChon(){
return $this->hasMany('AppMonTC','montc_id','id');
}
}
MonTC model:
class MonTC extends Model{
protected $table='monhoc_tuychon' ;
protected $fillable = [
'monhoc_id', 'montc_id',
];
public function monhoc(){
return $this->belongsTo('AppMonHoc','monhoc_id');
}
}
MonTQ model:
class MonTQ extends Model{
protected $table='montienquyet' ;
protected $fillable = [
'monhoc_id', 'montq_id',
];
public function monhoc(){
return $this->belongsTo('AppMonHoc','monhoc_id');
}
}
but when I use MonHoc model in controller:
public function test(MonHoc $monhoc){
$mon=$monhoc->monTienQuyet->toSql();
dd($mon);
}
it show SQL
select * from `montienquyet` where `montienquyet`.`montq_id` is null and `montienquyet`.`montq_id` is not null
It show null in MySQL because the where clause is the opposite. I don't know why the model export this SQL!
Please help!
laravel laravel-5 eloquent
edited Nov 22 '18 at 8:14
kit
1,1063816
asked Nov 22 '18 at 4:02
the manh Nguyenthe manh Nguyen
4912
I have 3 Models:
MonHoc Model:
class MonHoc extends Model{
protected $table='monhoc' ;
protected $fillable = [
'mamh', 'phuongthucgiangday', 'tenmh','tinchitichluy','tinchihocphi','hockydenghi',
];
public function monTienQuyet(){
return $this->hasMany('AppMonTQ','montq_id','id');
}
public function monTuyChon(){
return $this->hasMany('AppMonTC','montc_id','id');
}
}
MonTC model:
class MonTC extends Model{
protected $table='monhoc_tuychon' ;
protected $fillable = [
'monhoc_id', 'montc_id',
];
public function monhoc(){
return $this->belongsTo('AppMonHoc','monhoc_id');
}
}
MonTQ model:
class MonTQ extends Model{
protected $table='montienquyet' ;
protected $fillable = [
'monhoc_id', 'montq_id',
];
public function monhoc(){
return $this->belongsTo('AppMonHoc','monhoc_id');
}
}
but when I use MonHoc model in controller:
public function test(MonHoc $monhoc){
$mon=$monhoc->monTienQuyet->toSql();
dd($mon);
}
it show SQL
select * from `montienquyet` where `montienquyet`.`montq_id` is null and `montienquyet`.`montq_id` is not null
It show null in MySQL because the where clause is the opposite. I don't know why the model export this SQL!
Please help!
laravel laravel-5 eloquent
laravel laravel-5 eloquent
edited Nov 22 '18 at 8:14
kit
1,1063816
asked Nov 22 '18 at 4:02
the manh Nguyenthe manh Nguyen
4912
edited Nov 22 '18 at 8:14
kit
1,1063816
asked Nov 22 '18 at 4:02
the manh Nguyenthe manh Nguyen
4912
edited Nov 22 '18 at 8:14
kit
1,1063816
edited Nov 22 '18 at 8:14
kit
1,1063816
edited Nov 22 '18 at 8:14
kit
1,1063816
1,1063816
asked Nov 22 '18 at 4:02
the manh Nguyenthe manh Nguyen
4912
asked Nov 22 '18 at 4:02
the manh Nguyenthe manh Nguyen
4912
asked Nov 22 '18 at 4:02
the manh Nguyenthe manh Nguyen
4912
4912
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
0
Please try this one:
For hasMany:
return $this->hasMany(MonTC::class, 'montc_id');
For belongsTo:
return $this->belongsTo(MonHoc::class, 'monhoc_id');
Another solution is:
return $this->hasMany('AppModelsMonTC', 'montc_id');
And
return $this->belongsTo('AppModelsMonHoc', 'monhoc_id');
answered Nov 22 '18 at 5:04
Madhuri PatelMadhuri Patel
875517
it is same my model, and it show the same sql
– the manh Nguyen
Nov 22 '18 at 5:31
which solution?
– Madhuri Patel
Nov 22 '18 at 5:32
first solution, second solution will export error
– the manh Nguyen
Nov 22 '18 at 5:35
please adduse IlluminateDatabaseEloquentModel;before the class started.
– Madhuri Patel
Nov 22 '18 at 5:38
also add below code after class declaration:protected $fillable = [ 'monhoc_id','montc_id'];
– Madhuri Patel
Nov 22 '18 at 5:40
|
show 3 more comments
0
Check this:
public function test(MonHoc $monhoc){
$monhoc = $monhoc->find(1) //the id that exists
$mon=$monhoc->monTienQuyet;
dd($mon);
}
answered Nov 22 '18 at 9:49
shahabphpshahabphp
1115
add a comment |
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
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53423704%2feloquent-orm-relationship-always-return-null-in-laravel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
0
Please try this one:
For hasMany:
return $this->hasMany(MonTC::class, 'montc_id');
For belongsTo:
return $this->belongsTo(MonHoc::class, 'monhoc_id');
Another solution is:
return $this->hasMany('AppModelsMonTC', 'montc_id');
And
return $this->belongsTo('AppModelsMonHoc', 'monhoc_id');
answered Nov 22 '18 at 5:04
Madhuri PatelMadhuri Patel
875517
it is same my model, and it show the same sql
– the manh Nguyen
Nov 22 '18 at 5:31
which solution?
– Madhuri Patel
Nov 22 '18 at 5:32
first solution, second solution will export error
– the manh Nguyen
Nov 22 '18 at 5:35
please adduse IlluminateDatabaseEloquentModel;before the class started.
– Madhuri Patel
Nov 22 '18 at 5:38
also add below code after class declaration:protected $fillable = [ 'monhoc_id','montc_id'];
– Madhuri Patel
Nov 22 '18 at 5:40
|
show 3 more comments
0
Please try this one:
For hasMany:
return $this->hasMany(MonTC::class, 'montc_id');
For belongsTo:
return $this->belongsTo(MonHoc::class, 'monhoc_id');
Another solution is:
return $this->hasMany('AppModelsMonTC', 'montc_id');
And
return $this->belongsTo('AppModelsMonHoc', 'monhoc_id');
answered Nov 22 '18 at 5:04
Madhuri PatelMadhuri Patel
875517
it is same my model, and it show the same sql
– the manh Nguyen
Nov 22 '18 at 5:31
which solution?
– Madhuri Patel
Nov 22 '18 at 5:32
first solution, second solution will export error
– the manh Nguyen
Nov 22 '18 at 5:35
please adduse IlluminateDatabaseEloquentModel;before the class started.
– Madhuri Patel
Nov 22 '18 at 5:38
also add below code after class declaration:protected $fillable = [ 'monhoc_id','montc_id'];
– Madhuri Patel
Nov 22 '18 at 5:40
|
show 3 more comments
0
0
0
Please try this one:
For hasMany:
return $this->hasMany(MonTC::class, 'montc_id');
For belongsTo:
return $this->belongsTo(MonHoc::class, 'monhoc_id');
Another solution is:
return $this->hasMany('AppModelsMonTC', 'montc_id');
And
return $this->belongsTo('AppModelsMonHoc', 'monhoc_id');
answered Nov 22 '18 at 5:04
Madhuri PatelMadhuri Patel
875517
Please try this one:
For hasMany:
return $this->hasMany(MonTC::class, 'montc_id');
For belongsTo:
return $this->belongsTo(MonHoc::class, 'monhoc_id');
Another solution is:
return $this->hasMany('AppModelsMonTC', 'montc_id');
And
return $this->belongsTo('AppModelsMonHoc', 'monhoc_id');
answered Nov 22 '18 at 5:04
Madhuri PatelMadhuri Patel
875517
edited Nov 22 '18 at 5:15
answered Nov 22 '18 at 5:04
Madhuri PatelMadhuri Patel
875517
answered Nov 22 '18 at 5:04
Madhuri PatelMadhuri Patel
875517
answered Nov 22 '18 at 5:04
Madhuri PatelMadhuri Patel
875517
875517
it is same my model, and it show the same sql
– the manh Nguyen
Nov 22 '18 at 5:31
which solution?
– Madhuri Patel
Nov 22 '18 at 5:32
first solution, second solution will export error
– the manh Nguyen
Nov 22 '18 at 5:35
please adduse IlluminateDatabaseEloquentModel;before the class started.
– Madhuri Patel
Nov 22 '18 at 5:38
also add below code after class declaration:protected $fillable = [ 'monhoc_id','montc_id'];
– Madhuri Patel
Nov 22 '18 at 5:40
|
show 3 more comments
it is same my model, and it show the same sql
– the manh Nguyen
Nov 22 '18 at 5:31
which solution?
– Madhuri Patel
Nov 22 '18 at 5:32
first solution, second solution will export error
– the manh Nguyen
Nov 22 '18 at 5:35
please adduse IlluminateDatabaseEloquentModel;before the class started.
– Madhuri Patel
Nov 22 '18 at 5:38
also add below code after class declaration:protected $fillable = [ 'monhoc_id','montc_id'];
– Madhuri Patel
Nov 22 '18 at 5:40
it is same my model, and it show the same sql
– the manh Nguyen
Nov 22 '18 at 5:31
it is same my model, and it show the same sql
– the manh Nguyen
Nov 22 '18 at 5:31
which solution?
– Madhuri Patel
Nov 22 '18 at 5:32
which solution?
– Madhuri Patel
Nov 22 '18 at 5:32
first solution, second solution will export error
– the manh Nguyen
Nov 22 '18 at 5:35
first solution, second solution will export error
– the manh Nguyen
Nov 22 '18 at 5:35
please add
use IlluminateDatabaseEloquentModel; before the class started.– Madhuri Patel
Nov 22 '18 at 5:38
please add
use IlluminateDatabaseEloquentModel; before the class started.– Madhuri Patel
Nov 22 '18 at 5:38
also add below code after class declaration:
protected $fillable = [ 'monhoc_id','montc_id'];– Madhuri Patel
Nov 22 '18 at 5:40
also add below code after class declaration:
protected $fillable = [ 'monhoc_id','montc_id'];– Madhuri Patel
Nov 22 '18 at 5:40
|
show 3 more comments
0
Check this:
public function test(MonHoc $monhoc){
$monhoc = $monhoc->find(1) //the id that exists
$mon=$monhoc->monTienQuyet;
dd($mon);
}
answered Nov 22 '18 at 9:49
shahabphpshahabphp
1115
add a comment |
0
Check this:
public function test(MonHoc $monhoc){
$monhoc = $monhoc->find(1) //the id that exists
$mon=$monhoc->monTienQuyet;
dd($mon);
}
answered Nov 22 '18 at 9:49
shahabphpshahabphp
1115
add a comment |
0
0
0
Check this:
public function test(MonHoc $monhoc){
$monhoc = $monhoc->find(1) //the id that exists
$mon=$monhoc->monTienQuyet;
dd($mon);
}
answered Nov 22 '18 at 9:49
shahabphpshahabphp
1115
Check this:
public function test(MonHoc $monhoc){
$monhoc = $monhoc->find(1) //the id that exists
$mon=$monhoc->monTienQuyet;
dd($mon);
}
answered Nov 22 '18 at 9:49
shahabphpshahabphp
1115
answered Nov 22 '18 at 9:49
shahabphpshahabphp
1115
answered Nov 22 '18 at 9:49
shahabphpshahabphp
1115
answered Nov 22 '18 at 9:49
shahabphpshahabphp
1115
1115
add a comment |
add a comment |
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
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53423704%2feloquent-orm-relationship-always-return-null-in-laravel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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
