How to store item with one-to-many relations into sql-table?

Question

I have any form created on vuetify.js

In this for I have field:

1. Normal input field "Name", will this be stored in the table "person" (model Person, structure: id, name, ...).
2. Multiple select "Languages", should this be stored in the table "persons_languages" (structure: id, person_id, language_id).

1 person can speak more than 1-2-3 languages.

<v-form ref="form" @submit.prevent="addPerson">

<v-row>

    <v-col
        cols="12"
        md="6">
        <v-text-field
            v-model="person.name"
            label="Name">
        </v-text-field>
    </v-col>

    <v-col
        cols="12"
        md="6">
        <v-autocomplete
            chips
            deletable-chips
            multiple
            v-model="???"
            :items="allLanguages"
            :item-text="item =>`${item.name} (${item.local_name})`"
            item-value="id"
            label="Spoken languages">
        </v-autocomplete>
    </v-col>

</v-row>

</v-form>

<script>

export default {

    data() {
        return {
            person: {},

            allLanguages: [
                {
                    "id": 1,
                    "name": "Afar",
                    "code": "aa"
                },
                {
                    "id": 2,
                    "name": "Abkhazian",
                    "code": "ab"
                },
                {
                    "id": 3,
                    "name": "Afrikaans",
                    "code": "af"
                }
            ]
        }
    },

    methods: {
        addPerson() {
            this.axios
                .post('/api/persons', this.person)
                .then(response => {
                    this.$router.push({name: 'indexPersons'});
                })
                .catch(error => console.log(error))
        },
    },
}

</script>

How to store array of selected languages into "persons_languages" with ID of new not yet created person?

Tnx.

Answer 1

One of the way to save one to many relation data is using foreach loop. let you create a person which have 2 languages.

$person= Person::create([
    'name' => 'SOmthing',
]);

Person select 02 languages. $languauges variable have multiple data like:

$languages=[
                {
                    "id": 1,
                    "name": "Afar",
                    "code": "aa"
                },
                {
                    "id": 3,
                    "name": "Afrikaans",
                    "code": "af"
                }
            ]

Use foreach loop to save languages data in person_languages table against person Id create above.

foreach($languages as $lang) {
       PersonLanguage::create([
           'person_id' => $person->id,
            'language_id' => $lang->id
      ]);
}

You may use the create method, which accepts an array of attributes, creates a model, and inserts it into the database. The save/create method will automatically add the appropriate person_id value to the new Personlanguages model.

Read Documentation to more about Save Many and Create Many Save/ Create Many For example one post have many comments.

$post = App\Post::find(1);
 
$post->comments()->createMany([
    [
        'message' => 'A new comment.',
    ],
    [
        'message' => 'Another new comment.',
    ],
]);