public function update(Student $object) { $q = "UPDATE " . self::TABLE . " SET `name`='" . Singleton::create("NullConverter")->fromDOMtoDB($object->getName()) . "' WHERE studentId='" . addslashes($object->getStudentId()) . "'"; $pk = $object->getStudentId(); if ($object->isNew()) { if (empty($pk)) { $q = "INSERT INTO " . self::TABLE . " (`name`) VALUES ('" . Singleton::create("NullConverter")->fromDOMtoDB($object->getName()) . "')"; } else { $q = "INSERT INTO " . self::TABLE . " (`name`) VALUES ('" . Singleton::create("NullConverter")->fromDOMtoDB($object->getStudentId()) . "', '" . Singleton::create("NullConverter")->fromDOMtoDB($object->getName()) . "')"; } } $this->db->updateQuery($q); if (empty($pk)) { $pk = $this->db->selectQuery("SELECT studentId from " . self::TABLE . " ORDER BY studentId DESC limit 1")->getSingleton(); } $result = $this->findByPrimaryKey($pk); parent::$dbCache->resetEntity("Student"); parent::$dbCache->setSingle("Student", $pk, $result); return $result; }
function testFind() { //arrange $student_name = "Chemistry"; $student_id = 1; $student_number = "2015-12-12"; $test_student = new Student($student_name, $student_number, $student_id); $test_student->save(); $student_name2 = "Underwater Basketweaving"; $student_id2 = 2; $student_number2 = "2015-12-12"; $test_student2 = new Student($student_name2, $student_number2, $student_id2); $test_student2->save(); //act $result = Student::find($test_student->getStudentId()); //assert $this->assertEquals($test_student, $result); }
$datos = explode("|", $linea); switch ($opcion) { case 1: $student = new Student($db); $id_student = $student->getStudentId($datos[1]); $debt_share = new DebtShare($db); $data = array(1, $id_student, $datos[0], $datos[3], $datos[4], $datos[5]); $id = $debt_share->insertDebtShare($data, $idTransaction); //adicionar la confirmacion o error del insert //adicionar registro de los logs $res = $id; //resultado final break; case 2: $student = new Student($db); $id_student = $student->getStudentId($datos[0]); $debt_share = new DebtShare($db); $data = array(2, $id_student, $datos[0], $datos[3], $datos[4], $datos[5]); //corregir esto la estructura de la tabla es diferente $id = $debt_share->insertDebtShare($data, $idTransaction); //adicionar la confirmacion o error del insert //adicionar registro de los logs $res = $id; //resultado final break; } $contador = $contador + 1; } if ($res > 0) { $msg = "<br>Total Registros Cargados: " . $contador; Forms::setMessage('SUCCESS', $v_label["SHORT_MESSAGE_OK_UPLOAD"], $v_label["DETAIL_MESSAGE_OK_UPLOAD"] . $msg);
/** * @param Student $Student */ public function setStudent($Student) { $this->Student = $Student; $this->student_id = $Student->getStudentId(); }
<input id="firstN" size="30" maxlength="50" type="text" name="firstN" required value=<?php echo $student->getFirstName(); ?> > </div> <div class="field"> <label for="lastN">Last Name</label> <input id="lastN" size="30" maxlength="50" type="text" name="lastN" required value=<?php echo $student->getLastName(); ?> > </div> <div class="field"> <label for="studID">Student ID</label> <input id="studID" size="30" maxlength="7" type="text" pattern="[A-Za-z]{2}[0-9]{5}" title="AB12345" name="studID" disabled value=<?php echo $student->getStudentId(); ?> > </div> <div class="field"> <label for="email">E-mail</label> <input id="email" size="30" maxlength="255" type="email" name="email" required value=<?php echo $student->getEmail(); ?> > </div> <div class="field"> <label for="major">Major</label> <select id="major" name = "major"> <option <?php if ($student->getMajor() == 'CMPE') {