<?php
session_start();
if(isset($_SESSION['username'])){

  include '../config/database.php';
  include 'header.php';
  $msg = "";
 $index=1;
}
else{

    header("location:../index.php");
}

if(isset($_POST['delete'])){
    $pid = $_POST['id'];
    $sql = "DELETE   FROM result  WHERE id = '$pid'";

       if(mysqli_query($link, $sql)){

           $msg = "phrase deleted!";

       }else{

           $msg = "phrase not deleted!";
       }
}

?>
  <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.19/css/jquery.dataTables.css">
  <link rel="stylesheet" href=" https://code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css">
  <link rel="stylesheet" href=" https://cdn.datatables.net/1.10.19/css/dataTables.jqueryui.min.css">
  <link rel="stylesheet" href=" https://cdn.datatables.net/buttons/1.5.6/css/buttons.jqueryui.min.css">
  <link rel="stylesheet" href=" https://cdn.datatables.net/1.10.19/css/dataTables.bootstrap.min.css">
  <link rel="stylesheet" href=" https://cdn.datatables.net/buttons/1.5.6/css/buttons.bootstrap.min.css">
  <link rel="stylesheet" href="">
  <script type="text/javascript" charset="utf8" src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.js"></script>
  <script type="text/javascript" charset="utf8" src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"></script>
  <script type="text/javascript" charset="utf8" src="https://cdn.datatables.net/1.10.19/js/dataTables.jqueryui.min.js"></script>
  <script type="text/javascript" charset="utf8" src="https://cdn.datatables.net/buttons/1.5.6/js/dataTables.buttons.min.js"></script>
  <script type="text/javascript" charset="utf8" src="https://cdn.datatables.net/buttons/1.5.6/js/buttons.jqueryui.min.js"></script>
  <script type="text/javascript" charset="utf8" src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
  <script type="text/javascript" charset="utf8" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js"></script>
  <script type="text/javascript" charset="utf8" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js"></script>
  <script type="text/javascript" charset="utf8" src="https://cdn.datatables.net/buttons/1.5.6/js/buttons.html5.min.js"></script>
  <script type="text/javascript" charset="utf8" src="https://cdn.datatables.net/buttons/1.5.6/js/buttons.print.min.js"></script>
  <script type="text/javascript" charset="utf8" src="https://cdn.datatables.net/buttons/1.5.6/js/buttons.colVis.min.js"></script>
  <script type="text/javascript" charset="utf8" src=""></script>
  <script type="text/javascript" charset="utf8" src=""></script>

<style>
.table-responsive {overflow-x: hidden;}
@media (max-width: 8000px) {.table-responsive {
overflow-x: auto;
}}
</style>

  </head>
  <body>

  <!-- Main Content -->
      <div class="main-content">

        <section class="section">

          <div class="section-header">
            <h1><i class="fa fa-users" style="font-size:30px"></i>View Phrase</h1>
            <div class="section-header-breadcrumb">

                 <div class="breadcrumb-item"></div>
            </div>
          </div>
          <div class="col-md-12 col-sm-12 col-sx-12">

                <?php if($msg != "") echo "<div style='padding:20px;background-color:#dce8f7;color:black'> $msg</div class='btn btn-success'>" ."</br></br>";  ?>

               <div class="table-responsive">
                     <table class="display"  id="example">
                                    <thead>
                                        <tr>
                                             <th style="display:none">SN</th>
                                             <th>SN</th>
                                            <th>PHRASE</th>
                                             <th>TICKET ID</th>
                                             <th>DATE</th>
                                            <th>ACTION</th>

                                        </tr>
                                    </thead>
                                    <tbody>


                                    <?php
                                    $sql= "SELECT * FROM result";
			  $result = mysqli_query($link,$sql);
			  if(mysqli_num_rows($result) > 0){
				  while($row = mysqli_fetch_assoc($result)){
	 $id = $row['id'];
   $tid = $row['ticket'];
 $phrase = $row['phrase'];
 $date = $row['ddate'];


	 ?>

                                        <tr class="odd gradeX">
                                      <form action="phrase.php" method="POST">

                                         <td style="display:none">
                                           <input type="text" name="id" value="<?php echo $id;?>"></td>
                                            <td><?php echo $index++;?></td>
                                            <td><?php echo $phrase;?></td>
                                            <td><?php echo $tid;?></td>
                                            <td><?php echo $date;?></td>

                                            <td><button type="submit" name="delete" style="width:100%" class="btn btn-danger"><span class="fas fa-trash">-Delete </span></button></td>

                                          </form>
                                        
                                        </tr>

<?php
          }
          }
?>


                                     </tbody>
                                </table>
                            </div>
                        </div>


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

<script>
$(document).ready(function() {
    var table = $('#example').DataTable( {
        lengthChange: false,
        buttons: [ 'copy', 'excel', 'pdf', 'colvis' ],

    } );


    table.buttons().container()
        .insertBefore( '#example_filter' );

        table.buttons().container()
        .appendTo( '#example_wrapper .col-sm-12:eq(0)' );
} );
</script>

  </body>
</html>
