How to Insert multiple values on multiple column with laravel?

Question

I'm kinda new to Laravel, I ran into some problems with inserting multiple select to multiple columns in the database.

Here my view I'm using select picker for multiple select

  <select multiple="multiple"  name=language[] id="language[]" class="selectpicker"  data-selected-text-format="count">
    <option name="En">English</option>
    <option  name="It">Italian</option>
    <option  name="Ar">Arabic</option>                            
    <option  name="Jp">Japanese</option>
    </select>

The languages table:

+----+---------+---------+--------+--------+
| id | English | Italian | Arabic |Japanese|
+----+---------+---------+--------+--------+
|  1 |         |         |        |        |
|  2 |         |         |        |        |
|  3 |         |         |        |        |
+----+---------+---------+--------+--------+

How can I insert data to each column in the controller?
Here what I'm trying to do!

+----+---------+---------+--------+--------+
| id | English | Italian | Arabic |Japanese|
+----+---------+---------+--------+--------+
|  1 |   En    |         |   Ar   |   Jp   |
|  2 |         |    It   |        |        |
|  3 |   En    |         |        |   Jp   |
+----+---------+---------+--------+--------+

Tharaka Dilshan · Accepted Answer · 2019-04-19 15:53:08Z

1

First, make sure the tables id column is set to auto increment. and other columns as nullable.

$languages = request('languages');

DB::table('table_name')->insert([
    'English' => in_array('En', $languages) ? 'En' : null,
    'Italian' => in_array('It', $languages) ? 'It' : null,
    'Arabic' => in_array('Ar', $languages) ? 'Ar' : null,
    'Japanese' => in_array('Jp', $languages) ? 'Jp' : null,
]);

answered Apr 19, 2019 at 15:53

Tharaka Dilshan

4,4993 gold badges17 silver badges29 bronze badges

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

Comments

Zakaria Acharki · Accepted Answer · 2019-04-19 17:23:22Z

0

You'll receive an array language in your controller so you can check if the language exists add it to the DB :

$en = $it = $ar = $jp = null;

if(in_array('En', $language))
    $en = 'En';
if(in_array('It', $language))
    $it = 'It';
if(in_array('Ar', $language))
    $ar = 'Ar';
if(in_array('Jp', $language))
    $jp = 'Jp';

ModelName::insert(['English' => $en, 'Italian' => $it, 'Arabic' => $ar, 'Japanes' => $jp]);

edited Apr 19, 2019 at 17:23

answered Apr 19, 2019 at 13:45

Zakaria Acharki

67.5k15 gold badges79 silver badges106 bronze badges

2 Comments

Sul Alo Over a year ago

thank you for answering i try it and that gave me null inserting for all of them.

Zakaria Acharki Over a year ago

You must debug your code and give me the right specific issue. or you can share with us the content of your controller or just the relevant action code.

Collectives™ on Stack Overflow

How to Insert multiple values on multiple column with laravel?

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related