title: How to insert array in multiple rows in laravel
body: <p>hi i need to insert an array in a table and i don't know how to do
  i'm using the select2 plugin to select multiple values as tags and insert them in database as an array
  the input looks like this</p>
  
  <pre><code>&lt;select name="designation[]" class="form-control" multiple="multiple" id="select2"&gt;&lt;/select&gt;
  //script
  $('#select2').select2({
          tags: true,
          tokenSeparators: [',', ' '],
          selectOnClose: true
          });
  </code></pre>
  
  <p>EventController </p>
  
  <pre><code>public function store(Request $request){
          $validator = $request-&gt;validate([
              'theme' =&gt; ['required','unique:events,theme'],
          ]);
          $event = Event::create($request-&gt;except('designation'));
          $event-&gt;montant()-&gt;insert($request-&gt;get('designation'));
  
  
          return redirect()-&gt;to(route('admin.event.index'))
          -&gt;withFlashSuccess('L\'éventment a bien etait ajouté');
      }
  </code></pre>
  
  <p>with this code when i submit the form i have this error
  SQLSTATE[42S22]: Column not found: 1054 Unknown column '0' in 'field list' (SQL: insert into <code>event_montants</code> (<code>0</code>, <code>1</code>) values (222, 111))
  event_montant migration</p>
  
  <pre><code>public function up()
      {
          Schema::create('event_montants', function (Blueprint $table) {
              $table-&gt;increments('id');
              $table-&gt;bigInteger('designation');
              $table-&gt;unsignedInteger('event_id');
              $table-&gt;foreign('event_id')-&gt;references('id')-&gt;on('events')
              -&gt;onDelete('cascade');
              $table-&gt;timestamps();
          });
      }
  </code></pre>
  
  <p>please help i need to resolve this</p>