{"id":1276,"date":"2024-01-31T06:06:57","date_gmt":"2024-01-31T06:06:57","guid":{"rendered":"https:\/\/blog.uts.ac.id\/jul\/?p=1276"},"modified":"2025-05-21T04:26:20","modified_gmt":"2025-05-21T04:26:20","slug":"laravel-9-membuat-crud-dengan-laravel","status":"publish","type":"post","link":"https:\/\/blog.uts.ac.id\/jul\/2024\/01\/31\/laravel-9-membuat-crud-dengan-laravel\/","title":{"rendered":"Laravel #9 : Membuat CRUD Dengan Laravel"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"1276\" class=\"elementor elementor-1276\">\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-d7e25ea elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d7e25ea\" 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-488f841\" data-id=\"488f841\" 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-e744650 elementor-widget elementor-widget-text-editor\" data-id=\"e744650\" 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>Untuk bermain-main dengan database pada laravel, sebenarnya ada 2 cara yang umum digunakan. yaitu kita bisa menggunakan&nbsp;<strong>Query Builder<\/strong>&nbsp;dan&nbsp;<strong>Eloquent<\/strong>.<\/p>\n<p>Keduanya merupakan fitur yang sudah disediakan pada laravel. sehingga kita bisa lebih mudah dalam membuat CRUD pada laravel.<\/p>\n<p>Tetapi pada sub judul ini kita akan belajar&nbsp;<strong>membuat CRUD dengan menggunakan Query Builder pada laravel<\/strong>.<\/p>\n<p>Untuk tutorial membuat CRUD menggunakan Eloquent pada laravel akan kita bahas pada tutorial laravel selanjutnya.<\/p>\n<h3>Membuat CRUD Pada Laravel Dengan Query Builder<\/h3>\n<p>Untuk pembahasan tutorial&nbsp;<strong>membuat CRUD dengan laravel<\/strong>, akan kita awali dengan cara membuat CRUD menggunakan query builder dari laravel.<\/p>\n<p>Jika teman-teman ingin membaca dokumentasi tentang cara penggunaan query builder untuk mengolah data pada database dengan laravel, teman-teman bisa juga membaca nya di&nbsp;<a href=\"https:\/\/laravel.com\/docs\/5.7\/queries\" target=\"_blank\" rel=\"noopener\">sini<\/a>.<\/p>\n<p>Sebelumnya saya jelaskan dulu apa itu query builder. Query Builder bisa kita anggap sebagai fitur untuk menjalankan query database. jadi di sini laravel telah membuat fungsi-fungsi untuk menjalankan query database. misalnya untuk memilih mau menampilkan data pada table apa, kita bisa langsung saja menggunakan fungsi&nbsp;table()&nbsp;pada laravel.<\/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-9 col-lg-10 d-flex align-items-center\">&nbsp;<\/div>\n<\/div>\n<\/div>\n<p>Begitu juga jika kita ingin menampilkan data yang lebih spesifik seperti misalnya kita ingin menampilkan data yang memiliki kriteria tertentu misalnya menampilkan data yang id nya 5. maka kita tinggal menggunakan fungsi&nbsp;where( \u2018id\u2019 , \u2018id_nya_isi_di_sini\u2019 )&nbsp;saja setelah memilih nama tabel nya.<\/p>\n<p>Jadi penulisan query database jadi lebih singkat dan efisien.<\/p>\n<p>Tidak hanya cuma bisa memilih table dan menggunakan fungsi where(). ada juga fungsi lainnya seperti penggunaan JOIN, DISTINCT dan lain-lain.<\/p>\n<p>Pokok nya udah lengkap. teman-teman bisa lihat di&nbsp;<a href=\"https:\/\/laravel.com\/docs\/5.7\/queries\" target=\"_blank\" rel=\"noopener\">sini<\/a>&nbsp;apa saja yang bisa kita lakukan dengan query builder nya si laravel.<\/p>\n<p>Oke langsung saja kita mulai&nbsp;<strong>membuat CRUD Dengan Laravel<\/strong>. kita mulai dulu dengan melakukan konfigurasi database.<\/p>\n<h3>Pengaturan Database Pada Laravel<\/h3>\n<p>Contoh CRUD yang akan kita buat di sini adalah CRUD untuk data pegawai. jadi di sini kita akan membuat fungsi sebagai berikut :<\/p>\n<ol>\n<li>Menampilkan data dari database dengan laravel<\/li>\n<li>Menginput data ke database dengan laravel<\/li>\n<li>Mengupdate atau mengubah data pada database dengan laravel<\/li>\n<li>Menghapus data dari database dengan laravel<\/li>\n<\/ol>\n<p>Karena kita akan berurusan dengan database. maka sekarang kita akan melakukan konfigurasi database dulu di laravel.<\/p>\n<p>Silahkan teman-teman baca juga tutorial sebelumnya tentang&nbsp;<a href=\"https:\/\/www.malasngoding.com\/konfigurasi-dasar-pada-laravel\/\" target=\"_blank\" rel=\"noopener\">konfigurasi pengaturan dasar pada laravel<\/a>.<\/p>\n<p>Seperti yang sudah dijelaskan sebelumnya, untuk mengatur database pada laravel kita bisa mengaturnya pada file&nbsp;.env. letaknya di direktori paling luar. jika tidak ada file .env di project laravel teman-teman, silahkan atur koneksi database nya di&nbsp;belajar_laravel\/config\/database.php.<\/p>\n<p>Jika teman-teman mengikuti tutorial laravel di malasngoding.com dari bagian ke 1, nama project laravel kita kita buat dengan nama \u201cbelajar_laravel\u201d.<\/p>\n<div id=\"attachment_3416\" class=\"wp-caption aligncenter\">\n<p><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-3416 jetpack-lazy-image jetpack-lazy-image--handled\" src=\"https:\/\/www.malasngoding.com\/wp-content\/uploads\/2018\/12\/pengaturan-database-pada-laravel.png\" alt=\"pengaturan database pada laravel\" width=\"684\" height=\"778\" aria-describedby=\"caption-attachment-3416\" data-lazy-loaded=\"1\"><\/p>\n<p id=\"caption-attachment-3416\" class=\"wp-caption-text\">pengaturan database pada laravel<\/p>\n<\/div>\n<p>Perhatikan file .env pada gambar di atas.<\/p>\n<p>Silahkan teman-teman sesuaikan nama database yang akan digunakan, username dan password mysql nya.<\/p>\n<p>BACA JUGA :&nbsp;<a href=\"https:\/\/www.malasngoding.com\/membuat-crud-dengan-php-dan-mysqli-input-data\/\" target=\"_blank\" rel=\"noopener\">Tutorial CRUD Dengan PHP dan MySQLi<\/a><\/p>\n<p>Oke jika sudah, berarti konfigurasi databasenya selesai, cukup mudah.<\/p>\n<p>Selanjutnya kita lanjutkan dengan mempersiapkan database dan tabel yang kita butuhkan.<\/p>\n<h3>Mempersiapkan Database dan Tabel Pegawai<\/h3>\n<p>Silahkan teman-teman buat database dengan nama yang sesuai dengan nama database yang sudah teman-teman tulis tadi pada file .env. pada contoh ini saya membuat database dengan nama \u201c<strong>belajar_laravel<\/strong>\u201c.<\/p>\n<p>Dan buat table dengan nama \u201cpegawai\u201d. di sini kita membuat table pegawai dengan 5 column. yaitu pegawai_id, pegawai_nama, pegawai_jabatan, pegawai_umur dan pegawai_alamat.<\/p>\n<table border=\"1\">\n<tbody>\n<tr>\n<td>pegawai_id<\/td>\n<td>int ( auto increment )<\/td>\n<\/tr>\n<tr>\n<td>pegawai_nama<\/td>\n<td>varchar ( 50 )<\/td>\n<\/tr>\n<tr>\n<td>pegawai_jabatan<\/td>\n<td>varchar (20 )<\/td>\n<\/tr>\n<tr>\n<td>pegawai_umur<\/td>\n<td>int<\/td>\n<\/tr>\n<tr>\n<td>pegawai_alamat<\/td>\n<td>text<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Lebih detailnya bisa teman-teman lihat pada gambar berikut.<\/p>\n<div id=\"attachment_3413\" class=\"wp-caption aligncenter\">\n<p><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-3413 jetpack-lazy-image jetpack-lazy-image--handled\" src=\"https:\/\/www.malasngoding.com\/wp-content\/uploads\/2018\/12\/Tutorial-Membuat-Crud-Dengan-Laravel.png\" alt=\"Tutorial Membuat Crud Dengan Laravel\" width=\"742\" height=\"409\" aria-describedby=\"caption-attachment-3413\" data-lazy-loaded=\"1\"><\/p>\n<p id=\"caption-attachment-3413\" class=\"wp-caption-text\">Tutorial Membuat Crud Dengan Laravel<\/p>\n<\/div>\n<p>Klik save atau simpan, maka proses persiapan database dan tabel selesai.<\/p>\n<p>Selanjutnya kita lanjutkan dengan menampilkan data dari database menggunakan laravel.<\/p>\n<h3>Menampilkan Data Dari Database Dengan Laravel<\/h3>\n<p>Sebelum melangkah lebih jauh untuk cara menampilkan data dari databased dengan&nbsp; laravel. pastikan teman-teman sudah memiliki beberapa data di tabel admin. agar ada data yang bisa kita oleh. di sini saya sudah menginput beberapa data ke tabel pegawai. silahkan teman-teman input beberapa data pegawai terlebih dulu.<\/p>\n<div id=\"attachment_3415\" class=\"wp-caption aligncenter\">\n<p><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-3415 jetpack-lazy-image jetpack-lazy-image--handled\" src=\"https:\/\/www.malasngoding.com\/wp-content\/uploads\/2018\/12\/Membuat-crud-pada-laravel.png\" alt=\"Membuat crud pada laravel\" width=\"756\" height=\"388\" aria-describedby=\"caption-attachment-3415\" data-lazy-loaded=\"1\"><\/p>\n<p id=\"caption-attachment-3415\" class=\"wp-caption-text\">Membuat crud pada laravel<\/p>\n<\/div>\n<p>Setelah kita memiliki beberapa data untuk ditampilkan. maka sekarang kita mulai dengan membuat route untuk menampilkan data pegawai.<\/p>\n<p>Buat route baru dengan alamat \u2018\/pegawai\u2019.<\/p>\n<p><strong>belajar_laravel\/routes\/web.php<\/strong><\/p>\n<div id=\"crayon-65c0539692d97506940030\" class=\"crayon-syntax crayon-theme-classic crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-mouseover\">\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-65c0539692d97506940030-1\">1<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692d97506940030-2\">2<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-65c0539692d97506940030-1\" class=\"crayon-line\"><span class=\"crayon-c\">\/\/route CRUD<\/span><\/div>\n<div id=\"crayon-65c0539692d97506940030-2\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-i\">Route<\/span>::<span class=\"crayon-e\">get<\/span>(<span class=\"crayon-s\">&#8216;\/pegawai&#8217;<\/span>,<span class=\"crayon-s\">&#8216;PegawaiController@index&#8217;<\/span>);<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>di sini kita memerintahkan untuk menjalankan method&nbsp;index()&nbsp;pada controller&nbsp;PegawaiController&nbsp;pada saat route \u2018\/pegawai\u2018 di akses.<\/p>\n<p>Selanjutnya buat controller PegawaiController.php, karena kita belum mempunyai controller dengan nama PegawaiController.php.<\/p>\n<p>Silahkan teman-teman baca lagi&nbsp;<a href=\"https:\/\/www.malasngoding.com\/tutorial-membuat-controller-pada-laravel\/\" target=\"_blank\" rel=\"noopener\">cara membuat controller di laravel<\/a>. karena sudah dijelaskan juga sebelumnya.<\/p>\n<p>Disini saya membuat controller menggunakan&nbsp;php artisan.<\/p><div id=\"crayon-65c0539692da4679219372\" class=\"crayon-syntax crayon-theme-classic crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-mouseover\">\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-65c0539692da4679219372-1\">1<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-65c0539692da4679219372-1\" class=\"crayon-line\"><span class=\"crayon-e\">php <\/span><span class=\"crayon-e\">artisan <\/span><span class=\"crayon-i\">make<\/span><span class=\"crayon-st\">:<\/span><span class=\"crayon-e\">controller <\/span><span class=\"crayon-v\">PegawaiController<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>Karena sebelumnya pada route \u2018\/pegawai\u2019 kita memerintahkan untuk menjalankan method index(). maka pada PegawaiController.php ini kita akan membuat metho index().<\/p>\n<p>Dan karena kita akan menggunakan query builder laravel, maka kita wajib menambahkan perintah berikut pada bagian paling atas.<\/p><div id=\"crayon-65c0539692da8453361075\" class=\"crayon-syntax crayon-theme-classic crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-mouseover\">\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-65c0539692da8453361075-1\">1<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-65c0539692da8453361075-1\" class=\"crayon-line\"><span class=\"crayon-e\">use <\/span><span class=\"crayon-i\">Illuminate<\/span>\\<span class=\"crayon-i\">Support<\/span>\\<span class=\"crayon-i\">Facades<\/span>\\<span class=\"crayon-i\">DB<\/span>;<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>Sehingga keseluruhan isi dari controller PegawaiController.php akan menjadi seperti berikut.<\/p>\n<p><strong>belajar_laravel\/app\/Http\/Controllers\/PegawaiController.php<\/strong><\/p><div id=\"crayon-65c0539692daa998473154\" class=\"crayon-syntax crayon-theme-classic crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-mouseover\">\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-65c0539692daa998473154-1\">1<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692daa998473154-2\">2<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65c0539692daa998473154-3\">3<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692daa998473154-4\">4<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65c0539692daa998473154-5\">5<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692daa998473154-6\">6<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65c0539692daa998473154-7\">7<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692daa998473154-8\">8<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65c0539692daa998473154-9\">9<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692daa998473154-10\">10<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65c0539692daa998473154-11\">11<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692daa998473154-12\">12<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65c0539692daa998473154-13\">13<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692daa998473154-14\">14<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65c0539692daa998473154-15\">15<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692daa998473154-16\">16<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65c0539692daa998473154-17\">17<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692daa998473154-18\">18<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65c0539692daa998473154-19\">19<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692daa998473154-20\">20<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-65c0539692daa998473154-1\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span>?<span class=\"crayon-e\">php<\/span><\/div>\n<div id=\"crayon-65c0539692daa998473154-2\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65c0539692daa998473154-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-65c0539692daa998473154-4\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65c0539692daa998473154-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-65c0539692daa998473154-6\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-e\">use <\/span><span class=\"crayon-i\">Illuminate<\/span>\\<span class=\"crayon-i\">Support<\/span>\\<span class=\"crayon-i\">Facades<\/span>\\<span class=\"crayon-i\">DB<\/span>;<\/div>\n<div id=\"crayon-65c0539692daa998473154-7\" class=\"crayon-line\">&nbsp;<\/div>\n<div id=\"crayon-65c0539692daa998473154-8\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65c0539692daa998473154-9\" class=\"crayon-line\"><span class=\"crayon-e\">class<\/span> <span class=\"crayon-e\">PegawaiController<\/span> <span class=\"crayon-e\">extends<\/span> <span class=\"crayon-e\">Controller<\/span><\/div>\n<div id=\"crayon-65c0539692daa998473154-10\" class=\"crayon-line crayon-striped-line\">{<\/div>\n<div id=\"crayon-65c0539692daa998473154-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\">index<\/span>()<\/div>\n<div id=\"crayon-65c0539692daa998473154-12\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;<\/span>{<\/div>\n<div id=\"crayon-65c0539692daa998473154-13\" class=\"crayon-line\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp; <\/span><span class=\"crayon-c\">\/\/ mengambil data dari table pegawai<\/span><\/div>\n<div id=\"crayon-65c0539692daa998473154-14\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp; <\/span>$<span class=\"crayon-i\">pegawai<\/span> = <span class=\"crayon-i\">DB<\/span>::<span class=\"crayon-e\">table<\/span>(<span class=\"crayon-s\">&#8216;pegawai&#8217;<\/span>)-<span class=\"crayon-h\">&gt;<\/span><span class=\"crayon-e\">get<\/span>();<\/div>\n<div id=\"crayon-65c0539692daa998473154-15\" class=\"crayon-line\">&nbsp;<\/div>\n<div id=\"crayon-65c0539692daa998473154-16\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp; <\/span><span class=\"crayon-c\">\/\/ mengirim data pegawai ke view index<\/span><\/div>\n<div id=\"crayon-65c0539692daa998473154-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;index&#8217;<\/span>,[<span class=\"crayon-s\">&#8216;pegawai&#8217;<\/span> =<span class=\"crayon-h\">&gt;<\/span> $<span class=\"crayon-i\">pegawai<\/span>]);<\/div>\n<div id=\"crayon-65c0539692daa998473154-18\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65c0539692daa998473154-19\" class=\"crayon-line\"><span class=\"crayon-h\">&nbsp;&nbsp;&nbsp;&nbsp;<\/span>}<\/div>\n<div id=\"crayon-65c0539692daa998473154-20\" class=\"crayon-line crayon-striped-line\">}<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>Perhatikan pada fungsi index yang kita buat dalam controller PegawaiController.php di atas.<\/p>\n<p>di sana kita mengambil data dari table \u2018pegawai\u2019 hanya dengan perintah yang sangat pendek. yaitu<\/p><div id=\"crayon-65c0539692dab803142617\" class=\"crayon-syntax crayon-theme-classic crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-mouseover\">\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-65c0539692dab803142617-1\">1<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692dab803142617-2\">2<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-65c0539692dab803142617-1\" class=\"crayon-line\"><span class=\"crayon-c\">\/\/ mengirim data pegawai ke view index<\/span><\/div>\n<div id=\"crayon-65c0539692dab803142617-2\" class=\"crayon-line crayon-striped-line\">$<span class=\"crayon-i\">pegawai<\/span> = <span class=\"crayon-i\">DB<\/span>::<span class=\"crayon-e\">table<\/span>(<span class=\"crayon-s\">&#8216;pegawai&#8217;<\/span>)-<span class=\"crayon-h\">&gt;<\/span><span class=\"crayon-e\">get<\/span>();<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>Dengan fungsi table() kita menentukan nama table yang ingin di pilih. fungsi get() berguna untuk mengampil data dari table yang di pilih.<\/p>\n<p>Sehingga data yang diambil akan disimpan dalam variabel&nbsp;$pegawai.<\/p>\n<p>Jadi intinya fungsi di atas itu seperti kita menampilkan data dari database dengan query mysql biasa seperti \u201d&nbsp;SELECT * FROM pegawai&nbsp;\u201c.<\/p>\n<p>Selanjut nya kita passing atau kita kirim datanya ke view agar ditampilkan.<\/p><div id=\"crayon-65c0539692dac560829660\" class=\"crayon-syntax crayon-theme-classic crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-mouseover\">\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-65c0539692dac560829660-1\">1<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692dac560829660-2\">2<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-65c0539692dac560829660-1\" class=\"crayon-line\"><span class=\"crayon-c\">\/\/ mengirim data pegawai ke view index <\/span><\/div>\n<div id=\"crayon-65c0539692dac560829660-2\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-e\">return <\/span><span class=\"crayon-e\">view<\/span>(<span class=\"crayon-s\">&#8216;index&#8217;<\/span>,[<span class=\"crayon-s\">&#8216;pegawai&#8217;<\/span> =<span class=\"crayon-h\">&gt;<\/span> $<span class=\"crayon-i\">pegawai<\/span>]);<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>Silahkan baca tutorial sebelumnya tentang&nbsp;<a href=\"https:\/\/www.malasngoding.com\/passing-data-controller-ke-view-laravel\/\" target=\"_blank\" rel=\"noopener\">cara mempassing data dari controller ke view laravel<\/a>.<\/p>\n<p>Karena kita belum punya view index. maka sekarang kita buat dulu view nya dengan nama&nbsp;index.blade.php.<\/p>\n<p><strong>belajar_laravel\/resources\/views\/index.blade.php<\/strong><\/p><div id=\"crayon-65c0539692dad765877999\" class=\"crayon-syntax crayon-theme-classic crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-mouseover\">\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-65c0539692dad765877999-1\">1<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692dad765877999-2\">2<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65c0539692dad765877999-3\">3<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692dad765877999-4\">4<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65c0539692dad765877999-5\">5<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692dad765877999-6\">6<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65c0539692dad765877999-7\">7<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692dad765877999-8\">8<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65c0539692dad765877999-9\">9<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692dad765877999-10\">10<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65c0539692dad765877999-11\">11<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692dad765877999-12\">12<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65c0539692dad765877999-13\">13<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692dad765877999-14\">14<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65c0539692dad765877999-15\">15<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692dad765877999-16\">16<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65c0539692dad765877999-17\">17<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692dad765877999-18\">18<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65c0539692dad765877999-19\">19<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692dad765877999-20\">20<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65c0539692dad765877999-21\">21<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692dad765877999-22\">22<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65c0539692dad765877999-23\">23<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692dad765877999-24\">24<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65c0539692dad765877999-25\">25<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692dad765877999-26\">26<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65c0539692dad765877999-27\">27<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692dad765877999-28\">28<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65c0539692dad765877999-29\">29<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692dad765877999-30\">30<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65c0539692dad765877999-31\">31<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692dad765877999-32\">32<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65c0539692dad765877999-33\">33<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692dad765877999-34\">34<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65c0539692dad765877999-35\">35<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692dad765877999-36\">36<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65c0539692dad765877999-37\">37<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692dad765877999-38\">38<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65c0539692dad765877999-39\">39<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692dad765877999-40\">40<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65c0539692dad765877999-41\">41<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-65c0539692dad765877999-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-65c0539692dad765877999-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-65c0539692dad765877999-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-65c0539692dad765877999-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-e\">Membuat <\/span><span class=\"crayon-e\">CRUD <\/span><span class=\"crayon-e\">Pada <\/span><span class=\"crayon-i\">Laravel<\/span> &#8211; <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-i\">title<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65c0539692dad765877999-5\" 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-65c0539692dad765877999-6\" 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-65c0539692dad765877999-7\" class=\"crayon-line\">&nbsp;<\/div>\n<div id=\"crayon-65c0539692dad765877999-8\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-i\">h2<\/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-i\">h2<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65c0539692dad765877999-9\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-i\">h3<\/span><span class=\"crayon-h\">&gt;<\/span><span class=\"crayon-e\">Data <\/span><span class=\"crayon-i\">Pegawai<\/span><span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">h3<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65c0539692dad765877999-10\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65c0539692dad765877999-11\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-st\">a<\/span> <span class=\"crayon-i\">href<\/span>=<span class=\"crayon-s\">&#8220;\/pegawai\/tambah&#8221;<\/span><span class=\"crayon-h\">&gt;<\/span> + <span class=\"crayon-e\">Tambah <\/span><span class=\"crayon-e\">Pegawai <\/span><span class=\"crayon-i\">Baru<\/span><span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-st\">a<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65c0539692dad765877999-12\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65c0539692dad765877999-13\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-i\">br<\/span>\/<span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65c0539692dad765877999-14\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-i\">br<\/span>\/<span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65c0539692dad765877999-15\" class=\"crayon-line\">&nbsp;<\/div>\n<div id=\"crayon-65c0539692dad765877999-16\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-e\">table <\/span><span class=\"crayon-i\">border<\/span>=<span class=\"crayon-s\">&#8220;1&#8221;<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65c0539692dad765877999-17\" 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-65c0539692dad765877999-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\">Nama<\/span><span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">th<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65c0539692dad765877999-19\" 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\">Jabatan<\/span><span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">th<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65c0539692dad765877999-20\" 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\">Umur<\/span><span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">th<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65c0539692dad765877999-21\" 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\">Alamat<\/span><span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">th<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65c0539692dad765877999-22\" 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\">Opsi<\/span><span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">th<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65c0539692dad765877999-23\" 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-65c0539692dad765877999-24\" class=\"crayon-line crayon-striped-line\">@<span class=\"crayon-e\">foreach<\/span>($<span class=\"crayon-e\">pegawai <\/span><span class=\"crayon-i\">as<\/span> $<span class=\"crayon-t\">p<\/span>)<\/div>\n<div id=\"crayon-65c0539692dad765877999-25\" 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-65c0539692dad765877999-26\" 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\">pegawai_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-65c0539692dad765877999-27\" 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\">pegawai_jabatan<\/span> }}<span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-e\">td<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65c0539692dad765877999-28\" 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\">pegawai_umur<\/span> }}<span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-e\">td<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65c0539692dad765877999-29\" 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\">pegawai_alamat<\/span> }}<span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">td<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65c0539692dad765877999-30\" 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-65c0539692dad765877999-31\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-st\">a<\/span> <span class=\"crayon-i\">href<\/span>=<span class=\"crayon-s\">&#8220;\/pegawai\/edit\/{{ $p-&gt;pegawai_id }}&#8221;<\/span><span class=\"crayon-h\">&gt;<\/span><span class=\"crayon-i\">Edit<\/span><span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-st\">a<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65c0539692dad765877999-32\" class=\"crayon-line crayon-striped-line\">|<\/div>\n<div id=\"crayon-65c0539692dad765877999-33\" class=\"crayon-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-st\">a<\/span> <span class=\"crayon-i\">href<\/span>=<span class=\"crayon-s\">&#8220;\/pegawai\/hapus\/{{ $p-&gt;pegawai_id }}&#8221;<\/span><span class=\"crayon-h\">&gt;<\/span><span class=\"crayon-i\">Hapus<\/span><span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-st\">a<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65c0539692dad765877999-34\" 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-65c0539692dad765877999-35\" 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-65c0539692dad765877999-36\" class=\"crayon-line crayon-striped-line\">@<span class=\"crayon-i\">endforeach<\/span><\/div>\n<div id=\"crayon-65c0539692dad765877999-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-65c0539692dad765877999-38\" class=\"crayon-line crayon-striped-line\">&nbsp;<\/div>\n<div id=\"crayon-65c0539692dad765877999-39\" class=\"crayon-line\">&nbsp;<\/div>\n<div id=\"crayon-65c0539692dad765877999-40\" 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-65c0539692dad765877999-41\" 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>Oke, coba teman-teman perhatikan pada view index.blade.php di atas. sebelumnya, pada controller data yang kita ambil dari table pegawai kita simpan dalam variabel $pegawai. kemudian kita passing ke view.<\/p>\n<p>nah, pada view tinggal langsung kita tampilkan dalam perulangan foreach().<\/p><div id=\"crayon-65c0539692dae848436385\" class=\"crayon-syntax crayon-theme-classic crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-mouseover\">\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-65c0539692dae848436385-1\">1<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692dae848436385-2\">2<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65c0539692dae848436385-3\">3<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692dae848436385-4\">4<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65c0539692dae848436385-5\">5<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692dae848436385-6\">6<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65c0539692dae848436385-7\">7<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692dae848436385-8\">8<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65c0539692dae848436385-9\">9<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692dae848436385-10\">10<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65c0539692dae848436385-11\">11<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"crayon-65c0539692dae848436385-12\">12<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-65c0539692dae848436385-13\">13<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-65c0539692dae848436385-1\" class=\"crayon-line\">@<span class=\"crayon-e\">foreach<\/span>($<span class=\"crayon-e\">pegawai <\/span><span class=\"crayon-i\">as<\/span> $<span class=\"crayon-t\">p<\/span>)<\/div>\n<div id=\"crayon-65c0539692dae848436385-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-65c0539692dae848436385-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\">pegawai_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-65c0539692dae848436385-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\">pegawai_jabatan<\/span> }}<span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-e\">td<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65c0539692dae848436385-5\" 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\">pegawai_umur<\/span> }}<span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-e\">td<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65c0539692dae848436385-6\" 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\">pegawai_alamat<\/span> }}<span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-i\">td<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65c0539692dae848436385-7\" 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-65c0539692dae848436385-8\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-st\">a<\/span> <span class=\"crayon-i\">href<\/span>=<span class=\"crayon-s\">&#8220;\/pegawai\/edit\/{{ $p-&gt;pegawai_id }}&#8221;<\/span><span class=\"crayon-h\">&gt;<\/span><span class=\"crayon-i\">Edit<\/span><span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-st\">a<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65c0539692dae848436385-9\" class=\"crayon-line\">|<\/div>\n<div id=\"crayon-65c0539692dae848436385-10\" class=\"crayon-line crayon-striped-line\"><span class=\"crayon-h\">&lt;<\/span><span class=\"crayon-st\">a<\/span> <span class=\"crayon-i\">href<\/span>=<span class=\"crayon-s\">&#8220;\/pegawai\/hapus\/{{ $p-&gt;pegawai_id }}&#8221;<\/span><span class=\"crayon-h\">&gt;<\/span><span class=\"crayon-i\">Hapus<\/span><span class=\"crayon-h\">&lt;<\/span>\/<span class=\"crayon-st\">a<\/span><span class=\"crayon-h\">&gt;<\/span><\/div>\n<div id=\"crayon-65c0539692dae848436385-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-65c0539692dae848436385-12\" 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-65c0539692dae848436385-13\" class=\"crayon-line\">@<span class=\"crayon-v\">endforeach<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>Kenapa penulisan fungsi foreach() nya @foreach() sudah dijelaskan juga pada tutorial laravel sebelumnya.<\/p>\n<p>dan sekarang coba kita lihat hasilnya. silahkan akses route \u2018\/pegawai\u2019.<\/p>\n<div id=\"attachment_3417\" class=\"wp-caption aligncenter\">\n<p><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-3417 jetpack-lazy-image jetpack-lazy-image--handled\" src=\"https:\/\/www.malasngoding.com\/wp-content\/uploads\/2018\/12\/menampilkan-data-dari-database-dengan-laravel.png\" alt=\"menampilkan data dari database dengan laravel\" width=\"796\" height=\"488\" aria-describedby=\"caption-attachment-3417\" data-lazy-loaded=\"1\"><\/p>\n<p id=\"caption-attachment-3417\" class=\"wp-caption-text\">menampilkan data dari database dengan laravel<\/p>\n<\/div>\n<p>Sampai di sini kita telah berhasil menampilkan data pegawai dari database pada laravel.<\/p>\n<p>Oke sekian dulu tutorial membuat CRUD Dengan Laravel.<\/p>\n<p>Pada Part Selanjutnya kita akan melanjutkan tutorial membuat CRUD dengan Laravel ini dengan membuat proses input data ke database dengan laravel.<\/p>\n<p>Sampai jumpa di tutorial selanjutnya.<\/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>Untuk bermain-main dengan database pada laravel, sebenarnya ada 2 cara yang umum digunakan. yaitu kita bisa menggunakan&nbsp;Query Builder&nbsp;dan&nbsp;Eloquent. Keduanya merupakan fitur yang sudah disediakan pada laravel. sehingga kita bisa lebih mudah dalam membuat CRUD pada laravel. Tetapi pada sub judul ini kita akan belajar&nbsp;membuat CRUD dengan menggunakan Query Builder pada laravel. Untuk tutorial membuat CRUD [&hellip;]<\/p>\n","protected":false},"author":21,"featured_media":1285,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[12,9],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.uts.ac.id\/jul\/wp-json\/wp\/v2\/posts\/1276"}],"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=1276"}],"version-history":[{"count":6,"href":"https:\/\/blog.uts.ac.id\/jul\/wp-json\/wp\/v2\/posts\/1276\/revisions"}],"predecessor-version":[{"id":2255,"href":"https:\/\/blog.uts.ac.id\/jul\/wp-json\/wp\/v2\/posts\/1276\/revisions\/2255"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.uts.ac.id\/jul\/wp-json\/wp\/v2\/media\/1285"}],"wp:attachment":[{"href":"https:\/\/blog.uts.ac.id\/jul\/wp-json\/wp\/v2\/media?parent=1276"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.uts.ac.id\/jul\/wp-json\/wp\/v2\/categories?post=1276"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.uts.ac.id\/jul\/wp-json\/wp\/v2\/tags?post=1276"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}