Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/hifi11.in/public_html/ems/admin

Free Space:

10.26 TB

🔧 Quick Actions

✏️ Editing: send-receipt.php

<?php
// Include database connection
include('../../db_config.php');

// Check if an ID is passed via the URL
if (!isset($_GET['id']) || empty($_GET['id'])) {
    die("Invalid request, enrollment ID is missing.");
}

$id = $_GET['id'];

try {
    // Create DB connection using PDO
    $db = getDBConnection();
    
    // Fetch the enrollment data from the database based on the ID
    $query = "SELECT * FROM enrollment WHERE id = :id";
    $stmt = $db->prepare($query);
    $stmt->bindParam(':id', $id);
    $stmt->execute();
    
    $enrollment = $stmt->fetch(PDO::FETCH_ASSOC);
    
    if (!$enrollment) {
        die("Enrollment not found.");
    }

// Prepare the receipt content
 $receiptContent = "
 <html>
 <head><title>Receipt for Course Enrollment</title></head>
 <body>
 <h2>Receipt for Enrollment</h2>
 Full Name: " . htmlspecialchars($enrollment['full_name']) . "
 Course: " . htmlspecialchars($enrollment['course_name']) . "
 Amount Paid: ₹" . number_format($enrollment['amount'], 2) . "
 Transaction ID: " . htmlspecialchars($enrollment['transaction_id']) . "
 Payment Status: " . ucfirst($enrollment['payment_status']) . "
 Payment Date: " . date('d M Y H:i', strtotime($enrollment['payment_date'])) . "
 Thank you for enrolling with us!
 </body>
 </html>
 ";

// Send the email
    $to = $enrollment['email'];
    $subject = "Course Enrollment Receipt";
    $headers = "MIME-Version: 1.0" . "\r\n";
    $headers .= "Content-Type: text/html; charset=UTF-8" . "\r\n";
    $headers .= "From: no-reply@yourwebsite.com" . "\r\n";

// Mail function to send the receipt
    if (mail($to, $subject, $receiptContent, $headers)) {
        // Mark as receipt sent in the database
        $updateQuery = "UPDATE enrollment SET receipt_sent = 1 WHERE id = :id";
        $updateStmt = $db->prepare($updateQuery);
        $updateStmt->bindParam(':id', $id);
        $updateStmt->execute();
        
        echo "Receipt sent successfully!";
    } else {
        echo "Failed to send the receipt.";
    }
} catch (PDOException $e) {
    die("Error: " . $e->getMessage());
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: send-receipt.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation