How to create associative table in laravel?

drnwork — Wed, 06 Oct 2021 11:16:37 +0000

I want to create associative table , I have Many to Many relationship between L_Examen_Categorie and L_Examen_SousCategorie. My associative table named L_Examen_Categorie_Souscategorie where i am going to insert id_categorie and id_soucsategorie .

By the way I am getting the data from other tables P_Examen_Categorie and P_Examen_SousCategorie

Here is it my code:

$categorie = DB::table('P_Examen_Categorie as p')

            ->where('p.id_examen', '=', $id_examen)

            ->get();

    foreach ($categorie as $cat_item) {

        $l_cat_item = array(
            'code' =&gt; $cat_item-&gt;code,
            'libelle' =&gt; $cat_item-&gt;libelle,
            'id_examen' =&gt; $cat_item-&gt;id_examen,
            'Note' =&gt; $cat_item-&gt;Note,
            'coefficient' =&gt; $cat_item-&gt;coefficient,
            'id_lexamen' =&gt; $id
        );
        L_Examen_Categorie::insert($l_cat_item);
        $idcat=L_Examen_Categorie::get('id');
            $cat_item = DB::table('P_Examen_SousCategorie as p')
                -&gt;select('id', 'code', 'id_categorie', 'libelle', 'Note', 'coefficient')
                -&gt;where('p.id_categorie', '=', $cat_item-&gt;id)
                -&gt;get();


            foreach ($cat_item as $item) {
                $l_souscat_item = array(
                    'code' =&gt; $item-&gt;code,
                    'libelle' =&gt; $item-&gt;libelle,
                    'Note' =&gt; $item-&gt;Note,
                    'coefficient' =&gt; $item-&gt;coefficient,
                    'id_categorie' =&gt; $item-&gt;id_categorie,
                );
                L_Examen_SousCategorie::insert((array)$l_souscat_item);
                $model = array(
                    'id_categorie' =&gt;$cat_item-&gt;id,
                    'id_souscategorie' =&gt;$item-&gt;id,
                );
                L_Examen_Categorie_Souscategorie::insert($model);
            }
    }

DEV Community: drnwork

How to create associative table in laravel?

Laravel #php