course.php

<?php include 'connection.php';
include 'topnav.php'; ?>

         <div class="col-lg-12">
                       <div>
            <i class="fas fa-table"></i>

            Course Records <br></br>  
             Add New <a></a>  
            <a href="courseAdd.php?action=add" type="button" class="btn btn-xs fa fa-user-plus"></a>
            </div> 

                        <br> </br>       
                        <div class="table-responsive">
                            <table class="table table-bordered table-hover table-striped">
                                <thead>
                                    <tr>
                                        <th>COURSE ID</th>
                                        <th>COURSE</th>
                                        <th>DESCRIPTION</th>
                                        <th>OPTION</th>
                                    </tr>
                                </thead>
                                <tbody>
                                 <?php                  
                $query = 'SELECT * FROM course';
                    $result = mysqli_query($db, $query) or die (mysqli_error($db));
                  
                        while ($row = mysqli_fetch_assoc($result)) {
                                             
                            echo '<tr>';
                            echo '<td>'. $row['COURSE_ID'].'</td>';
                            echo '<td>'. $row['NAME'].'</td>';
                            echo '<td>'. $row['DESCRIPTION'].'</td>';
                            
                            echo '<td>';
                            echo ' <a  type="button" class="btn btn-xs btn-warning fa fa-edit" href="course_edit.php?action=edit & id='.$row['COURSE_ID'] . '"> </a> ';
                            echo ' <a  type="button" class="btn btn-xs btn-danger fa fa-trash" href="courseDel.php?type=course&delete & id='.$row['COURSE_ID'] . '"> </a> </td>';
                            echo '</tr> ';
                }
            ?> 
                                    
                                </tbody>
                            </table>
                        </div><?php include 'footer.php'; ?>