Exemplo n.º 1
0
 public static function addSubject($subjectName, $teacherId)
 {
     $db = bdd::Conn();
     $sql = $db->prepare('INSERT INTO subject (subjectName, teacherId) VALUES (:subjectName, :teacherId)');
     $flag = array('subjectName' => $subjectName, 'teacherId' => $teacherId);
     $sql->execute($flag);
 }
Exemplo n.º 2
0
 public static function delClass($classId)
 {
     $db = bdd::Conn();
     if ($classId != 1) {
         $sql = $db->prepare('DELETE FROM class WHERE classId = :classId');
         $flags = array('classId' => $classId);
         $sql->execute($flags);
         $sql = $db->prepare('UPDATE user SET classId = 1 WHERE classId = :classId');
         $sql->execute($flags);
     }
 }
Exemplo n.º 3
0
 public static function updateUser($adminId, $password, $classId)
 {
     $db = bdd::Conn();
     $sql = $db->prepare('UPDATE user SET password = :password, classId = :classId WHERE userId = :adminId');
     $flags = array('password' => $password, 'adminId' => $adminId, 'classId' => $classId);
     $sql->execute($flags);
 }