Assign an array of objects to another object's key in Laravel

Question

I am working on a Q&A app in Laravel. Here, I have two migrations or database tables, one is question_bank and second is answer_choices. There is one to many relation between question and answers table. While retrieving a question, I want to retrieve all of the answers which are related with this question.

For this i wrote a method:

public function getQuestion($id){
    $question=QuestionBank::find($id);
    $answers=AnswerBank::where('question_id','=',$id)->get();
    $question->answers=$answers;
        return Response::json($question);
}

The answer_choices migration is :

class AnswerChoices extends Migration {
public function up()
{
Schema::create('answer_choices', function (Blueprint $table) {
        $table->increments('id');
        $table->integer('question_id')->unsigned();
        $table->mediumtext('answer_text');
        $table->boolean('correct')->nullable();
        $table->foreign('question_id')->references('id')->on('question_bank');
    });
}

public function down()
{
    Schema::drop('answer_choices');
}
}

And the model is :

<?php

class AnswerBank extends \Eloquent {
protected $fillable = [];
protected $table = "answer_choices";
}

Question model is

<?php

class QuestionBank extends \Eloquent {
protected $fillable = [];
protected $table = "question_bank";
}

I expected i will get result as question.answers:[{},{},{}]
but on client side I am getting it like "question.answers":{} as a blank object. When I return only $answers, it shows all the answer objects in the array like [{},{},{]].

How can I get the answers objects as an array of objects in JavaScript?

Sarfraz Ahmad · Accepted Answer · 2014-05-31 12:16:07Z

1

Answer Given by Creator is totally fine just having a small mistake. Corect that and your code will be run.
Change this function

public function answers(){

    return $this->HasMany('AnswerBank','id','question_id');

 }

to

public function answers(){

    return $this->HasMany('AnswerBank','question_id','id');

}

Replace question_id with id and it will work.
And return question object with answers like this

public function getQuestion($id){  
    $answers=QuestionBank::with('answers')->find($id);
    return Response::json($answers);
}

answered May 31, 2014 at 12:16

Sarfraz Ahmad

1,4393 gold badges15 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Laurence · Accepted Answer · 2014-05-26 11:26:29Z

1

There is one to many relation between question and answers table. While retrieving a question, I want to retrieve all of the answers which are related with this question

Since you already have a relationship defined, you just need to Eager Load the relationship when you get the questions, and it will include the answers automatically

public function getQuestion($id){
    $question=QuestionBank::with('answers')->find($id);
    return Response::json($question);
}

answered May 26, 2014 at 11:26

Laurence

60.2k22 gold badges178 silver badges215 bronze badges

8 Comments

Sajid Ahmad Over a year ago

what is with('answers') here?

Laurence Over a year ago

Thats how you Eager Load. Check the link to the official docs I provided.

Sajid Ahmad Over a year ago

okay, means answers in $question=QuestionBank::with('answers')->find($id); is the name of migration. isn't it?

Laurence Over a year ago

'answers' is your relationship between question and answers table. You said you setup the relationship already.

Sajid Ahmad Over a year ago

Schema::create('answer_choices', function (Blueprint $table) {               $table->increments('id');               $table->integer('question_id')->unsigned();               $table->mediumtext('answer_text');               $table->boolean('correct')->nullable();                $table->foreign('question_id')->references('id')->on('question_bank');                   });

This is the table or migration

|

Sajid Ahmad · Accepted Answer · 2014-05-27 06:58:54Z

1

I think you haven't declared any relation in model. It could be the reason for null output. Alright in you QuestionBank first declare a relation and then call

// in model QuestionBank 


public function answers(){

  return $this->HasMany('AnswerBank','id','question_id');

 } 

 // In AnswerBank Model use this

  public function question(){

  return  $this->BelongsTo('QuestionBank');

   }

Now you can get all answers to your question by Calling:

public function getQuestion($id){
  $answers=QuestionBank::with('answers')->find($id);
  return Response::json($answers);
 }

edited May 27, 2014 at 6:58

Sajid Ahmad

1,1445 gold badges18 silver badges42 bronze badges

answered May 26, 2014 at 13:05

Anil Sharma

2,9625 gold badges32 silver badges45 bronze badges

6 Comments

Sajid Ahmad Over a year ago

it is working but returning a blank array for answers

Anil Sharma Over a year ago

have you declared HasMany in your QuestionBank Model?

Sajid Ahmad Over a year ago

Still it is returning empty array. but if i change return $this->HasMany('AnswerBank','id','question_id'); to return $this->belongsTo('AnswerBank','id','question_id'); it return a single answer as an object not array of objects or answers

Anil Sharma Over a year ago

can you show you both table attribute here? according to you one question has many answers . So QuestionBank ->has many AnswerBank. IF this is the case above answer should be working.

Sajid Ahmad Over a year ago

|

Collectives™ on Stack Overflow

Assign an array of objects to another object's key in Laravel

3 Answers 3

Comments

8 Comments

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

8 Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related