function process_students()
{
global $userrole;
if ($userrole === "admin") {
print '<b>Students</b><br /><br />';
if (isset($_GET['act'])) {
if ($_POST['Edit'] === 'edit') {
$st = db_students();
edit_student($st);
} else {
if ($_POST['Add'] === 'add') {
add_student();
} else {
if ($_POST['Save'] === 'save') {
save_student();
} else {
if ($_POST['Remove'] === 'remove') {
$st = db_students();
remove_record($st);
} else {
if ($_POST['AddOption'] === 'add') {
add_study_program_to_student_and_edit_student();
} else {
if ($_POST['Remove'] === 'yes') {
yes_remove();
} else {
if ($_POST['Remove'] === 'no') {
no_remove();
} else {
foreach ($_POST as $var => $val) {
if (strncmp($var, 'deletelist', 10) === 0) {
delete_sp_and_edit_student($var);
break;
}
}
}
}
}
}
}
}
}
}
$stdata = db_students();
$stfd = format_student_data($stdata);
show_table(array('ID', 'First name', 'Middle names', 'Last name', 'Born', 'StudentID', 'Gender', 'Citizenship', 'E-mail', 'Study programs', 'Year 1st participated'), $stfd);
} else {
return;
}
}
// print_r($_POST);
$values['ID #'] = $_POST['studentid'];
$values['Last'] = $_POST['lname'];
$values['First'] = $_POST['fname'];
$values['Advisor'] = $_POST['advisor'];
$values['startsem'] = $_POST['start_semester'];
$values['startyear'] = $_POST['start_year'];
$values['Option'] = $_POST['major'];
$check = studentid_validation($_POST['studentid']);
//print_r($values);
if ($check == "false") {
$result = 0;
echo '<script>alert("Student id already exists"); </script>';
} else {
//print_r($values);
$result = add_student($values);
}
if ($result == 1) {
$_SESSION['student'] = $_POST;
redirect_to("add_student_foundation.php");
} else {
$error = "Student data enter failed";
}
}
?>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>
<div id="page" class="container">
<div id="add_student_wrapper">
<div id="add_student_title">
<h1>
//check if button submit is clicked
$message = '';
if (isset($_POST['submit'])) {
$photo = $_FILES['photo'];
if ($photo && !$photo['error']) {
$name = $photo['name'];
$type = $photo['type'];
$path = $photo['tmp_name'];
$bytes = file_get_contents($path);
$fName = trim($_POST['fName']);
$mName = trim($_POST['mName']);
$lName = trim($_POST['lName']);
$id = trim($_POST['id']);
$course = trim($_POST['COURSE']);
$yr = trim($_POST['YR']);
add_student($id, $fName, $mName, $lName, $course, $yr, 1);
add_photo($id, $name, $type, $bytes, 'student', 1);
add_sitinDetails($id, 0, 30);
//Sit-in details for student is added
$target = "../uploadedPhotos/";
$target = $target . basename($_FILES['photo']['name']);
if (move_uploaded_file($_FILES['photo']['tmp_name'], $target)) {
//echo "The file ". basename( $_FILES['photo']['name']). " has been uploaded, and your information has been added to the directory";
}
$message = "<div class = 'alert alert-success' style = 'width: 265px;'>Successfully added.</div>";
echo "<script>";
//go back to viewPhotos page after 3 seconds.
echo "setTimeout(function(){ document.location = '?p=viewStudent'; }, 2000);";
echo "</script>";
} else {
$message = "<div class = 'alert alert-warning' style = 'width: 265px;'>Photo is invalid!</div>";
<?php
require '../model/database.php';
require '../model/students_db.php';
if ($_POST['action'] == "delete_student") {
$studentID = $_POST['student_id'];
delete_student($studentID);
} else {
$studentID = $_POST['ID'];
$firstName = $_POST['firstName'];
$lastName = $_POST['lastName'];
$parentID = $_POST['parentID'];
$userName = $_POST['username'];
$password = $_POST['password'];
if (!empty($studentID) || !empty($firstName) || !empty($lastName) || !empty($userName) || !empty($password) || !empty($parentID)) {
add_student($studentID, $firstName, $lastName, $parentID, $userName, $password);
}
}
header("Location: mstudent.php");
<option value="2nd">2nd</option>
<option value="3rd">3rd</option>
</select>
</td>
</tr>
<tr>
<th height="23" scope="row">Email</th>
<td><input type="text" name="email"></td>
</tr>
<tr>
<th height="23" scope="row">Password</th>
<td><input type="password" name="password"></td>
</tr>
<tr>
<input name="submit" type="submit" id="Submit" value="submit">
</tr>
</table>
</form>
</center>
<?php
if (isset($_POST['submit'])) {
include_once 'functions.php';
add_student($_POST);
//header('location:history.php');
}
include_once "footer.php";
?>
</body>
</html>
function add_students_from_csv($files)
{
$filename = "";
//print_r($files);
$filename = $files["file"]["tmp_name"];
//print_r($files);
$options['delimiter'] = ",";
//echo tableFromCsv($files["file"]["name"], true, $options);
//echo "<pre>";
$result = extractCsv($filename, true, $options);
// echo"<pre>";print_r($result);
// echo "iambatman . $result";
// print_r($result);
$ids = array_column($result, "ID #");
//echo "<pre>";print_r($ids);
$keys = array_keys($result[0]);
$check_keys = array_slice($keys, 0, 6);
//echo "<pre>";print_r($check_keys);
$format_key = array("ID #", "Last", "First", "Advisor", "Start SEM.", "Option");
// echo "<pre>";print_r($format_key);
//echo "value".($check_keys === $format_key);
if ($check_keys === $format_key) {
//echo "iambatman";
$students = array();
$counter = 0;
// echo"<pre>";print_r($ids);
for ($i = 0; $i < sizeof($ids); $i++) {
$check = studentid_validation($ids[$i]);
if ($check == "false") {
// echo "<br>".$ids[$i];
$students[$counter][$i] = $ids[$i];
$counter++;
}
// echo $i." ".$ids[$i]."<br>";
}
if ($counter > 0) {
// echo"<pre>";print_r($students);
return $students;
} else {
$keys = array_keys($result[0]);
//echo "<pre>";print_r($keys);
/*foreach ($result as $i => $values) {
//echo "<pre>";print_r($values);
add_student($values);
}*/
foreach ($result as $i => $values) {
add_student($values);
for ($i = 6; $i < sizeof($keys); $i++) {
//echo $values ['ID #'].$keys[$i];print_r($values[$keys[$i]]);echo "<br>";
add_foundatation($values['ID #'], "GCIS " . $keys[$i], $values[$keys[$i]]);
}
}
return 1;
}
} else {
return 0;
}
}
$res = mysql_query($sql);
$data = array();
while ($row = mysql_fetch_assoc($res)) {
$data[] = $row;
}
echo json_encode($data);
}
function delete_student()
{
mysql_query("DELETE FROM students where id='" . $_POST['id'] . "'");
echo "OK";
}
if ($_POST['action'] == 'fetch_classes') {
fetch_classes();
} else {
if ($_POST['action'] == 'add_student') {
add_student();
} else {
if ($_POST['action'] == 'load_students') {
load_students();
} else {
if ($_POST['action'] == 'delete_student') {
delete_student();
} else {
if ($_POST['action'] == 'fetch_interests') {
fetch_interests();
}
}
}
}
}
<?php
/*
* Sameer Jain
* sameejain@my.smccd.edu
* CIS 380
* OL
* final
* Sameer Jain
* 12/18/15
*/
require '../model/database.php';
require '../model/product_db.php';
$student_name = filter_input(INPUT_POST, 'student_name');
$gender = filter_input(INPUT_POST, 'gender');
$student_email = filter_input(INPUT_POST, 'student_email');
$student_number = filter_input(INPUT_POST, 'student_number');
$at_sign = strpos($student_email, "@");
$dot_sign = strpos($student_email, ".");
if ($student_name == NULL || $gender == NULL || !preg_match("/^[0-9]{3}-[0-9]{3}-[0-9]{4}\$/", $student_number) || $dot_sign === false || $at_sign === false) {
$error = "Invalid data. Check all fields and try again.";
include '../errors/error.php';
} else {
add_student($student_name, $gender, $student_email, $student_number);
header("Location: ..");
}
