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); }
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); } }
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); }