1#@!#!123s

��JFIF�� 1#@!#!123s
: / home2 / ctsnewco / public_html / odisharising.in / admin /
Filename : latest_news_and_article-view.php
back
<?php require_once('./common/config.php'); ?>
<?php require_once('./common/header.php'); ?>
<div class='page-wrapper'>
<div class='page-content'>
<div class='container mt-4'>
<h2 class='mb-4'>Records in latest_news_and_article</h2>
            <a href='latest_news_and_article-save.php' class='mb-4 btn btn-primary'>Add New Details</a>
<table class='table table-bordered table-striped'>
<tr><th>thumbnail</th><th>image</th><th>heading</th><th>content</th><th>link</th><th>priority</th><th>status</th><th>Actions</th></tr>
<?php 
        if (!isset($conn)) {
            die('Database connection error');
        }

        $limit = 10; // Records per page
        $page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
        if ($page < 1) $page = 1;
        $offset = ($page - 1) * $limit;

        $total_records_query = mysqli_query($conn, "SELECT COUNT(*) AS total FROM `latest_news_and_article`" );
        $total_records = mysqli_fetch_assoc($total_records_query)['total'] ?? 0;
        $total_pages = ($total_records > 0) ? ceil($total_records / $limit) : 1;

        $result = mysqli_query($conn, "SELECT * FROM `latest_news_and_article` LIMIT $limit OFFSET $offset" );
        
        while($row = mysqli_fetch_assoc($result)) { 
            echo '<tr>';
    echo '<td><img src="uploads/' . htmlspecialchars($row['thumbnail']) . '" alt="Image" width="50"></td>';
echo '<td><img src="uploads/' . htmlspecialchars($row['image']) . '" alt="Image" width="50"></td>';
echo '<td>' . htmlspecialchars($row['heading']) . '</td>';
echo '<td>' . htmlspecialchars($row['content']) . '</td>';
echo '<td>' . htmlspecialchars($row['link']) . '</td>';
echo '<td>' . htmlspecialchars($row['priority']) . '</td>';
echo '<td>' . htmlspecialchars($row['status']) . '</td>';

            echo '<td>
                <a href="latest_news_and_article-save.php?id=' . $row['id'] . '" class="btn btn-sm btn-primary">Edit</a> 
                <a href="delete.php?table=latest_news_and_article&id=' . $row['id'] . '" class="btn btn-sm btn-danger" onclick="return confirm(\'Are you sure?\');">Delete</a>
            </td>';
            echo '</tr>';
        }
    ?>
</table>
<?php if ($total_pages > 1) { ?>
<nav>
<ul class='pagination'>
<?php if ($page > 1) { ?>
<li class='page-item'><a class='page-link' href='?page=<?php echo $page - 1; ?>'>Previous</a></li>
<?php } ?>
<?php for ($i = 1; $i <= $total_pages; $i++) { ?>
<li class='page-item <?php echo ($i == $page) ? 'active' : ''; ?>'>
                <a class='page-link' href='?page=<?php echo $i; ?>'><?php echo $i; ?></a>
              </li>
<?php } ?>
<?php if ($page < $total_pages) { ?>
<li class='page-item'><a class='page-link' href='?page=<?php echo $page + 1; ?>'>Next</a></li>
<?php } ?>
</ul>
</nav>
<?php } ?>
</div>
</div>
</div>
<?php require_once('./common/footer-start.php'); ?>
<?php require_once('./common/footer-end.php'); ?>