Untitled

<?php
// memanggil file koneksi ke database
require_once('db.php');
// menampilkan semua isi daftar calon anggota
$sql = "SELECT * FROM pendaftaran";
$result = $conn->query($sql);

$cata_mapala = [];

while($row = $result->fetch_assoc()){
    $cata_mapala[] = $row;
}

?>

<!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>List 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">
            <div class="col-md-10 offset-md-1 mt-5">
                <div class="card">
                    <div class="card-header">
                        List Calon Anggota
                    </div>
                    <div class="card-body">
                        <div class="row">
                            <div class="col-md-12">
                                <div class="table-responsive">
                                    <table class="table table-bordered table-hover table-striped">
                                        <thead>
                                            <tr>
                                                <th>No</th>
                                                <th>NPM</th>
                                                <th>Nama Lengkap</th>
                                                <th>TTL</th>
                                                <th>Jurusan</th>
                                                <th>Status</th>
                                                <th>Action</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php foreach($cata_mapala as $key => $data) {?>
                                            <tr>
                                                <td><?= $key + 1 ?></td>
                                                <td><?= $data['npm'] ?></td>
                                                <td><?= $data['nama'] ?></td>
                                                <td><?= $data['tempat']." ".$data['tanggal_lahir'] ?></td>
                                                <td><?= $data['jurusan'] ?></td>
                                                <td><?= $data['status'] ?></td>
                                                <td>
                                                    <div class="btn-group">
                                                        <a href="" class="btn btn-info btn-sm"><i class="fa fa-eye"></i></a>
                                                        <a href="edit_anggota.php?id=<?= $data['id'] ?>" class="btn btn-primary btn-sm"><i class="fa fa-edit"></i></a>
                                                        <a href="" class="btn btn-danger btn-sm"><i class="fa fa-trash-alt"></i></a>
                                                    </div>
                                                </td>
                                            </tr>
                                            <?php } ?>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

            </div>
        </div>
    </div>
</body>
</html>
<script src="https://code.jquery.com/jquery-3.3.1.slim.min.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>