get_last_attempt_time.php

<?php
// Include the database connection
include("config/db.php");

// Check if the user ID and lesson ID are provided via POST
if (isset($_POST['userId']) && isset($_POST['lessonId'])) {
    // Retrieve user ID and lesson ID from POST data
    $userId = $_POST['userId'];
    $lessonId = $_POST['lessonId'];

    // Function to get the last attempt time
    function getLastAttemptTime($userId, $lessonId, $con)
{
    $sql = "SELECT end_time FROM quiz_attempts WHERE user_id = $userId AND qlesson_id = $lessonId ORDER BY attempt_id DESC LIMIT 1";
    $result = mysqli_query($con, $sql);
    if ($result && mysqli_num_rows($result) > 0) {
        $row = mysqli_fetch_assoc($result);
        $endTimeSeconds = $row['end_time'];
        if ($endTimeSeconds < 60) {
            return $endTimeSeconds . " seconds";
        } else {
            $endTimeMinutes = floor($endTimeSeconds / 60);
            return $endTimeMinutes . " minutes";
        }
    }
    return "None";
}

    // Function to get the time limit for a lesson
    function getTimeLimit($lessonId, $con)
    {
        $sql = "SELECT time_limit FROM quizlessons WHERE qlesson_id = $lessonId";
        $result = mysqli_query($con, $sql);
        if ($result && mysqli_num_rows($result) > 0) {
            $row = mysqli_fetch_assoc($result);
            return $row['time_limit'];
        }
        return null;
    }

    // Call the function to get the last attempt time and time limit
    $lastAttemptTime = getLastAttemptTime($userId, $lessonId, $con);
    $timeLimit = getTimeLimit($lessonId, $con);
    // Call the function to get the last attempt time
    $lastAttemptTime = getLastAttemptTime($userId, $lessonId, $con);

    // Return the last attempt time and time limit as JSON
    echo json_encode(array("lastAttemptTime" => $lastAttemptTime, "timeLimit" => $timeLimit));
} else {
    // Return an error message if user ID or lesson ID is not provided
    echo json_encode("Error: User ID or Lesson ID not provided.");
}