File Manager

✏️ php

<?php
require_once '../config.php';

$pdo->exec("CREATE TABLE IF NOT EXISTS knowledge (
    id INT AUTO_INCREMENT PRIMARY KEY,
    judul VARCHAR(255) NOT NULL,
    slug VARCHAR(255),
    kategori VARCHAR(100),
    konten TEXT,
    durasi VARCHAR(50),
    thumbnail VARCHAR(500),
    status ENUM('aktif', 'nonaktif') DEFAULT 'aktif',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)");

switch($method) {
    case 'GET':
        if (isset($_GET['id'])) {
            $stmt = $pdo->prepare("SELECT * FROM knowledge WHERE id = ?");
            $stmt->execute([$_GET['id']]);
            $data = $stmt->fetch();
            response($data ?: ['error' => 'Data not found'], $data ? 200 : 404);
        }
        $search = $_GET['search'] ?? '';
        $kategori = $_GET['kategori'] ?? '';
        
        $sql = "SELECT * FROM knowledge WHERE 1=1";
        $params = [];
        
        if ($search) {
            $sql .= " AND (judul LIKE ? OR konten LIKE ?)";
            $params[] = "%$search%";
            $params[] = "%$search%";
        }
        if ($kategori) {
            $sql .= " AND kategori = ?";
            $params[] = $kategori;
        }
        $sql .= " ORDER BY id DESC";
        
        $stmt = $pdo->prepare($sql);
        $stmt->execute($params);
        response($stmt->fetchAll());
        break;
        
    case 'POST':
        $judul = sanitize($input['judul'] ?? '');
        $kategori = sanitize($input['kategori'] ?? '');
        $konten = sanitize($input['konten'] ?? '');
        $durasi = sanitize($input['durasi'] ?? '');
        $thumbnail = sanitize($input['thumbnail'] ?? '');
        
        if (!$judul) response(['error' => 'Judul wajib diisi'], 400);
        
        $slug = strtolower(str_replace(' ', '-', preg_replace('/[^\w\s-]/', '', $judul)));
        
        $stmt = $pdo->prepare("INSERT INTO knowledge (judul, slug, kategori, konten, durasi, thumbnail) VALUES (?, ?, ?, ?, ?, ?)");
        $stmt->execute([$judul, $slug, $kategori, $konten, $durasi, $thumbnail]);
        response(['id' => $pdo->lastInsertId(), 'message' => 'Artikel berhasil ditambahkan'], 201);
        break;
        
    case 'PUT':
        $id = intval($input['id'] ?? 0);
        $judul = sanitize($input['judul'] ?? '');
        $kategori = sanitize($input['kategori'] ?? '');
        $konten = sanitize($input['konten'] ?? '');
        $durasi = sanitize($input['durasi'] ?? '');
        $thumbnail = sanitize($input['thumbnail'] ?? '');
        $status = $input['status'] ?? 'aktif';
        
        if (!$id || !$judul) response(['error' => 'ID dan Judul wajib diisi'], 400);
        
        $slug = strtolower(str_replace(' ', '-', preg_replace('/[^\w\s-]/', '', $judul)));
        
        $stmt = $pdo->prepare("UPDATE knowledge SET judul=?, slug=?, kategori=?, konten=?, durasi=?, thumbnail=?, status=? WHERE id=?");
        $stmt->execute([$judul, $slug, $kategori, $konten, $durasi, $thumbnail, $status, $id]);
        response(['message' => 'Artikel berhasil diupdate']);
        break;
        
    case 'DELETE':
        $id = intval($_GET['id'] ?? 0);
        if (!$id) response(['error' => 'ID wajib diisi'], 400);
        
        $stmt = $pdo->prepare("DELETE FROM knowledge WHERE id = ?");
        $stmt->execute([$id]);
        response(['message' => 'Artikel berhasil dihapus']);
        break;
}

response(['error' => 'Method not allowed'], 405);

Batal

⬅ public_html 11 item

Nama	Tipe	Ukuran	Diubah	Aksi
📁data	dir	—	2026-08-04 23:08	📂 Buka
🐘artikel.php	php	3 KB	2026-08-01 11:46	✏️ 👁️
🐘faq.php	php	2.5 KB	2026-08-01 11:24	✏️ 👁️
🐘galeri.php	php	4.1 KB	2026-08-05 18:24	✏️ 👁️
🐘klien.php	php	3.4 KB	2026-08-01 11:25	✏️ 👁️
🐘knowledge.php	php	3.4 KB	2026-08-01 11:24	✏️ 👁️
🐘produk.php	php	3.6 KB	2026-08-01 11:23	✏️ 👁️
🐘simpan-permintaan.php	php	2.4 KB	2026-08-10 16:27	✏️ 👁️
🐘slideshow.php	php	740 B	2026-08-10 16:10	✏️ 👁️
🐘testimoni.php	php	2.9 KB	2026-08-01 11:23	✏️ 👁️
🐘visitors.php	php	6.2 KB	2026-08-10 16:36	✏️ 👁️

✏️ Rename