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';