function getCourses() { $conn = DBManager::getConn(); $stmt = $conn->prepare("SELECT * FROM `course`"); $stmt->execute(); $info = $stmt->fetchAll(); if ($stmt->rowCount() > 0) { return $info; } else { return null; } }
function getUserAccountTypeById($user_id) { $conn = DBManager::getConn(); $stmt = $conn->prepare("SELECT * FROM `student` WHERE `student_id` = :user_id"); $stmt->bindValue(":user_id", $user_id); $stmt->execute(); if ($stmt->rowCount() === 1) { return "Student"; } $stmt = $conn->prepare("SELECT * FROM `tutor` WHERE `tutor_id` = :user_id"); $stmt->bindValue(":user_id", $user_id); $stmt->execute(); if ($stmt->rowCount() === 1) { return "Tutor"; } return null; }
function changeProfilePic($user_id, $path) { $conn = DBManager::getConn(); $stmt = $conn->prepare("UPDATE `user` SET `profile_pic` = :profile_pic WHERE `user_id` = :user_id"); $stmt->bindValue(":user_id", $user_id); $stmt->bindValue(":profile_pic", $path); $stmt->execute(); }
function insertUserMessage($message_id, $uId, $oId, $folder) { $conn = DBManager::getConn(); $stmt = $conn->prepare("INSERT INTO `user_messages` (`message_id`, `user_id`, `other_user_id`, `folder`) VALUES (:message_id, :uId, :oId, :folder)"); $stmt->bindValue(":message_id", $message_id); $stmt->bindValue(":uId", $uId); $stmt->bindValue(":oId", $oId); $stmt->bindValue(":folder", $folder); $stmt->execute(); }