PHP LAB FULL

Name	Size	Date	CHMOD	Action
— FILE —
logo_1773801405.php	6.73 KB	2026-03-18 02:36	644 (rw-r--r--)	Edit \| Rename \| Preview \| Del

🧪 PHP Preview

<?php
// logic.php - Otak Dashboard
ini_set('display_errors', 1);
error_reporting(E_ALL);

$id_user = isset($_SESSION['id_user']) ? $_SESSION['id_user'] : 0;
$page = isset($_GET['page']) ? $_GET['page'] : 'home';

// 1. AMBIL DATA PESERTA DIDIK
$query_me = mysqli_query($koneksi, "SELECT * FROM peserta_didik WHERE id = '$id_user'");
$me = mysqli_fetch_assoc($query_me);

if (!$me) {
    header("location:index.php?pesan=gagal");
    exit();
}

// 2. LOGIKA HITUNG DATA
$jml_materi = 0;
$res_materi = @mysqli_query($koneksi, "SELECT COUNT(*) as total FROM materi");
if ($res_materi) {
    $row_materi = mysqli_fetch_assoc($res_materi);
    $jml_materi = $row_materi['total'];
}

$jml_tugas = 0;
$res_tugas = @mysqli_query($koneksi, "SELECT COUNT(*) as total FROM tugas WHERE user_id_peserta = '$id_user'");
if ($res_tugas) {
    $row_tugas = mysqli_fetch_assoc($res_tugas);
    $jml_tugas = $row_tugas['total'];
}

// 3. LOGIKA CEK ABSENSI HARI INI
$tgl_sekarang = date('Y-m-d');
$data_absen = null;
$res_absen = mysqli_query($koneksi, "SELECT * FROM absensi WHERE id_peserta = '$id_user' AND tanggal = '$tgl_sekarang' LIMIT 1");
if ($res_absen && mysqli_num_rows($res_absen) > 0) {
    $data_absen = mysqli_fetch_assoc($res_absen);
}

// 4. DATA PENGUMUMAN MARQUEE
$running_text = "Selamat Datang di Birulogi LMS - Belajar Seru dengan Peserta Didik Berprestasi!";
$res_ann = @mysqli_query($koneksi, "SELECT judul, isi_pengumuman FROM pengumuman ORDER BY created_at DESC LIMIT 3");
if ($res_ann && mysqli_num_rows($res_ann) > 0) {
    $ann_list = []; 
    while($r = mysqli_fetch_assoc($res_ann)) { 
        $ann_list[] = "[ ".$r['judul'].": ".$r['isi_pengumuman']." ]"; 
    }
    $running_text = implode(" • ", $ann_list);
}

// 5. LOGIKA JELAJAHI TEMAN
$limit = 6; 
$halaman = isset($_GET['p']) ? (int)$_GET['p'] : 1;
$offset = ($halaman > 1) ? ($halaman * $limit) - $limit : 0;
$query_teman = mysqli_query($koneksi, "SELECT nama_lengkap, foto_profil, kelas FROM peserta_didik WHERE id != '$id_user' LIMIT $offset, $limit");

// Query Postingan - Sesuaikan dengan kolom: konten, media_path, created_at
$query_posts = mysqli_query($koneksi, "SELECT posts.*, peserta_didik.nama_lengkap, peserta_didik.foto_profil 
    FROM posts 
    JOIN peserta_didik ON posts.user_id = peserta_didik.id 
    ORDER BY posts.created_at DESC LIMIT 15");

// Cek jika query gagal untuk menghindari Fatal Error
if (!$query_posts) {
    die("Query Error: " . mysqli_error($koneksi));
}

// Ambil kata pertama, ubah jadi huruf kecil semua, lalu kapital lurus di awal
$nama_mentah = explode(' ', trim($me['nama_lengkap']))[0];
$nama_panggilan = ucfirst(strtolower($nama_mentah));

📁 File Manager

🧪 PHP Preview

🖥 Linux CMD