UTHM Crawler

<title>UTHM Lecturer Crawler</title>


<center><h1>UTHM Lecturer Crawler</h1></center>

<center>
<form method=post>
<p>Masukkan Nama Lecturer : <input type=text name=lect></p>
<input type=submit value='Cari'>
</form>
</center>

<?php

$nama = $_POST['lect'];

if(!empty($_POST['lect'])){

$mysqli = new mysqli ("localhost","paan123","sekolah123","uthm");

if(!$mysqli) { echo "takleh masuk"; }

$jalan = "SELECT * FROM login WHERE nama LIKE '%$nama%'";
$query = $mysqli -> query($jalan);


$jumlah = "SELECT COUNT(nama) FROM login";
$total = $mysqli -> query($jumlah);
$tengok = $total -> fetch_array(MYSQLI_ASSOC);
$view = $tengok['COUNT(nama)'];



?>
<center>
<table border='1'>
          <tr>
            <th>Nama</th>
            <th>No Kad Pengenalan</th>
            <th>Email</th>
            <th>Password(MD5)</th>
          </tr>

<?php



echo"<h1>Result : </h1> Here We Have Over <b>$view</b> Of Data";

while($row = $query -> fetch_array(MYSQLI_ASSOC)){

  ?>

  <tr>
    <td><?php echo $row['nama']; ?></td>
    <td><?php echo $row['nokp']; ?></td>
    <td><?php echo $row['email']; ?></td>
    <td><?php echo $row['pwd']; ?></td>
  </tr>

 <?php

}

}

?>