{"id":1296,"date":"2024-01-31T06:32:53","date_gmt":"2024-01-31T06:32:53","guid":{"rendered":"https:\/\/blog.uts.ac.id\/jul\/?p=1296"},"modified":"2024-02-05T04:08:12","modified_gmt":"2024-02-05T04:08:12","slug":"laravel-16-membuat-pencarian-pada-laravel","status":"publish","type":"post","link":"https:\/\/blog.uts.ac.id\/jul\/2024\/01\/31\/laravel-16-membuat-pencarian-pada-laravel\/","title":{"rendered":"Laravel #16 : Membuat Pencarian Pada Laravel"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t

Form pencarian yang akan kita buat adalah form pencarian pada data pegawai yang sudah kita buat pada tutorial sebelumnya.<\/p>\n

Silahkan teman-teman ikuti tutorial sebelumnya jika belum, agar penjelasan tentang cara membuat pencarian pada laravel<\/strong> ini lebih mudah teman-teman pahami.<\/p>\n

Persiapan<\/h3>\n

Akan saya ulang sekilas. untuk sekedar memastikan kembali. pastikan teman-teman sudah mempunyai database dan sebuah tabel yang akan kita buat pencarian data pada tabel tersebut.<\/p>\n

Pada tutorial ini kita sudah mempunyai database dengan nama \u2018belajar_laravel\u2019. dan sebuah tabel dengan nama \u2018pegawai\u2019.<\/p>\n

Silahkan teman-teman buat terlebih dulu jika belum.<\/p>\n

Atau untuk menghemat waktu silahkan teman-teman import sql berikut ke database \u2018belajar_laravel\u2019.<\/p>\n

pegawai.sql<\/strong><\/p>\n

\n
\n
\n
\n<\/div>\n<\/div>\n<\/div>\n
 <\/div>\n
\n\n\n\n
\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n
30<\/div>\n
31<\/div>\n
32<\/div>\n
33<\/div>\n
34<\/div>\n
35<\/div>\n
36<\/div>\n
37<\/div>\n
38<\/div>\n
39<\/div>\n
40<\/div>\n
41<\/div>\n
42<\/div>\n
43<\/div>\n
44<\/div>\n
45<\/div>\n
46<\/div>\n
47<\/div>\n
48<\/div>\n
49<\/div>\n
50<\/div>\n
51<\/div>\n
52<\/div>\n
53<\/div>\n
54<\/div>\n
55<\/div>\n
56<\/div>\n
57<\/div>\n
58<\/div>\n
59<\/div>\n
60<\/div>\n
61<\/div>\n
62<\/div>\n
63<\/div>\n
64<\/div>\n
65<\/div>\n
66<\/div>\n
67<\/div>\n
68<\/div>\n
69<\/div>\n
70<\/div>\n
71<\/div>\n
72<\/div>\n
73<\/div>\n
74<\/div>\n
75<\/div>\n
76<\/div>\n
77<\/div>\n
78<\/div>\n
79<\/div>\n
80<\/div>\n
81<\/div>\n
82<\/div>\n
83<\/div>\n
84<\/div>\n
85<\/div>\n
86<\/div>\n
87<\/div>\n
88<\/div>\n
89<\/div>\n
90<\/div>\n
91<\/div>\n
92<\/div>\n
93<\/div>\n
94<\/div>\n
95<\/div>\n
96<\/div>\n
97<\/div>\n
98<\/div>\n
99<\/div>\n
100<\/div>\n
101<\/div>\n
102<\/div>\n
103<\/div>\n
104<\/div>\n
105<\/div>\n
106<\/div>\n
107<\/div>\n
108<\/div>\n
109<\/div>\n
110<\/div>\n
111<\/div>\n
112<\/div>\n
113<\/div>\n
114<\/div>\n
115<\/div>\n
116<\/div>\n
117<\/div>\n
118<\/div>\n
119<\/div>\n
120<\/div>\n
121<\/div>\n<\/div>\n<\/td>\n
\n
\n
— phpMyAdmin <\/span>SQL <\/span>Dump<\/span><\/div>\n
— version<\/span> 4.8.0.1<\/span><\/div>\n
— https<\/span>:\/\/www.phpmyadmin.net\/<\/span><\/div>\n
—<\/div>\n
— Host<\/span>: localhost<\/span><\/div>\n
— Generation <\/span>Time<\/span>: Dec<\/span> 16<\/span>, 2018<\/span> at<\/span> 01<\/span>:<\/span>33<\/span> PM<\/span><\/div>\n
— Server <\/span>version<\/span>: 10.1.32<\/span>–MariaDB<\/span><\/div>\n
— PHP <\/span>Version<\/span>: 5.6.36<\/span><\/div>\n
 <\/div>\n
SET <\/span>SQL_MODE<\/span> = “NO_AUTO_VALUE_ON_ZERO”<\/span>;<\/div>\n
SET <\/span>AUTOCOMMIT<\/span> = 0<\/span>;<\/div>\n
START <\/span>TRANSACTION<\/span>;<\/div>\n
SET <\/span>time_zone<\/span> = “+00:00”<\/span>;<\/div>\n
 <\/div>\n
 <\/div>\n
\/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT *\/<\/span>;<\/div>\n
\/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS *\/<\/span>;<\/div>\n
\/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION *\/<\/span>;<\/div>\n
\/*!40101 SET NAMES utf8mb4 *\/<\/span>;<\/div>\n
 <\/div>\n
—<\/div>\n
— Database<\/span>: `belajar_laravel<\/span>`<\/div>\n
—<\/div>\n
 <\/div>\n
— ——————————————————–<\/div>\n
 <\/div>\n
—<\/div>\n
— Table <\/span>structure <\/span>for <\/span>table<\/span> `pegawai<\/span>`<\/div>\n
—<\/div>\n
 <\/div>\n
CREATE <\/span>TABLE<\/span> `pegawai<\/span>` (<\/div>\n
  <\/span>`pegawai_id<\/span>` int<\/span>(11<\/span>) NOT <\/span>NULL<\/span>,<\/div>\n
  <\/span>`pegawai_nama<\/span>` varchar<\/span>(50<\/span>) NOT <\/span>NULL<\/span>,<\/div>\n
  <\/span>`pegawai_jabatan<\/span>` varchar<\/span>(20<\/span>) NOT <\/span>NULL<\/span>,<\/div>\n
  <\/span>`pegawai_umur<\/span>` int<\/span>(11<\/span>) NOT <\/span>NULL<\/span>,<\/div>\n
  <\/span>`pegawai_alamat<\/span>` text <\/span>NOT <\/span>NULL<\/span><\/div>\n
) ENGINE<\/span>=InnoDB <\/span>DEFAULT <\/span>CHARSET<\/span>=latin1<\/span>;<\/div>\n
 <\/div>\n
—<\/div>\n
— Dumping <\/span>data <\/span>for <\/span>table<\/span> `pegawai<\/span>`<\/div>\n
—<\/div>\n
 <\/div>\n
INSERT <\/span>INTO<\/span> `pegawai<\/span>` (`pegawai_id<\/span>`, `pegawai_nama<\/span>`, `pegawai_jabatan<\/span>`, `pegawai_umur<\/span>`, `pegawai_alamat<\/span>`) VALUES<\/span><\/div>\n
(2<\/span>, ‘Diki Alfarabi Hadi’<\/span>, ‘Staff IT’<\/span>, 26<\/span>, ‘Jl. Merak Putih’<\/span>),<\/div>\n
(4<\/span>, ‘Malas Ngoding’<\/span>, ‘Programmer’<\/span>, 30<\/span>, ‘Jl. Cendrawasih nomor 31’<\/span>),<\/div>\n
(7<\/span>, ‘Joni’<\/span>, ‘Web Designer’<\/span>, 25<\/span>, ‘Jl. Panglateh’<\/span>),<\/div>\n
(8<\/span>, ‘Elma Sudiati’<\/span>, ‘quo’<\/span>, 38<\/span>, ‘Gg. Cikapayang No. 255, Sungai Penuh 32691, Riau’<\/span>),<\/div>\n
(9<\/span>, ‘Slamet Lega Rajata S.Farm’<\/span>, ‘voluptatem’<\/span>, 32<\/span>, ‘Gg. Supono No. 84, Sawahlunto 47885, SulSel’<\/span>),<\/div>\n
(10<\/span>, ‘Jaya Naradi Situmorang’<\/span>, ‘quasi’<\/span>, 33<\/span>, ‘Dk. Imam Bonjol No. 814, Palu 46518, SumUt’<\/span>),<\/div>\n
(11<\/span>, ‘Rendy Habibi S.Psi’<\/span>, ‘sit’<\/span>, 37<\/span>, ‘Gg. Basuki No. 314, Administrasi Jakarta Pusat 73176, NTB’<\/span>),<\/div>\n
(12<\/span>, ‘Yahya Sinaga’<\/span>, ‘enim’<\/span>, 26<\/span>, ‘Ki. Industri No. 238, Sungai Penuh 38002, SulSel’<\/span>),<\/div>\n
(13<\/span>, ‘Hesti Janet Hasanah S.Sos’<\/span>, ‘est’<\/span>, 35<\/span>, ‘Dk. Wahidin Sudirohusodo No. 637, Surabaya 44801, Banten’<\/span>),<\/div>\n
(14<\/span>, ‘Sari Rahmi Melani’<\/span>, ‘laborum’<\/span>, 36<\/span>, ‘Psr. Dipatiukur No. 227, Balikpapan 19234, SulTeng’<\/span>),<\/div>\n
(15<\/span>, ‘Clara Wahyuni’<\/span>, ‘eveniet’<\/span>, 38<\/span>, ‘Jln. Otista No. 163, Dumai 91798, KalUt’<\/span>),<\/div>\n
(16<\/span>, ‘Dasa Jais Maheswara’<\/span>, ‘esse’<\/span>, 32<\/span>, ‘Kpg. Radio No. 94, Padangpanjang 14989, Bali’<\/span>),<\/div>\n
(17<\/span>, ‘Viktor Prasasta’<\/span>, ‘sunt’<\/span>, 27<\/span>, ‘Jln. BKR No. 694, Surakarta 95932, NTB’<\/span>),<\/div>\n
(18<\/span>, ‘Lurhur Damanik’<\/span>, ‘nemo’<\/span>, 29<\/span>, ‘Psr. Salak No. 990, Bau-Bau 25079, SulSel’<\/span>),<\/div>\n
(19<\/span>, ‘Zelaya Nasyidah’<\/span>, ‘sit’<\/span>, 29<\/span>, ‘Jr. Kali No. 589, Administrasi Jakarta Barat 96388, Gorontalo’<\/span>),<\/div>\n
(20<\/span>, ‘Oman Damanik’<\/span>, ‘maiores’<\/span>, 28<\/span>, ‘Psr. Taman No. 461, Banjarbaru 37220, Maluku’<\/span>),<\/div>\n
(21<\/span>, ‘Lili Anggraini’<\/span>, ‘id’<\/span>, 25<\/span>, ‘Jr. Baranang No. 631, Pariaman 57837, JaTim’<\/span>),<\/div>\n
(22<\/span>, ‘Harto Prabowo’<\/span>, ‘quos’<\/span>, 38<\/span>, ‘Jln. Ki Hajar Dewantara No. 213, Tual 51023, Jambi’<\/span>),<\/div>\n
(23<\/span>, ‘Kanda Habibi’<\/span>, ‘nam’<\/span>, 35<\/span>, ‘Kpg. Baan No. 69, Blitar 72288, Lampung’<\/span>),<\/div>\n
(24<\/span>, ‘Wani Prastuti’<\/span>, ‘doloremque’<\/span>, 33<\/span>, ‘Gg. Bakau No. 67, Pagar Alam 78006, Papua’<\/span>),<\/div>\n
(25<\/span>, ‘Vero Natsir’<\/span>, ‘illum’<\/span>, 34<\/span>, ‘Ds. Salak No. 391, Pontianak 80916, KalTeng’<\/span>),<\/div>\n
(26<\/span>, ‘Paris Hani Nuraini S.IP’<\/span>, ‘quo’<\/span>, 39<\/span>, ‘Ds. Dahlia No. 744, Ambon 99599, KalTeng’<\/span>),<\/div>\n
(27<\/span>, ‘Padma Salimah Suartini S.H.’<\/span>, ‘ab’<\/span>, 38<\/span>, ‘Ds. Bawal No. 241, Salatiga 42046, Papua’<\/span>),<\/div>\n
(28<\/span>, ‘Kasiran Pangeran Prasetyo’<\/span>, ‘aut’<\/span>, 35<\/span>, ‘Ki. Fajar No. 272, Prabumulih 45913, Aceh’<\/span>),<\/div>\n
(29<\/span>, ‘Aslijan Sirait’<\/span>, ‘repellendus’<\/span>, 25<\/span>, ‘Gg. Ujung No. 11, Pekanbaru 57006, MalUt’<\/span>),<\/div>\n
(30<\/span>, ‘Ira Nuraini’<\/span>, ‘magnam’<\/span>, 36<\/span>, ‘Gg. Yohanes No. 441, Jambi 46510, SumSel’<\/span>),<\/div>\n
(31<\/span>, ‘Kiandra Puspita’<\/span>, ‘enim’<\/span>, 40<\/span>, ‘Dk. Kali No. 33, Pontianak 12025, MalUt’<\/span>),<\/div>\n
(32<\/span>, ‘Harsaya Prayoga’<\/span>, ‘esse’<\/span>, 25<\/span>, ‘Kpg. Dago No. 928, Kupang 92150, Bali’<\/span>),<\/div>\n
(33<\/span>, ‘Mala Lailasari’<\/span>, ‘cupiditate’<\/span>, 25<\/span>, ‘Dk. Wahidin Sudirohusodo No. 13, Cirebon 44084, Bali’<\/span>),<\/div>\n
(34<\/span>, ‘Ayu Zizi Kuswandari’<\/span>, ‘voluptas’<\/span>, 32<\/span>, ‘Psr. Laksamana No. 259, Batu 93531, KalSel’<\/span>),<\/div>\n
(35<\/span>, ‘Adika Wasita’<\/span>, ‘cum’<\/span>, 29<\/span>, ‘Jr. Ki Hajar Dewantara No. 725, Sawahlunto 19536, Gorontalo’<\/span>),<\/div>\n
(36<\/span>, ‘Najib Omar Anggriawan’<\/span>, ‘omnis’<\/span>, 25<\/span>, ‘Kpg. Suniaraja No. 917, Tanjung Pinang 37324, SumUt’<\/span>),<\/div>\n
(37<\/span>, ‘Edward Tomi Saptono M.M.’<\/span>, ‘praesentium’<\/span>, 29<\/span>, ‘Dk. Sadang Serang No. 852, Surakarta 37423, SulTeng’<\/span>),<\/div>\n
(38<\/span>, ‘Ajimat Ardianto M.Kom.’<\/span>, ‘excepturi’<\/span>, 40<\/span>, ‘Gg. Bakti No. 251, Parepare 48583, Maluku’<\/span>),<\/div>\n
(39<\/span>, ‘Carub Gamblang Prasasta S.H.’<\/span>, ‘inventore’<\/span>, 34<\/span>, ‘Gg. Cikutra Barat No. 259, Gunungsitoli 25016, SumUt’<\/span>),<\/div>\n
(40<\/span>, ‘Dimaz Prabowo S.Gz’<\/span>, ‘libero’<\/span>, 26<\/span>, ‘Ds. Baya Kali Bungur No. 472, Bitung 95442, Lampung’<\/span>),<\/div>\n
(41<\/span>, ‘Siti Farida’<\/span>, ‘autem’<\/span>, 37<\/span>, ‘Dk. Hang No. 1, Bengkulu 71277, SumUt’<\/span>),<\/div>\n
(42<\/span>, ‘Uchita Astuti’<\/span>, ‘recusandae’<\/span>, 40<\/span>, ‘Ki. Sutami No. 779, Pontianak 99497, JaTim’<\/span>),<\/div>\n
(43<\/span>, ‘Zalindra Ghaliyati Puspita S.E.I’<\/span>, ‘saepe’<\/span>, 39<\/span>, ‘Ki. Flores No. 891, Bandar Lampung 35072, SulSel’<\/span>),<\/div>\n
(44<\/span>, ‘Respati Tampubolon’<\/span>, ‘facere’<\/span>, 31<\/span>, ‘Jr. Bagas Pati No. 769, Bukittinggi 80941, SulTeng’<\/span>),<\/div>\n
(45<\/span>, ‘Zulaikha Puspita’<\/span>, ‘quam’<\/span>, 40<\/span>, ‘Gg. Baan No. 59, Pematangsiantar 98370, KalBar’<\/span>),<\/div>\n
(46<\/span>, ‘Maya Andriani’<\/span>, ‘voluptatibus’<\/span>, 39<\/span>, ‘Kpg. Warga No. 155, Payakumbuh 15521, Jambi’<\/span>),<\/div>\n
(47<\/span>, ‘Tantri Putri Namaga S.T.’<\/span>, ‘voluptatem’<\/span>, 29<\/span>, ‘Kpg. Laswi No. 427, Banjarbaru 52446, KalUt’<\/span>),<\/div>\n
(48<\/span>, ‘Dimaz Rajasa M.M.’<\/span>, ‘sit’<\/span>, 39<\/span>, ‘Gg. Madiun No. 340, Pontianak 29529, SulUt’<\/span>),<\/div>\n
(49<\/span>, ‘Lintang Lalita Astuti S.Psi’<\/span>, ‘beatae’<\/span>, 33<\/span>, ‘Kpg. Baja No. 834, Gunungsitoli 25347, PapBar’<\/span>),<\/div>\n
(50<\/span>, ‘Sakura Widiastuti’<\/span>, ‘exercitationem’<\/span>, 35<\/span>, ‘Dk. Cokroaminoto No. 844, Padangpanjang 88917, Gorontalo’<\/span>),<\/div>\n
(51<\/span>, ‘Laksana Hidayat’<\/span>, ‘sunt’<\/span>, 40<\/span>, ‘Ds. Bakau Griya Utama No. 757, Bandar Lampung 42512, SumSel’<\/span>),<\/div>\n
(52<\/span>, ‘Faizah Kusmawati S.Ked’<\/span>, ‘tempora’<\/span>, 37<\/span>, ‘Ds. Badak No. 423, Pangkal Pinang 76234, SumSel’<\/span>),<\/div>\n
(53<\/span>, ‘Tami Nilam Widiastuti’<\/span>, ‘esse’<\/span>, 40<\/span>, ‘Psr. Bahagia No. 723, Jayapura 94256, Maluku’<\/span>),<\/div>\n
(54<\/span>, ‘Tina Maryati’<\/span>, ‘est’<\/span>, 36<\/span>, ‘Jln. Lumban Tobing No. 182, Bau-Bau 47907, SumUt’<\/span>),<\/div>\n
(55<\/span>, ‘Enteng Habibi S.Pd’<\/span>, ‘voluptate’<\/span>, 39<\/span>, ‘Jr. Achmad Yani No. 211, Tasikmalaya 38586, JaBar’<\/span>),<\/div>\n
(56<\/span>, ‘Waluyo Samosir’<\/span>, ‘ipsum’<\/span>, 39<\/span>, ‘Ki. Badak No. 252, Sorong 37092, SulTeng’<\/span>),<\/div>\n
(57<\/span>, ‘Malika Eli Kusmawati’<\/span>, ‘exercitationem’<\/span>, 32<\/span>, ‘Ds. Banda No. 618, Tanjung Pinang 93287, Gorontalo’<\/span>);<\/div>\n
 <\/div>\n
—<\/div>\n
— Indexes <\/span>for <\/span>dumped <\/span>tables<\/span><\/div>\n
—<\/div>\n
 <\/div>\n
—<\/div>\n
— Indexes <\/span>for <\/span>table<\/span> `pegawai<\/span>`<\/div>\n
—<\/div>\n
ALTER <\/span>TABLE<\/span> `pegawai<\/span>`<\/div>\n
  <\/span>ADD <\/span>PRIMARY <\/span>KEY<\/span> (`pegawai_id<\/span>`);<\/div>\n
 <\/div>\n
—<\/div>\n
— AUTO_INCREMENT <\/span>for <\/span>dumped <\/span>tables<\/span><\/div>\n
—<\/div>\n
 <\/div>\n
—<\/div>\n
— AUTO_INCREMENT <\/span>for <\/span>table<\/span> `pegawai<\/span>`<\/div>\n
—<\/div>\n
ALTER <\/span>TABLE<\/span> `pegawai<\/span>`<\/div>\n
  <\/span>MODIFY<\/span> `pegawai_id<\/span>` int<\/span>(11<\/span>) NOT <\/span>NULL <\/span>AUTO_INCREMENT<\/span>, AUTO_INCREMENT<\/span>=58<\/span>;<\/div>\n
COMMIT<\/span>;<\/div>\n
 <\/div>\n
\/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT *\/<\/span>;<\/div>\n
\/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS *\/<\/span>;<\/div>\n
\/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION *\/<\/span>;<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Dan jangan lupa untuk membuat konfigurasi database project laravel nya pada file .env.<\/p>\n

Membuat Pencarian Data Pada Laravel<\/h3>\n

Oke langsung saja kita mulai<\/p>\n

Untuk membuat pencarian menggunakan laravel, kita membutuhkan 2 buah route dan 2 buah method.<\/p>\n

Baca lagi : Belajar Route dan View pada Laravel<\/a><\/p>\n

Buat route untuk menampilkan data pegawai secara default (tanpa pencarian). dan 1 buah route untuk mengarahkan ke method yang menangani proses pencarian.<\/p>\n

belajar_laravel\/routes\/web.php<\/strong><\/p>\n

\n
\n\n\n\n
\n
\n
1<\/div>\n
2<\/div>\n<\/div>\n<\/td>\n
\n
\n
Route<\/span>::get<\/span>(‘\/pegawai’<\/span>,‘PegawaiController@index’<\/span>);<\/div>\n
Route<\/span>::get<\/span>(‘\/pegawai\/cari’<\/span>,‘PegawaiController@cari’<\/span>);<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Perhatikan pada route di atas. pada route<\/p>\n

\n
\n\n\n\n
\n
\n
1<\/div>\n<\/div>\n<\/td>\n
\n
\n
Route<\/span>::get<\/span>(‘\/pegawai’<\/span>,‘PegawaiController@index’<\/span>);<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

kita akan menampilkan semua data pegawai. kita juga akan membuat sebuah form pencarian pada method index. dan pada route<\/p>

\n
\n\n\n\n
\n
\n
1<\/div>\n<\/div>\n<\/td>\n
\n
\n
Route<\/span>::get<\/span>(‘\/pegawai\/cari’<\/span>,‘PegawaiController@cari’<\/span>);<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

kita akan menjadikan method cari sebagai method yang menangani data pencarian yang dikirim dari form pencarian yang dikirim dari method index.<\/p>\n

oke, saya rasa teman-teman sudah familiar dengan route, method, controller dan views pada laravel. karena sudah berulang-ulang kali kita bahas pada tutorial sebelumnya.<\/p>\n

Kemudian buat controller PegawaiController.php jika belum. untuk teman-teman yang sudah mengikuti tutorial laravel di malasngoding.com pasti sudah punya controller PegawaiController.php.<\/p>\n

belajar_laravel\/app\/Http\/controllers\/PegawaiController.php<\/strong><\/p>

\n
\n\n\n\n
\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n
30<\/div>\n
31<\/div>\n
32<\/div>\n
33<\/div>\n
34<\/div>\n
35<\/div>\n
36<\/div>\n<\/div>\n<\/td>\n
\n
\n
<<\/span>?php<\/span><\/div>\n
 <\/div>\n
namespace <\/span>App<\/span>\\Http<\/span>\\Controllers<\/span>;<\/div>\n
 <\/div>\n
use <\/span>Illuminate<\/span>\\Http<\/span>\\Request<\/span>;<\/div>\n
use <\/span>Illuminate<\/span>\\Support<\/span>\\Facades<\/span>\\DB<\/span>;<\/div>\n
 <\/div>\n
 <\/div>\n
class<\/span> PegawaiController<\/span> extends<\/span> Controller<\/span><\/div>\n
{<\/div>\n
public <\/span>function <\/span>index<\/span>()<\/div>\n
{<\/div>\n
     <\/span>\/\/ mengambil data dari table pegawai<\/span><\/div>\n
$pegawai<\/span> = DB<\/span>::table<\/span>(‘pegawai’<\/span>)-><\/span>paginate<\/span>(10<\/span>);<\/div>\n
 <\/div>\n
     <\/span>\/\/ mengirim data pegawai ke view index<\/span><\/div>\n
return <\/span>view<\/span>(‘index’<\/span>,[‘pegawai’<\/span> =><\/span> $pegawai<\/span>]);<\/div>\n
 <\/div>\n
}<\/div>\n
 <\/div>\n
public <\/span>function <\/span>cari<\/span>(Request<\/span> $request<\/span>)<\/div>\n
{<\/div>\n
\/\/ menangkap data pencarian<\/span><\/div>\n
$cari<\/span> = $request<\/span>–><\/span>cari<\/span>;<\/div>\n
 <\/div>\n
     <\/span>\/\/ mengambil data dari table pegawai sesuai pencarian data<\/span><\/div>\n
$pegawai<\/span> = DB<\/span>::table<\/span>(‘pegawai’<\/span>)<\/div>\n
–><\/span>where<\/span>(‘pegawai_nama’<\/span>,‘like’<\/span>,“%”<\/span>.$cari<\/span>.“%”<\/span>)<\/div>\n
–><\/span>paginate<\/span>();<\/div>\n
 <\/div>\n
     <\/span>\/\/ mengirim data pegawai ke view index<\/span><\/div>\n
return <\/span>view<\/span>(‘index’<\/span>,[‘pegawai’<\/span> =><\/span> $pegawai<\/span>]);<\/div>\n
 <\/div>\n
}<\/div>\n
 <\/div>\n
}<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Seperti yang sudah kita tetapkan pada route, ada 2 buah method yang akan kita gunakan, yaitu method yang akan menampilkan data pegawai yang belum di proses. dan method cari yang melakukan proses pencarian data dan menampilkan datanya kembali.<\/p>\n

Karena pada method index kita menampilkan data pegawai ke view index. maka sekarang buat view baru dengan nama index.blade.php<\/p>\n

belajar_laravel\/resources\/views\/index.blade.php<\/strong><\/p>

\n
\n\n\n\n
\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n
30<\/div>\n
31<\/div>\n
32<\/div>\n
33<\/div>\n
34<\/div>\n
35<\/div>\n
36<\/div>\n
37<\/div>\n
38<\/div>\n
39<\/div>\n
40<\/div>\n
41<\/div>\n
42<\/div>\n
43<\/div>\n
44<\/div>\n
45<\/div>\n
46<\/div>\n
47<\/div>\n
48<\/div>\n
49<\/div>\n
50<\/div>\n
51<\/div>\n
52<\/div>\n
53<\/div>\n
54<\/div>\n
55<\/div>\n<\/div>\n<\/td>\n
\n
\n
<<\/span>!DOCTYPE <\/span>html<\/span>><\/span><\/div>\n
<<\/span>html<\/span>><\/span><\/div>\n
<<\/span>head<\/span>><\/span><\/div>\n
<<\/span>title<\/span>><\/span>Tutorial <\/span>Membuat <\/span>Pencarian <\/span>Pada <\/span>Laravel<\/span> – www<\/span>.<\/span>malasngoding<\/span>.<\/span>com<\/span><<\/span>\/title<\/span>><\/span><\/div>\n
<<\/span>\/head<\/span>><\/span><\/div>\n
<<\/span>body<\/span>><\/span><\/div>\n
 <\/div>\n
<style <\/span>type<\/span>=”text\/css”><\/span><\/div>\n
.pagination li<\/span>{<\/div>\n
float<\/span>: left<\/span>;<\/div>\n
list-style-type<\/span>: none<\/span>;<\/div>\n
margin<\/span>:5px<\/span>;<\/div>\n
}<\/div>\n
<\/style><\/span><\/div>\n
 <\/div>\n
<<\/span>h2<\/span>><\/span><<\/span>a<\/span> href<\/span>=“https:\/\/www.malasngoding.com”<\/span>><\/span>www<\/span>.<\/span>malasngoding<\/span>.<\/span>com<\/span><<\/span>\/a<\/span>><\/span><<\/span>\/h2<\/span>><\/span><\/div>\n
<<\/span>h3<\/span>><\/span>Data <\/span>Pegawai<\/span><<\/span>\/h3<\/span>><\/span><\/div>\n
 <\/div>\n
 <\/div>\n
<<\/span>p<\/span>><\/span>Cari <\/span>Data <\/span>Pegawai<\/span> :<<\/span>\/p<\/span>><\/span><\/div>\n
<<\/span>form <\/span>action<\/span>=“\/pegawai\/cari”<\/span> method<\/span>=“GET”<\/span>><\/span><\/div>\n
<<\/span>input <\/span>type<\/span>=“text”<\/span> name<\/span>=“cari”<\/span> placeholder<\/span>=“Cari Pegawai ..”<\/span> value<\/span>=“{{ old(‘cari’) }}”<\/span>><\/span><\/div>\n
<<\/span>input <\/span>type<\/span>=“submit”<\/span> value<\/span>=“CARI”<\/span>><\/span><\/div>\n
<<\/span>\/form<\/span>><\/span><\/div>\n
 <\/div>\n
<<\/span>br<\/span>\/><\/span><\/div>\n
 <\/div>\n
<<\/span>table <\/span>border<\/span>=“1”<\/span>><\/span><\/div>\n
<<\/span>tr<\/span>><\/span><\/div>\n
<<\/span>th<\/span>><\/span>Nama<\/span><<\/span>\/th<\/span>><\/span><\/div>\n
<<\/span>th<\/span>><\/span>Jabatan<\/span><<\/span>\/th<\/span>><\/span><\/div>\n
<<\/span>th<\/span>><\/span>Umur<\/span><<\/span>\/th<\/span>><\/span><\/div>\n
<<\/span>th<\/span>><\/span>Alamat<\/span><<\/span>\/th<\/span>><\/span><\/div>\n
<<\/span>\/tr<\/span>><\/span><\/div>\n
@foreach<\/span>($pegawai <\/span>as<\/span> $p<\/span>)<\/div>\n
<<\/span>tr<\/span>><\/span><\/div>\n
<<\/span>td<\/span>><\/span>{{ $p<\/span>–><\/span>pegawai_nama<\/span> }}<<\/span>\/td<\/span>><\/span><\/div>\n
<<\/span>td<\/span>><\/span>{{ $p<\/span>–><\/span>pegawai_jabatan<\/span> }}<<\/span>\/td<\/span>><\/span><\/div>\n
<<\/span>td<\/span>><\/span>{{ $p<\/span>–><\/span>pegawai_umur<\/span> }}<<\/span>\/td<\/span>><\/span><\/div>\n
<<\/span>td<\/span>><\/span>{{ $p<\/span>–><\/span>pegawai_alamat<\/span> }}<<\/span>\/td<\/span>><\/span><\/div>\n
<<\/span>\/tr<\/span>><\/span><\/div>\n
@endforeach<\/span><\/div>\n
<<\/span>\/table<\/span>><\/span><\/div>\n
 <\/div>\n
<<\/span>br<\/span>\/><\/span><\/div>\n
Halaman<\/span> : {{ $pegawai<\/span>–><\/span>currentPage<\/span>() }} <<\/span>br<\/span>\/><\/span><\/div>\n
Jumlah <\/span>Data<\/span> : {{ $pegawai<\/span>–><\/span>total<\/span>() }} <<\/span>br<\/span>\/><\/span><\/div>\n
Data <\/span>Per <\/span>Halaman<\/span> : {{ $pegawai<\/span>–><\/span>perPage<\/span>() }} <<\/span>br<\/span>\/><\/span><\/div>\n
 <\/div>\n
 <\/div>\n
{{$pegawai<\/span>–><\/span>links<\/span>() }}<\/div>\n
 <\/div>\n
 <\/div>\n
<<\/span>\/body<\/span>><\/span><\/div>\n
<<\/span>\/html<\/span>><\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Pada view index ini kita membuat sebuah form untuk pencarian data.<\/p>

\n
\n\n\n\n
\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n<\/div>\n<\/td>\n
\n
\n
<<\/span>p<\/span>><\/span>Cari <\/span>Data <\/span>Pegawai<\/span> :<<\/span>\/p<\/span>><\/span><\/div>\n
<<\/span>form <\/span>action<\/span>=“\/pegawai\/cari”<\/span> method<\/span>=“GET”<\/span>><\/span><\/div>\n
<<\/span>input <\/span>type<\/span>=“text”<\/span> name<\/span>=“cari”<\/span> placeholder<\/span>=“Cari Pegawai ..”<\/span> value<\/span>=“{{ old(‘cari’) }}”<\/span>><\/span><\/div>\n
<<\/span>input <\/span>type<\/span>=“submit”<\/span> value<\/span>=“CARI”<\/span>><\/span><\/div>\n
<<\/span>\/form<\/span>><\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Kemudian perhatikan pada method cari.<\/p>\n

Inti dari form pencarian ini ada pada method cari.<\/p>

\n
\n\n\n\n
\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n<\/div>\n<\/td>\n
\n
\n
public <\/span>function <\/span>cari<\/span>(Request<\/span> $request<\/span>)<\/div>\n
{<\/div>\n
\/\/ menangkap data pencarian<\/span><\/div>\n
$cari<\/span> = $request<\/span>–><\/span>cari<\/span>;<\/div>\n
 <\/div>\n
\/\/ mengambil data dari table pegawai sesuai pencarian data<\/span><\/div>\n
$pegawai<\/span> = DB<\/span>::table<\/span>(‘pegawai’<\/span>)<\/div>\n
–><\/span>where<\/span>(‘pegawai_nama’<\/span>,‘like’<\/span>,“%”<\/span>.$cari<\/span>.“%”<\/span>)<\/div>\n
–><\/span>paginate<\/span>();<\/div>\n
 <\/div>\n
     <\/span>\/\/ mengirim data pegawai ke view index<\/span><\/div>\n
return <\/span>view<\/span>(‘index’<\/span>,[‘pegawai’<\/span> =><\/span> $pegawai<\/span>]);<\/div>\n
 <\/div>\n
}<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

pada method cari ini kita tangkap data yang dikirim dari form pencarian.<\/p>

\n
\n\n\n\n
\n
\n
1<\/div>\n
2<\/div>\n<\/div>\n<\/td>\n
\n
\n
\/\/ menangkap data pencarian <\/span><\/div>\n
$cari<\/span> = $request<\/span>–><\/span>cari<\/span>;<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

kemudian kita cari data nya pada table pegawai dengan menggunakan fungsi like. untuk mencari data yang mirip dengan data yang di input pada form pencarian.<\/p>\n

Dan terakhir kita tampilkan data nya kembali ke view index.<\/p>

\n
\n\n\n\n
\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n<\/div>\n<\/td>\n
\n
\n
\/\/ mengambil data dari table pegawai sesuai pencarian data<\/span><\/div>\n
$pegawai<\/span> = DB<\/span>::table<\/span>(‘pegawai’<\/span>)<\/div>\n
–><\/span>where<\/span>(‘pegawai_nama’<\/span>,‘like’<\/span>,“%”<\/span>.$cari<\/span>.“%”<\/span>)<\/div>\n
–><\/span>paginate<\/span>();<\/div>\n
 <\/div>\n
\/\/ mengirim data pegawai ke view index<\/span><\/div>\n
return <\/span>view<\/span>(‘index’<\/span>,[‘pegawai’<\/span> =><\/span> $pegawai<\/span>]);<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Sekarang coba kita lihat hasilnya.<\/p>\n

Silahkan akses project laravel<\/a> teman-teman<\/p>\n

localhost:8000\/pegawai<\/p>\n

\n

\"Membuat<\/p>\n

Membuat Pencarian Pada Laravel<\/p>\n<\/div>\n

Di sini saya mencoba menginput \u201cdiki\u201d pada pencarian. dan klik cari.<\/p>\n

\n

\"search<\/p>\n

search laravel<\/p>\n<\/div>\n

Maka hasil pencariannya pun muncul.<\/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":"

Form pencarian yang akan kita buat adalah form pencarian pada data pegawai yang sudah kita buat pada tutorial sebelumnya. Silahkan teman-teman ikuti tutorial sebelumnya jika belum, agar penjelasan tentang cara membuat pencarian pada laravel ini lebih mudah teman-teman pahami. Persiapan Akan saya ulang sekilas. untuk sekedar memastikan kembali. pastikan teman-teman sudah mempunyai database dan sebuah tabel yang […]<\/p>\n","protected":false},"author":21,"featured_media":1310,"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\/1296"}],"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=1296"}],"version-history":[{"count":4,"href":"https:\/\/blog.uts.ac.id\/jul\/wp-json\/wp\/v2\/posts\/1296\/revisions"}],"predecessor-version":[{"id":1585,"href":"https:\/\/blog.uts.ac.id\/jul\/wp-json\/wp\/v2\/posts\/1296\/revisions\/1585"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.uts.ac.id\/jul\/wp-json\/wp\/v2\/media\/1310"}],"wp:attachment":[{"href":"https:\/\/blog.uts.ac.id\/jul\/wp-json\/wp\/v2\/media?parent=1296"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.uts.ac.id\/jul\/wp-json\/wp\/v2\/categories?post=1296"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.uts.ac.id\/jul\/wp-json\/wp\/v2\/tags?post=1296"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}