.-.-.-.-.-

<?php
function getPopularCourses($conn, $limit = 3) {
    $sql = "SELECT c.*, cat.name as category_name, i.name as instructor_name 
            FROM courses c 
            LEFT JOIN categories cat ON c.category_id = cat.id 
            LEFT JOIN instructors i ON c.instructor_id = i.id 
            WHERE c.is_popular = 1 
            ORDER BY c.created_at DESC 
            LIMIT ?";
    $stmt = $conn->prepare($sql);
    $stmt->bind_param("i", $limit);
    $stmt->execute();
    return $stmt->get_result();
}

function getCourseDetails($conn, $course_id) {
    $sql = "SELECT c.*, cat.name as category_name, i.name as instructor_name, i.bio as instructor_bio, i.expertise as instructor_expertise 
            FROM courses c 
            LEFT JOIN categories cat ON c.category_id = cat.id 
            LEFT JOIN instructors i ON c.instructor_id = i.id 
            WHERE c.id = ?";
    $stmt = $conn->prepare($sql);
    $stmt->bind_param("i", $course_id);
    $stmt->execute();
    return $stmt->get_result()->fetch_assoc();
}

function addToCart($conn, $user_id, $course_id) {
    // Check if already in cart
    $check_sql = "SELECT id FROM cart WHERE user_id = ? AND course_id = ?";
    $check_stmt = $conn->prepare($check_sql);
    $check_stmt->bind_param("ii", $user_id, $course_id);
    $check_stmt->execute();
    
    if($check_stmt->get_result()->num_rows > 0) {
        return false; // Already in cart
    }
    
    $sql = "INSERT INTO cart (user_id, course_id) VALUES (?, ?)";
    $stmt = $conn->prepare($sql);
    $stmt->bind_param("ii", $user_id, $course_id);
    return $stmt->execute();
}

function getCartItems($conn, $user_id) {
    $sql = "SELECT c.*, cart.id as cart_id 
            FROM cart 
            JOIN courses c ON cart.course_id = c.id 
            WHERE cart.user_id = ?";
    $stmt = $conn->prepare($sql);
    $stmt->bind_param("i", $user_id);
    $stmt->execute();
    return $stmt->get_result();
}

function removeFromCart($conn, $cart_id, $user_id) {
    $sql = "DELETE FROM cart WHERE id = ? AND user_id = ?";
    $stmt = $conn->prepare($sql);
    $stmt->bind_param("ii", $cart_id, $user_id);
    return $stmt->execute();
}
?>

/home/users/unlimited/www/wordpress/../nigeria.codeskitter.site/includes/functions.php