{"id":1321,"date":"2024-01-31T06:56:37","date_gmt":"2024-01-31T06:56:37","guid":{"rendered":"https:\/\/blog.uts.ac.id\/jul\/?p=1321"},"modified":"2024-01-31T06:57:44","modified_gmt":"2024-01-31T06:57:44","slug":"laravel-25-relasi-many-to-many-eloquent","status":"publish","type":"post","link":"https:\/\/blog.uts.ac.id\/jul\/2024\/01\/31\/laravel-25-relasi-many-to-many-eloquent\/","title":{"rendered":"Laravel #25 : Relasi Many To Many Eloquent"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"1321\" class=\"elementor elementor-1321\">\n\t\t\t\t\t\t<div class=\"elementor-inner\">\n\t\t\t\t<div class=\"elementor-section-wrap\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5d6286c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5d6286c\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5844b6d\" data-id=\"5844b6d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3663f33 elementor-widget elementor-widget-text-editor\" data-id=\"3663f33\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p>Relasi Many To Many adalah relasi antar table dimana banyak dari masing-masing record tersebut bisa memiliki banyak relasi ke table lainnya.<\/p>\n<h3>Penjelasan<\/h3>\n<p>Untuk tutorial relasi many to many, kita buat contoh dengan misalnya membuat sistem pendataan hadiah untuk pengguna. jadi misalnya kita bisa membuat pendataan untuk masing-masing anggota memiliki\/mendapat hadiah apa saja. dan nanti kita bisa melihat untuk hadiah A, siapa saja pengguna yang mendapatkannya.<\/p>\n<p>Untuk proses relasi many to many seperti ini ada 3 table yang kita butuhkan, katakanlah kita membutuhkan:<\/p>\n<ul>\n<li>table&nbsp;anggota<\/li>\n<li>table&nbsp;hadiah<\/li>\n<li>table&nbsp;anggota_hadiah<\/li>\n<\/ul>\n<p>Table anggota kita gunakan untuk menyimpan data-data anggota, table hadiah untuk menyimpan data-data hadiah.<\/p>\n<p>dan pasti teman-teman bertanya untuk apa kita membuat table anggota_hadiah ? untuk apa gunanya? dan kenapa harus diberi nama dengan anggota_hadiah? kenapa bukan hadiah_anggota atau yang lainnya?<\/p>\n<p>Karena kita akan menghubungkan table anggota dan table hadiah. dan yang menjadi penghubungnya adalah table anggota_hadiah.<\/p>\n<p>di sini table&nbsp;anggota_hadiah&nbsp;juga disebut sebagai&nbsp;<em><strong>pivot table<\/strong><\/em>. yaitu table yang menjadi penghubung beberapa table dalam proses relasi many to many.<\/p>\n<p>untuk penamaannya kenapa kita namakan dengan table anggota_hadiah ? kenapa bukan hadiah_anggota?<\/p>\n<p>karena laravel menerapkan sistem pengurutan alfabet. jadi laravel akan secara otomatis nama table tersebut adalah anggota_hadiah. karena huruf yang diurutkan adalah huruf pertama dari tiap kata. karena huruf&nbsp;A&nbsp;lebih dulu dari pada huruf&nbsp;H, maka jadinya&nbsp;anggota_hadiah.<\/p>\n<div class=\"iklan-produk my-2 border border-2 rounded p-3 my-4 border-primary bg-info bg-opacity-10 border-dashed\">\n<div class=\"row\">\n<div class=\"col-3 col-lg-2 d-flex align-items-center\"><br><\/div><div class=\"col-9 col-lg-10 d-flex align-items-center\">\n<\/div>\n<\/div>\n<\/div>\n<p>Selanjutnya didalam table anggota_hadiah kita akan menyimpan id dari anggota dan id dari hadiah. dan kita beri nama masing-masing kolum nya dengan anggota_id dan hadiah_id.<\/p>\n<p>Oke teman-teman saya rasa teman-teman sudah paham tentang penamaan table ini.<\/p>\n<h3>Persiapan<\/h3>\n<p>Pada tahap ini kita akan membuat table anggota, table hadiah, dan table anggota_hadiah.<\/p>\n<p><strong>table anggota<\/strong><\/p>\n<ul>\n<li>id<\/li>\n<li>nama<\/li>\n<\/ul>\n<p><strong>table hadiah<\/strong><\/p>\n<ul>\n<li>id<\/li>\n<li>nama_hadiah<\/li>\n<\/ul>\n<p><strong>table anggota_hadiah<\/strong><\/p>\n<ul>\n<li>id<\/li>\n<li>anggota_id<\/li>\n<li>hadiah_id<\/li>\n<\/ul>\n<p>Buat ketiga table tersebut lengkap dengan kolumnya seperti yang ada pada list di atas.<\/p>\n<p>Teman-teman bisa membuat table ini seperti cara sebelumnya yang sudah kita pelajari, yaitu menggunakan&nbsp;<a href=\"https:\/\/www.malasngoding.com\/crud-laravel-menggunakan-eloquent\/\" target=\"_blank\" rel=\"noopener\">model<\/a>&nbsp;dan&nbsp;<a href=\"https:\/\/www.malasngoding.com\/migration-laravel\/\" target=\"_blank\" rel=\"noopener\">migration<\/a>. kemudian diikuti dengan&nbsp;<a href=\"https:\/\/www.malasngoding.com\/seeding-dan-faker-pada-laravel\/\" target=\"_blank\" rel=\"noopener\">menginput data dummy menggunakan Faker<\/a>.<\/p>\n<p>Teman-teman bisa mengimport query sql berikut jika ingin cepat. di sini saya sudah membuat ketiga table diatas dan sudah saya isi dengan data dummy menggunakan Seeding Faker.<\/p>\n<p><strong>SQL<\/strong><\/p>\n<div id=\"crayon-65b9ea52f13b4864700998\" class=\"crayon-syntax crayon-theme-classic crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-mouseover\">\n<div class=\"crayon-toolbar\" data-settings=\" show\">\n<div class=\"crayon-tools\">\n<div class=\"crayon-button crayon-nums-button crayon-pressed\" title=\"Toggle Line Numbers\">\n<div class=\"crayon-button-icon\">&nbsp;<\/div>\n<\/div>\n<div class=\"crayon-button crayon-wrap-button\" title=\"Toggle Line Wrap\">\n<div class=\"crayon-button-icon\">&nbsp;<\/div>\n<\/div>\n<div class=\"crayon-button crayon-expand-button\" title=\"Expand Code\">\n<div class=\"crayon-button-icon\">&nbsp;<\/div>\n<\/div>\n<div class=\"crayon-button crayon-popup-button\" title=\"Open Code In New Window\">\n<div class=\"crayon-button-icon\">&nbsp;<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"crayon-plain-wrap\">&nbsp;<\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"show\">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-1\">1<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-2\">2<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-3\">3<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-4\">4<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-5\">5<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-6\">6<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-7\">7<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-8\">8<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-9\">9<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-10\">10<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-11\">11<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-12\">12<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-13\">13<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-14\">14<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-15\">15<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-16\">16<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-17\">17<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-18\">18<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-19\">19<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-20\">20<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-21\">21<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-22\">22<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-23\">23<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-24\">24<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-25\">25<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-26\">26<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-27\">27<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-28\">28<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-29\">29<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-30\">30<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-31\">31<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-32\">32<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-33\">33<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-34\">34<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-35\">35<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-36\">36<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-37\">37<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-38\">38<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-39\">39<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-40\">40<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-41\">41<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-42\">42<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-43\">43<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-44\">44<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-45\">45<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-46\">46<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-47\">47<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-48\">48<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-49\">49<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-50\">50<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-51\">51<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-52\">52<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-53\">53<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-54\">54<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-55\">55<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-56\">56<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-57\">57<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-58\">58<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-59\">59<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-60\">60<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-61\">61<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-62\">62<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-63\">63<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-64\">64<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-65\">65<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-66\">66<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-67\">67<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-68\">68<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-69\">69<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-70\">70<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-71\">71<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-72\">72<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-73\">73<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-74\">74<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-75\">75<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-76\">76<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-77\">77<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-78\">78<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-79\">79<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-80\">80<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-81\">81<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-82\">82<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-83\">83<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-84\">84<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-85\">85<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-86\">86<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-87\">87<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-88\">88<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-89\">89<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-90\">90<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-91\">91<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-92\">92<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-93\">93<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-94\">94<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-95\">95<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-96\">96<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-97\">97<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-98\">98<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-99\">99<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-100\">100<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-101\">101<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-102\">102<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-103\">103<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-104\">104<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-105\">105<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-106\">106<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-107\">107<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-108\">108<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-109\">109<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-110\">110<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-111\">111<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-112\">112<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-113\">113<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-114\">114<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-115\">115<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-116\">116<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-117\">117<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-118\">118<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-119\">119<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-120\">120<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-121\">121<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-122\">122<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-123\">123<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-124\">124<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-125\">125<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-126\">126<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-127\">127<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-128\">128<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-129\">129<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-130\">130<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-131\">131<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-132\">132<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-133\">133<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-134\">134<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-135\">135<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-136\">136<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-137\">137<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-138\">138<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-139\">139<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-140\">140<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-141\">141<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-142\">142<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-143\">143<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-144\">144<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-145\">145<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-146\">146<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-147\">147<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13b4864700998-148\">148<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13b4864700998-149\">149<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-65b9ea52f13b4864700998-1\" class=\"crayon-line\">&#8212; <span class=\"crayon-e\">phpMyAdmin <\/span><span class=\"crayon-e\">SQL <\/span><span class=\"crayon-i\">Dump<\/span><\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-2\" class=\"crayon-line crayon-striped-line\">&#8212; <span class=\"crayon-i\">version<\/span> <span class=\"crayon-cn\">4.8.3<\/span><\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-3\" class=\"crayon-line\">&#8212; <span class=\"crayon-i\">https<\/span>:<span class=\"crayon-c\">\/\/www.phpmyadmin.net\/<\/span><\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-4\" class=\"crayon-line crayon-striped-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-5\" class=\"crayon-line\">&#8212; <span class=\"crayon-i\">Host<\/span>: <span class=\"crayon-i\">localhost<\/span><span class=\"crayon-st\">:<\/span><span class=\"crayon-cn\">3306<\/span><\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-6\" class=\"crayon-line crayon-striped-line\">&#8212; <span class=\"crayon-e\">Generation <\/span><span class=\"crayon-i\">Time<\/span>: <span class=\"crayon-i\">Jan<\/span> <span class=\"crayon-cn\">17<\/span>, <span class=\"crayon-cn\">2019<\/span> <span class=\"crayon-i\">at<\/span> <span class=\"crayon-cn\">08<\/span><span class=\"crayon-st\">:<\/span><span class=\"crayon-cn\">34<\/span> <span class=\"crayon-i\">AM<\/span><\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-7\" class=\"crayon-line\">&#8212; <span class=\"crayon-e\">Server <\/span><span class=\"crayon-i\">version<\/span>: <span class=\"crayon-cn\">5.7.23<\/span><\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-8\" class=\"crayon-line crayon-striped-line\">&#8212; <span class=\"crayon-e\">PHP <\/span><span class=\"crayon-i\">Version<\/span>: <span class=\"crayon-cn\">7.2.10<\/span><\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-9\" class=\"crayon-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-10\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-e\">SET <\/span><span class=\"crayon-i\">SQL_MODE<\/span> = <span class=\"crayon-s\">&#8220;NO_AUTO_VALUE_ON_ZERO&#8221;<\/span>;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-11\" class=\"crayon-line\"><span class=\"crayon-e\">SET <\/span><span class=\"crayon-i\">time_zone<\/span> = <span class=\"crayon-s\">&#8220;+00:00&#8221;<\/span>;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-12\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-13\" class=\"crayon-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-14\" class=\"crayon-line crayon-striped-line\">&#8212; <span class=\"crayon-i\">Database<\/span>: `<span class=\"crayon-i\">belajar_laravel<\/span>`<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-15\" class=\"crayon-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-16\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-17\" class=\"crayon-line\">&#8212; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-18\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-19\" class=\"crayon-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-20\" class=\"crayon-line crayon-striped-line\">&#8212; <span class=\"crayon-e\">Table <\/span><span class=\"crayon-e\">structure <\/span><span class=\"crayon-e\">for <\/span><span class=\"crayon-i\">table<\/span> `<span class=\"crayon-i\">anggota<\/span>`<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-21\" class=\"crayon-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-22\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-23\" class=\"crayon-line\"><span class=\"crayon-e\">CREATE <\/span><span class=\"crayon-i\">TABLE<\/span> `<span class=\"crayon-i\">anggota<\/span>` (<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-24\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&nbsp;&nbsp;<\/span>`<span class=\"crayon-i\">id<\/span>` <span class=\"crayon-e\">int<\/span>(<span class=\"crayon-cn\">10<\/span>) <span class=\"crayon-e\">UNSIGNED <\/span><span class=\"crayon-e\">NOT <\/span><span class=\"crayon-i\">NULL<\/span>,<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-25\" class=\"crayon-line\"><span class=\"crayon-h\">&nbsp;&nbsp;<\/span>`<span class=\"crayon-i\">nama<\/span>` <span class=\"crayon-e\">varchar<\/span>(<span class=\"crayon-cn\">255<\/span>) <span class=\"crayon-e\">COLLATE <\/span><span class=\"crayon-e\">utf8mb4_unicode_ci <\/span><span class=\"crayon-e\">NOT <\/span><span class=\"crayon-i\">NULL<\/span>,<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-26\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&nbsp;&nbsp;<\/span>`<span class=\"crayon-i\">created_at<\/span>` <span class=\"crayon-e\">timestamp <\/span><span class=\"crayon-e\">NULL <\/span><span class=\"crayon-e\">DEFAULT <\/span><span class=\"crayon-i\">NULL<\/span>,<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-27\" class=\"crayon-line\"><span class=\"crayon-h\">&nbsp;&nbsp;<\/span>`<span class=\"crayon-i\">updated_at<\/span>` <span class=\"crayon-e\">timestamp <\/span><span class=\"crayon-e\">NULL <\/span><span class=\"crayon-e\">DEFAULT <\/span><span class=\"crayon-i\">NULL<\/span><\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-28\" class=\"crayon-line crayon-striped-line\">) <span class=\"crayon-i\">ENGINE<\/span>=<span class=\"crayon-e\">InnoDB <\/span><span class=\"crayon-e\">DEFAULT <\/span><span class=\"crayon-i\">CHARSET<\/span>=<span class=\"crayon-e\">utf8mb4 <\/span><span class=\"crayon-i\">COLLATE<\/span>=<span class=\"crayon-i\">utf8mb4_unicode_ci<\/span>;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-29\" class=\"crayon-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-30\" class=\"crayon-line crayon-striped-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-31\" class=\"crayon-line\">&#8212; <span class=\"crayon-e\">Dumping <\/span><span class=\"crayon-e\">data <\/span><span class=\"crayon-e\">for <\/span><span class=\"crayon-i\">table<\/span> `<span class=\"crayon-i\">anggota<\/span>`<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-32\" class=\"crayon-line crayon-striped-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-33\" class=\"crayon-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-34\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-e\">INSERT <\/span><span class=\"crayon-i\">INTO<\/span> `<span class=\"crayon-i\">anggota<\/span>` (`<span class=\"crayon-i\">id<\/span>`, `<span class=\"crayon-i\">nama<\/span>`, `<span class=\"crayon-i\">created_at<\/span>`, `<span class=\"crayon-i\">updated_at<\/span>`) <span class=\"crayon-e\">VALUES<\/span><\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-35\" class=\"crayon-line\">(<span class=\"crayon-cn\">1<\/span>, <span class=\"crayon-s\">&#8216;Sari Tania Puspita&#8217;<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-36\" class=\"crayon-line crayon-striped-line\">(<span class=\"crayon-cn\">2<\/span>, <span class=\"crayon-s\">&#8216;Diki Alfarabi Hadi&#8217;<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-37\" class=\"crayon-line\">(<span class=\"crayon-cn\">3<\/span>, <span class=\"crayon-s\">&#8216;Luluh Sinaga&#8217;<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-38\" class=\"crayon-line crayon-striped-line\">(<span class=\"crayon-cn\">4<\/span>, <span class=\"crayon-s\">&#8216;Lamar Putra&#8217;<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-39\" class=\"crayon-line\">(<span class=\"crayon-cn\">5<\/span>, <span class=\"crayon-s\">&#8216;Banawi Kuswoyo&#8217;<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-40\" class=\"crayon-line crayon-striped-line\">(<span class=\"crayon-cn\">6<\/span>, <span class=\"crayon-s\">&#8216;Ratih Wijayanti&#8217;<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>);<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-41\" class=\"crayon-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-42\" class=\"crayon-line crayon-striped-line\">&#8212; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-43\" class=\"crayon-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-44\" class=\"crayon-line crayon-striped-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-45\" class=\"crayon-line\">&#8212; <span class=\"crayon-e\">Table <\/span><span class=\"crayon-e\">structure <\/span><span class=\"crayon-e\">for <\/span><span class=\"crayon-i\">table<\/span> `<span class=\"crayon-i\">anggota_hadiah<\/span>`<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-46\" class=\"crayon-line crayon-striped-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-47\" class=\"crayon-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-48\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-e\">CREATE <\/span><span class=\"crayon-i\">TABLE<\/span> `<span class=\"crayon-i\">anggota_hadiah<\/span>` (<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-49\" class=\"crayon-line\"><span class=\"crayon-h\">&nbsp;&nbsp;<\/span>`<span class=\"crayon-i\">id<\/span>` <span class=\"crayon-e\">int<\/span>(<span class=\"crayon-cn\">10<\/span>) <span class=\"crayon-e\">UNSIGNED <\/span><span class=\"crayon-e\">NOT <\/span><span class=\"crayon-i\">NULL<\/span>,<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-50\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&nbsp;&nbsp;<\/span>`<span class=\"crayon-i\">anggota_id<\/span>` <span class=\"crayon-e\">int<\/span>(<span class=\"crayon-cn\">10<\/span>) <span class=\"crayon-e\">UNSIGNED <\/span><span class=\"crayon-e\">NOT <\/span><span class=\"crayon-i\">NULL<\/span>,<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-51\" class=\"crayon-line\"><span class=\"crayon-h\">&nbsp;&nbsp;<\/span>`<span class=\"crayon-i\">hadiah_id<\/span>` <span class=\"crayon-e\">int<\/span>(<span class=\"crayon-cn\">10<\/span>) <span class=\"crayon-e\">UNSIGNED <\/span><span class=\"crayon-e\">NOT <\/span><span class=\"crayon-i\">NULL<\/span>,<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-52\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&nbsp;&nbsp;<\/span>`<span class=\"crayon-i\">created_at<\/span>` <span class=\"crayon-e\">timestamp <\/span><span class=\"crayon-e\">NULL <\/span><span class=\"crayon-e\">DEFAULT <\/span><span class=\"crayon-i\">NULL<\/span>,<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-53\" class=\"crayon-line\"><span class=\"crayon-h\">&nbsp;&nbsp;<\/span>`<span class=\"crayon-i\">updated_at<\/span>` <span class=\"crayon-e\">timestamp <\/span><span class=\"crayon-e\">NULL <\/span><span class=\"crayon-e\">DEFAULT <\/span><span class=\"crayon-i\">NULL<\/span><\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-54\" class=\"crayon-line crayon-striped-line\">) <span class=\"crayon-i\">ENGINE<\/span>=<span class=\"crayon-e\">InnoDB <\/span><span class=\"crayon-e\">DEFAULT <\/span><span class=\"crayon-i\">CHARSET<\/span>=<span class=\"crayon-e\">utf8mb4 <\/span><span class=\"crayon-i\">COLLATE<\/span>=<span class=\"crayon-i\">utf8mb4_unicode_ci<\/span>;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-55\" class=\"crayon-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-56\" class=\"crayon-line crayon-striped-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-57\" class=\"crayon-line\">&#8212; <span class=\"crayon-e\">Dumping <\/span><span class=\"crayon-e\">data <\/span><span class=\"crayon-e\">for <\/span><span class=\"crayon-i\">table<\/span> `<span class=\"crayon-i\">anggota_hadiah<\/span>`<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-58\" class=\"crayon-line crayon-striped-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-59\" class=\"crayon-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-60\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-e\">INSERT <\/span><span class=\"crayon-i\">INTO<\/span> `<span class=\"crayon-i\">anggota_hadiah<\/span>` (`<span class=\"crayon-i\">id<\/span>`, `<span class=\"crayon-i\">anggota_id<\/span>`, `<span class=\"crayon-i\">hadiah_id<\/span>`, `<span class=\"crayon-i\">created_at<\/span>`, `<span class=\"crayon-i\">updated_at<\/span>`) <span class=\"crayon-e\">VALUES<\/span><\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-61\" class=\"crayon-line\">(<span class=\"crayon-cn\">1<\/span>, <span class=\"crayon-cn\">6<\/span>, <span class=\"crayon-cn\">6<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-62\" class=\"crayon-line crayon-striped-line\">(<span class=\"crayon-cn\">2<\/span>, <span class=\"crayon-cn\">2<\/span>, <span class=\"crayon-cn\">5<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-63\" class=\"crayon-line\">(<span class=\"crayon-cn\">3<\/span>, <span class=\"crayon-cn\">6<\/span>, <span class=\"crayon-cn\">10<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-64\" class=\"crayon-line crayon-striped-line\">(<span class=\"crayon-cn\">4<\/span>, <span class=\"crayon-cn\">3<\/span>, <span class=\"crayon-cn\">4<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-65\" class=\"crayon-line\">(<span class=\"crayon-cn\">5<\/span>, <span class=\"crayon-cn\">3<\/span>, <span class=\"crayon-cn\">6<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-66\" class=\"crayon-line crayon-striped-line\">(<span class=\"crayon-cn\">6<\/span>, <span class=\"crayon-cn\">1<\/span>, <span class=\"crayon-cn\">4<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-67\" class=\"crayon-line\">(<span class=\"crayon-cn\">7<\/span>, <span class=\"crayon-cn\">4<\/span>, <span class=\"crayon-cn\">11<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-68\" class=\"crayon-line crayon-striped-line\">(<span class=\"crayon-cn\">8<\/span>, <span class=\"crayon-cn\">5<\/span>, <span class=\"crayon-cn\">5<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-69\" class=\"crayon-line\">(<span class=\"crayon-cn\">9<\/span>, <span class=\"crayon-cn\">2<\/span>, <span class=\"crayon-cn\">9<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-70\" class=\"crayon-line crayon-striped-line\">(<span class=\"crayon-cn\">10<\/span>, <span class=\"crayon-cn\">6<\/span>, <span class=\"crayon-cn\">6<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-71\" class=\"crayon-line\">(<span class=\"crayon-cn\">11<\/span>, <span class=\"crayon-cn\">3<\/span>, <span class=\"crayon-cn\">2<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-72\" class=\"crayon-line crayon-striped-line\">(<span class=\"crayon-cn\">12<\/span>, <span class=\"crayon-cn\">2<\/span>, <span class=\"crayon-cn\">3<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-73\" class=\"crayon-line\">(<span class=\"crayon-cn\">13<\/span>, <span class=\"crayon-cn\">1<\/span>, <span class=\"crayon-cn\">8<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-74\" class=\"crayon-line crayon-striped-line\">(<span class=\"crayon-cn\">14<\/span>, <span class=\"crayon-cn\">6<\/span>, <span class=\"crayon-cn\">8<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-75\" class=\"crayon-line\">(<span class=\"crayon-cn\">15<\/span>, <span class=\"crayon-cn\">3<\/span>, <span class=\"crayon-cn\">2<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>);<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-76\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-77\" class=\"crayon-line\">&#8212; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-78\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-79\" class=\"crayon-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-80\" class=\"crayon-line crayon-striped-line\">&#8212; <span class=\"crayon-e\">Table <\/span><span class=\"crayon-e\">structure <\/span><span class=\"crayon-e\">for <\/span><span class=\"crayon-i\">table<\/span> `<span class=\"crayon-i\">hadiah<\/span>`<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-81\" class=\"crayon-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-82\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-83\" class=\"crayon-line\"><span class=\"crayon-e\">CREATE <\/span><span class=\"crayon-i\">TABLE<\/span> `<span class=\"crayon-i\">hadiah<\/span>` (<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-84\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&nbsp;&nbsp;<\/span>`<span class=\"crayon-i\">id<\/span>` <span class=\"crayon-e\">int<\/span>(<span class=\"crayon-cn\">10<\/span>) <span class=\"crayon-e\">UNSIGNED <\/span><span class=\"crayon-e\">NOT <\/span><span class=\"crayon-i\">NULL<\/span>,<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-85\" class=\"crayon-line\"><span class=\"crayon-h\">&nbsp;&nbsp;<\/span>`<span class=\"crayon-i\">nama_hadiah<\/span>` <span class=\"crayon-e\">varchar<\/span>(<span class=\"crayon-cn\">255<\/span>) <span class=\"crayon-e\">COLLATE <\/span><span class=\"crayon-e\">utf8mb4_unicode_ci <\/span><span class=\"crayon-e\">NOT <\/span><span class=\"crayon-i\">NULL<\/span>,<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-86\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&nbsp;&nbsp;<\/span>`<span class=\"crayon-i\">created_at<\/span>` <span class=\"crayon-e\">timestamp <\/span><span class=\"crayon-e\">NULL <\/span><span class=\"crayon-e\">DEFAULT <\/span><span class=\"crayon-i\">NULL<\/span>,<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-87\" class=\"crayon-line\"><span class=\"crayon-h\">&nbsp;&nbsp;<\/span>`<span class=\"crayon-i\">updated_at<\/span>` <span class=\"crayon-e\">timestamp <\/span><span class=\"crayon-e\">NULL <\/span><span class=\"crayon-e\">DEFAULT <\/span><span class=\"crayon-i\">NULL<\/span><\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-88\" class=\"crayon-line crayon-striped-line\">) <span class=\"crayon-i\">ENGINE<\/span>=<span class=\"crayon-e\">InnoDB <\/span><span class=\"crayon-e\">DEFAULT <\/span><span class=\"crayon-i\">CHARSET<\/span>=<span class=\"crayon-e\">utf8mb4 <\/span><span class=\"crayon-i\">COLLATE<\/span>=<span class=\"crayon-i\">utf8mb4_unicode_ci<\/span>;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-89\" class=\"crayon-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-90\" class=\"crayon-line crayon-striped-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-91\" class=\"crayon-line\">&#8212; <span class=\"crayon-e\">Dumping <\/span><span class=\"crayon-e\">data <\/span><span class=\"crayon-e\">for <\/span><span class=\"crayon-i\">table<\/span> `<span class=\"crayon-i\">hadiah<\/span>`<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-92\" class=\"crayon-line crayon-striped-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-93\" class=\"crayon-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-94\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-e\">INSERT <\/span><span class=\"crayon-i\">INTO<\/span> `<span class=\"crayon-i\">hadiah<\/span>` (`<span class=\"crayon-i\">id<\/span>`, `<span class=\"crayon-i\">nama_hadiah<\/span>`, `<span class=\"crayon-i\">created_at<\/span>`, `<span class=\"crayon-i\">updated_at<\/span>`) <span class=\"crayon-e\">VALUES<\/span><\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-95\" class=\"crayon-line\">(<span class=\"crayon-cn\">1<\/span>, <span class=\"crayon-s\">&#8216;Kulkas&#8217;<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-96\" class=\"crayon-line crayon-striped-line\">(<span class=\"crayon-cn\">2<\/span>, <span class=\"crayon-s\">&#8216;Lemari&#8217;<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-97\" class=\"crayon-line\">(<span class=\"crayon-cn\">3<\/span>, <span class=\"crayon-s\">&#8216;Rumah&#8217;<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-98\" class=\"crayon-line crayon-striped-line\">(<span class=\"crayon-cn\">4<\/span>, <span class=\"crayon-s\">&#8216;Mobil&#8217;<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-99\" class=\"crayon-line\">(<span class=\"crayon-cn\">5<\/span>, <span class=\"crayon-s\">&#8216;Sepeda Motor&#8217;<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-100\" class=\"crayon-line crayon-striped-line\">(<span class=\"crayon-cn\">6<\/span>, <span class=\"crayon-s\">&#8216;Pulpen&#8217;<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-101\" class=\"crayon-line\">(<span class=\"crayon-cn\">7<\/span>, <span class=\"crayon-s\">&#8216;Tas&#8217;<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-102\" class=\"crayon-line crayon-striped-line\">(<span class=\"crayon-cn\">8<\/span>, <span class=\"crayon-s\">&#8216;Sepatu&#8217;<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-103\" class=\"crayon-line\">(<span class=\"crayon-cn\">9<\/span>, <span class=\"crayon-s\">&#8216;Voucher&#8217;<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-104\" class=\"crayon-line crayon-striped-line\">(<span class=\"crayon-cn\">10<\/span>, <span class=\"crayon-s\">&#8216;Mouse&#8217;<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-105\" class=\"crayon-line\">(<span class=\"crayon-cn\">11<\/span>, <span class=\"crayon-s\">&#8216;Laptop&#8217;<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>);<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-106\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-107\" class=\"crayon-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-108\" class=\"crayon-line crayon-striped-line\">&#8212; <span class=\"crayon-e\">Indexes <\/span><span class=\"crayon-e\">for <\/span><span class=\"crayon-e\">dumped <\/span><span class=\"crayon-i\">tables<\/span><\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-109\" class=\"crayon-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-110\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-111\" class=\"crayon-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-112\" class=\"crayon-line crayon-striped-line\">&#8212; <span class=\"crayon-e\">Indexes <\/span><span class=\"crayon-e\">for <\/span><span class=\"crayon-i\">table<\/span> `<span class=\"crayon-i\">anggota<\/span>`<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-113\" class=\"crayon-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-114\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-e\">ALTER <\/span><span class=\"crayon-i\">TABLE<\/span> `<span class=\"crayon-i\">anggota<\/span>`<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-115\" class=\"crayon-line\"><span class=\"crayon-h\">&nbsp;&nbsp;<\/span><span class=\"crayon-e\">ADD <\/span><span class=\"crayon-e\">PRIMARY <\/span><span class=\"crayon-e\">KEY<\/span> (`<span class=\"crayon-i\">id<\/span>`);<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-116\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-117\" class=\"crayon-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-118\" class=\"crayon-line crayon-striped-line\">&#8212; <span class=\"crayon-e\">Indexes <\/span><span class=\"crayon-e\">for <\/span><span class=\"crayon-i\">table<\/span> `<span class=\"crayon-i\">anggota_hadiah<\/span>`<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-119\" class=\"crayon-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-120\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-e\">ALTER <\/span><span class=\"crayon-i\">TABLE<\/span> `<span class=\"crayon-i\">anggota_hadiah<\/span>`<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-121\" class=\"crayon-line\"><span class=\"crayon-h\">&nbsp;&nbsp;<\/span><span class=\"crayon-e\">ADD <\/span><span class=\"crayon-e\">PRIMARY <\/span><span class=\"crayon-e\">KEY<\/span> (`<span class=\"crayon-i\">id<\/span>`);<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-122\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-123\" class=\"crayon-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-124\" class=\"crayon-line crayon-striped-line\">&#8212; <span class=\"crayon-e\">Indexes <\/span><span class=\"crayon-e\">for <\/span><span class=\"crayon-i\">table<\/span> `<span class=\"crayon-i\">hadiah<\/span>`<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-125\" class=\"crayon-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-126\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-e\">ALTER <\/span><span class=\"crayon-i\">TABLE<\/span> `<span class=\"crayon-i\">hadiah<\/span>`<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-127\" class=\"crayon-line\"><span class=\"crayon-h\">&nbsp;&nbsp;<\/span><span class=\"crayon-e\">ADD <\/span><span class=\"crayon-e\">PRIMARY <\/span><span class=\"crayon-e\">KEY<\/span> (`<span class=\"crayon-i\">id<\/span>`);<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-128\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-129\" class=\"crayon-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-130\" class=\"crayon-line crayon-striped-line\">&#8212; <span class=\"crayon-e\">AUTO_INCREMENT <\/span><span class=\"crayon-e\">for <\/span><span class=\"crayon-e\">dumped <\/span><span class=\"crayon-i\">tables<\/span><\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-131\" class=\"crayon-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-132\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-133\" class=\"crayon-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-134\" class=\"crayon-line crayon-striped-line\">&#8212; <span class=\"crayon-e\">AUTO_INCREMENT <\/span><span class=\"crayon-e\">for <\/span><span class=\"crayon-i\">table<\/span> `<span class=\"crayon-i\">anggota<\/span>`<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-135\" class=\"crayon-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-136\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-e\">ALTER <\/span><span class=\"crayon-i\">TABLE<\/span> `<span class=\"crayon-i\">anggota<\/span>`<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-137\" class=\"crayon-line\"><span class=\"crayon-h\">&nbsp;&nbsp;<\/span><span class=\"crayon-i\">MODIFY<\/span> `<span class=\"crayon-i\">id<\/span>` <span class=\"crayon-e\">int<\/span>(<span class=\"crayon-cn\">10<\/span>) <span class=\"crayon-e\">UNSIGNED <\/span><span class=\"crayon-e\">NOT <\/span><span class=\"crayon-e\">NULL <\/span><span class=\"crayon-i\">AUTO_INCREMENT<\/span>, <span class=\"crayon-i\">AUTO_INCREMENT<\/span>=<span class=\"crayon-cn\">9<\/span>;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-138\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-139\" class=\"crayon-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-140\" class=\"crayon-line crayon-striped-line\">&#8212; <span class=\"crayon-e\">AUTO_INCREMENT <\/span><span class=\"crayon-e\">for <\/span><span class=\"crayon-i\">table<\/span> `<span class=\"crayon-i\">anggota_hadiah<\/span>`<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-141\" class=\"crayon-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-142\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-e\">ALTER <\/span><span class=\"crayon-i\">TABLE<\/span> `<span class=\"crayon-i\">anggota_hadiah<\/span>`<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-143\" class=\"crayon-line\"><span class=\"crayon-h\">&nbsp;&nbsp;<\/span><span class=\"crayon-i\">MODIFY<\/span> `<span class=\"crayon-i\">id<\/span>` <span class=\"crayon-e\">int<\/span>(<span class=\"crayon-cn\">10<\/span>) <span class=\"crayon-e\">UNSIGNED <\/span><span class=\"crayon-e\">NOT <\/span><span class=\"crayon-e\">NULL <\/span><span class=\"crayon-i\">AUTO_INCREMENT<\/span>, <span class=\"crayon-i\">AUTO_INCREMENT<\/span>=<span class=\"crayon-cn\">16<\/span>;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-144\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-145\" class=\"crayon-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-146\" class=\"crayon-line crayon-striped-line\">&#8212; <span class=\"crayon-e\">AUTO_INCREMENT <\/span><span class=\"crayon-e\">for <\/span><span class=\"crayon-i\">table<\/span> `<span class=\"crayon-i\">hadiah<\/span>`<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-147\" class=\"crayon-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-148\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-e\">ALTER <\/span><span class=\"crayon-i\">TABLE<\/span> `<span class=\"crayon-i\">hadiah<\/span>`<\/div>\n<div id=\"crayon-65b9ea52f13b4864700998-149\" class=\"crayon-line\"><span class=\"crayon-h\">&nbsp;&nbsp;<\/span><span class=\"crayon-i\">MODIFY<\/span> `<span class=\"crayon-i\">id<\/span>` <span class=\"crayon-e\">int<\/span>(<span class=\"crayon-cn\">10<\/span>) <span class=\"crayon-e\">UNSIGNED <\/span><span class=\"crayon-e\">NOT <\/span><span class=\"crayon-e\">NULL <\/span><span class=\"crayon-i\">AUTO_INCREMENT<\/span>, <span class=\"crayon-i\">AUTO_INCREMENT<\/span>=<span class=\"crayon-cn\">12<\/span>;<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>jangan lupa&nbsp;<a href=\"https:\/\/www.malasngoding.com\/konfigurasi-dasar-pada-laravel\/\" target=\"_blank\" rel=\"noopener\">mengatur koneksi database laravel<\/a>&nbsp;pada file&nbsp;<strong>.env<\/strong>.<\/p>\n<p>Sampai di sini kita telah mempunyai 3 buah table.<\/p>\n<div id=\"attachment_3579\" class=\"wp-caption aligncenter\"><p><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-3579 jetpack-lazy-image jetpack-lazy-image--handled\" src=\"https:\/\/www.malasngoding.com\/wp-content\/uploads\/2019\/01\/relasi-many-to-many-eloquent.jpg\" alt=\"relasi many to many eloquent\" width=\"679\" height=\"453\" aria-describedby=\"caption-attachment-3579\" data-lazy-loaded=\"1\"><\/p>\n<p id=\"caption-attachment-3579\" class=\"wp-caption-text\">relasi many to many eloquent<\/p>\n<\/div>\n<p>Perhatikan pada gambar di atas,<\/p>\n<p>pada table anggota_hadiah kita hubungkan antara kedua buah table lainnya. pada table anggota_hadiah kita hanya menyimpan data id anggota dan id hadiah. misalnya data yang pertama ada ratih wijayanti (id 6) memilik hadiah pulpen (id 6) dan seterusnya. jadi ingat, hanya id nya saja yang kita simpan.<\/p>\n<h3>Model<\/h3>\n<p>Pastikan kita telah memiliki model untuk anggota dan hadiah. jika belum silahkan teman-teman buat dulu kedua model tersebut.<\/p>\n<p>php artisan make:model Anggota<\/p>\n<p>dan<\/p>\n<p>php artisan make:model Hadiah<\/p>\n<p>Pada model Anggota.php, hubungkan dengan model\/table hadiah.<\/p>\n<p><strong>belajar_laravel\/app\/Anggota.php<\/strong><\/p>\n<div id=\"crayon-65b9ea52f13bc006054523\" class=\"crayon-syntax crayon-theme-classic crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-mouseover\">\n<div class=\"crayon-toolbar\" data-settings=\" show\">\n<div class=\"crayon-tools\">\n<div class=\"crayon-button crayon-nums-button crayon-pressed\" title=\"Toggle Line Numbers\">\n<div class=\"crayon-button-icon\">&nbsp;<\/div>\n<\/div>\n<div class=\"crayon-button crayon-wrap-button\" title=\"Toggle Line Wrap\">\n<div class=\"crayon-button-icon\">&nbsp;<\/div>\n<\/div>\n<div class=\"crayon-button crayon-popup-button\" title=\"Open Code In New Window\">\n<div class=\"crayon-button-icon\">&nbsp;<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"crayon-plain-wrap\">&nbsp;<\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"show\">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13bc006054523-1\">1<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13bc006054523-2\">2<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13bc006054523-3\">3<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13bc006054523-4\">4<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13bc006054523-5\">5<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13bc006054523-6\">6<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13bc006054523-7\">7<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13bc006054523-8\">8<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13bc006054523-9\">9<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13bc006054523-10\">10<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13bc006054523-11\">11<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13bc006054523-12\">12<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13bc006054523-13\">13<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13bc006054523-14\">14<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13bc006054523-15\">15<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-65b9ea52f13bc006054523-1\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span>?<span class=\"crayon-e\">php<\/span><\/div>\n<div id=\"crayon-65b9ea52f13bc006054523-2\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13bc006054523-3\" class=\"crayon-line\"><span class=\"crayon-e\">namespace <\/span><span class=\"crayon-i\">App<\/span>;<\/div>\n<div id=\"crayon-65b9ea52f13bc006054523-4\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13bc006054523-5\" class=\"crayon-line\"><span class=\"crayon-e\">use <\/span><span class=\"crayon-i\">Illuminate<\/span>\\<span class=\"crayon-i\">Database<\/span>\\<span class=\"crayon-i\">Eloquent<\/span>\\<span class=\"crayon-i\">Model<\/span>;<\/div>\n<div id=\"crayon-65b9ea52f13bc006054523-6\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13bc006054523-7\" class=\"crayon-line\"><span class=\"crayon-e\">class<\/span> <span class=\"crayon-e\">Anggota<\/span> <span class=\"crayon-e\">extends<\/span> <span class=\"crayon-e\">Model<\/span><\/div>\n<div id=\"crayon-65b9ea52f13bc006054523-8\" class=\"crayon-line crayon-striped-line\">{<\/div>\n<div id=\"crayon-65b9ea52f13bc006054523-9\" class=\"crayon-line\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span class=\"crayon-i\">protected<\/span> $<span class=\"crayon-i\">table<\/span> = <span class=\"crayon-s\">&#8220;anggota&#8221;<\/span>;<\/div>\n<div id=\"crayon-65b9ea52f13bc006054523-10\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13bc006054523-11\" class=\"crayon-line\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span class=\"crayon-e\">public <\/span><span class=\"crayon-e\">function <\/span><span class=\"crayon-e\">hadiah<\/span>()<\/div>\n<div id=\"crayon-65b9ea52f13bc006054523-12\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;<\/span>{<\/div>\n<div id=\"crayon-65b9ea52f13bc006054523-13\" class=\"crayon-line\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp; <\/span><span class=\"crayon-i\">return<\/span> $<span class=\"crayon-i\">this<\/span>&#8211;<span class=\"crayon-h\">&gt;<\/span><span class=\"crayon-e\">belongsToMany<\/span>(<span class=\"crayon-s\">&#8216;App\\Hadiah&#8217;<\/span>);<\/div>\n<div id=\"crayon-65b9ea52f13bc006054523-14\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;<\/span>}<\/div>\n<div id=\"crayon-65b9ea52f13bc006054523-15\" class=\"crayon-line\">}<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>Perhatikan pada model Anggota.php di atas, kita membuat method hadiah() untuk menghubungkan model anggota dangan model hadiah.<\/p>\n<div id=\"crayon-65b9ea52f13c7045158499\" class=\"crayon-syntax crayon-theme-classic crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-mouseover\">\n<div class=\"crayon-toolbar\" data-settings=\" show\">\n<div class=\"crayon-tools\">\n<div class=\"crayon-button crayon-nums-button crayon-pressed\" title=\"Toggle Line Numbers\">\n<div class=\"crayon-button-icon\">&nbsp;<\/div>\n<\/div>\n<div class=\"crayon-button crayon-wrap-button\" title=\"Toggle Line Wrap\">\n<div class=\"crayon-button-icon\">&nbsp;<\/div>\n<\/div>\n<div class=\"crayon-button crayon-popup-button\" title=\"Open Code In New Window\">\n<div class=\"crayon-button-icon\">&nbsp;<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"crayon-plain-wrap\">&nbsp;<\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"show\">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13c7045158499-1\">1<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13c7045158499-2\">2<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13c7045158499-3\">3<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-65b9ea52f13c7045158499-1\" class=\"crayon-line\"><span class=\"crayon-e\">public <\/span><span class=\"crayon-e\">function <\/span><span class=\"crayon-e\">hadiah<\/span>(){<\/div>\n<div id=\"crayon-65b9ea52f13c7045158499-2\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp; <\/span><span class=\"crayon-i\">return<\/span> $<span class=\"crayon-i\">this<\/span>&#8211;<span class=\"crayon-h\">&gt;<\/span><span class=\"crayon-e\">belongsToMany<\/span>(<span class=\"crayon-s\">&#8216;App\\Hadiah&#8217;<\/span>);<\/div>\n<div id=\"crayon-65b9ea52f13c7045158499-3\" class=\"crayon-line\">}<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>Disini kita menggunakan fungsi&nbsp;belongsToMany()&nbsp;karena kita akan menbuat relasi many to many, pada model hadiah juga kita akan gunakan fungsi&nbsp;belongsToMany().<\/p>\n<p><strong>belajar_laravel\/app\/Hadiah.php<\/strong><\/p>\n<div id=\"crayon-65b9ea52f13c9291379710\" class=\"crayon-syntax crayon-theme-classic crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-mouseover\">\n<div class=\"crayon-toolbar\" data-settings=\" show\">\n<div class=\"crayon-tools\">\n<div class=\"crayon-button crayon-nums-button crayon-pressed\" title=\"Toggle Line Numbers\">\n<div class=\"crayon-button-icon\">&nbsp;<\/div>\n<\/div>\n<div class=\"crayon-button crayon-wrap-button\" title=\"Toggle Line Wrap\">\n<div class=\"crayon-button-icon\">&nbsp;<\/div>\n<\/div>\n<div class=\"crayon-button crayon-popup-button\" title=\"Open Code In New Window\">\n<div class=\"crayon-button-icon\">&nbsp;<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"crayon-plain-wrap\">&nbsp;<\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"show\">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13c9291379710-1\">1<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13c9291379710-2\">2<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13c9291379710-3\">3<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13c9291379710-4\">4<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13c9291379710-5\">5<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13c9291379710-6\">6<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13c9291379710-7\">7<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13c9291379710-8\">8<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13c9291379710-9\">9<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13c9291379710-10\">10<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13c9291379710-11\">11<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13c9291379710-12\">12<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13c9291379710-13\">13<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13c9291379710-14\">14<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13c9291379710-15\">15<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-65b9ea52f13c9291379710-1\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span>?<span class=\"crayon-e\">php<\/span><\/div>\n<div id=\"crayon-65b9ea52f13c9291379710-2\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13c9291379710-3\" class=\"crayon-line\"><span class=\"crayon-e\">namespace <\/span><span class=\"crayon-i\">App<\/span>;<\/div>\n<div id=\"crayon-65b9ea52f13c9291379710-4\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13c9291379710-5\" class=\"crayon-line\"><span class=\"crayon-e\">use <\/span><span class=\"crayon-i\">Illuminate<\/span>\\<span class=\"crayon-i\">Database<\/span>\\<span class=\"crayon-i\">Eloquent<\/span>\\<span class=\"crayon-i\">Model<\/span>;<\/div>\n<div id=\"crayon-65b9ea52f13c9291379710-6\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13c9291379710-7\" class=\"crayon-line\"><span class=\"crayon-e\">class<\/span> <span class=\"crayon-e\">Hadiah<\/span> <span class=\"crayon-e\">extends<\/span> <span class=\"crayon-e\">Model<\/span><\/div>\n<div id=\"crayon-65b9ea52f13c9291379710-8\" class=\"crayon-line crayon-striped-line\">{<\/div>\n<div id=\"crayon-65b9ea52f13c9291379710-9\" class=\"crayon-line\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span class=\"crayon-i\">protected<\/span> $<span class=\"crayon-i\">table<\/span> = <span class=\"crayon-s\">&#8220;hadiah&#8221;<\/span>;<\/div>\n<div id=\"crayon-65b9ea52f13c9291379710-10\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13c9291379710-11\" class=\"crayon-line\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span class=\"crayon-e\">public <\/span><span class=\"crayon-e\">function <\/span><span class=\"crayon-e\">anggota<\/span>()<\/div>\n<div id=\"crayon-65b9ea52f13c9291379710-12\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;<\/span>{<\/div>\n<div id=\"crayon-65b9ea52f13c9291379710-13\" class=\"crayon-line\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp; <\/span><span class=\"crayon-i\">return<\/span> $<span class=\"crayon-i\">this<\/span>&#8211;<span class=\"crayon-h\">&gt;<\/span><span class=\"crayon-e\">belongsToMany<\/span>(<span class=\"crayon-s\">&#8216;App\\Anggota&#8217;<\/span>);<\/div>\n<div id=\"crayon-65b9ea52f13c9291379710-14\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;<\/span>}<\/div>\n<div id=\"crayon-65b9ea52f13c9291379710-15\" class=\"crayon-line\">}<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>Oke tahap model selesai, kita lanjut dengan langsung membuat route.<\/p>\n<h3>Route<\/h3>\n<p>Langsung saja persiapkan route untuk menampilkan data anggota dan hadiahnya. disini saya membuat route baru yaitu:<\/p>\n<p><strong>belajar_laravel\/routes\/web.php<\/strong><\/p>\n<div id=\"crayon-65b9ea52f13cb792557713\" class=\"crayon-syntax crayon-theme-classic crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-mouseover\">\n<div class=\"crayon-toolbar\" data-settings=\" show\">\n<div class=\"crayon-tools\">\n<div class=\"crayon-button crayon-nums-button crayon-pressed\" title=\"Toggle Line Numbers\">\n<div class=\"crayon-button-icon\">&nbsp;<\/div>\n<\/div>\n<div class=\"crayon-button crayon-wrap-button\" title=\"Toggle Line Wrap\">\n<div class=\"crayon-button-icon\">&nbsp;<\/div>\n<\/div>\n<div class=\"crayon-button crayon-popup-button\" title=\"Open Code In New Window\">\n<div class=\"crayon-button-icon\">&nbsp;<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"crayon-plain-wrap\">&nbsp;<\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"show\">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13cb792557713-1\">1<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-65b9ea52f13cb792557713-1\" class=\"crayon-line\"><span class=\"crayon-i\">Route<\/span>::<span class=\"crayon-e\">get<\/span>(<span class=\"crayon-s\">&#8216;\/anggota&#8217;<\/span>, <span class=\"crayon-s\">&#8216;DikiController@index&#8217;<\/span>);<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>Pada route ini kita akan menggunakan controller DikiController.php.<\/p>\n<p>jadi buat sebuah controller baru, di sini saya membuat controllernya dengan menggunakan php artisan.<\/p>\n<p>php artisan make:controller DikiController<\/p>\n<p>Kemudian pada controller DikiController.php buat method index().<\/p>\n<p><strong>belajar_laravel\/app\/Http\/controllers\/DikiController.php<\/strong><\/p>\n<div id=\"crayon-65b9ea52f13cc924087176\" class=\"crayon-syntax crayon-theme-classic crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-mouseover\">\n<div class=\"crayon-toolbar\" data-settings=\" show\">\n<div class=\"crayon-tools\">\n<div class=\"crayon-button crayon-nums-button crayon-pressed\" title=\"Toggle Line Numbers\">\n<div class=\"crayon-button-icon\">&nbsp;<\/div>\n<\/div>\n<div class=\"crayon-button crayon-wrap-button\" title=\"Toggle Line Wrap\">\n<div class=\"crayon-button-icon\">&nbsp;<\/div>\n<\/div>\n<div class=\"crayon-button crayon-popup-button\" title=\"Open Code In New Window\">\n<div class=\"crayon-button-icon\">&nbsp;<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"crayon-plain-wrap\">&nbsp;<\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"show\">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13cc924087176-1\">1<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13cc924087176-2\">2<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13cc924087176-3\">3<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13cc924087176-4\">4<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13cc924087176-5\">5<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13cc924087176-6\">6<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13cc924087176-7\">7<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13cc924087176-8\">8<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13cc924087176-9\">9<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13cc924087176-10\">10<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13cc924087176-11\">11<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13cc924087176-12\">12<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13cc924087176-13\">13<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13cc924087176-14\">14<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13cc924087176-15\">15<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13cc924087176-16\">16<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13cc924087176-17\">17<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-65b9ea52f13cc924087176-1\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span>?<span class=\"crayon-e\">php<\/span><\/div>\n<div id=\"crayon-65b9ea52f13cc924087176-2\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13cc924087176-3\" class=\"crayon-line\"><span class=\"crayon-e\">namespace <\/span><span class=\"crayon-i\">App<\/span>\\<span class=\"crayon-i\">Http<\/span>\\<span class=\"crayon-i\">Controllers<\/span>;<\/div>\n<div id=\"crayon-65b9ea52f13cc924087176-4\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13cc924087176-5\" class=\"crayon-line\"><span class=\"crayon-e\">use <\/span><span class=\"crayon-i\">Illuminate<\/span>\\<span class=\"crayon-i\">Http<\/span>\\<span class=\"crayon-i\">Request<\/span>;<\/div>\n<div id=\"crayon-65b9ea52f13cc924087176-6\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13cc924087176-7\" class=\"crayon-line\"><span class=\"crayon-e\">use <\/span><span class=\"crayon-i\">App<\/span>\\<span class=\"crayon-i\">Anggota<\/span>;<\/div>\n<div id=\"crayon-65b9ea52f13cc924087176-8\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-e\">use <\/span><span class=\"crayon-i\">App<\/span>\\<span class=\"crayon-i\">Hadiah<\/span>;<\/div>\n<div id=\"crayon-65b9ea52f13cc924087176-9\" class=\"crayon-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13cc924087176-10\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-e\">class<\/span> <span class=\"crayon-e\">DikiController<\/span> <span class=\"crayon-e\">extends<\/span> <span class=\"crayon-e\">Controller<\/span><\/div>\n<div id=\"crayon-65b9ea52f13cc924087176-11\" class=\"crayon-line\">{<\/div>\n<div id=\"crayon-65b9ea52f13cc924087176-12\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span class=\"crayon-e\">public <\/span><span class=\"crayon-e\">function <\/span><span class=\"crayon-e\">index<\/span>()<\/div>\n<div id=\"crayon-65b9ea52f13cc924087176-13\" class=\"crayon-line\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;<\/span>{<\/div>\n<div id=\"crayon-65b9ea52f13cc924087176-14\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp; <\/span>$<span class=\"crayon-i\">anggota<\/span> = <span class=\"crayon-i\">Anggota<\/span>::<span class=\"crayon-e\">get<\/span>();<\/div>\n<div id=\"crayon-65b9ea52f13cc924087176-15\" class=\"crayon-line\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp; <\/span><span class=\"crayon-e\">return <\/span><span class=\"crayon-e\">view<\/span>(<span class=\"crayon-s\">&#8216;anggota&#8217;<\/span>, [<span class=\"crayon-s\">&#8216;anggota&#8217;<\/span> =<span class=\"crayon-h\">&gt;<\/span> $<span class=\"crayon-i\">anggota<\/span>]);<\/div>\n<div id=\"crayon-65b9ea52f13cc924087176-16\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;<\/span>}<\/div>\n<div id=\"crayon-65b9ea52f13cc924087176-17\" class=\"crayon-line\">}<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>Perhatikan pada controller di atas, kita panggil dulu model yang kita perlukan.<\/p>\n<div id=\"crayon-65b9ea52f13cd987744592\" class=\"crayon-syntax crayon-theme-classic crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-mouseover\">\n<div class=\"crayon-toolbar\" data-settings=\" show\">\n<div class=\"crayon-tools\">\n<div class=\"crayon-button crayon-nums-button crayon-pressed\" title=\"Toggle Line Numbers\">\n<div class=\"crayon-button-icon\">&nbsp;<\/div>\n<\/div>\n<div class=\"crayon-button crayon-wrap-button\" title=\"Toggle Line Wrap\">\n<div class=\"crayon-button-icon\">&nbsp;<\/div>\n<\/div>\n<div class=\"crayon-button crayon-popup-button\" title=\"Open Code In New Window\">\n<div class=\"crayon-button-icon\">&nbsp;<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"crayon-plain-wrap\">&nbsp;<\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"show\">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13cd987744592-1\">1<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13cd987744592-2\">2<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-65b9ea52f13cd987744592-1\" class=\"crayon-line\"><span class=\"crayon-e\">use <\/span><span class=\"crayon-i\">App<\/span>\\<span class=\"crayon-i\">Anggota<\/span>;<\/div>\n<div id=\"crayon-65b9ea52f13cd987744592-2\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-e\">use <\/span><span class=\"crayon-i\">App<\/span>\\<span class=\"crayon-i\">Hadiah<\/span>;<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>kemudian method index() nya kita ambil data anggota dari database dan kita passing ke view anggota.blade.php<\/p>\n<div id=\"crayon-65b9ea52f13cf011326023\" class=\"crayon-syntax crayon-theme-classic crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-mouseover\">\n<div class=\"crayon-toolbar\" data-settings=\" show\">\n<div class=\"crayon-tools\">\n<div class=\"crayon-button crayon-nums-button crayon-pressed\" title=\"Toggle Line Numbers\">\n<div class=\"crayon-button-icon\">&nbsp;<\/div>\n<\/div>\n<div class=\"crayon-button crayon-wrap-button\" title=\"Toggle Line Wrap\">\n<div class=\"crayon-button-icon\">&nbsp;<\/div>\n<\/div>\n<div class=\"crayon-button crayon-popup-button\" title=\"Open Code In New Window\">\n<div class=\"crayon-button-icon\">&nbsp;<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"crayon-plain-wrap\">&nbsp;<\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"show\">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13cf011326023-1\">1<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13cf011326023-2\">2<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13cf011326023-3\">3<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13cf011326023-4\">4<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-65b9ea52f13cf011326023-1\" class=\"crayon-line\"><span class=\"crayon-e\">public <\/span><span class=\"crayon-e\">function <\/span><span class=\"crayon-e\">index<\/span>(){<\/div>\n<div id=\"crayon-65b9ea52f13cf011326023-2\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp; <\/span>$<span class=\"crayon-i\">anggota<\/span> = <span class=\"crayon-i\">Anggota<\/span>::<span class=\"crayon-e\">get<\/span>();<\/div>\n<div id=\"crayon-65b9ea52f13cf011326023-3\" class=\"crayon-line\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp; <\/span><span class=\"crayon-e\">return <\/span><span class=\"crayon-e\">view<\/span>(<span class=\"crayon-s\">&#8216;anggota&#8217;<\/span>, [<span class=\"crayon-s\">&#8216;anggota&#8217;<\/span> =<span class=\"crayon-h\">&gt;<\/span> $<span class=\"crayon-i\">anggota<\/span>]);<\/div>\n<div id=\"crayon-65b9ea52f13cf011326023-4\" class=\"crayon-line crayon-striped-line\">}<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>Buat view nya.<\/p>\n<p><strong>belajar_laravel\/resources\/views\/anggota.blade.php<\/strong><\/p>\n<div id=\"crayon-65b9ea52f13d0378160507\" class=\"crayon-syntax crayon-theme-classic crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-mouseover\">\n<div class=\"crayon-toolbar\" data-settings=\" show\">\n<div class=\"crayon-tools\">\n<div class=\"crayon-button crayon-nums-button crayon-pressed\" title=\"Toggle Line Numbers\">\n<div class=\"crayon-button-icon\">&nbsp;<\/div>\n<\/div>\n<div class=\"crayon-button crayon-wrap-button\" title=\"Toggle Line Wrap\">\n<div class=\"crayon-button-icon\">&nbsp;<\/div>\n<\/div>\n<div class=\"crayon-button crayon-expand-button\" title=\"Expand Code\">\n<div class=\"crayon-button-icon\">&nbsp;<\/div>\n<\/div>\n<div class=\"crayon-button crayon-popup-button\" title=\"Open Code In New Window\">\n<div class=\"crayon-button-icon\">&nbsp;<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"crayon-plain-wrap\">&nbsp;<\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"show\">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13d0378160507-1\">1<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13d0378160507-2\">2<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13d0378160507-3\">3<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13d0378160507-4\">4<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13d0378160507-5\">5<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13d0378160507-6\">6<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13d0378160507-7\">7<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13d0378160507-8\">8<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13d0378160507-9\">9<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13d0378160507-10\">10<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13d0378160507-11\">11<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13d0378160507-12\">12<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13d0378160507-13\">13<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13d0378160507-14\">14<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13d0378160507-15\">15<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13d0378160507-16\">16<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13d0378160507-17\">17<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13d0378160507-18\">18<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13d0378160507-19\">19<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13d0378160507-20\">20<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13d0378160507-21\">21<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13d0378160507-22\">22<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13d0378160507-23\">23<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13d0378160507-24\">24<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13d0378160507-25\">25<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13d0378160507-26\">26<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13d0378160507-27\">27<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13d0378160507-28\">28<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13d0378160507-29\">29<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13d0378160507-30\">30<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13d0378160507-31\">31<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13d0378160507-32\">32<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13d0378160507-33\">33<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13d0378160507-34\">34<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13d0378160507-35\">35<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13d0378160507-36\">36<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13d0378160507-37\">37<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13d0378160507-38\">38<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13d0378160507-39\">39<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13d0378160507-40\">40<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13d0378160507-41\">41<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13d0378160507-42\">42<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13d0378160507-43\">43<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-65b9ea52f13d0378160507-1\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span>!<span class=\"crayon-e\">DOCTYPE <\/span><span class=\"crayon-i\">html<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-2\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-i\">html<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-3\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-i\">head<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-4\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-i\">title<\/span><span class=\"crayon-h\">&gt;<\/span><span class=\"crayon-e\">Tutorial <\/span><span class=\"crayon-i\">Laravel<\/span> <span class=\"crayon-p\">#25 : Relasi Many To Many Eloquent&lt;\/title&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-5\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-e\">link <\/span><span class=\"crayon-i\">href<\/span>=<span class=\"crayon-s\">&#8220;https:\/\/stackpath.bootstrapcdn.com\/bootstrap\/4.2.1\/css\/bootstrap.min.css&#8221;<\/span> <span class=\"crayon-i\">rel<\/span>=<span class=\"crayon-s\">&#8220;stylesheet&#8221;<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-6\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">head<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-7\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-i\">body<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-8\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-9\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-e\">div <\/span><span class=\"crayon-i\">class<\/span>=<span class=\"crayon-s\">&#8220;container&#8221;<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-10\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-e\">div <\/span><span class=\"crayon-i\">class<\/span>=<span class=\"crayon-s\">&#8220;card mt-5&#8221;<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-11\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-e\">div <\/span><span class=\"crayon-i\">class<\/span>=<span class=\"crayon-s\">&#8220;card-body&#8221;<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-12\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-e\">h3 <\/span><span class=\"crayon-i\">class<\/span>=<span class=\"crayon-s\">&#8220;text-center&#8221;<\/span><span class=\"crayon-h\">&gt;<\/span><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-st\">a<\/span> <span class=\"crayon-i\">href<\/span>=<span class=\"crayon-s\">&#8220;https:\/\/www.malasngoding.com&#8221;<\/span><span class=\"crayon-h\">&gt;<\/span><span class=\"crayon-i\">www<\/span><span class=\"crayon-st\">.<\/span><span class=\"crayon-i\">malasngoding<\/span><span class=\"crayon-st\">.<\/span><span class=\"crayon-i\">com<\/span><span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-st\">a<\/span><span class=\"crayon-h\">&gt;<\/span><span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">h3<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-13\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-e\">h5 <\/span><span class=\"crayon-i\">class<\/span>=<span class=\"crayon-s\">&#8220;text-center my-4&#8221;<\/span><span class=\"crayon-h\">&gt;<\/span><span class=\"crayon-e\">Eloquent <\/span><span class=\"crayon-e\">Many <\/span><span class=\"crayon-e\">To <\/span><span class=\"crayon-e\">Many <\/span><span class=\"crayon-i\">Relationship<\/span><span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">h5<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-14\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-e\">table <\/span><span class=\"crayon-i\">class<\/span>=<span class=\"crayon-s\">&#8220;table table-bordered table-striped&#8221;<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-15\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-i\">thead<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-16\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-i\">tr<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-17\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-i\">th<\/span><span class=\"crayon-h\">&gt;<\/span><span class=\"crayon-e\">Nama <\/span><span class=\"crayon-i\">Pengguna<\/span><span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">th<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-18\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-i\">th<\/span><span class=\"crayon-h\">&gt;<\/span><span class=\"crayon-i\">Hadiah<\/span><span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">th<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-19\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-e\">th <\/span><span class=\"crayon-i\">width<\/span>=<span class=\"crayon-s\">&#8220;1%&#8221;<\/span><span class=\"crayon-h\">&gt;<\/span><span class=\"crayon-i\">Jumlah<\/span><span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">th<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-20\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">tr<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-21\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">thead<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-22\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-i\">tbody<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-23\" class=\"crayon-line\">@<span class=\"crayon-e\">foreach<\/span>($<span class=\"crayon-e\">anggota <\/span><span class=\"crayon-i\">as<\/span> $<span class=\"crayon-st\">a<\/span>)<\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-24\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-e\">tr<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-25\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-e\">td<\/span><span class=\"crayon-h\">&gt;<\/span>{{ $<span class=\"crayon-st\">a<\/span>&#8211;<span class=\"crayon-h\">&gt;<\/span><span class=\"crayon-i\">nama<\/span> }}<span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">td<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-26\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-i\">td<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-27\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-i\">ul<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-28\" class=\"crayon-line crayon-striped-line\">@<span class=\"crayon-e\">foreach<\/span>($<span class=\"crayon-st\">a<\/span>&#8211;<span class=\"crayon-h\">&gt;<\/span><span class=\"crayon-e\">hadiah <\/span><span class=\"crayon-i\">as<\/span> $<span class=\"crayon-i\">h<\/span>)<\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-29\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-e\">li<\/span><span class=\"crayon-h\">&gt;<\/span> {{ $<span class=\"crayon-i\">h<\/span>&#8211;<span class=\"crayon-h\">&gt;<\/span><span class=\"crayon-i\">nama_hadiah<\/span> }} <span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">li<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-30\" class=\"crayon-line crayon-striped-line\">@<span class=\"crayon-i\">endforeach<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-31\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">ul<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-32\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">td<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-33\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-e\">td <\/span><span class=\"crayon-i\">class<\/span>=<span class=\"crayon-s\">&#8220;text-center&#8221;<\/span><span class=\"crayon-h\">&gt;<\/span>{{ $<span class=\"crayon-st\">a<\/span>&#8211;<span class=\"crayon-h\">&gt;<\/span><span class=\"crayon-i\">hadiah<\/span>&#8211;<span class=\"crayon-h\">&gt;<\/span><span class=\"crayon-e\">count<\/span>() }}<span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">td<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-34\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">tr<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-35\" class=\"crayon-line\">@<span class=\"crayon-i\">endforeach<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-36\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">tbody<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-37\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">table<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-38\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">div<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-39\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">div<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-40\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">div<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-41\" class=\"crayon-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-42\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">body<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d0378160507-43\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">html<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>Nah, pada view langsung kita tampilkan datanya. seperti yang teman-teman lihat, karena model anggota sudah terhubung dengan model hadiah (many to many), sekarang kita bisa langsung mengakses data hadiah masih-masing anggota di dalam variabel $anggota yang kita passing dari controller.<\/p>\n<p>$a-&gt;hadiah berisi data hadiah untuk masing-masing anggota. tergantung yang kita hubungkan pada table anggota_hadiah sebelumnya.<\/p>\n<div id=\"crayon-65b9ea52f13d2905383489\" class=\"crayon-syntax crayon-theme-classic crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-mouseover\">\n<div class=\"crayon-toolbar\" data-settings=\" show\">\n<div class=\"crayon-tools\">\n<div class=\"crayon-button crayon-nums-button crayon-pressed\" title=\"Toggle Line Numbers\">\n<div class=\"crayon-button-icon\">&nbsp;<\/div>\n<\/div>\n<div class=\"crayon-button crayon-wrap-button\" title=\"Toggle Line Wrap\">\n<div class=\"crayon-button-icon\">&nbsp;<\/div>\n<\/div>\n<div class=\"crayon-button crayon-popup-button\" title=\"Open Code In New Window\">\n<div class=\"crayon-button-icon\">&nbsp;<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"crayon-plain-wrap\">&nbsp;<\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"show\">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13d2905383489-1\">1<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13d2905383489-2\">2<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13d2905383489-3\">3<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13d2905383489-4\">4<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13d2905383489-5\">5<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13d2905383489-6\">6<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13d2905383489-7\">7<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13d2905383489-8\">8<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13d2905383489-9\">9<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13d2905383489-10\">10<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13d2905383489-11\">11<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13d2905383489-12\">12<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13d2905383489-13\">13<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea52f13d2905383489-14\">14<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea52f13d2905383489-15\">15<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-65b9ea52f13d2905383489-1\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-i\">tbody<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d2905383489-2\" class=\"crayon-line crayon-striped-line\">@<span class=\"crayon-e\">foreach<\/span>($<span class=\"crayon-e\">anggota <\/span><span class=\"crayon-i\">as<\/span> $<span class=\"crayon-st\">a<\/span>)<\/div>\n<div id=\"crayon-65b9ea52f13d2905383489-3\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-e\">tr<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d2905383489-4\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-e\">td<\/span><span class=\"crayon-h\">&gt;<\/span>{{ $<span class=\"crayon-st\">a<\/span>&#8211;<span class=\"crayon-h\">&gt;<\/span><span class=\"crayon-i\">nama<\/span> }}<span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">td<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d2905383489-5\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-i\">td<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d2905383489-6\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-i\">ul<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d2905383489-7\" class=\"crayon-line\">@<span class=\"crayon-e\">foreach<\/span>($<span class=\"crayon-st\">a<\/span>&#8211;<span class=\"crayon-h\">&gt;<\/span><span class=\"crayon-e\">hadiah <\/span><span class=\"crayon-i\">as<\/span> $<span class=\"crayon-i\">h<\/span>)<\/div>\n<div id=\"crayon-65b9ea52f13d2905383489-8\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-e\">li<\/span><span class=\"crayon-h\">&gt;<\/span> {{ $<span class=\"crayon-i\">h<\/span>&#8211;<span class=\"crayon-h\">&gt;<\/span><span class=\"crayon-i\">nama_hadiah<\/span> }} <span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">li<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d2905383489-9\" class=\"crayon-line\">@<span class=\"crayon-i\">endforeach<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d2905383489-10\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">ul<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d2905383489-11\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">td<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d2905383489-12\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-e\">td <\/span><span class=\"crayon-i\">class<\/span>=<span class=\"crayon-s\">&#8220;text-center&#8221;<\/span><span class=\"crayon-h\">&gt;<\/span>{{ $<span class=\"crayon-st\">a<\/span>&#8211;<span class=\"crayon-h\">&gt;<\/span><span class=\"crayon-i\">hadiah<\/span>&#8211;<span class=\"crayon-h\">&gt;<\/span><span class=\"crayon-e\">count<\/span>() }}<span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">td<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d2905383489-13\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">tr<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d2905383489-14\" class=\"crayon-line crayon-striped-line\">@<span class=\"crayon-i\">endforeach<\/span><\/div>\n<div id=\"crayon-65b9ea52f13d2905383489-15\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">tbody<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>Kita lihat hasilnya ya.<\/p>\n<p>Jalankan project.<\/p>\n<p>php artisan serve<\/p>\n<p>akses<\/p>\n<p>localhost:8000\/anggota<\/p>\n<div id=\"attachment_3580\" class=\"wp-caption aligncenter\"><p><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-3580 jetpack-lazy-image jetpack-lazy-image--handled\" src=\"https:\/\/www.malasngoding.com\/wp-content\/uploads\/2019\/01\/relasy-many-to-many-laravel.jpg\" alt=\"relasy many to many laravel\" width=\"710\" height=\"438\" aria-describedby=\"caption-attachment-3580\" data-lazy-loaded=\"1\"><\/p>\n<p id=\"caption-attachment-3580\" class=\"wp-caption-text\">relasy many to many laravel<\/p>\n<\/div>\n<p>Bisa teman-teman lihat pada contoh di atas, misalnya diki alfarabi hadi memiliki hadiah apa saja, dan berapa jumlahnya sudah kelihatan. data yang tampil sesuai dengan data id anggota dan hadiah yang sudah kita set pada table&nbsp;anggota_hadiah.<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Relasi Many To Many adalah relasi antar table dimana banyak dari masing-masing record tersebut bisa memiliki banyak relasi ke table lainnya. Penjelasan Untuk tutorial relasi many to many, kita buat contoh dengan misalnya membuat sistem pendataan hadiah untuk pengguna. jadi misalnya kita bisa membuat pendataan untuk masing-masing anggota memiliki\/mendapat hadiah apa saja. dan nanti kita [&hellip;]<\/p>\n","protected":false},"author":21,"featured_media":1354,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[9],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.uts.ac.id\/jul\/wp-json\/wp\/v2\/posts\/1321"}],"collection":[{"href":"https:\/\/blog.uts.ac.id\/jul\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.uts.ac.id\/jul\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.uts.ac.id\/jul\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.uts.ac.id\/jul\/wp-json\/wp\/v2\/comments?post=1321"}],"version-history":[{"count":4,"href":"https:\/\/blog.uts.ac.id\/jul\/wp-json\/wp\/v2\/posts\/1321\/revisions"}],"predecessor-version":[{"id":1358,"href":"https:\/\/blog.uts.ac.id\/jul\/wp-json\/wp\/v2\/posts\/1321\/revisions\/1358"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.uts.ac.id\/jul\/wp-json\/wp\/v2\/media\/1354"}],"wp:attachment":[{"href":"https:\/\/blog.uts.ac.id\/jul\/wp-json\/wp\/v2\/media?parent=1321"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.uts.ac.id\/jul\/wp-json\/wp\/v2\/categories?post=1321"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.uts.ac.id\/jul\/wp-json\/wp\/v2\/tags?post=1321"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}