function test_update()
{
$name = "Chris";
$date = "1111-11-11";
$test_student = new Student($name, $date);
$test_student->save();
$new_name = "Chris the Jerk";
$test_student->update($new_name);
$this->assertEquals("Chris the Jerk", $test_student->getName());
}
function testUpdate()
{
$name = "Bob";
$enrollment_date = "2015-01-01";
$test_student = new Student($name, $enrollment_date);
$test_student->save();
$new_name = "Kevin";
$test_student->update($new_name, $enrollment_date);
$this->assertEquals("Kevin", $test_student->getName());
}
function testUpdate()
{
//Arrange
$name = "Ben";
$enroll_date = "0000-00-00";
$id = 1;
$test_student = new Student($name, $enroll_date, $id);
$test_student->save();
$new_name = "Jen";
//Act
$test_student->update($new_name);
//Assert
$this->assertEquals($new_name, $test_student->getName());
}
function testUpdate()
{
//Arrange
$name = "Elliot Michaels";
$date = "2015-08-03";
$id = 1;
$test_student = new Student($name, $date, $id);
$test_student->save();
$new_name = "Drake Michaels";
//Act
$test_student->update($new_name);
//Assert
$this->assertEquals("Drake Michaels", $test_student->getName());
}
function test_update()
{
//Arange
$name = "Steve Beekman";
$date = "2015-08-23";
$test_student = new Student($name, $date);
$test_student->save();
$name2 = "Fred Flintstone";
$date2 = "0001-01-01";
$test_student->update($name2, $date2);
//Act
$id = $test_student->getId();
$result = new Student($name2, $date2, $id);
//Assert
$this->assertEquals(Student::find($id), $result);
}
$decriptionError = 'You must enter a description for the student';
} else {
//what they typed was okay, so store it to show it in the form
$description = $_POST['udescription'];
}
//END VALIDATION
//ADD THE ROW: if all the values the user typed are valid...
if ($all_valid == true) {
$student->stud_name = $_POST['ustud_name'];
$student->prog_id = $_POST['uprog_id'];
$student->quarter = $_POST['uquarter'];
$student->award = $_POST['uaward'];
$student->description = $_POST['udescription'];
$student->image = $_FILES['uimage'];
//Perform the following query based on the information provided by the user
if ($student->update($stud_id)) {
echo '<p class="success">Student record has been updated.</p>';
} else {
//otherwise show 'fail' feedback
echo '<p class="danger">ERROR: Student record has NOT been updated.</p>';
}
}
//END THE ADD ROW
}
//END THE POST. Now in all cases show them the form...
?>
<form action="<?php
echo htmlspecialchars($_SERVER["PHP_SELF"]);
?>
" method="post" enctype="multipart/form-data" id="add-form">
require_once "init.php";
//echo "i am here";
$student = new Student(new PDOdb("mysql:host=localhost;dbname=usjr", "root", ""));
$result = $student->show();
if (!$result) {
echo "No data contained in the result set...";
} else {
foreach ($result as $res) {
echo $res['studid'] . ' ' . $res['studfname'] . ' ' . $res['studlname'] . "<br>";
}
}
// $studid = 'AA-002';
// $studfname = 'Jeoffrey';
// $studlname = 'Gudio';
// $studmname = 'Camocamo';
// $studcourse = 'BSIT';
// $studyear = 4;
// $result = $student->insert(array($studid,$studfname,
// $studlname,$studmname,$studcourse,$studyear));
// if($result > 0)
// echo "Data added";
// else
// echo "Data was not added";
$result = $student->update(array('studid' => 'AA01', 'studfname' => 'Jeoffrey'), array('studlname' => 'Gudio', 'studcourse' => 'BSCS'), 2);
echo $result;
if ($result > 0) {
echo "Operation done";
} else {
echo "Operation failed";
}
<?php
require_once "../init.php";
$student = new Student(new PDOdb("mysql:host=localhost;dbname=usjr", "root", ""));
$studid = $_POST['stid'];
$studfname = $_POST['stfname'];
$studmname = $_POST['stmname'];
$studlname = $_POST['stlname'];
$studcourse = $_POST['stcourse'];
$studyear = $_POST['styear'];
$result = $student->update(array('studfname' => $studfname, 'studmname' => $studmname, 'studlname' => $studlname, 'studcourse' => $studcourse, 'studyear' => $studyear), array('studid' => $studid), 1);
header('Location:studentUpdateList.php');
function test_update()
{
//Arrange
$name = "Shmuel Irving-Jones";
$enroll_date = "2015-08-25";
$test_student = new Student($name, $enroll_date);
$test_student->save();
$new_name = "Reginald Irving-Jones";
//Act
$test_student->update($new_name);
//Assert
$this->assertEquals($new_name, $test_student->getName());
}
function showStudent()
{
global $connector;
global $result;
$student = new Student();
$course = new Course();
$plan = new Plan();
$student->setConnector($connector);
$course->setConnector($connector);
$plan->setConnector($connector);
if (isset($_POST['operation'])) {
list($operation, $params) = explode("#", $_POST['operation']);
switch ($operation) {
case 'delete':
$error_msg = $student->delete($params);
break;
case 'edit':
$stud = $student->getById($params);
$result['edit'] = $stud;
$result['edit']->student = $stud;
$exam = new Exam();
$exam->setConnector($connector);
$result['edit']->exam = $exam->getList($result['edit']->student);
break;
case 'editChanges':
$student->storeFormValues($_POST);
$error_msg = $student->update();
break;
case 'saveChanges':
$student->storeFormValues($_POST);
$error_msg = $student->insert();
if ($error_msg) {
$result['edit'] = $student;
}
break;
case 'nextPage':
$student->storeFormValues($_POST);
$result['edit'] = $student;
break;
case 'createPassword':
$stud = $student->getById($params);
$stud->setConnector($connector);
$error_msg = $stud->generatePassword();
$result['edit'] = $stud;
break;
default:
$error_msg = "Operazione non valida";
}
if ($error_msg != "") {
$result["errorMessage"] = $error_msg;
} elseif ($operation != 'edit' && $operation != "nextPage") {
$result["statusMessage"] = "Operazione completata!";
}
}
if (isset($_POST['search'])) {
$result["students"] = $student->search($_POST['search']);
} else {
$result["students"] = $student->getList();
}
$result["plans"] = $plan->getList("id_piano");
$result["courses"] = $course->getList("nome");
$page = "student.php";
include_once BASE_PATH . "template.php";
}
function testUpdate()
{
//Arrange
$student_name = "Paco";
$id = 1;
$enroll_date = "2015-08-29";
$test_student = new Student($student_name, $enroll_date, $id);
$test_student->save();
$new_student_name = "Pablo";
//Act
$test_student->update($new_student_name);
//Assert
$this->assertEquals("Pablo", $test_student->getStudentName());
}
function test_update()
{
//Arrange
$name = "Jeff Lebowski";
$enrollment_date = "1973-12-12";
$id = 1;
$student = new Student($name, $enrollment_date, $id);
$student->save();
$new_name = "The Dude";
//Act
$student->update($new_name);
//Assert
$this->assertEquals("The Dude", $student->getName());
}
public static function update($id, $data)
{
session_start();
$headers = apache_request_headers();
$token = $headers['X-Auth-Token'];
if (!$headers['X-Auth-Token']) {
header('Invalid CSRF Token', true, 401);
return print json_encode(array('success' => false, 'status' => 400, '1msg' => 'Invalid CSRF Token / Bad Request / Unauthorized ... Please Login again'), JSON_PRETTY_PRINT);
die;
} else {
if ($token != $_SESSION['form_token']) {
header('Invalid CSRF Token', true, 401);
return print json_encode(array('success' => false, 'status' => 400, 'msg' => 'Invalid CSRF Token / Bad Request / Unauthorized ... Please Login again'), JSON_PRETTY_PRINT);
die;
} else {
if (isset($data['studid']) && empty($data['studid'])) {
return print json_encode(array('success' => false, 'status' => 200, 'msg' => 'Student ID is required'), JSON_PRETTY_PRINT);
die;
} else {
if (isset($data['fname']) && empty($data['fname'])) {
return print json_encode(array('success' => false, 'status' => 200, 'msg' => 'Student Firstname is required'), JSON_PRETTY_PRINT);
die;
} else {
if (isset($data['lname']) && empty($data['lname'])) {
return print json_encode(array('success' => false, 'status' => 200, 'msg' => 'Student Lastname is required'), JSON_PRETTY_PRINT);
die;
} else {
if (isset($data['mobileno']) && empty($data['mobileno'])) {
return print json_encode(array('success' => false, 'status' => 200, 'msg' => 'Mobile No. is required'), JSON_PRETTY_PRINT);
die;
} else {
if (isset($data['email']) && empty($data['email'])) {
return print json_encode(array('success' => false, 'status' => 200, 'msg' => 'Email Address is required'), JSON_PRETTY_PRINT);
die;
} else {
$var = ['studid' => $data['studid'], 'fname' => $data['fname'], 'lname' => $data['lname'], 'mobileno' => $data['mobileno'], 'email' => $data['email'], 'address' => $data['address'], 'birthdate' => $data['birthdate'], 'graduated' => $data['graduated'], 'last_school' => $data['last_school'], 'pref_course' => $data['pref_course'], 'gender' => $data['gender']];
Student::update($id, $var);
}
}
}
}
}
}
}
}
function test_update()
{
//Arrange
$student_name = "Joker";
$enrollment_date = "6000-12-14";
$id = 1;
$student = new Student($student_name, $enrollment_date, $id);
$student->save();
$new_student_name = "Spot";
//Act
$student->update($new_student_name);
//Assert
$this->assertEquals("Spot", $student->getStudentName());
}
$stage = "1";
if (isset($_REQUEST["stage"])) {
$stage = $_REQUEST["stage"];
}
switch ($stage) {
case "2":
case "final":
$student->setSurName($_POST["surname"]);
$student->setOtherNames($_POST["otherNames"]);
$student->setSchoolID($_POST["schoolID"]);
//$student -> setDateOfBirth( $_POST[ "dateOfBirth" ] );
$student->setDateOfAdmission($_POST["dateOfAdmission"]);
$student->setGender($_POST["gender"]);
$student->setYearOfStudyAtAdmission($_POST["yearOfStudyAtAdmission"]);
$student->setEntryScore($_POST["entryScore"]);
if ($student->update()) {
$pageBody .= '
<div class="dialog info">
<p>The following student : </p>
<table>
<tbody>
<tr>
<th>school ID</th>
<td>' . $student->getSchoolID() . '</td>
</tr>
<tr>
<th>name</th>
<td>' . $student->getSurName() . ', ' . $student->getOtherNames() . '</td>
</tr> <!--
<tr>
<th>Date of Birth</th>
function doEdit()
{
if (isset($_POST['submit'])) {
$IDNO = $_POST['idno'];
$LNAME = $_POST['lName'];
$FNAME = $_POST['fName'];
$MNAME = $_POST['mName'];
$SEX = $_POST['gender'];
$BDAY = $_POST['bday'];
$BPLACE = $_POST['bplace'];
$STATUS = $_POST['status'];
$AGE = $_POST['age'];
$NATIONALITY = $_POST['nationality'];
$RELIGION = $_POST['religion'];
$CONTACT_NO = $_POST['contact'];
$HOME_ADD = $_POST['home'];
$EMAIL = $_POST['email'];
$student = new Student();
//$student->S_ID = "null";
$student->IDNO = $IDNO;
$student->LNAME = $LNAME;
$student->FNAME = $FNAME;
$student->MNAME = $MNAME;
$student->SEX = $SEX;
$student->BDAY = $BDAY;
$student->BPLACE = $BPLACE;
$student->STATUS = $STATUS;
$student->AGE = $AGE;
$student->NATIONALITY = $NATIONALITY;
$student->RELIGION = $RELIGION;
$student->CONTACT_NO = $CONTACT_NO;
$student->HOME_ADD = $HOME_ADD;
$student->EMAIL = $EMAIL;
//course infor
/*$course = $_POST['course'];
$semester = $_POST['semester'];
$ay = $_POST['AY'];
$sy = new Schoolyr();
$sy->AY = $ay;
$sy->SEMESTER = $semester;
$sy->COURSE_ID = $course;
$sy->IDNO = $IDNO;*/
/*if ($istrue) {
output_message('course info successfully added!');
redirect ('newstudent.php');
}
*/
//secondary Details
$FATHER = $_POST['father'];
$FATHER_OCCU = $_POST['fOccu'];
$MOTHER = $_POST['mother'];
$MOTHER_OCCU = $_POST['mOccu'];
$BOARDING = $_POST['boarding'];
$WITH_FAMILY = $_POST['withfamily'];
$GUARDIAN = $_POST['guardian'];
$GUARDIAN_ADDRESS = $_POST['guardianAdd'];
$OTHER_PERSON_SUPPORT = $_POST['otherperson'];
$ADDRESS = $_POST['otherAddress'];
$studdetails = new Student_details();
$studdetails->FATHER = $FATHER;
$studdetails->FATHER_OCCU = $FATHER_OCCU;
$studdetails->MOTHER = $MOTHER;
$studdetails->MOTHER_OCCU = $MOTHER_OCCU;
$studdetails->BOARDING = $BOARDING;
$studdetails->WITH_FAMILY = $WITH_FAMILY;
$studdetails->GUARDIAN = $GUARDIAN;
$studdetails->GUARDIAN_ADDRESS = $GUARDIAN_ADDRESS;
$studdetails->OTHER_PERSON_SUPPORT = $OTHER_PERSON_SUPPORT;
$studdetails->ADDRESS = $ADDRESS;
$studdetails->IDNO = $IDNO;
//
/*if ($istrue) {
output_message('Seccondary details successfully added!');
redirect ('newstudent.php');
}
*/
//requirements
$nso = isset($_POST['nso']) ? "Yes" : "No";
$bapt = isset($_POST['baptismal']) ? "Yes" : "No";
$entrance = isset($_POST['entrance']) ? "Yes" : "No";
$mir_contract = isset($_POST['mir_contract']) ? "Yes" : "No";
$certifcateOfTransfer = isset($_POST['certifcateOfTransfer']) ? "Yes" : "No";
$requirements = new Requirements();
$requirements->NSO = $nso;
$requirements->BAPTISMAL = $bapt;
$requirements->ENTRANCE_TEST_RESULT = $entrance;
$requirements->MARRIAGE_CONTRACT = $mir_contract;
$requirements->CERTIFICATE_OF_TRANSFER = $certifcateOfTransfer;
$requirements->IDNO = $IDNO;
//$istrue = $requirements->create();
/*if ($istrue) {
output_message('Student requirements successfully added!');
redirect ('newstudent.php');
}
*/
if ($IDNO == "") {
message('ID Number is required!', "error");
redirect('index.php?view=edit&id=' . $IDNO);
} elseif ($LNAME == "") {
message('Last Name is required!', "error");
redirect('index.php?view=edit&id=' . $IDNO);
} elseif ($FNAME == "") {
message('First Name is required!', "error");
redirect('index.php?view=edit&id=' . $IDNO);
} elseif ($MNAME == "") {
message('Middle Name is required!', "error");
redirect('index.php?view=edit&id=' . $IDNO);
} elseif ($EMAIL == "") {
message('Email address is required!', "error");
redirect('index.php?view=edit&id=' . $IDNO);
} else {
$student->update($_GET['id']);
//$sy->update($_GET['id']);
$studdetails->update($_GET['id']);
$requirements->update($_GET['id']);
message('Student infomation updated successfully!', "info");
redirect('index.php');
}
}
}
function testUpdate()
{
$student_name = "John Doe";
$enrollment_date = "2015-09-01";
$test_student = new Student($student_name, $enrollment_date);
$test_student->save();
$new_student_name = "Jane Smith";
$new_enrollment_date = "2013-09-01";
$new_student = new Student($new_student_name, $new_enrollment_date, $test_student->getId());
$test_student->update($new_student_name, $new_enrollment_date);
$this->assertEquals($test_student, $new_student);
}
function testUpdate()
{
//Arrange
$name = "Rick";
$date = "2015-08-15";
$id = 1;
$test_student = new Student($name, $date, $id);
$test_student->save();
$new_name = "Obama";
$new_date = "2015-10-10";
//Act
$test_student->update($new_name, $new_date);
//Assert
$this->assertEquals("Obama", $test_student->getName());
$this->assertEquals("2015-10-10", $test_student->getDate());
}
function testUpdate()
{
$id = null;
$name = "Micah";
$enrollment_date = "2015-08-30";
$test_student = new Student($id, $name, $enrollment_date);
$test_student->save();
$new_name = "Phil";
//Act
$test_student->update($new_name);
//Assert
$this->assertEquals("Phil", $test_student->getName());
}
function testUpdate()
{
//Arrange
$name = "Bob";
$enrollment_date = "2015-06-06";
$id = 1;
$test_student = new Student($name, $enrollment_date, $id);
$test_student->save();
$new_name = "Billy Bob";
//Act
$test_student->update($new_name);
//Assert
$this->assertEquals("Billy Bob", $test_student->getName());
}
function testUpdate()
{
//Arrange
$name = "Math";
$date = '0000-00-00';
$id = null;
$test_course = new Course($name, $id);
$test_course->save();
$student_name = "Student1";
$course_id = $test_course->getId();
$test_student = new Student($student_name, $id, $date, $course_id);
$test_student->save();
$new_student_name = "Student2";
//Act
$test_student->update($new_student_name);
//Assert
$this->assertEquals("Student2", $test_student->getStudentName());
}
function test_update()
{
$student_name = "Abe Lincoln";
$enroll_date = "06-15-2015";
$test_student = new Student($student_name, $enroll_date);
$test_student->save();
$column_to_update = "student_name";
$new_student_name = "Abraham Lincoln";
$test_student->update($column_to_update, $new_student_name);
$result = Student::getAll();
$this->assertEquals("Abraham Lincoln", $result[0]->getStudentName());
}
