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