Create New Item
Item Type
File
Folder
Item Name
Search file in folder and subfolders...
Are you sure want to rename?
File Manager
/
Formaciones
/
Modelos
:
EstudianteModelo.php
Advanced Search
Upload
New Item
Settings
Back
Back Up
Advanced Editor
Save
<?php // Modelos/EstudianteModelo.php class EstudianteModelo { private $db; public function __construct($db) { $this->db = $db; } /** Obtiene todos los cursos asignados al estudiante con su mejor puntaje */ public function obtenerMisCursos($usuario_id) { $query = " SELECT c.id AS curso_id, c.title AS titulo_curso, c.description, ca.assigned_at, (SELECT MAX(score) FROM quiz_results qr JOIN quizzes q ON q.id = qr.quiz_id WHERE q.course_id = c.id AND qr.user_id = ?) AS mejor_puntaje FROM course_assignments ca JOIN courses c ON c.id = ca.course_id WHERE ca.user_id = ? ORDER BY ca.assigned_at DESC"; $stmt = $this->db->prepare($query); $stmt->bind_param("ii", $usuario_id, $usuario_id); $stmt->execute(); return $stmt->get_result(); } }