function save_class()
{
//add message to alert array
include "../app/student/studentmanager.php";
$connection = db_connect();
//connect to database
$class = $_SESSION['class'];
$teacherid = $_SESSION['id'];
$classname = $class['name'][0];
$query = "INSERT INTO `project`.`class` (`id`, `teacher_id`, `class_group`) VALUES (NULL, '{$teacherid}', '{$classname}')";
$result = mysqli_query($connection, $query);
//perform query
$classid = mysqli_insert_id($connection);
if ($result) {
//check if query ran
for ($i = 0; $i < count($class['fname']); $i++) {
create_student($class['fname'][$i], $class['lname'][$i], $classid);
}
add_success("Class Created.");
clear_class();
} else {
add_error("Class not created, Error in SQL");
}
db_close($connection);
}
$s = test_password($password, $first_name, $last_name, $username);
if (is_string($s)) {
fail("Sorry, password is inadequate: {$s}");
}
}
if ($teacher_code == "") {
fail("No teacher code provided.");
}
$sql = "select * from users where active=1 and user_type='t' and teacher_code={$teacher_code}";
dbg("sql={$sql}");
$rs = dbExec($sql);
if ($rs->RecordCount() != 1) {
fail("The teacher-code provided is invalid. Please re-enter.");
}
$school_code = $rs->fields("school_code");
create_student($teacher_code, $first_name, $last_name, $username, $password);
anchorRedirect($anchor, $tab);
}
}
}
}
}
}
}
}
}
}
$tab = rt("tab");
if ($tab == "") {
$tab = "mgr_addstudents";
}
release_all_groups($teacher_code);
// create groups and assign students
foreach ($teams as $n4 => $t4) {
$ROLE = $r;
$TEAM = $n4;
$s = create_group($teacher_code, $TEAM);
if (is_string($s)) {
err("Failed to create group \"{$TEAM}\" - {$s}");
} else {
$gid = $s;
//$rcodes = array("sd", "mm", "nh", "sb", );
$rnums = array(3, 4, 5, 6);
for ($j = 0; $j < count($rcodes); $j++) {
if (isset($t4[$rcodes[$j]])) {
$l = $t4[$rcodes[$j]];
$id = create_student($teacher_code, $l[0], $l[1], $l[4], $l[5]);
assignStudentToGroupAndClass($id, $gid, $rnums[$j]);
}
}
}
}
}
header("Location: groups.php");
} else {
?>
<div style="border: solid 2px green; text-align: center; padding: 10px; background-color: #efe;">
<b>Congratulations!</b><br>
No errors were detected.
<p>
<b> BUT WAIT! YOU'RE NOT DONE!</b>
Your input looks satisfactory,but you still have to <br>
<?php
include 'functions.php';
session_start();
global $page;
$page = $_REQUEST["page"];
if ($_REQUEST["action"] == 'create_student') {
$message = create_student();
}
if ($_REQUEST["action"] == 'create_tutor') {
$message = create_tutor();
}
if ($_REQUEST["action"] == 'create_tutor_request') {
$message = create_tutor_request();
}
if ($_REQUEST["action"] == 'edit_request') {
$message = edit_request();
}
if ($_REQUEST["action"] == 'cancel_request') {
$message = cancel_request();
}
if ($_REQUEST["action"] == 'login') {
$message = login();
}
if ($_REQUEST["action"] == 'logout') {
$message = logout();
}
if ($_REQUEST["action"] == 'confirm') {
$message = confirm();
}
include 'header.php';
