raport.php

<?php
include ("koneksi.php");

ini_set( "display_errors", 0);

$kata_kunci = $_POST ['kata_kunci'];
$cari=mysql_query("SELECT siswa.NISN, siswa.Nama_Siswa, mata_diklat.nama_mata_diklat, siswa.Kode_KK, nilai.Nilai_huruf
FROM siswa, mata_diklat, nilai
WHERE nilai.NISN = siswa.NISN
AND nilai.Kode_mata_diklat = mata_diklat.Kode_mata_diklat and siswa.NISN like '%$kata_kunci%' ");


?>

<html>
<head>
    <link href="../css/bootstrap.min.css" rel="stylesheet">
    <link href="../css/bootstrap.css" rel="stylesheet">
    <link href="../css/simple-sidebar.css" rel="stylesheet">
    <link href="../css/adm.css" rel="stylesheet">
</head>

<body>
    <form action="raport.php" method="POST">
<table border="1" class="table table-striped" align="center" >

    <tr>
    <th colspan = "9"> <center> <h1>Hasil Belajar Mahasiswa</h1> </center>
    <span class="glyphicon glyphicon-search" aria-hidden="true" ></span>
    <input type="text" class = "cari"  name="kata_kunci" placeholder = "Cari berdasarkan NISN"/> </th> </tr>

            <tr>
                <th> <center> No </center></th>
                <th> <center> NIM </center></th>
                <th> <center> Nama Mahasiswa  </center> </th>
                <th> <center> Prodi  </center> </th>
                <th> <center> Mata Diklat   </center> </th>
                <th> <center> Grade  </center> </th>
            </tr>

            <?php
                $no=1;
                while($data = mysql_fetch_array($cari)){
                    ?>
                        <tr>
                            <td> <center> <?php echo $no; ?> </center> </td>
                            <td> <?php echo $data['NISN']; ?> </td>
                            <td> <?php echo $data['Nama_Siswa']; ?> </td>
                            <td> <?php echo $data['Kode_KK']; ?> </td>
                            <td> <?php echo $data['nama_mata_diklat']; ?> </td>
                            <td> <?php echo $data['Nilai_huruf']; ?> </td>
                            </tr>

                            <?php
                            $no++;
                }
                ?>

            </table>

            <a href = "cetak_raport.php?kata_kunci=<?php echo $kata_kunci ?>" target = "blank" style ="text-decoration : none;">
             <span class="glyphicon glyphicon-download-alt" aria-hidden="true"  style = "margin-left : %;"></span> &nbsp; Cetak ke PDF </a>

        </form>
    </body>
</html>