mardi 14 février 2017

Multiple options to questions using eloquent

Im creating a survey app, and basically when a user selects a input type of "select" it appears a option input that can be dynamiclly increase, but that im having some issues in inserting these options in my database, im sugin the sync method to insert these options in my table, but is giving me a error of

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'toufarto.question_id' doesn't exist (SQL: select `option_question_id` from `question_id` where `id` = 11)

Here is my code:

Tables:
questions:
- id;
- input_type;

option_question
- id;
- label_option;
- question_id

My controller:

 public function store(Request $request)
        {

$this->validate($request, array(
            'label_option'             => 'max:255',
            'input_type'            => 'required|integer'
        ));
            $question = new Question(); 
            $question->input_type = $request->input_type;
            $question->save();
            $question->options()->sync($request->option, false);

            Session::flash('success', 'success');

            return back();
        }

My Question Model:

public function options()
    {

        return $this->belongsToMany(OptionQuestion::class,'question_id','id');
    }

My OptionQuestion Model:

class OptionQuestion extends Model
{
    protected $table = "option_question";
}

Note: How i could add the label column to the "sync" method, since i need to insert the label from the option field of the form



from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2ktZrNg
via IFTTT

Aucun commentaire:

Enregistrer un commentaire