Untitled

<?php
//connecting
$link=mysqli_connect('localhost','root','qwerty');
header ("location : header.php");

//disconnected
if (!$link)
{
	die("connection failure, check your users and password");
}

//pakai database apotek
$result=mysqli_query($link,'USE u377281409_local');
if (!$result)
{
	die("database apotek gagal digunakan");
}

//tampilkan tabel konsumen
$result=mysqli_query($link,'SELECT * FROM `users` ORDER BY user_id DESC')
?>
<!DOCTYPE html>
<head>
	<meta charset="UTF-8">
	<title>APOTEK SEHAT SELALU</title>
	<style>
	h3{
		text-align:center;}
	table{
		border-collapse:collapse;
		border-spacing:0;
		font-family:arial, sans-serif;
		font-size:16px
		padding-left:300px;
		margin:auto;}
	table th{
		font-weight:bold;
		padding:10px;
		color:#fff;
		background-color:#2A72BA;
		border-top:1px black solid;}
	table td{
		padding:10px;
		border-top:1px black solid;
		border-bottom:1px black solid;
		text-align:center; }
   tr:nth-child(even) {
		background-color: #DFEBF8; }
   </style>
</head>

<body>
	<h3>Daftar Karyawan <a href=home.php>APOTEK SEHAT SELALU</a></h3>
	<center><font size="3">untuk sementara password masih diperlihatkan, kedepannya hanya admin yang bisa melihat password karyawan</center></font>
	<div id="header" align="left">
				<tr><td><a href=home.php>				<button type="submit" name="btn-login">HOME</a></button></td></tr>
				<tr><td><a href=tabelkaryawan.php>		<button type="submit" name="btn-login">Tabel Karyawan</a></button></td></tr>
				<tr><td><a href=register.php>			<button type="submit" name="btn-login">Tambah Karyawan</a></button></td></tr>
				<tr><td><a href=tabelkonsumen.php>		<button type="submit" name="btn-login">Tabel Konsumen</a></button></td></tr>
				<tr><td><a href=registerkonsumen.php>	<button type="submit" name="btn-login">Tambah Konsumen</a></button></td></tr>
				<tr><td><a href=tabelobat.php>			<button type="submit" name="btn-login">Tabel Obat</a></button></td></tr>
				<tr><td><a href=registerobat.php>		<button type="submit" name="btn-login">Tambah Obat</a></button></td></tr>
	</div>
		<div id="header" align="right">
			<!-- form quick search -->
<form name="form1" method="get" action="">
Search : <input type="text" name="search" id="search"  placeholder="cari berdasarkan nama"/> <input type="submit" value="Search"/>
</form>
<!-- menampilkan hasil pencarian -->
<?php
if(isset($_GET['search']) && ($_GET['search']))
{
	$cari = $_GET['search'];
	$sql = "SELECT * from users where username like '$cari'";
	$hasilcari = mysqli_query($link,$sql);
	if(mysqli_num_rows($hasilcari)>0)
	{
		?>
		<table>
			<tr>
				<th>id</th>
				<th>nama</th>
				<th>email</th>
				<th>password</th>
				<th>No Telp</th>
			</tr>
			<?php
			while ($find=mysqli_fetch_array($hasilcari))
			{
				echo "<tr>";
				echo "<td>".$hasilcari['user_id']."</td>";
				echo "<td>".$hasilcari['username']."</td>";
				echo "<td>".$hasilcari['email']."</td>";
				echo "<td>".$hasilcari['password']."</td>";
				echo "<td>".$hasilcari['phone']."</td>";
			}
			?>
				</table>
				<?php
	}
	else
	{
		echo 'Data not found!';
	}
}
				?>
		</div>
				<table>
<tr>
	<th>id</th>
	<th>nama</th>
	<th>email</th>
	<th>password</th>
	<th>No Telp</th>
	<th>Option</th>
</tr>
<?php
while ($row=mysqli_fetch_array($result))
{
	echo "<tr>";
	echo "<td>".$row['0']."</td>";
	echo "<td>".$row['1']."</td>";
	echo "<td>".$row['2']."</td>";
	echo "<td>".$row['3']."</td>";
	echo "<td>".$row['4']."</td>";
	echo '<td><a href="edit.php?id='.$row['user_id'].'">Edit</a> / <a href="hapus.php?id='.$row['user_id'].'" onclick="return confirm(\'Yakin?\')">Hapus</a></td>';
	echo "</tr>";
}
?>
</body>
</html>