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