UserDAO.php 910 B

123456789101112131415161718192021222324252627282930313233
  1. <?php
  2. class FreshRSS_UserDAO extends Minz_ModelPdo {
  3. public function createUser($username) {
  4. require_once(APP_PATH . '/sql.php');
  5. $db = Minz_Configuration::dataBase();
  6. $sql = sprintf(SQL_CREATE_TABLES, $db['prefix'] . $username . '_');
  7. $stm = $this->bd->prepare($sql, array(PDO::ATTR_EMULATE_PREPARES => true));
  8. if ($stm && $stm->execute()) {
  9. return true;
  10. } else {
  11. $info = $stm->errorInfo();
  12. Minz_Log::record ('SQL error : ' . $info[2], Minz_Log::ERROR);
  13. return false;
  14. }
  15. }
  16. public function deleteUser($username) {
  17. require_once(APP_PATH . '/sql.php');
  18. $db = Minz_Configuration::dataBase();
  19. $sql = sprintf(SQL_DROP_TABLES, $db['prefix'] . $username . '_');
  20. $stm = $this->bd->prepare($sql);
  21. if ($stm && $stm->execute()) {
  22. return true;
  23. } else {
  24. $info = $stm->errorInfo();
  25. Minz_Log::record ('SQL error : ' . $info[2], Minz_Log::ERROR);
  26. return false;
  27. }
  28. }
  29. }