Papar User

<html>
<title>Paparkan Data User</title>
<center>
<h2>Melihat User Dengan Memasukkan Email</h2>
<form method=get>
<b>EMAIL : </b><input type=text name=email>
<input type=submit value='Cari'>
</form>
<?php

$email = $_GET['email'];

$masuk = mysql_connect("localhost","user_webadmin","sekolah123");

//Memastikan Masuk Ke DB

if(!$masuk) {
     die ('Kesalahan :'.mysql_error());
     }

//Pilih DB


mysql_select_db("web_admin",$masuk);

//Jalankan SQL Query
//Table Name : webadmin
//username,password,adminame,email (VARCHAR)

$query = mysql_query("SELECT * FROM webadmin WHERE email = '{$email}'");

while($row = mysql_fetch_array($query)){

  echo"<center><h1>Result : </h1></center>";
  echo"<table border='1'>";
  echo"<tr>";
  echo"<td><b>Username  </b></td><td>{$row['username']}</td>";
  echo"</tr>";

  echo"<tr>";
  echo"<td><b>Password  </b></td><td>{$row['password']}</td>";
  echo"</tr>";

  echo"<tr>";
  echo"<td><b>Name </b></td><td>{$row['adminame']}</td>";
  echo"</tr>";

  echo"<tr>";
  echo"<td><b>Email  </b></td><td>{$row['email']}</td>";
  echo"</tr>";
  echo"</table>";


}


//Tutup MYSql
mysql_close($masuk);


?>