Membuat Fungsi Search di PHP
kegunaan search yakni kegunaan bagi pencarian data, kegunaan ini sangatlah urgen dan acap kali digunakan bagi mencari data-data atau kalimat atau yang lainnya. Nah di panduan kali ini saya akan membagikan bagaimana cara Membuat Fungsi Search di PHP, mari kita praktekan.
Pertama-tama tama kalian siapkan data base kalian di phpmyadmin dan ketikan kode PHP berikut di database yang telah kalian bikin tepatnya di SQL.
CREATE TABLE IF NOT EXISTS `arif_gaji` (
`id` int(11) NOT NULL,
`nim` varchar(10) NOT NULL,
`id_jabatan` int(11) NOT NULL,
`nama_pegawai` varchar(35) NOT NULL,
`pph` int(11) NOT NULL,
`tunjangan_jabatan` int(11) NOT NULL,
`tgl_gajian` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`bln_gajian` varchar(20) NOT NULL,
`total_gaji` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
setelah merancang tabelnya, lalu insert table nya, ketikan kode di bawah ini.
INSERT INTO `arif_gaji` (`id`, `nim`, `id_jabatan`, `nama_pegawai`, `pph`, `tunjangan_jabatan`, `tgl_gajian`, `bln_gajian`, `total_gaji`) VALUES
(8, '1244', 2, 'indah', 500000, 100000, '2017-10-22 06:22:45', 'Februari', 4600000),
(11, 'i900', 2, 'joko susilo', 500000, 1200000, '2017-10-21 04:46:21', 'Agustus', 5700000),
(13, '354312', 1, 'Wawan', 1500000, 120000, '2017-10-21 04:59:03', 'Desember', 13620000),
(14, '12344', 2, 'Ambar', 500000, 120000, '2017-10-21 09:47:03', 'Januari', 4620000),
(15, 'saeas', 1, 'andi', 1500000, 120000, '2017-10-22 08:24:37', 'November', 13620000),
(16, '1243124', 1, 'jambul', 1500000, 120000, '2017-10-22 08:24:50', 'Agustus', 13620000),
(17, '12314', 2, 'ambar', 500000, 12431241, '2017-10-22 08:25:16', 'Oktober', 16931241),
(18, '412412', 1, 'wahid', 1500000, 124325, '2017-11-20 06:30:07', 'Maret', 13624325),
(19, '14524356', 2, 'anto', 500000, 123124124, '2017-10-22 08:25:41', 'Juli', 127624124),
(20, '987-078', 1, 'Eko', 1500000, 214321421, '2017-10-22 08:25:54', 'September', 227821421);
lalu terakhir ketikan kode PHP berikut dan simpan dengan nama index.php.
<?php
$host = localhost;
$user = dumet; //sesuai dengan username kalian
$pass = school; //sesuai dengan password kalian
$db = webmaster; //sesuai databse yang kalian bikin
$conn = mysqli_connect($host, $user, $pass, $db);
if(!$conn) die(error.mysqli_connect_errno());
$query = mysqli_query($conn, SELECT * FROM arif_gaji);
$cari = $_POST['cari'];
$data = mysqli_query($conn, SELECT * FROM arif_gaji WHERE nim LIKE '%$cari%' OR nama_pegawai LIKE '%$cari%' OR bln_gajian LIKE '%$cari%' OR total_gaji LIKE '%$cari%' );
?>
<!DOCTYPE html>
<html lang=en>
<head>
<meta charset=UTF-8>
<title>Guna Cari</title>
<link rel=stylesheet href=https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css integrity=sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u crossorigin=anonymous>
<!-- Optional theme -->
<link rel=stylesheet href=https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap-theme.min.css integrity=sha384-rHyoN1iRsVXV4nD0JutlnGaslCJuC7uwjduW9SVrLvRYooPp2bWYgmgJQIXwl/Sp crossorigin=anonymous>
</head>
<body>
<div class=container>
<div class=row>
<div class=col-md-2></div>
<div class=col-md-8>
<h2 class=text-info>Guna Search</h2>
<form action= method=post>
<input class=form-control type=text placeholder=cari disini .. name=cari> <br>
<input class=form-control type=submit name=ss value=Cari> <br>
</form>
<div class=table-responsive>
<table class=table table-hover >
<tr>
<th>No</th>
<th>Nim</th>
<th>Nama Karyawan</th>
<th>Bulan Gajian</th>
<th>Total Gaji</th>
</tr>
<?php $no=1; ?>
<?php if(mysqli_num_rows($data)>0){ ?>
<?php while($row=mysqli_fetch_array($data)){ ?>
<tr>
<td><?php echo $no++ ?></td>
<td><?php echo $row['nim'] ?></td>
<td><?php echo $row['nama_pegawai'] ?></td>
<td><?php echo $row['bln_gajian'] ?></td>
<td><?php echo $row['total_gaji'] ?></td>
<?php } ?>
<?php }else{ ?>
<tr>
<td colspan=5><h3 class=text-danger text-center>Data Kosong</h3></td>
</tr>
<?php } ?>
</tr>
</table>
</div>
</div>
<div class=col-md-2></div>
</div>
</div>
</body>
</html>
lalu ketika kode javascript berikut sebelum tab penutup </body>
<script src=”https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js” “></script>
bila telah karenanya kegunaan search akan berjalan apabila tak ada kesalahan di penulisan kode tersebut di atas.
demikianlah panduan Membuat Fungsi Search di PHP, semoga bermanfaat.. keep coding 😀
Sumber https://kursuswebsite.org
