{"id":1319,"date":"2024-01-31T06:53:40","date_gmt":"2024-01-31T06:53:40","guid":{"rendered":"https:\/\/blog.uts.ac.id\/jul\/?p=1319"},"modified":"2024-01-31T06:54:41","modified_gmt":"2024-01-31T06:54:41","slug":"laravel-23-relasi-one-to-one-eloquent","status":"publish","type":"post","link":"https:\/\/blog.uts.ac.id\/jul\/2024\/01\/31\/laravel-23-relasi-one-to-one-eloquent\/","title":{"rendered":"Laravel #23 : Relasi One To One Eloquent"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"1319\" class=\"elementor elementor-1319\">\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-09053dc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"09053dc\" 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-1447cfe\" data-id=\"1447cfe\" 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-02537ec elementor-widget elementor-widget-text-editor\" data-id=\"02537ec\" 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<h2>Relasi One To One Eloquent<\/h2>\n<p>Dalam tutorial Relasi One To One Eloquent ini akan kita uraikan satu per satu fitur keren&nbsp;<a href=\"https:\/\/laravel.com\/docs\/5.7\/eloquent-relationships\" target=\"_blank\" rel=\"noopener noreferrer\">Eloquent Relationship<\/a>&nbsp;laravel.<\/p>\n<p>Diantaranya adalah :<\/p>\n<ul>\n<li>One To One<\/li>\n<li>One To Many<\/li>\n<li>Many To Many<\/li>\n<\/ul>\n<p>Jika teman-teman pernah belajar perancangan database, pasti sudah tidak asing dengan list di atas. atau biasanya juga disebut dengan&nbsp;1 .. 1,&nbsp;1 .. n,&nbsp;n .. n.<\/p>\n<p>Biasanya untuk menghubungkan 2 table atau lebih, kita menggunakan fungsi join, atau langsung menggabungkannya menggunakan query sql. Tapi di laravel, sudah ada ada fitur untuk menghubungkan 2 table atau lebih. yaitu sudah diterapkan dalam Eloquent. jadi kita bisa menampilkan data dari 2 table atau lebih dengan laravel.<\/p>\n<p>Yuk langsung kita simak penjelasan berikut.<\/p>\n<h3>Relasi One To One Eloquent<\/h3>\n<p>Relasi One To One maksudnya&nbsp;1 record&nbsp;data dari&nbsp;table A&nbsp;memiliki relasi ke&nbsp;1 record&nbsp;data di&nbsp;table B.<\/p>\n<div id=\"attachment_3555\" class=\"wp-caption aligncenter\"><p><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-3555 jetpack-lazy-image jetpack-lazy-image--handled\" src=\"https:\/\/www.malasngoding.com\/wp-content\/uploads\/2019\/01\/Relasi-One-To-One-Eloquent.png\" alt=\"Relasi One To One Eloquent\" width=\"731\" height=\"489\" aria-describedby=\"caption-attachment-3555\" data-lazy-loaded=\"1\"><\/p>\n<p id=\"caption-attachment-3555\" class=\"wp-caption-text\">Relasi One To One Eloquent<\/p>\n<\/div>\n<p>Saya buatkan contohnya. gambar di atas adalah contoh sederhana one to one relationship. misalnya satu orang pengguna, memiliki satu nomor telepon. begitu juga kebalikannya, satu record data nomor telepon dimiliki oleh satu orang pengguna.<\/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>Langsung saja kita masuk ke contoh penggunaan Relasi One To One dengan Eloquent Laravel.<\/p>\n<h3>Contoh Relasi One To One Eloquent<\/h3>\n<p>Seperti pada gambar di atas, kita akan membuat dan menggunakan dua buah table seperti yang ada pada gambar di atas, yaitu kita akan menggunakan table pengguna dan table telepon sebagai contoh.<\/p>\n<p>Silahkan teman-teman buat kedua buah table tersebut. teman-teman bisa membuatnya dengan menggunakan&nbsp;<a href=\"https:\/\/www.malasngoding.com\/migration-laravel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Migration<\/a>&nbsp;dan mengisi datanya dengan&nbsp;<a href=\"https:\/\/www.malasngoding.com\/seeding-dan-faker-pada-laravel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Seeding Faker<\/a>.<\/p>\n<p>Atau jika teman-teman ingin mengimport langsung, silahkan import sql berikut.<\/p>\n<p><strong>SQL<\/strong><\/p>\n<div id=\"crayon-65b9ea532fd39586247636\" 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-65b9ea532fd39586247636-1\">1<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-2\">2<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-3\">3<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-4\">4<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-5\">5<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-6\">6<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-7\">7<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-8\">8<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-9\">9<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-10\">10<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-11\">11<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-12\">12<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-13\">13<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-14\">14<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-15\">15<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-16\">16<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-17\">17<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-18\">18<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-19\">19<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-20\">20<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-21\">21<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-22\">22<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-23\">23<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-24\">24<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-25\">25<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-26\">26<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-27\">27<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-28\">28<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-29\">29<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-30\">30<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-31\">31<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-32\">32<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-33\">33<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-34\">34<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-35\">35<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-36\">36<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-37\">37<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-38\">38<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-39\">39<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-40\">40<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-41\">41<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-42\">42<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-43\">43<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-44\">44<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-45\">45<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-46\">46<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-47\">47<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-48\">48<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-49\">49<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-50\">50<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-51\">51<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-52\">52<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-53\">53<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-54\">54<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-55\">55<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-56\">56<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-57\">57<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-58\">58<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-59\">59<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-60\">60<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-61\">61<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-62\">62<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-63\">63<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-64\">64<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-65\">65<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-66\">66<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-67\">67<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-68\">68<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-69\">69<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-70\">70<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-71\">71<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-72\">72<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-73\">73<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-74\">74<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-75\">75<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-76\">76<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-77\">77<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-78\">78<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-79\">79<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-80\">80<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-81\">81<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-82\">82<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-83\">83<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-84\">84<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-85\">85<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-86\">86<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-87\">87<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-88\">88<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-89\">89<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-90\">90<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-91\">91<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-92\">92<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-93\">93<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-94\">94<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-95\">95<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-96\">96<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-97\">97<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-98\">98<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-99\">99<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-100\">100<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-101\">101<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-102\">102<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd39586247636-103\">103<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd39586247636-104\">104<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-65b9ea532fd39586247636-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-65b9ea532fd39586247636-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-65b9ea532fd39586247636-3\" class=\"crayon-line\">&#8212; <span class=\"crayon-i\">https<\/span>:<span class=\"crayon-c\">\/\/www.phpmyadmin.net\/<\/span><\/div>\n<div id=\"crayon-65b9ea532fd39586247636-4\" class=\"crayon-line crayon-striped-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-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-65b9ea532fd39586247636-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\">14<\/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\">00<\/span> <span class=\"crayon-i\">AM<\/span><\/div>\n<div id=\"crayon-65b9ea532fd39586247636-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-65b9ea532fd39586247636-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-65b9ea532fd39586247636-9\" class=\"crayon-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-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-65b9ea532fd39586247636-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-65b9ea532fd39586247636-12\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-13\" class=\"crayon-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-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-65b9ea532fd39586247636-15\" class=\"crayon-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-16\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-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-65b9ea532fd39586247636-18\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-19\" class=\"crayon-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-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\">pengguna<\/span>`<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-21\" class=\"crayon-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-22\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-23\" class=\"crayon-line\"><span class=\"crayon-e\">CREATE <\/span><span class=\"crayon-i\">TABLE<\/span> `<span class=\"crayon-i\">pengguna<\/span>` (<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-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-65b9ea532fd39586247636-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-65b9ea532fd39586247636-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-65b9ea532fd39586247636-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-65b9ea532fd39586247636-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-65b9ea532fd39586247636-29\" class=\"crayon-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-30\" class=\"crayon-line crayon-striped-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-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\">pengguna<\/span>`<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-32\" class=\"crayon-line crayon-striped-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-33\" class=\"crayon-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-34\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-e\">INSERT <\/span><span class=\"crayon-i\">INTO<\/span> `<span class=\"crayon-i\">pengguna<\/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-65b9ea532fd39586247636-35\" class=\"crayon-line\">(<span class=\"crayon-cn\">1<\/span>, <span class=\"crayon-s\">&#8216;Padmi Kamila Hassanah S.Farm&#8217;<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-36\" class=\"crayon-line crayon-striped-line\">(<span class=\"crayon-cn\">2<\/span>, <span class=\"crayon-s\">&#8216;Julia Oktaviani&#8217;<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-37\" class=\"crayon-line\">(<span class=\"crayon-cn\">3<\/span>, <span class=\"crayon-s\">&#8216;Darmana Sitompul&#8217;<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-38\" class=\"crayon-line crayon-striped-line\">(<span class=\"crayon-cn\">4<\/span>, <span class=\"crayon-s\">&#8216;Naradi Nainggolan&#8217;<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-39\" class=\"crayon-line\">(<span class=\"crayon-cn\">5<\/span>, <span class=\"crayon-s\">&#8216;Tedi Winarno&#8217;<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-40\" class=\"crayon-line crayon-striped-line\">(<span class=\"crayon-cn\">6<\/span>, <span class=\"crayon-s\">&#8216;Ulya Yani Permata S.Pt&#8217;<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-41\" class=\"crayon-line\">(<span class=\"crayon-cn\">7<\/span>, <span class=\"crayon-s\">&#8216;Maida Uyainah&#8217;<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-42\" class=\"crayon-line crayon-striped-line\">(<span class=\"crayon-cn\">8<\/span>, <span class=\"crayon-s\">&#8216;Putri Dian Nasyidah M.Pd&#8217;<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-43\" class=\"crayon-line\">(<span class=\"crayon-cn\">9<\/span>, <span class=\"crayon-s\">&#8216;Lantar Uwais&#8217;<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>);<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-44\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-45\" 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-65b9ea532fd39586247636-46\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-47\" class=\"crayon-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-48\" 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\">telepon<\/span>`<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-49\" class=\"crayon-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-50\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-51\" class=\"crayon-line\"><span class=\"crayon-e\">CREATE <\/span><span class=\"crayon-i\">TABLE<\/span> `<span class=\"crayon-i\">telepon<\/span>` (<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-52\" 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-65b9ea532fd39586247636-53\" class=\"crayon-line\"><span class=\"crayon-h\">&nbsp;&nbsp;<\/span>`<span class=\"crayon-i\">nomor_telepon<\/span>` <span class=\"crayon-e\">varchar<\/span>(<span class=\"crayon-cn\">20<\/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-65b9ea532fd39586247636-54\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&nbsp;&nbsp;<\/span>`<span class=\"crayon-i\">pengguna_id<\/span>` <span class=\"crayon-e\">int<\/span>(<span class=\"crayon-cn\">11<\/span>) <span class=\"crayon-e\">NOT <\/span><span class=\"crayon-i\">NULL<\/span>,<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-55\" class=\"crayon-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-65b9ea532fd39586247636-56\" class=\"crayon-line crayon-striped-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-65b9ea532fd39586247636-57\" class=\"crayon-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-65b9ea532fd39586247636-58\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-59\" class=\"crayon-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-60\" class=\"crayon-line crayon-striped-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\">telepon<\/span>`<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-61\" class=\"crayon-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-62\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-63\" class=\"crayon-line\"><span class=\"crayon-e\">INSERT <\/span><span class=\"crayon-i\">INTO<\/span> `<span class=\"crayon-i\">telepon<\/span>` (`<span class=\"crayon-i\">id<\/span>`, `<span class=\"crayon-i\">nomor_telepon<\/span>`, `<span class=\"crayon-i\">pengguna_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-65b9ea532fd39586247636-64\" class=\"crayon-line crayon-striped-line\">(<span class=\"crayon-cn\">1<\/span>, <span class=\"crayon-s\">&#8216;(+62) 878 0989 834&#8217;<\/span>, <span class=\"crayon-cn\">1<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-65\" class=\"crayon-line\">(<span class=\"crayon-cn\">2<\/span>, <span class=\"crayon-s\">&#8216;(+62) 509 9868 0557&#8217;<\/span>, <span class=\"crayon-cn\">2<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-66\" class=\"crayon-line crayon-striped-line\">(<span class=\"crayon-cn\">3<\/span>, <span class=\"crayon-s\">&#8216;023 9503 4379&#8217;<\/span>, <span class=\"crayon-cn\">3<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-67\" class=\"crayon-line\">(<span class=\"crayon-cn\">4<\/span>, <span class=\"crayon-s\">&#8216;(+62) 24 1120 052&#8217;<\/span>, <span class=\"crayon-cn\">4<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-68\" class=\"crayon-line crayon-striped-line\">(<span class=\"crayon-cn\">5<\/span>, <span class=\"crayon-s\">&#8216;0535 3676 2454&#8217;<\/span>, <span class=\"crayon-cn\">5<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-69\" class=\"crayon-line\">(<span class=\"crayon-cn\">6<\/span>, <span class=\"crayon-s\">&#8216;0614 0945 4128&#8217;<\/span>, <span class=\"crayon-cn\">6<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-70\" class=\"crayon-line crayon-striped-line\">(<span class=\"crayon-cn\">7<\/span>, <span class=\"crayon-s\">&#8216;0460 8541 5478&#8217;<\/span>, <span class=\"crayon-cn\">7<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-71\" class=\"crayon-line\">(<span class=\"crayon-cn\">8<\/span>, <span class=\"crayon-s\">&#8216;(+62) 713 5497 976&#8217;<\/span>, <span class=\"crayon-cn\">8<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>),<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-72\" class=\"crayon-line crayon-striped-line\">(<span class=\"crayon-cn\">9<\/span>, <span class=\"crayon-s\">&#8216;(+62) 653 4057 294&#8217;<\/span>, <span class=\"crayon-cn\">9<\/span>, <span class=\"crayon-i\">NULL<\/span>, <span class=\"crayon-i\">NULL<\/span>);<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-73\" class=\"crayon-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-74\" class=\"crayon-line crayon-striped-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-75\" class=\"crayon-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-65b9ea532fd39586247636-76\" class=\"crayon-line crayon-striped-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-77\" class=\"crayon-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-78\" class=\"crayon-line crayon-striped-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-79\" class=\"crayon-line\">&#8212; <span class=\"crayon-e\">Indexes <\/span><span class=\"crayon-e\">for <\/span><span class=\"crayon-i\">table<\/span> `<span class=\"crayon-i\">pengguna<\/span>`<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-80\" class=\"crayon-line crayon-striped-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-81\" class=\"crayon-line\"><span class=\"crayon-e\">ALTER <\/span><span class=\"crayon-i\">TABLE<\/span> `<span class=\"crayon-i\">pengguna<\/span>`<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-82\" class=\"crayon-line crayon-striped-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-65b9ea532fd39586247636-83\" class=\"crayon-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-84\" class=\"crayon-line crayon-striped-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-85\" class=\"crayon-line\">&#8212; <span class=\"crayon-e\">Indexes <\/span><span class=\"crayon-e\">for <\/span><span class=\"crayon-i\">table<\/span> `<span class=\"crayon-i\">telepon<\/span>`<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-86\" class=\"crayon-line crayon-striped-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-87\" class=\"crayon-line\"><span class=\"crayon-e\">ALTER <\/span><span class=\"crayon-i\">TABLE<\/span> `<span class=\"crayon-i\">telepon<\/span>`<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-88\" class=\"crayon-line crayon-striped-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-65b9ea532fd39586247636-89\" class=\"crayon-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-90\" class=\"crayon-line crayon-striped-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-91\" class=\"crayon-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-65b9ea532fd39586247636-92\" class=\"crayon-line crayon-striped-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-93\" class=\"crayon-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-94\" class=\"crayon-line crayon-striped-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-95\" class=\"crayon-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\">pengguna<\/span>`<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-96\" class=\"crayon-line crayon-striped-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-97\" class=\"crayon-line\"><span class=\"crayon-e\">ALTER <\/span><span class=\"crayon-i\">TABLE<\/span> `<span class=\"crayon-i\">pengguna<\/span>`<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-98\" class=\"crayon-line crayon-striped-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\">10<\/span>;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-99\" class=\"crayon-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-100\" class=\"crayon-line crayon-striped-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-101\" class=\"crayon-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\">telepon<\/span>`<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-102\" class=\"crayon-line crayon-striped-line\">&#8212;<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-103\" class=\"crayon-line\"><span class=\"crayon-e\">ALTER <\/span><span class=\"crayon-i\">TABLE<\/span> `<span class=\"crayon-i\">telepon<\/span>`<\/div>\n<div id=\"crayon-65b9ea532fd39586247636-104\" class=\"crayon-line crayon-striped-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\">10<\/span>;<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>Sampai di sini kita sudah punya table pengguna dan table telepon.<\/p>\n<p>dan saya sudah mengisi data sebagai contoh saja.<\/p>\n<div id=\"attachment_3557\" class=\"wp-caption aligncenter\"><p><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-3557 jetpack-lazy-image jetpack-lazy-image--handled\" src=\"https:\/\/www.malasngoding.com\/wp-content\/uploads\/2019\/01\/relasi-one-to-one-eloquent-laravel.png\" alt=\"relasi one to one eloquent laravel\" width=\"733\" height=\"365\" aria-describedby=\"caption-attachment-3557\" data-lazy-loaded=\"1\"><\/p>\n<p id=\"caption-attachment-3557\" class=\"wp-caption-text\">relasi one to one eloquent laravel<\/p>\n<\/div>\n<p>Kemudian silahkan buat model model untuk pengguna.<\/p>\n<p>php artisan make:model Pengguna<\/p>\n<p>Kemudian buka model Pengguna yang sudah dibuat tersebut. dan ketik perintah berikut.<\/p>\n<p><strong>belajar_laravel\/app\/Pengguna.php<\/strong><\/p>\n<div id=\"crayon-65b9ea532fd45667563696\" 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-65b9ea532fd45667563696-1\">1<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd45667563696-2\">2<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd45667563696-3\">3<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd45667563696-4\">4<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd45667563696-5\">5<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd45667563696-6\">6<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd45667563696-7\">7<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd45667563696-8\">8<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd45667563696-9\">9<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd45667563696-10\">10<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd45667563696-11\">11<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd45667563696-12\">12<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd45667563696-13\">13<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd45667563696-14\">14<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd45667563696-15\">15<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd45667563696-16\">16<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-65b9ea532fd45667563696-1\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span>?<span class=\"crayon-e\">php<\/span><\/div>\n<div id=\"crayon-65b9ea532fd45667563696-2\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea532fd45667563696-3\" class=\"crayon-line\"><span class=\"crayon-e\">namespace <\/span><span class=\"crayon-i\">App<\/span>;<\/div>\n<div id=\"crayon-65b9ea532fd45667563696-4\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea532fd45667563696-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-65b9ea532fd45667563696-6\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea532fd45667563696-7\" class=\"crayon-line\"><span class=\"crayon-e\">class<\/span> <span class=\"crayon-e\">Pengguna<\/span> <span class=\"crayon-e\">extends<\/span> <span class=\"crayon-e\">Model<\/span><\/div>\n<div id=\"crayon-65b9ea532fd45667563696-8\" class=\"crayon-line crayon-striped-line\">{<\/div>\n<div id=\"crayon-65b9ea532fd45667563696-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;pengguna&#8221;<\/span>;<\/div>\n<div id=\"crayon-65b9ea532fd45667563696-10\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea532fd45667563696-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\">telepon<\/span>()<\/div>\n<div id=\"crayon-65b9ea532fd45667563696-12\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;<\/span>{<\/div>\n<div id=\"crayon-65b9ea532fd45667563696-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\">hasOne<\/span>(<span class=\"crayon-s\">&#8216;App\\Telepon&#8217;<\/span>);<\/div>\n<div id=\"crayon-65b9ea532fd45667563696-14\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;<\/span>}<\/div>\n<div id=\"crayon-65b9ea532fd45667563696-15\" class=\"crayon-line\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;<\/span><\/div>\n<div id=\"crayon-65b9ea532fd45667563696-16\" class=\"crayon-line crayon-striped-line\">}<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>Di sini kita memberitahukan bahwa table yang digunakan adalah table \u201cpengguna\u201d. bukan \u201cpenggunas\u201d (plural). bagian ini sudah dijelaskan pada tutorial sebelumnya tentang pembuatan model dan penamaan otomatisnya pada laravel.<\/p>\n<p>Selanjutnya kita buat sebuah fungsi baru untuk memberitahukan model pengguna, bahwa table pengguna memiliki relasi 1 ke model atau table telepon.<\/p>\n<div id=\"crayon-65b9ea532fd4f791038980\" 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-65b9ea532fd4f791038980-1\">1<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd4f791038980-2\">2<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd4f791038980-3\">3<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-65b9ea532fd4f791038980-1\" class=\"crayon-line\"><span class=\"crayon-e\">public <\/span><span class=\"crayon-e\">function <\/span><span class=\"crayon-e\">telepon<\/span>(){<\/div>\n<div id=\"crayon-65b9ea532fd4f791038980-2\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&nbsp;&nbsp;&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\">hasOne<\/span>(<span class=\"crayon-s\">&#8216;App\\Telepon&#8217;<\/span>);<\/div>\n<div id=\"crayon-65b9ea532fd4f791038980-3\" class=\"crayon-line\">}<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>Sekarang buat model untuk table telepon.<\/p>\n<p>php artisan make:model Telepon<\/p>\n<p><strong>belajar_laravel\/app\/Telepon.php<\/strong><\/p>\n<div id=\"crayon-65b9ea532fd51777834538\" 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-65b9ea532fd51777834538-1\">1<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd51777834538-2\">2<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd51777834538-3\">3<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd51777834538-4\">4<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd51777834538-5\">5<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd51777834538-6\">6<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd51777834538-7\">7<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd51777834538-8\">8<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd51777834538-9\">9<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd51777834538-10\">10<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd51777834538-11\">11<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd51777834538-12\">12<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd51777834538-13\">13<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd51777834538-14\">14<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd51777834538-15\">15<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-65b9ea532fd51777834538-1\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span>?<span class=\"crayon-e\">php<\/span><\/div>\n<div id=\"crayon-65b9ea532fd51777834538-2\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea532fd51777834538-3\" class=\"crayon-line\"><span class=\"crayon-e\">namespace <\/span><span class=\"crayon-i\">App<\/span>;<\/div>\n<div id=\"crayon-65b9ea532fd51777834538-4\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea532fd51777834538-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-65b9ea532fd51777834538-6\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea532fd51777834538-7\" class=\"crayon-line\"><span class=\"crayon-e\">class<\/span> <span class=\"crayon-e\">Telepon<\/span> <span class=\"crayon-e\">extends<\/span> <span class=\"crayon-e\">Model<\/span><\/div>\n<div id=\"crayon-65b9ea532fd51777834538-8\" class=\"crayon-line crayon-striped-line\">{<\/div>\n<div id=\"crayon-65b9ea532fd51777834538-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;telepon&#8221;<\/span>;<\/div>\n<div id=\"crayon-65b9ea532fd51777834538-10\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea532fd51777834538-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\">pengguna<\/span>()<\/div>\n<div id=\"crayon-65b9ea532fd51777834538-12\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;<\/span>{<\/div>\n<div id=\"crayon-65b9ea532fd51777834538-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\">belongsTo<\/span>(<span class=\"crayon-s\">&#8216;App\\Pengguna&#8217;<\/span>);<\/div>\n<div id=\"crayon-65b9ea532fd51777834538-14\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;<\/span>}<\/div>\n<div id=\"crayon-65b9ea532fd51777834538-15\" class=\"crayon-line\">}<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>Pada model telepon ini, kita deklarasikan dulu bahwa table yang kita gunakan adalah table \u201ctelepon\u201d.<\/p>\n<div id=\"crayon-65b9ea532fd53362729349\" 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-65b9ea532fd53362729349-1\">1<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-65b9ea532fd53362729349-1\" class=\"crayon-line\"><span class=\"crayon-i\">protected<\/span> $<span class=\"crayon-i\">table<\/span> = <span class=\"crayon-s\">&#8220;telepon&#8221;<\/span>;<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>kemudian kita buat fungsi untuk menjelaskan pada model telepon, bahwa model telepon terhubung dengan model pengguna.<\/p>\n<div id=\"crayon-65b9ea532fd54999180935\" 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-65b9ea532fd54999180935-1\">1<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd54999180935-2\">2<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd54999180935-3\">3<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd54999180935-4\">4<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-65b9ea532fd54999180935-1\" class=\"crayon-line\"><span class=\"crayon-e\">public <\/span><span class=\"crayon-e\">function <\/span><span class=\"crayon-e\">pengguna<\/span>()<\/div>\n<div id=\"crayon-65b9ea532fd54999180935-2\" class=\"crayon-line crayon-striped-line\">{<\/div>\n<div id=\"crayon-65b9ea532fd54999180935-3\" 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\">belongsTo<\/span>(<span class=\"crayon-s\">&#8216;App\\Pengguna&#8217;<\/span>);<\/div>\n<div id=\"crayon-65b9ea532fd54999180935-4\" class=\"crayon-line crayon-striped-line\">}<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>Nah, coba teman-teman perhatikan. sebelumnya pada model Pengguna, kita memberitahukan bahwa table pengguna memiliki relasi 1 ke table telepon.<\/p>\n<p>dan di Model telepon kita beritahu bahwa table telepon ini dimiliki oleh table pengguna.<\/p>\n<p>Jadi satu sama lain sudah terhubung sekarang.<\/p>\n<div id=\"attachment_3558\" class=\"wp-caption aligncenter\"><p><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-3558 jetpack-lazy-image jetpack-lazy-image--handled\" src=\"https:\/\/www.malasngoding.com\/wp-content\/uploads\/2019\/01\/relasi-antar-table-laravel.png\" alt=\"relasi antar table laravel\" width=\"706\" height=\"352\" aria-describedby=\"caption-attachment-3558\" data-lazy-loaded=\"1\"><\/p>\n<p id=\"caption-attachment-3558\" class=\"wp-caption-text\">relasi antar table laravel<\/p>\n<\/div>\n<p>Kedua table ini dihubungkan oleh kolum&nbsp;pengguna_id&nbsp;yang ada pada table telepon.<\/p>\n<p>nama kolum pengguna_id mengikuti nama table yang dihubungkan dengannya. jadi secara otomatis table telepon mencari id pengguna nya masing-masing ke table pengguna.<\/p>\n<p>pengguna = pengguna_id<\/p>\n<p>Sungguh sangat sederhana. fitur ini akan banyak sekali teman-teman butuhkan pada saat teman-teman membuat aplikasi yang berukuran besar. kita tidak perlu lagi repot-repot menghubungkan table.<\/p>\n<p>cukup mendeklarasikan pada model nya masing-masing, bahwa model tersebut terhubung ke table\/model mana saja. dan bagaiamana jenisnya, one to one kah? one to many? atau many to many.<\/p>\n<p>Pada tutorial ini kita masih membahas&nbsp;<strong>relasi one to one<\/strong>. pada tutorial selanjutnya kita juga akan membahas relasi&nbsp;<strong>one to many<\/strong>&nbsp;dan&nbsp;<strong>many to many<\/strong>.<\/p>\n<p>Oke kita lihat hasilnya.<\/p>\n<p>Buat route \u201c\/pengguna\u201d, kita akan menampilkan data pengguna dan data nomor telepon masing-masing pengguna pada route ini.<\/p>\n<p><strong>belajar_laravel\/routes\/web.php<\/strong><\/p>\n<div id=\"crayon-65b9ea532fd59191096643\" 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-65b9ea532fd59191096643-1\">1<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-65b9ea532fd59191096643-1\" class=\"crayon-line\"><span class=\"crayon-i\">Route<\/span>::<span class=\"crayon-e\">get<\/span>(<span class=\"crayon-s\">&#8216;\/pengguna&#8217;<\/span>, <span class=\"crayon-s\">&#8216;PenggunaController@index&#8217;<\/span>);<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>kemudian buat controller PenggunaController.php.<\/p>\n<p>saya mencoba membuat controller ini menggunakan&nbsp;<strong>php artisan<\/strong>. masuk ke direktori project laravel kita, dan ketik perintah berikut.<\/p>\n<p>php artisan make:controller PenggunaController<\/p>\n<p>Cara membuat controller pada laravel menggunakan php artisan sudah saya jelaskan pada tutorial sebelumnya.<\/p>\n<p>Baca :&nbsp;<a href=\"https:\/\/www.malasngoding.com\/tutorial-membuat-controller-pada-laravel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Tutorial Laravel #3 : Membuat Controller Dengan Laravel<\/a><\/p>\n<p>Setelah membuat controller PenggunaController.php, kemudian buat method index() di dalamnya.<\/p>\n<p><strong>belajar_laravel\/app\/Http\/controllers\/PenggunaController.php<\/strong><\/p>\n<div id=\"crayon-65b9ea532fd5b407436474\" 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-65b9ea532fd5b407436474-1\">1<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd5b407436474-2\">2<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd5b407436474-3\">3<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd5b407436474-4\">4<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd5b407436474-5\">5<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd5b407436474-6\">6<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd5b407436474-7\">7<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd5b407436474-8\">8<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd5b407436474-9\">9<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd5b407436474-10\">10<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd5b407436474-11\">11<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd5b407436474-12\">12<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd5b407436474-13\">13<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd5b407436474-14\">14<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd5b407436474-15\">15<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd5b407436474-16\">16<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd5b407436474-17\">17<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd5b407436474-18\">18<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd5b407436474-19\">19<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-65b9ea532fd5b407436474-1\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span>?<span class=\"crayon-e\">php<\/span><\/div>\n<div id=\"crayon-65b9ea532fd5b407436474-2\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea532fd5b407436474-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-65b9ea532fd5b407436474-4\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea532fd5b407436474-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-65b9ea532fd5b407436474-6\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea532fd5b407436474-7\" class=\"crayon-line\"><span class=\"crayon-c\">\/\/ memanggil model Pengguna<\/span><\/div>\n<div id=\"crayon-65b9ea532fd5b407436474-8\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-e\">use <\/span><span class=\"crayon-i\">App<\/span>\\<span class=\"crayon-i\">Pengguna<\/span>;<\/div>\n<div id=\"crayon-65b9ea532fd5b407436474-9\" class=\"crayon-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea532fd5b407436474-10\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-e\">class<\/span> <span class=\"crayon-e\">PenggunaController<\/span> <span class=\"crayon-e\">extends<\/span> <span class=\"crayon-e\">Controller<\/span><\/div>\n<div id=\"crayon-65b9ea532fd5b407436474-11\" class=\"crayon-line\">{<\/div>\n<div id=\"crayon-65b9ea532fd5b407436474-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-65b9ea532fd5b407436474-13\" class=\"crayon-line\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;<\/span>{<\/div>\n<div id=\"crayon-65b9ea532fd5b407436474-14\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp; <\/span><span class=\"crayon-c\">\/\/ mengambil semua data pengguna<\/span><\/div>\n<div id=\"crayon-65b9ea532fd5b407436474-15\" class=\"crayon-line\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp; <\/span>$<span class=\"crayon-i\">pengguna<\/span> = <span class=\"crayon-i\">Pengguna<\/span>::<span class=\"crayon-e\">all<\/span>();<\/div>\n<div id=\"crayon-65b9ea532fd5b407436474-16\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp; <\/span><span class=\"crayon-c\">\/\/ return data ke view<\/span><\/div>\n<div id=\"crayon-65b9ea532fd5b407436474-17\" 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;pengguna&#8217;<\/span>, [<span class=\"crayon-s\">&#8216;pengguna&#8217;<\/span> =<span class=\"crayon-h\">&gt;<\/span> $<span class=\"crayon-i\">pengguna<\/span>]);<\/div>\n<div id=\"crayon-65b9ea532fd5b407436474-18\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;<\/span>}<\/div>\n<div id=\"crayon-65b9ea532fd5b407436474-19\" class=\"crayon-line\">}<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>pada controller ini kita ambil data pengguna, dan kita return ke view pengguna, caranya masih sama seperti yang sudah kita pelajari sebelumnya.<\/p>\n<p>buat sebuah view untuk menampilkan data pengguna. buat view sesuai dengan yang sudah kita tentukan pada controller, yaitu view&nbsp;pengguna.blade.php<\/p>\n<p><strong>belajar_laravel\/resources\/views\/pengguna.blade.php<\/strong><\/p>\n<div id=\"crayon-65b9ea532fd5d421281426\" 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-65b9ea532fd5d421281426-1\">1<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd5d421281426-2\">2<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd5d421281426-3\">3<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd5d421281426-4\">4<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd5d421281426-5\">5<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd5d421281426-6\">6<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd5d421281426-7\">7<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd5d421281426-8\">8<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd5d421281426-9\">9<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd5d421281426-10\">10<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd5d421281426-11\">11<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd5d421281426-12\">12<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd5d421281426-13\">13<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd5d421281426-14\">14<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd5d421281426-15\">15<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd5d421281426-16\">16<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd5d421281426-17\">17<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd5d421281426-18\">18<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd5d421281426-19\">19<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd5d421281426-20\">20<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd5d421281426-21\">21<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd5d421281426-22\">22<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd5d421281426-23\">23<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd5d421281426-24\">24<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd5d421281426-25\">25<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd5d421281426-26\">26<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd5d421281426-27\">27<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd5d421281426-28\">28<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd5d421281426-29\">29<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd5d421281426-30\">30<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd5d421281426-31\">31<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd5d421281426-32\">32<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd5d421281426-33\">33<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd5d421281426-34\">34<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd5d421281426-35\">35<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-65b9ea532fd5d421281426-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-65b9ea532fd5d421281426-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-65b9ea532fd5d421281426-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-65b9ea532fd5d421281426-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\">#23 : Relasi One To One Eloquent&lt;\/title&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea532fd5d421281426-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-65b9ea532fd5d421281426-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-65b9ea532fd5d421281426-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-65b9ea532fd5d421281426-8\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea532fd5d421281426-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-65b9ea532fd5d421281426-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-65b9ea532fd5d421281426-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-65b9ea532fd5d421281426-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-65b9ea532fd5d421281426-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\">One <\/span><span class=\"crayon-e\">To <\/span><span class=\"crayon-e\">One <\/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-65b9ea532fd5d421281426-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-65b9ea532fd5d421281426-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-65b9ea532fd5d421281426-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-65b9ea532fd5d421281426-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-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-65b9ea532fd5d421281426-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-e\">Nomor <\/span><span class=\"crayon-i\">Telepon<\/span><span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">th<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea532fd5d421281426-19\" 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-65b9ea532fd5d421281426-20\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">thead<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea532fd5d421281426-21\" 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-65b9ea532fd5d421281426-22\" class=\"crayon-line crayon-striped-line\">@<span class=\"crayon-e\">foreach<\/span>($<span class=\"crayon-e\">pengguna <\/span><span class=\"crayon-i\">as<\/span> $<span class=\"crayon-t\">p<\/span>)<\/div>\n<div id=\"crayon-65b9ea532fd5d421281426-23\" 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-65b9ea532fd5d421281426-24\" 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-t\">p<\/span>&#8211;<span class=\"crayon-h\">&gt;<\/span><span class=\"crayon-i\">nama<\/span> }}<span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-e\">td<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea532fd5d421281426-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-t\">p<\/span>&#8211;<span class=\"crayon-h\">&gt;<\/span><span class=\"crayon-i\">telepon<\/span>&#8211;<span class=\"crayon-h\">&gt;<\/span><span class=\"crayon-i\">nomor_telepon<\/span> }}<span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">td<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea532fd5d421281426-26\" 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-65b9ea532fd5d421281426-27\" class=\"crayon-line\">@<span class=\"crayon-i\">endforeach<\/span><\/div>\n<div id=\"crayon-65b9ea532fd5d421281426-28\" 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-65b9ea532fd5d421281426-29\" 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-65b9ea532fd5d421281426-30\" 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-65b9ea532fd5d421281426-31\" 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-65b9ea532fd5d421281426-32\" 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-65b9ea532fd5d421281426-33\" class=\"crayon-line\">&nbsp;<\/div>\n<div id=\"crayon-65b9ea532fd5d421281426-34\" 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-65b9ea532fd5d421281426-35\" 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>Perhatikan pada view di atas, kita menampilkan data pengguna menggunakan foreach.<\/p>\n<div id=\"crayon-65b9ea532fd5f083008146\" 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-65b9ea532fd5f083008146-1\">1<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd5f083008146-2\">2<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd5f083008146-3\">3<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd5f083008146-4\">4<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65b9ea532fd5f083008146-5\">5<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65b9ea532fd5f083008146-6\">6<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-65b9ea532fd5f083008146-1\" class=\"crayon-line\">@<span class=\"crayon-e\">foreach<\/span>($<span class=\"crayon-e\">pengguna <\/span><span class=\"crayon-i\">as<\/span> $<span class=\"crayon-t\">p<\/span>)<\/div>\n<div id=\"crayon-65b9ea532fd5f083008146-2\" 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-65b9ea532fd5f083008146-3\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-e\">td<\/span><span class=\"crayon-h\">&gt;<\/span>{{ $<span class=\"crayon-t\">p<\/span>&#8211;<span class=\"crayon-h\">&gt;<\/span><span class=\"crayon-i\">nama<\/span> }}<span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-e\">td<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea532fd5f083008146-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-t\">p<\/span>&#8211;<span class=\"crayon-h\">&gt;<\/span><span class=\"crayon-i\">telepon<\/span>&#8211;<span class=\"crayon-h\">&gt;<\/span><span class=\"crayon-i\">nomor_telepon<\/span> }}<span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">td<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65b9ea532fd5f083008146-5\" 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-65b9ea532fd5f083008146-6\" class=\"crayon-line crayon-striped-line\">@<span class=\"crayon-v\">endforeach<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>Tapi ada yang keren di sini, kita bisa langsung mengakses data telepon dari data pengguna ini.<\/p>\n<div id=\"crayon-65b9ea532fd64206781473\" 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-65b9ea532fd64206781473-1\">1<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-65b9ea532fd64206781473-1\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-e\">td<\/span><span class=\"crayon-h\">&gt;<\/span>{{ $<span class=\"crayon-t\">p<\/span>&#8211;<span class=\"crayon-h\">&gt;<\/span><span class=\"crayon-i\">telepon<\/span>&#8211;<span class=\"crayon-h\">&gt;<\/span><span class=\"crayon-i\">nomor_telepon<\/span> }}<span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">td<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>Hal ini bisa dilakukan karena kita sudah mendeklarasikan relasi one to one antara kedua table ini. (model\/table pengguna dan model\/table telepon).<\/p>\n<p>dari variabel&nbsp;$p&nbsp;kita bisa langsung mengakses ke data telepon (&nbsp;$p-&gt;telepon&nbsp;), dan lebih spesifik lagi dengan memilih nama kolum nya (&nbsp;$p-&gt;telepon-&gt;nomor_telepon&nbsp;).<\/p>\n<p>Kita lihat hasilnya ya.<\/p>\n<p>silahkan jalankan project.<\/p>\n<p>php artisan serve<\/p>\n<p>dan akses<\/p>\n<p>localhost:8000\/pengguna<\/p>\n<p>Maka berikut hasil&nbsp;<em>one to one relationship<\/em>&nbsp;yang kita dapatkan.<\/p>\n<div id=\"attachment_3559\" class=\"wp-caption aligncenter\"><p><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-3559 jetpack-lazy-image jetpack-lazy-image--handled\" src=\"https:\/\/www.malasngoding.com\/wp-content\/uploads\/2019\/01\/one-to-one-eloquent-laravel.png\" alt=\"one to one eloquent laravel\" width=\"729\" height=\"475\" aria-describedby=\"caption-attachment-3559\" data-lazy-loaded=\"1\"><\/p>\n<p id=\"caption-attachment-3559\" class=\"wp-caption-text\">one to one eloquent laravel<\/p>\n<\/div>\n<p>Oke teman-teman, sekian tutorial&nbsp;<strong>Relasi One To One Eloquent<\/strong>, semoga dapat bermanfaat untuk teman-teman semua.<\/p>\n<p><\/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 One To One Eloquent Dalam tutorial Relasi One To One Eloquent ini akan kita uraikan satu per satu fitur keren&nbsp;Eloquent Relationship&nbsp;laravel. Diantaranya adalah : One To One One To Many Many To Many Jika teman-teman pernah belajar perancangan database, pasti sudah tidak asing dengan list di atas. atau biasanya juga disebut dengan&nbsp;1 .. 1,&nbsp;1 [&hellip;]<\/p>\n","protected":false},"author":21,"featured_media":1344,"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\/1319"}],"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=1319"}],"version-history":[{"count":4,"href":"https:\/\/blog.uts.ac.id\/jul\/wp-json\/wp\/v2\/posts\/1319\/revisions"}],"predecessor-version":[{"id":1348,"href":"https:\/\/blog.uts.ac.id\/jul\/wp-json\/wp\/v2\/posts\/1319\/revisions\/1348"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.uts.ac.id\/jul\/wp-json\/wp\/v2\/media\/1344"}],"wp:attachment":[{"href":"https:\/\/blog.uts.ac.id\/jul\/wp-json\/wp\/v2\/media?parent=1319"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.uts.ac.id\/jul\/wp-json\/wp\/v2\/categories?post=1319"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.uts.ac.id\/jul\/wp-json\/wp\/v2\/tags?post=1319"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}