ABCDY/assignTestTo.php at master · DmitriyKom/ABCDY · 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
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
<?php
/* Date         Name            Changes
 * 11/27/2019   Dmitriy           Coding page
 *
 *
 *
 */
include('wrapper/Header.php');
session_start();//session is starting
//checking if loggedin session is set, and role is Manager, if not rederecting to main page
if (!isset($_SESSION["loggedin"]) || $_SESSION["loggedin"] !== true || !isset($_SESSION["role"]) || $_SESSION["role"] !== "Manager") {
    header("location: index.php");
    exit;
}
include_once("./includes/open_conn.inc");    //opening connection to db
function getTrainingName($test_id, $link)
{//this function is returning  test title(aka name) from the  test id
    //	include_once("./includes/open_conn.inc");	//opening connection to db
    $select_title_query = "SELECT  test_title from  test where  test_id='" . $test_id . "'";
    $answr = "UNKNOWN ERROR";
    if ($result = mysqli_query($link, $select_title_query)) {
        if (mysqli_num_rows($result) > 0) {
            while ($row = mysqli_fetch_array($result)) {
                $answr = $row['test_title'];
            }
        }
    }
    return $answr;
}


?>
<script type="text/javascript" src="./js_scripts/addMoreLinks.js"></script>
<title>Assign Training</title>
<link rel="stylesheet" href="./design/bootstrap.css">
<style type="text/css">
    body {
        font: 14px sans-serif;
        text-align: center;
        background-image: url("wrapper/Background.jpeg");
        background-repeat: no-repeat;
        background-position: center;
        background-size: cover;
    }

    table {
        font-family: arial, sans-serif;
        border-collapse: collapse;
        width: 75%;
    }


</style>
<?php include('wrapper/Logo.php'); ?>
<div class="page-header">
    <h1><b><?php echo htmlspecialchars($_SESSION["username"]); ?>
        </b> please select users to assign<span style="color:red;"></h1>
    <h1><?php echo htmlspecialchars(getTrainingName($_GET['test_id'], $link)); ?></span>
        Training to:</h1>
    <br><br>
        <form action="./php_scripts/assignTest.php" method="post"  ">
                <?php
                echo '<input type="hidden" name=" test_id" value="' . $_GET['test_id'] . '">'; // hidden field for sending  test id into form action script
                $num_of_columns = 5;
                $counter = 0;
                $select_query = "SELECT username, id, role, firstName, lastName from users, user_info where users.id = user_info.user_id and enabled=b'1' and role='Trainee'";     // this query is selecting trainee user info from two tables: users and user_info
                if ($result = mysqli_query($link, $select_query)) {
                    if (mysqli_num_rows($result) > 0) {
                        while ($row = mysqli_fetch_array($result)) {
                            echo"<br>";
                            echo '<input style="text-align:left;" type="checkbox" name="checked_trainiees[]" value="' . $row['id'] . '" title="' . $row['username'] . " is " . $row['role'] . " whose id is " . $row['id'] . ' and name is ' . $row['firstName'] . " " . $row['lastName'] . '" /> ' .$row['username'];
                            echo"<br>";
                            $counter++;

                        }
                    }
                }
                include_once("./includes/close_conn.inc"); //closing connection to db
                ?>
            <br>
    <br>
            <div class="form-group">
                <a href="./showAllTest.php" type="reset" class="btn btn-default" value="Back">Back</a>
                <input type="submit" class="btn btn-primary" value="Assign Test To Selected Users">
            </div>
        </form>
</div>
        <?php
        include('wrapper/Footer.php');
        ?>