?>
<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";
