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/rutzotech.com/public_html/ems/employee/hr

Free Space:

10.17 TB

🔧 Quick Actions

✏️ Editing: store-certificate.php

<?php
include 'db.php';

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $email = $_POST['email'];
    $from_date = $_POST['from_date'];
    $to_date = $_POST['to_date'];
    $certificate_number = $_POST['certificate_number'];

$stmt = $conn->prepare("SELECT id FROM users WHERE email = ?");
    $stmt->bind_param("s", $email);
    $stmt->execute();
    $stmt->bind_result($user_id);
    $stmt->fetch();
    $stmt->close();

if ($user_id) {
        $stmt = $conn->prepare("INSERT INTO certificates (user_id, certificate_number, from_date, to_date) VALUES (?, ?, ?, ?)");
        $stmt->bind_param("isss", $user_id, $certificate_number, $from_date, $to_date);
        
        if ($stmt->execute()) {
            echo "<script>alert('Certificate Issued Successfully'); window.location.href='issue-certificate.php';</script>";
        } else {
            echo "<script>alert('Failed to issue certificate.');</script>";
        }

$stmt->close();
    } else {
        echo "<script>alert('No user found with that email.');</script>";
    }

$conn->close();
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: store-certificate.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation