V1rus Private

Viewing: querymanager.php

<?php
include("layouts/navbar.php");
?>

<head>
  <title>Home</title>
  <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <script src='./js/queryDeleteHandler.js'></script>
  <script src='./js/bootstrap.bundel.min.js'></script>
</head>


<div class="container-fluid " style="margin-top:55px;"><br>
  <h2 class=" text-uppercase text-center text-dark " style="font-family: 'BioRhyme', serif; ">QUERY INFORMATION</h2><br>
  <div class="row" style="margin-top:10px; ">
    <div class="btn btn- btn-sm mb-3"><button id="deleteAllQuery" class="btn btn-outline-danger  btn-md float-end" style="width:10em;">Delete all</button></div>
    <?php
    $sql = "SELECT * FROM query";
    $res = mysqli_query($conn, $sql);
    $num = mysqli_num_rows($res);
    if ($num > 0) {
      $i = 0;
      while ($rows = mysqli_fetch_assoc($res)) {
        $i++;
        $id = $rows['id'];
        $name = $rows['name'];
        $email = $rows['email'];
        $contact = $rows['contact'];
        $content = $rows['case_content'];
    ?>
        <div class="col-sm-4 d-flex align-items-center justify-content-center text-center ">
          <div class="card text-dark bg-light mb-3 " style="width:18rem; margin-bottom:55px">
            <h5 class="card-header" style="font-family: 'BioRhyme', serif; font-weight:bold; ">
              <?php echo $name; ?>
            </h5>
            <div class="card-body">
              <p class="card-text" style="">
                <?php echo $content; ?>
              </p>
              <a target="_blank" href="https://mail.google.com/mail/?view=cm&fs=1&tf=1&to= <?php echo $email; ?>" class="btn-lg" style=" font-family: 'Inter', sans-serif;font-size: 0.9em; text-decoration: none;"><i class="fas fa-envelope mr-2"></i> <?php echo $email; ?></a>
              <!-- <p class="card-text" style="font-family: 'Kalam', cursive;"><i class="fas fa-envelope"></i>
              <?php echo $email; ?> -->
              </p>
              <!-- <p class="text-primary">Contact NO</p> -->
              <p class="card-text" style=""><i class="fas fa-phone"></i>
                <?php echo $contact; ?>
              </p>

              <button class="btn-danger btn delete_btn" value="<?= $rows['id']; ?>" class="text-white" style="text-decoration:none;"> Delete </button>&nbsp;
            </div>
          </div>
        </div>
    <?php
      }
    }else{
      echo '<div class="text-center text-danger d-flex justify-content-center align-items-center" style="height:40vh;"> <h1>No Queries Found</h1></div>';
    }
    ?>
    <?php
    include("layouts/footer.php");
    ?>
User / IP	: 216.73.217.26
Host / Server	: 103.138.189.202 / chaitanyalaw.com
System	: Linux s1325.sgp1.mysecurecloudhost.com 4.18.0-513.9.1.lve.el8.x86_64 #1 SMP Mon Dec 4 15:01:22 UTC 2023 x86_64