Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.54.1.lve.el8.x86_64

PHP Version:

7.3.33

User:

u435171512

Directory:

/home/u435171512/domains/isaconsouthzone2024.com/public_html

Free Space:

4.08 TB

🔧 Quick Actions

✏️ Editing: generate_cme.php

<?php
require_once('tcpdf/tcpdf.php');
include('includes/config.php');

// Check if event parameter is set
if (!isset($_GET['event'])) {
    die('Event parameter is missing.');
}

$event = $_GET['event'];

// Extend the TCPDF class to create custom Header and Footer
class MYPDF extends TCPDF {

public function Header() {
        // get the current page break margin
        $bMargin = $this->getBreakMargin();
        // get current auto-page-break mode
        $auto_page_break = $this->AutoPageBreak;
        // disable auto-page-break
        $this->SetAutoPageBreak(false, 0);
        // set background image
        $img_file = 'images/cme-certificate.jpg';
        $this->Image($img_file, 0, 0, 210, 297, '', '', '', false, 300, '', false, false, 0);
        // restore auto-page-break status
        $this->SetAutoPageBreak($auto_page_break, $bMargin);
        // set the starting point for the page content
        $this->setPageMark();
    }
}

// Fetch participants data from database
$sql = "SELECT * FROM participants WHERE events_category_id = '$event'";
$result = mysqli_query($conn, $sql);

if (!$result) {
    die('Error: ' . mysqli_error($conn));
}

// Directory path for saving individual PDFs
$root_path = __DIR__ . '/certificates/cme/';

// Create directory if it doesn't exist
if (!file_exists($root_path)) {
    mkdir($root_path, 0777, true);
}

// Process each participant
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
    // Retrieve participant data
    $participants_id = $row['participants_id'];
    $participant_name = $row['participant_name'];
    $crn_no = $row['crn_no'];
    $mobile = $row['mobile'];
    $mci_no = $row['mci_no'];
    $registered_with = $row['registered_with'];
    $mc_affiliated = $row['mc_affiliated'];
    
    // Create a new instance of MYPDF for each participant
    $pdf = new MYPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);

// set document information
    $pdf->SetCreator(PDF_CREATOR);
    $pdf->SetAuthor('ISACON2024');
    $pdf->SetTitle('CME Certificate');
    $pdf->SetSubject('CME Certificate');
    $pdf->SetKeywords('CME, Certificate, TCPDF');

// set fonts
    $pdf->SetFont('dejavusans', '', 10);

// add a page
    $pdf->AddPage();

// Build HTML content for PDF
    $html = '<table width="800px;">
    <tr><td height="351px">&nbsp;</td><td>&nbsp;</td></tr>
    <tr><td width="50px;">&nbsp;</td><td align="center"><span>' . $participant_name . '</span></td></tr>
    <tr><td height="3px">&nbsp;</td><td>&nbsp;</td></tr>
    <tr><td width="200px;" align="right"><span>' . $mci_no . '</span></td><td width="220px;" align="right"><span>' . $registered_with . '</span></td></tr>
    <tr><td height="2px">&nbsp;</td><td>&nbsp;</td></tr>
    <tr><td width="160px;">&nbsp;</td><td align="center"><span>' . $mc_affiliated . '</span></td></tr></table>';
    
    // Write HTML content to PDF
    $pdf->writeHTML($html, true, false, true, false, '');

// Generate unique file name for PDF
    $file_name = $crn_no . '_' . $mobile . '_' . rand(100, 999) . '.pdf';
    $file_path = $root_path . $file_name;

// Path for database storage
    $file_source = '/certificates/cme/' . $file_name;

// Update database with file path
    $update_sql = "UPDATE participants SET certificate_path = '$file_source', certificate_generated = 'yes' WHERE participants_id = '$participants_id'";
    mysqli_query($conn, $update_sql);

// Save PDF file
    $pdf->Output($file_path, 'F');
    
    // Clear TCPDF buffers
    $pdf->close();

unset($pdf);
}

// Display success message or redirect to another page
echo "Certificates generated successfully.";

// Close the database connection
mysqli_close($conn);
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: generate_cme.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation