File Manager

✏️ p

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

$pdo->exec("CREATE TABLE IF NOT EXISTS artikel (
    id INT AUTO_INCREMENT PRIMARY KEY,
    judul VARCHAR(255) NOT NULL,
    kategori VARCHAR(100) DEFAULT 'Edukasi',
    gambar VARCHAR(500) DEFAULT '',
    deskripsi TEXT,
    konten TEXT,
    penulis VARCHAR(100) DEFAULT 'Admin',
    tanggal DATE DEFAULT (CURRENT_DATE),
    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 artikel WHERE id = ?");
            $stmt->execute([$_GET['id']]);
            $data = $stmt->fetch();
            response($data ?: ['error' => 'Data not found'], $data ? 200 : 404);
        }
        $stmt = $pdo->query("SELECT * FROM artikel WHERE status='aktif' ORDER BY created_at DESC");
        response($stmt->fetchAll());
        break;
        
    case 'POST':
        $judul = sanitize($input['judul'] ?? '');
        $kategori = sanitize($input['kategori'] ?? 'Edukasi');
        $gambar = sanitize($input['gambar'] ?? '');
        $deskripsi = sanitize($input['deskripsi'] ?? '');
        $konten = sanitize($input['konten'] ?? '');
        $penulis = sanitize($input['penulis'] ?? 'Admin');
        
        if (!$judul) response(['error' => 'Judul wajib diisi'], 400);
        
        $stmt = $pdo->prepare("INSERT INTO artikel (judul, kategori, gambar, deskripsi, konten, penulis) VALUES (?, ?, ?, ?, ?, ?)");
        $stmt->execute([$judul, $kategori, $gambar, $deskripsi, $konten, $penulis]);
        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'] ?? 'Edukasi');
        $gambar = sanitize($input['gambar'] ?? '');
        $deskripsi = sanitize($input['deskripsi'] ?? '');
        $konten = sanitize($input['konten'] ?? '');
        $penulis = sanitize($input['penulis'] ?? 'Admin');
        $status = $input['status'] ?? 'aktif';
        
        if (!$id) response(['error' => 'ID wajib diisi'], 400);
        
        $stmt = $pdo->prepare("UPDATE artikel SET judul=?, kategori=?, gambar=?, deskripsi=?, konten=?, penulis=?, status=? WHERE id=?");
        $stmt->execute([$judul, $kategori, $gambar, $deskripsi, $konten, $penulis, $status, $id]);
        response(['message' => 'Artikel berhasil diperbarui']);
        break;
        
    case 'DELETE':
        $id = intval($input['id'] ?? $_GET['id'] ?? 0);
        if (!$id) response(['error' => 'ID wajib diisi'], 400);
        
        $stmt = $pdo->prepare("DELETE FROM artikel WHERE id = ?");
        $stmt->execute([$id]);
        response(['message' => 'Artikel berhasil dihapus']);
        break;
        
    default:
        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