?> <div class="hidden adminForms"> <div class="panel panel-default col-md-8 col-md-offset-2" id="profilePanel"> <div class="panel-heading"> <h3 class="panel-title">Ändra utbildning</h3> </div> <div class="panel-body"> <div class="col-md-12"> <form action="profile.php" method="POST"> <select name="editEducation" class="form-control"> <option>Utbildningar</option> <?php foreach (selectAllFrom("educations") as $edu) { echo "<option value =" . $edu["id"] . ">" . $edu["education_name"] . "</option>"; } ?> </select> <input type="submit" name="chooseEducation" class="form-control formSubmits"> </form> <?php if (isset($_POST["chooseEducation"])) { try { $id = $_POST["editEducation"]; $query = "SELECT * FROM educations "; $query .= "WHERE id = :id";
function selectAllFromWhereColumnDiffersToValue($table, $column, $value) { $query = selectAllFrom($table) . where(compare($column, '<>', $value)); return $query; }
foreach (selectAllFrom("courses") as $c) { $content .= "\r\n"; $content .= $c['id'] . ";"; $content .= $c['course_id'] . ";"; $content .= $c['education_key'] . ";"; } $content .= "\r\n"; $content .= "\r\n"; $content .= "//EDUCATIONS"; $content .= "\r\n"; //j foreach (selectAllFrom("educations") as $e) { $content .= "\r\n"; $content .= $e['id'] . ";"; $content .= $e['education_key'] . ";"; } $content .= "\r\n"; $content .= "\r\n"; $content .= "//GRADES"; $content .= "\r\n"; foreach (selectAllFrom("grades") as $g) { $content .= "\r\n"; $content .= $g['id'] . ";"; $content .= $g['user_id'] . ";"; $content .= $g['course_id'] . ";"; $content .= $g['grade'] . ";"; } file_put_contents("dbDump.txt", $content); } catch (Exception $exception) { echo $exception; }
<?php require_once "dbConnection.php"; require_once "functions.php"; try { echo "<div class='row'>"; echo "<div class='col-md-8 col-md-offset-2'"; echo "<form>"; echo "<select name='educations' class='form-control selectWidth' onchange=\"displayStudents(this.value)\">"; echo "<option value=''>Kurser</option>"; foreach (selectAllFrom("courses") as $c) { echo "<option value=" . $c["course_id"] . ">" . $c["course_id"] . "</option>"; } echo "</select>"; echo "</form>"; } catch (Exception $exception) { echo $exception; } //this "posts" to grading php if (isset($_GET['filterStudents'])) { try { //creating list of students in a particular course $query = "SELECT users.name, users.lastname, users.user_id, courses.course_id "; $query .= "FROM users JOIN courses "; //ON is what joins (with education_key) $query .= "ON users.education_key = courses.education_key "; $query .= "WHERE courses.course_id = :course_id"; $ps = $db->prepare($query); $ps->execute(array("course_id" => $_GET['filterStudents'])); $usersAndCourses = $ps->fetchAll(); $output = "";
?> <div class="hidden adminForms"> <div class="panel panel-default col-md-8 col-md-offset-2" id="profilePanel"> <div class="panel-heading"> <h3 class="panel-title">Lägg till Användare</h3> </div> <div class="panel-body"> <div class="col-md-12"> <form action="profile.php" method="POST"> <select name="editUser" class="form-control"> <option>Användare</option> <?php foreach (selectAllFrom("users") as $u) { echo "<option value =" . $u["user_id"] . ">" . $u["name"] . " " . $u["lastname"] . "</option>"; } ?> </select> <input type="submit" name="chooseUser" class="form-control formSubmits"> </form> <?php if (isset($_POST["chooseUser"])) { try { $user_id = $_POST["editUser"]; $query = "SELECT * FROM users "; $query .= "WHERE user_id = :user_id";