function add($config, $parameters) { loadModel('models/Subjects'); loadModel('models/Students'); $subjects = getAllSubjects($config); if (!$subjects['status']) { $subjects['subjects'] = []; } if ('POST' == getRequestMethod()) { $result = addStudent($config, $_POST); $_SESSION['addStatus'] = $result['status']; $_SESSION['addStatusMessage'] = $result['message']; header('Location: /students'); } return ['status' => true, 'message' => 'An error occured while trying to retrieve Student records.', 'subjects' => $subjects['subjects']]; }
//deleteCust //deleteCust case 'deleteEmp': deleteEmp(); break; case 'deleteStd': deleteStd(); break; case 'deleteFac': deleteFac(); break; case 'addEmp': addEmp(); break; case 'addStudent': addStudent(); break; case 'addFaculty': addFaculty(); break; case 'editEmp': editEmp(); break; case 'editStudent': editStudent(); break; case 'editFaculty': editFaculty(); break; default: // if action is not defined or unknown
// is leerling $gegevens[$values]["account_activated"] = 0; //account is nog niet geactiveerd, dit wordt pas gedaan als gebruiker eerste keer inlogt. $gegevens[$values]["generated_password"] = generate_random_password(); $gegevens[$values]["wachtwoord"] = password_hash($gegevens[$values]["generated_password"], PASSWORD_BCRYPT); $gegevens[$values]["email_code"] = md5($gegevens[$values]["voornaam"] + microtime()); } //checken of email en student_id uniek zijn foreach ($gegevens as $leerling_gegevens) { if ($leerling_gegevens['emailadres'] === FALSE) { $false_email = [$leerling_gegevens['emailadres']]; } else { if (checkIfUserExists($leerling_gegevens['emailadres'], $leerling_gegevens['leerling_id']) === FALSE) { //email adres niet in gebruik, dus gebruiker kan worden toegevoegd. // gegevens inserten addStudent($leerling_gegevens, $leerling_gegevens["emailadres"], $leerling_gegevens["leerling_id"], $leerling_gegevens["klas"]); } else { //email adres in gebruik gebruiker wordt op de hoogte gesteld dat dit email adres bezet is. $_SESSION['message'] = "Email adres " . $leerling_gegevens['emailadres'] . " is al in gebruik"; } } } } } if (isset($_POST["submit_bewerk_leerling"])) { if ($_POST['voornaam'] == "" or $_POST['achternaam'] == "" or $_POST['leerling_id'] == "" or $_POST['emailadres'] == "") { $_SESSION['message'] = "Je moet alle gegevens invullen!"; } else { // overbodige ingevoerde spaties weghalen met functie trim $voornaam = filter_var(trim($_POST['voornaam']), FILTER_SANITIZE_STRING); $achternaam = filter_var(trim($_POST['achternaam']), FILTER_SANITIZE_STRING);
$htmlbody = str_replace("settings.phone", $settings->{'phone'}, $htmlbody); $htmlbody = str_replace("parq.firstname", $parq->{'firstname'}, $htmlbody); $htmlbody = str_replace("parq.surname", $parq->{'surname'}, $htmlbody); $htmlbody = str_replace("parq.address", $parq->{'address'}, $htmlbody); $htmlbody = str_replace("parq.postcode", $parq->{'postcode'}, $htmlbody); $htmlbody = str_replace("parq.homephone", $parq->{'homephone'}, $htmlbody); $htmlbody = str_replace("parq.mobile", $parq->{'mobile'}, $htmlbody); $htmlbody = str_replace("parq.dob", $parq->{'dob'}, $htmlbody); $htmlbody = str_replace("parq.email", $parq->{'email'}, $htmlbody); $htmlbody = str_replace("parq.emergencycontact", $parq->{'emergencycontact'}, $htmlbody); $htmlbody = str_replace("parq.emergencynumber", $parq->{'emergencynumber'}, $htmlbody); $htmlbody = str_replace("parq.howhear", $parq->{'howhear'}, $htmlbody); $htmlbody = str_replace("parq.q1_heart", $parq->{'q1_heart'} ? $trueVal : $falseVal, $htmlbody); $htmlbody = str_replace("parq.q2_chest", $parq->{'q2_chest'} ? $trueVal : $falseVal, $htmlbody); $htmlbody = str_replace("parq.q3_chestmonth", $parq->{'q3_chestmonth'} ? $trueVal : $falseVal, $htmlbody); $htmlbody = str_replace("parq.q4_dizzy", $parq->{'q4_dizzy'} ? $trueVal : $falseVal, $htmlbody); $htmlbody = str_replace("parq.q5_bone", $parq->{'q5_bone'} ? $trueVal : $falseVal, $htmlbody); $htmlbody = str_replace("parq.q6_blood", $parq->{'q6_blood'} ? $trueVal : $falseVal, $htmlbody); $htmlbody = str_replace("parq.q7_supervision", $parq->{'q7_supervision'} ? $trueVal : $falseVal, $htmlbody); $htmlbody = str_replace("parq.q8_pregnant", $parq->{'q8_pregnant'} ? $trueVal : $falseVal, $htmlbody); $htmlbody = str_replace("parq.q9_additional", $parq->{'q9_additional'}, $htmlbody); $htmlbody = str_replace("parq.secret", $parq->{'secret'}, $htmlbody); } // Add student to SugarCRM addStudent($upload); $from = $settings->{'email'}; $to = $parq->{'email'}; // Send email to student send_mail($from, $to, "Stay Safe Krav Maga", $htmlbody); // Send email to instructor send_mail($from, $from, "Stay Safe Krav Maga", $htmlbody);
$excelheaders = array_shift($exceldata); $leerlingendata = rebuildExcelClassDataArray($exceldata, $excelheaders); } //****** VIA EXCEL BESTAND KLAS(SEN) MET LEERLINGEN TOEVOEGEN ******// if (isset($_POST['submit_excel_data'])) { unset($_POST['submit_excel_data']); $leerlingendata = rebuildArray($_POST); //controleren of klas al bestaat, zo niet: aanmaken foreach ($leerlingendata as $leerling) { $getKlas = getKlas($leerling["klas"]); if ($getKlas == 0) { addKlas($leerling); } if (checkIfUserExists($leerling['emailadres']) === FALSE) { $leerling = addStudentCredentials($leerling); addStudent($leerling, $leerling["emailadres"], $leerling["leerling_id"], $leerling["klas"]); } } } //**************** KLAS TOEVOEGEN ******************// if (isset($_POST['submit_add_klas'])) { if (isset($_POST['klas'], $_POST['examenjaar'], $_POST['docent_afk'])) { //binnenkomende array ombouwen unset($_POST['submit_add_klas']); $gegevens = rebuildArray($_POST); if (!checkArrayForEmptyValues($gegevens)) { $_SESSION['message'] = "Je moet alle gegevens invullen!"; } else { //Ingevoerde gegevens door filter halen en trimmen $gegevens = addKlasFilter($gegevens); //checken of er geen lege waarden zijn ingevoerd
* Check if the no. of students is forty or not */ if (!checkFourtyStud($cid)) { echo '<script language="javascript"> alert("You cannot enter more than 40 students !!"); window.location="' . SERVER . '/teacher/course/' . $cid . '"; </script>'; return; } /** @var int $tid Teacher ID */ $tid = $_SESSION['tid']; /** * Check the student has already added or not */ if (!checkUniqueId($tid, $stuId, $cid)) { echo '<script language="javascript"> alert("ID has already inserted !!"); window.location="' . SERVER . '/course/' . $cid . '/addstudent"; </script>'; return; } /** * Adding Student in the Course */ addStudent($tid, $stuId, $cid); attendence($stuId, $cid); addMarks($stuId, $cid); echo '<script language="javascript"> alert("Successfully Added"); window.location="' . SERVER . '/teacher/course/' . $cid . '"; </script>';
<?php include 'functions.php'; if (!empty($_POST)) { if (!empty($_POST['submit'])) { $submit = $_POST['submit']; if ($submit == 'add') { if (!empty($_POST['StudentUsername']) && !empty($_POST['StudentPassword']) && !empty($_POST['selectedDepartmentId'])) { $departmentId = $_POST['selectedDepartmentId']; $studentUsername = $_POST['StudentUsername']; $studentPassword = $_POST['StudentPassword']; $isExecutedSuccessful = addStudent($studentUsername, $studentPassword, $departmentId); } } else { if ($submit == 'change') { if (!empty($_POST['selectedStudentId'])) { $studentId = $_POST['selectedStudentId']; if (!empty($_POST['studentUsername'])) { $studentUsername = $_POST['studentUsername']; $isExecutedSuccessful = changestudentUsername($studentUsername, $studentId); } if (!empty($_POST['studentPassword'])) { $studentPassword = $_POST['studentPassword']; $isExecutedSuccessful = changestudentPassword($studentPassword, $studentId); } } } else { if ($submit == 'transfer') { if (!empty($_POST['selectedStudentId']) && !empty($_POST['selectedDepartmentIdTo'])) { $studentId = $_POST['selectedStudentId']; $departmentIdTo = $_POST['selectedDepartmentIdTo'];
<?php include_once "database.php"; $inputJSON = file_get_contents('php://input'); $student = json_decode($inputJSON, TRUE); //convert JSON into array addStudent($student["student_name"], $student["regno"], $student["cgpa"]);
<?php include 'db_helper.php'; if ($_GET['f'] == 'add' && $_GET['name'] && $_GET['gender'] && $_GET['email'] && $_GET['phone']) { addStudent($_GET['name'], $_GET['gender'], $_GET['email'], $_GET['phone']); } elseif ($_GET['f'] == 'get' && $_GET['email']) { getStudent($_GET['email']); } elseif ($_GET['f'] == 'update' && $_GET['name'] && $_GET['gender'] && $_GET['phone'] && $_GET['sid']) { updateStudent($_GET['name'], $_GET['gender'], $_GET['phone'], $_GET['sid']); } elseif ($_GET['f'] == 'get' && $_GET['sid']) { getStudentInfo($_GET['sid']); } function getStudent($email) { $dbQuery = sprintf("SELECT ID FROM Student WHERE email = '%s'", mysql_real_escape_string($email)); // $result = getDBResultRecord($dbQuery); //header("Content-type: application/json"); echo json_encode($result); } function addStudent($name, $gender, $email, $phone) { $dbQuery = sprintf("INSERT INTO Student (name,gender,email,phone) VALUES ('%s','%d','%s','%d')", mysql_real_escape_string($name), $gender, mysql_real_escape_string($email), $phone); $result = getDBResultInserted($dbQuery, 'ID'); //header("Content-type: application/json"); echo json_encode($result); } function updateStudent($name, $gender, $phone, $sid) { $dbQuery = sprintf("UPDATE Student SET name = '%s',gender='%d',phone='%d' WHERE ID = '%d'", mysql_real_escape_string($name), $gender, $phone, $sid); $result = getDBResultAffected($dbQuery);