1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / ultrabio / nirvakam /
Filename : contactus_enquery.php
back
<?php
session_start();

if (isset($_SESSION['login']) && $_SESSION['login'] == 'true') {

  include "../includes/config.php";

  // CSV download
  if (isset($_POST['download_csv'])) {
    $result = $conn->query("SELECT * FROM contact_enquery");

    header('Content-Type: text/csv; charset=utf-8');
    header('Content-Disposition: attachment; filename=contact_list.csv');
    fputs($output = fopen('php://output', 'w'), chr(0xEF) . chr(0xBB) . chr(0xBF)); // UTF-8 BOM

    fputcsv($output, ['Id', 'Name', 'Email', 'Phone', 'Comment']);
    $i = 1;
    while ($row = $result->fetch_assoc()) {
      fputcsv($output, [
        $i++,
        $row['name'],
        $row['email'],
        $row['phone'],
        $row['comment']
      ]);
    }

    fclose($output);
    exit;
  }

  include "includes/header.php";
  include "includes/leftmenu.php";
  include "includes/topbar.php";

  // Load records
  $result = $conn->query("SELECT * FROM contact_enquery");
?>

  <div class="container-fluid">
    <nav aria-label="breadcrumb">
      <ol class="breadcrumb my-0 ms-2">
        <li class="breadcrumb-item">
          <a href="#">Home</a>
        </li>
        <li class="breadcrumb-item active"><span>Contactus</span></li>
      </ol>
    </nav>
  </div>
  </header>
  <div class="body flex-grow-1 px-3">
    <div class="container-lg">
      <div class="card mb-4">
        <div class="card-header" style="display: flex;justify-content:space-between;"> Contactus
          <form method="post">
            <button type="submit" name="download_csv" class="btn btn-success">Download CSV</button>
          </form>
        </div>
        <div class="card-body">




          <table class="table">
            <thead class="table-dark">
              <tr>
                <th scope="col">Id</th>
                <th scope="col">Name</th>
                <th scope="col">Email</th>
                <th scope="col">Phone</th>
                <th scope="col">Comment</th>
                <th scope="col"> </th>
              </tr>
            </thead>
            <tbody>
              <?php
              while ($row = $result->fetch_assoc()) {
              ?>
                <tr>
                  <td> <?php echo $row['id']; ?></td>
                  <td> <?php echo $row['name']; ?></td>
                  <td> <?php echo $row['email']; ?></td>
                  <td> <?php echo $row['phone']; ?></td>
                  <td> <?php echo $row['comment']; ?></td>


                <?php } ?>
                </tr>
                </tr>


            </tbody>
          </table>



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

  <?php include "includes/footer.php"; ?>

<?php

} else {
  header("location:index.php");
} ?>