LibraryCountingCamera/exportExcelDailyExit.php at main · cam-byte/LibraryCountingCamera · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
<?php
$connect = mysqli_connect("localhost", "p_f21_16", "e3m6rq", "p_f21_16_db");
$sql = "SELECT * FROM DailyReportDataExited";
$result = mysqli_query($connect, $sql);
?>
<html>
 <head>
  <title>Export Daily Exited Report Data to Excel</title>
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" />
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.0/jquery.min.js"></script>
 </head>
 <body>
  <div class="container">
   <br />
   <br />
   <br />
   <div class="table-responsive">
    <h2 align="center">Export Daily Exited Report Data to Excel</h2><br />
    <table class="table table-bordered">
     <tr>
       <th>Time Exited</th>
       <th>People Exited</th>
     </tr>
     <?php
     while($row = mysqli_fetch_array($result))
     {
        echo '
       <tr>
         <td>'.$row["TimeExited"].'</td>
         <td>'.$row["PeopleExited"].'</td>
       </tr>
        ';
     }
     ?>
    </table>
    <br />
    <form method="post" action="successExportDailyExited.php">
     <input type="submit" name="export" class="btn btn-success" value="Export" />
    </form>
   </div>
  </div>
 </body>
</html>