1#@!#!123s

��JFIF�� 1#@!#!123s
: / home2 / ctsnewco / public_html / odisharising.in / admin /
Filename : stakeholders-speak-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 about_stakeholders_speak</h2>
            <a href='stakeholders-speak-save.php' class='mb-4 btn btn-primary'>Add New Details</a>
<table class='table table-bordered table-striped'>
<tr><th>photo</th><th>name</th><th>designation</th><th>content</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 `about_stakeholders_speak`" );
        $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 `about_stakeholders_speak` LIMIT $limit OFFSET $offset" );
        
        while($row = mysqli_fetch_assoc($result)) { 
            echo '<tr>';
    echo '<td><img src="uploads/' . htmlspecialchars($row['photo']) . '" alt="Image" width="50"></td>';
echo '<td>' . htmlspecialchars($row['name']) . '</td>';
echo '<td>' . htmlspecialchars($row['designation']) . '</td>';
echo '<td>' . htmlspecialchars($row['content']) . '</td>';
echo '<td>' . htmlspecialchars($row['priority']) . '</td>';
echo '<td>' . htmlspecialchars($row['status']) . '</td>';

            echo '<td>
                <a href="stakeholders-speak-save.php?id=' . $row['id'] . '" class="btn btn-sm btn-primary">Edit</a> 
                <a href="delete.php?table=about_stakeholders_speak&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'); ?>