Exemplo n.º 1
0
 public static function tk_change_password(array $data, tkDatabase $db)
 {
     try {
         $result = $db->get_connection()->prepare("UPDATE users\n\t\t\t\t\t\t\t\t\t\t\t\t\t  SET password = :new_password\n\t\t\t\t\t\t\t\t\t\t\t\t\t  WHERE email = :email\n\t\t\t\t\t\t\t\t\t\t\t\t\t  AND password = :current_password");
         $result->execute($data);
     } catch (PDOException $e) {
         return $e->getMessage();
     }
 }
Exemplo n.º 2
0
 public static function tk_add_test(array $data, tkDatabase $db)
 {
     try {
         $result = $db->get_connection()->prepare("INSERT INTO tests (lesson_level_id, title, questions, answers, joins)\n\t\t\t\t\t\t\t\t\t\t\t\t\t  VALUES (:lesson_level_id, :title, :questions, :answers, :joins)");
         $result->execute($data);
     } catch (PDOException $e) {
         return $e->getMessage();
     }
     return true;
 }
Exemplo n.º 3
0
 public static function tk_get_level_id(array $data, tkDatabase $db)
 {
     try {
         $result = $db->get_connection()->prepare("SELECT * FROM lesson_level \n\t\t\t\t\t\t\t\t\t\t\t\t\t  WHERE level = :level\n\t\t\t\t\t\t\t\t\t\t\t\t\t  LIMIT 1");
         $result->execute($data);
     } catch (PDOException $e) {
         return $e->getMessage();
     }
     return $result->fetch();
 }
Exemplo n.º 4
0
 public static function tk_video(array $data, tkDatabase $db)
 {
     try {
         $statement = $db->get_connection()->prepare("SELECT * FROM videos\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t INNER JOIN playlist\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t ON playlist.id = videos.playlist\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t WHERE playlist.id = :playlist\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t ORDER BY videos.id ASC");
         $statement->execute($data);
     } catch (PDOException $e) {
         return $e->getMessage();
     }
     return $statement->fetchAll();
 }
Exemplo n.º 5
0
 public function tk_get_rating(tkDatabase $db)
 {
     $result = $db->get_connection()->query("SELECT first_name, last_name, user_rating \n\t\t\t\t\t\t\t\t\t\t\t\tFROM users INNER JOIN records \n\t\t\t\t\t\t\t\t\t\t\t\tON users.id = records.user_id\n\t\t\t\t\t\t\t\t\t\t\t\tORDER BY user_rating DESC LIMIT 50");
     return $result;
 }