Untitled

<?php
// memanggil file koneksi ke database
require_once('db.php');

$id = $_GET['id'];

$sql = "SELECT * FROM pendaftaran WHERE id = '$id'";
$result = $conn->query($sql);
$row = $result->fetch_assoc();

$id = $row['id'];
$nama = $row['nama'];
$tempat = $row['tempat'];
$tanggal_lahir = $row['tanggal_lahir'];
$npm = $row['npm'];
$jurusan = $row['jurusan'];
$alamat = $row['alamat'];
$motivasi = $row['motivasi'];
$ktp = $row['ktp'];
$foto = $row['foto'];
$siot = $row['siot'];
$skd = $row['skd'];
$status = $row['status'];

?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title>Detail Pendaftaran Calon Anggota Mapala Raflesia Unindra</title>
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css">
    <link rel="stylesheet" href="fontawesome/css/all.min.css">
</head>
<body>
    <div class="container-fluid">
        <div class="row mt-5 mb-5">
            <div class="col-md-10 offset-md-1">
                <div class="card">
                    <div class="card-header">
                        Detail Data Calon Anggota
                    </div>
                    <div class="card-body">

                        <div class="row">
                            <div class="col-md-2">
                            <img src="/cata_mapala_unindra/uploads/<?= $foto ?>" alt="" width="100%">
                            </div>
                                <div class="col-md-10">
                                    <table class="table">
                                    <tr>
                                        <td width="30%">NPM</td>
                                        <td width="1%">:</td>
                                        <td><?= $npm ?></td>
                                    </tr>
                                    <tr>
                                        <td width="30%">Nama Lengkap</td>
                                        <td width="1%">:</td>
                                        <td><?= $nama ?></td>
                                    </tr>
                                    <tr>
                                        <td width="30%">Jurusan</td>
                                        <td width="1%">:</td>
                                        <td><?= $jurusan ?></td>
                                    </tr>
                                    <tr>
                                        <td width="30%">TTL</td>
                                        <td width="1%">:</td>
                                        <td><?= $tempat.", ".date('d-m-Y', strtotime($tanggal_lahir)) ?></td>
                                    </tr>
                                    <tr>
                                        <td width="30%">Alamat</td>
                                        <td width="1%">:</td>
                                        <td><?= $alamat ?></td>
                                    </tr>
                                    <tr>
                                        <td width="30%">Motivasi</td>
                                        <td width="1%">:</td>
                                        <td><?= $motivasi ?></td>
                                    </tr>
                                    <tr>
                                        <td width="30%">Status</td>
                                        <td width="1%">:</td>
                                        <td>
                                            <?php
                                            if($status == "Calon Anggota"){
                                                echo "<div class='btn btn-warning'>Calon Anggota</div>";
                                            } else if($status == "Tidak Lulus"){
                                                echo "<div class='btn btn-danger'>Tidak Lulus</div>";
                                            } else if($status == "Lulus"){
                                                echo "<div class='btn btn-success'>Lulus</div>";
                                            } else {
                                                echo "";
                                            }
                                            ?>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td width="30%">Surat Keterangan Sehat</td>
                                        <td width="1%">:</td>
                                        <td><a href="/cata_mapala_unindra/uploads/<?= $skd ?>"><?= $skd ?></a></td>
                                    </tr>
                                    <tr>
                                        <td width="30%">Surat Izin Orang Tua</td>
                                        <td width="1%">:</td>
                                        <td><a href="/cata_mapala_unindra/uploads/<?= $siot ?>"><?= $siot ?></a></td>
                                    </tr>
                                    <tr>
                                        <td width="30%">Foto / Scan KTP</td>
                                        <td width="1%">:</td>
                                        <td>
                                            <img src="/cata_mapala_unindra/uploads/<?= $ktp ?>" alt="" width="30%">
                                        </td>
                                    </tr>
                                </table>
                            </div>
                        </div>


                    </div>
                    <div class="card-footer">
                        <a href="/cata_mapala_unindra" class="btn btn-outline-info">Back</a>
                    </div>
                </div>
            </div>
        </div>
    </div>
</body>
</html>
<script src="https://code.jquery.com/jquery.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.3/umd/popper.min.js"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/js/bootstrap.min.js"></script>