DCMS/logs.php at main · IamLotlot/DCMS · 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
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <link rel="shortcut icon" type="icon" href="img">
	<link rel="icon" type="image/x-icon" href="css/img/logo1.png">
    <link rel="stylesheet" href="css/nav.css">
    <link rel="stylesheet" href="css/logs.css">
    <script src="https://kit.fontawesome.com/8ef5e4d9da.js"></script>
    <title>DCMS | Logs Page</title>
</head>
<body onload="onStart(); setColors()">
<?php
    include 'nav.php';
?>
    <section>
        <div class="tableHeader">
            <label>Name</label>
            <label>Position</label>
            <label>Service</label>
            <label>Date Scheduled</label>
            <label>Date Created</label>
            <label>State</label>
        </div>
        <div class="table">
            <?php

                $sql = "SELECT * FROM `log`";

                $result = mysqli_query($conn, $sql);

                if ($result) {
                    while ($row = mysqli_fetch_assoc($result)) {
                        $name = $row['name'];
                        $position = $row['position'];
                        $service = $row['service'];
                        $dateCreated = $row['dateCreated'];
                        $dateEnd = $row['dateEnd'];
                        $state = $row['state'];

                        echo '
                        <div class="tableContent">
                            <label>'.$name.'</label>
                            <label>'.$position.'</label>
                            <label>'.$service.'</label>
                            <label>'.$dateCreated.'</label>
                            <label>'.$dateEnd.'</label>
                            <label class="'.$state.'" id="state">'.$state.'</label>
                        </div>
                        ';
                    }
                }
            ?>
        <div>

        </div>
    </section>
    <script src="js/nav.js"></script>
    <script src="js/logs.js"></script>
</body>
</html>