Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require_once('db.php');
- $sql = "SELECT * FROM students";
- // Membuat function paginate
- $result = $conn->query($sql);
- $students = [];
- while($row = $result->fetch_assoc()){
- $students[] = $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 Student</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="mt-5">
- <div class="col-md-12">
- <div class="container">
- <div class="row">
- <div class="col-md-12">
- <div class="table-responsive">
- <table class="table table-bordered table-hovered">
- <thead>
- <tr>
- <th width="5%">No</th>
- <th>Name</th>
- <th width="20%">No Hp</th>
- <th width="10%">Gender</th>
- <th width="15%">Jenjang</th>
- <th width="15%">Hobi</th>
- <th width="10%">Action</th>
- </tr>
- </thead>
- <tbody>
- <?php foreach($students as $k => $student) { ?>
- <tr>
- <td><?= $k + 1 ?></td>
- <td><?= $student['nama_depan']." ".$student['nama_belakang'] ?></td>
- <td><?= $student['no_hp'] ?></td>
- <td><?= $student['gender'] ?></td>
- <td><?= $student['jenjang'] ?></td>
- <td><?= $student['hobi'] ?></td>
- <td>
- <div class="btn-group">
- <a href="" class="btn btn-primary btn-sm"><i class="fa fa-eye"></i></a>
- <a href="" class="btn btn-success 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>
- <!-- Page Script -->
- <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>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement