File "account_show.php"

Full path: /home/fsibplc/public_html/fsib/accountOpening-v2/account_show.php
File size: 4.76 B (4.76 KB bytes)
MIME-type: text/x-php
Charset: utf-8

Download   Open   Edit   Advanced Editor   Back

<?php


header("Cache-Control: no-cache, must-revalidate");

include 'dbconnect.php';

$result=$conn->query("SELECT * FROM `account_info` ORDER BY `id` ASC");
?>
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Account Show</title>
    <!-- <link rel="stylesheet" href="https://cdn.datatables.net/2.1.8/css/dataTables.dataTables.css"> -->
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet">
    <link href="css/bootstrap.min.css" rel="stylesheet">
    <!-- Font Awesome Icons -->
    <link rel="stylesheet" href="css/fontawesome-free-6.6.0-web/css/all.min.css">
    <!-- <link rel="stylesheet" href="css/style.css"> -->
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/fomantic-ui/2.9.2/semantic.min.css">
    <link rel="stylesheet" href="https://cdn.datatables.net/2.1.8/css/dataTables.semanticui.css">

    <style>
.dataTables_wrapper  div.row:first-of-type {
  background-color: gray;
}
    </style>
</head>

<body>

    <div class="card-container p-5">
        <div class="card">
            <div class="card-header text-center fw-bold">All Request</div>
            <div class="card-body p-5">


                <div class="container p-2">
                    <div class="account_table">
                        <table id="example" class="table table-hover table-striped table-bordered dt-responsive" style="width:100%">
                            <thead class="">
                                <tr>
                                    <th>Applicant Name</th>
                                    <th>Father Name</th>
                                    <th>Mother Name</th>
                                    <th>Date Of Birth</th>
                                    <th>Status</th>
                                    <th>Informed</th>
                                    <th>Details</th>

                                </tr>
                            </thead>
                            <tbody>
                                <?php while($rows=$result->fetch_assoc()){
                        ?>
                                <tr>
                                    <td><?php echo $rows['name']; ?></td>
                                    <td><?php echo $rows['father_name']; ?></td>
                                    <td><?php echo $rows['mother_name']; ?></td>
                                    <td><?php echo $rows['dob']; ?></td>
                                    <td class="text-center"><?php echo $rows['status']; ?></td>
                                    <td class="text-center"><?php echo $rows['inform']; ?></td>
                                    <td class="text-center"><?php if(!empty($rows['inform'])){ ?>
                                        <a href="account_details_show.php?id=<?php echo $rows['id'];?>"
                                            target="_blank"><input type="submit" class="btn btn-warning" value="View"
                                                name="acc_details_show" id="acc_details_show"></a>
                                        <?php  }else{     ?>
                                        <a href="account_details.php?id=<?php echo $rows['id'];?>"
                                            target="_blank"><input type="submit" class="btn btn-primary" value="Details"
                                                name="acc_details" id="acc_details"></a>
                                        <?php } ?>
                                    </td>
                                </tr>
                                <?php } ?>
                            </tbody>
                        </table>

                        <!-- MOdal of acc details  start-->


                        <!-- Modal of acc details end -->

                    </div>
                </div>

            </div>
        </div>
    </div>

    <!-- <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.bundle.min.js"></script> -->
    <script src="https://code.jquery.com/jquery-3.7.1.js"></script>
    <script src="https://cdn.datatables.net/2.1.8/js/dataTables.js"></script>
    <!-- <script src="https://cdn.datatables.net/2.1.8/js/dataTables.bootstrap5.js"></script> -->
     <script src="https://cdnjs.cloudflare.com/ajax/libs/fomantic-ui/2.9.2/semantic.min.js"></script>
     <script src="https://cdn.datatables.net/2.1.8/js/dataTables.semanticui.js"></script>
     <script src="https://cdnjs.cloudflare.com/ajax/libs/fomantic-ui/2.9.2/semantic.min.js"></script>
    <script>
    new DataTable('#example', {
        scrollY: true,
        "order": []
    });
    </script>

</body>

</html>