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: .."); }