mencari data sesua dengan katagori option
Pembahasan
php kali ini tentang bagaimana mencari data sesuai kategori yang diinginkan
dengan menggunakan pilihan / option,sebagai contoh silahkan lihat demo . untuk langkah awal seperti biasa
kita buat file koneksi ke database terlebih dahulu,disini saya tidak
menampilkan struktur apa saja yang harus disiapkan dalam tabel,untuk struktur
tabel nya silahkan anda sesuaikan dengan tabel masing2,oke ile koneksi masukan
kode berikut :
<?php
$host = "localhost"; // default
$user = "root"; // default
$pass = ""; // sesuaikan dengan password mysql anda
$d_base = ""; // sesuaikan dengan nama db anda
mysql_connect($host, $user, $pass) or die ("waduh om,koneksi masih gagal.....".mysql_error());
mysql_select_db($d_base) or die ("Databasenya kayanya blm ada deh om,cek lagi.. ".mysql_error());
?>
$host = "localhost"; // default
$user = "root"; // default
$pass = ""; // sesuaikan dengan password mysql anda
$d_base = ""; // sesuaikan dengan nama db anda
mysql_connect($host, $user, $pass) or die ("waduh om,koneksi masih gagal.....".mysql_error());
mysql_select_db($d_base) or die ("Databasenya kayanya blm ada deh om,cek lagi.. ".mysql_error());
?>
simpan kode
diatas dengan nama koneksi.php
langkah
selanjutnya masukan kode berikut :
<?php
if(!isset($_SESSION['username']))
include "koneksi.php"; ?>
<html>
<head>
<title>Data kependudukan Warga RT / RT .....</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="/pagination.css" rel="stylesheet" type="text/css">
<link href="/grey.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.style2 {color: #006633; font-weight: bold; }
.style3 {color: #FFFFFF; }
-->
</style>
</head>
<body>
<div class="post">
<h2 align="center" class="title"><a href="#">Data kependudukan Warga RT / RT .....</a></h2>
<div class="entry">
<a href="#">Login</a> |
<a href="#"> Mengisi Data</a> | <a href="#">Edit Data Keanggotaan</a>
<?
echo "<form action=' viewdata.php' method='post' name='postform'>";
echo "<br>";
echo "Cari berdasarkan<br>";
echo "<select name='pilihan'>";
echo "<option value='nama_field1'>Nama </option>";
echo "<option value='nama_field3'>Jenis Kelamin </option>";
echo "<option value='nama_field4'>Agama </option>";
echo "<option value='nama_field6'>Pekerjaan </option>";
echo "<option value='nama_field10'>Hp </option>";
echo "</select> ";
echo "<input type='text' name='cari'>";
echo "<input type='submit' value='cari'>";
echo " | ";
echo "<input type='submit' value='Tampilkan'>";
echo "</form>";
?>
<span class="style1">Total Anggota : </span>
<table width="100%" border="0" align="center" cellpadding="2" background="#666600">
<td width="60">
<tr><td bgcolor="#CC9900" width="80"><div align="center" class="style2">Nama</div></td>
<td bgcolor="#CC9900" width="90"><div align="center" class="style2">Foto</div></td>
<td bgcolor="#CC9900" width="56"><div align="center" class="style2">Jenis Kelamin</div></td>
<td bgcolor="#CC9900" width="47"><div align="center" class="style2">Agama</div></td>
<td bgcolor="#CC9900" width="34"><div align="center" class="style2">TTL</div></td>
<td bgcolor="#CC9900" width="122"><div align="center" class="style2">Kewarganegaraan</div></td>
<td bgcolor="#CC9900" width="68"><div align="center" class="style2">Pekerjaan</div></td>
<td bgcolor="#CC9900" width="48"><div align="center" class="style2">Alamat</div></td>
<td bgcolor="#CC9900" width="30"><div align="center" class="style2">Telp</div></td>
<td bgcolor="#CC9900" width="21"><div align="center" class="style2">HP</div></td>
</tr></td>
<?php
//di proses jika sudah klik tombol cari
if(isset($_POST['cari'])){
//menangkap nilai form
$option=$_POST['pilihan'];
$katakunci=$_POST['cari'];
if(empty($katakunci)){
//jika tidak menginput apa2
$query=mysql_query("select * from nama_tabel");
}else{
?><?php
$query=mysql_query("select * from nama_tabel where $option like '%$katakunci%'");
}
?>
</p>
<td bgcolor="#00CCCC"><div align="center" class="style3"><?php echo "".$row['nama_field1']."";?></div></td>
<td><div align="center" class="style3"><img src="/image/<?php echo "".$row['nama_field2']."";?>" height="90" width="90" /></div></td>
<td bgcolor="#00CCCC"><div align="center" class="style3"><?php echo "".$row['nama_fild3']."";?></div></td>
<td bgcolor="#00CCCC"><div align="center" class="style3"><?php echo "".$row['nama_field4']."";?></div></td>
<td bgcolor="#00CCCC"><div align="center" class="style3"><?php echo "".$row['nama_field5']."";?></div></td>
<td bgcolor="#00CCCC"><div align="center" class="style3"><?php echo "".$row['nama_field6']."";?></div></td>
<td bgcolor="#00CCCC"><div align="center" class="style3"><?php echo "".$row['nama_field7']."";?></div></td>
<td bgcolor="#00CCCC"><div align="center" class="style3"><?php echo "".$row['nama_field8']."";?></div></td>
<td bgcolor="#00CCCC"><div align="center" class="style3"><?php echo "".$row['nama_field9']."";?></div></td>
<td bgcolor="#00CCCC"><div align="center" class="style3"><?php echo "".$row['nama_field10']."";?></div></td>
</tr>
<?php
if (isset($_GET['msg'])) {
echo "<div class=\"error\">$_GET[msg]</div>";
}
?>
<tr><th colspan="10"></th></tr>
<?php
}
}
</table>
</div>
</div>
</div>
</body>
</html>
if(!isset($_SESSION['username']))
include "koneksi.php"; ?>
<html>
<head>
<title>Data kependudukan Warga RT / RT .....</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="/pagination.css" rel="stylesheet" type="text/css">
<link href="/grey.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.style2 {color: #006633; font-weight: bold; }
.style3 {color: #FFFFFF; }
-->
</style>
</head>
<body>
<div class="post">
<h2 align="center" class="title"><a href="#">Data kependudukan Warga RT / RT .....</a></h2>
<div class="entry">
<a href="#">Login</a> |
<a href="#"> Mengisi Data</a> | <a href="#">Edit Data Keanggotaan</a>
<?
echo "<form action=' viewdata.php' method='post' name='postform'>";
echo "<br>";
echo "Cari berdasarkan<br>";
echo "<select name='pilihan'>";
echo "<option value='nama_field1'>Nama </option>";
echo "<option value='nama_field3'>Jenis Kelamin </option>";
echo "<option value='nama_field4'>Agama </option>";
echo "<option value='nama_field6'>Pekerjaan </option>";
echo "<option value='nama_field10'>Hp </option>";
echo "</select> ";
echo "<input type='text' name='cari'>";
echo "<input type='submit' value='cari'>";
echo " | ";
echo "<input type='submit' value='Tampilkan'>";
echo "</form>";
?>
<span class="style1">Total Anggota : </span>
<table width="100%" border="0" align="center" cellpadding="2" background="#666600">
<td width="60">
<tr><td bgcolor="#CC9900" width="80"><div align="center" class="style2">Nama</div></td>
<td bgcolor="#CC9900" width="90"><div align="center" class="style2">Foto</div></td>
<td bgcolor="#CC9900" width="56"><div align="center" class="style2">Jenis Kelamin</div></td>
<td bgcolor="#CC9900" width="47"><div align="center" class="style2">Agama</div></td>
<td bgcolor="#CC9900" width="34"><div align="center" class="style2">TTL</div></td>
<td bgcolor="#CC9900" width="122"><div align="center" class="style2">Kewarganegaraan</div></td>
<td bgcolor="#CC9900" width="68"><div align="center" class="style2">Pekerjaan</div></td>
<td bgcolor="#CC9900" width="48"><div align="center" class="style2">Alamat</div></td>
<td bgcolor="#CC9900" width="30"><div align="center" class="style2">Telp</div></td>
<td bgcolor="#CC9900" width="21"><div align="center" class="style2">HP</div></td>
</tr></td>
<?php
//di proses jika sudah klik tombol cari
if(isset($_POST['cari'])){
//menangkap nilai form
$option=$_POST['pilihan'];
$katakunci=$_POST['cari'];
if(empty($katakunci)){
//jika tidak menginput apa2
$query=mysql_query("select * from nama_tabel");
}else{
?><?php
$query=mysql_query("select * from nama_tabel where $option like '%$katakunci%'");
}
?>
</p>
<td bgcolor="#00CCCC"><div align="center" class="style3"><?php echo "".$row['nama_field1']."";?></div></td>
<td><div align="center" class="style3"><img src="/image/<?php echo "".$row['nama_field2']."";?>" height="90" width="90" /></div></td>
<td bgcolor="#00CCCC"><div align="center" class="style3"><?php echo "".$row['nama_fild3']."";?></div></td>
<td bgcolor="#00CCCC"><div align="center" class="style3"><?php echo "".$row['nama_field4']."";?></div></td>
<td bgcolor="#00CCCC"><div align="center" class="style3"><?php echo "".$row['nama_field5']."";?></div></td>
<td bgcolor="#00CCCC"><div align="center" class="style3"><?php echo "".$row['nama_field6']."";?></div></td>
<td bgcolor="#00CCCC"><div align="center" class="style3"><?php echo "".$row['nama_field7']."";?></div></td>
<td bgcolor="#00CCCC"><div align="center" class="style3"><?php echo "".$row['nama_field8']."";?></div></td>
<td bgcolor="#00CCCC"><div align="center" class="style3"><?php echo "".$row['nama_field9']."";?></div></td>
<td bgcolor="#00CCCC"><div align="center" class="style3"><?php echo "".$row['nama_field10']."";?></div></td>
</tr>
<?php
if (isset($_GET['msg'])) {
echo "<div class=\"error\">$_GET[msg]</div>";
}
?>
<tr><th colspan="10"></th></tr>
<?php
}
}
</table>
</div>
</div>
</div>
</body>
</html>
No comments: