<?php include("common/conn.php"); ?>
<div class="card panel-default">
    <div class="card-header"><span class="glyphicon glyphicon-list-alt"></span><b>News</b></div>
    <div class="card-body">
        <div class="row">
            <div class="col-xs-12">
                <ul class="news">
                    <?php
                        $sql="SELECT * FROM news_list ORDER BY id desc";
                        if ($results=mysqli_query($conn,$sql)){
                            $rowcount = mysqli_num_rows($results);
                            $i = 1;
                            // Fetch one and one row
                            while ($row=mysqli_fetch_row($results)){
                    ?>
                    <li class="news-item">
                        <?php echo $row[1]; ?>
                    </li>
                    <?php }
					// Free result set
					mysqli_free_result($results);
                    } ?>
                </ul>
                <?php 
                    if($rowcount == 0){
                        echo '<div class="alert alert-danger mt-3">News items not available.</div>';
                    } ?>

            </div>
        </div>
    </div>
    <div class="card-footer"> </div>
</div>