<?php
    // PHP code di sini
    echo "Hello World!";
?>

<?php
$nilai = 85;

// If sederhana
if ($nilai >= 80) {
    echo "Nilai Anda: A (Sangat Baik)";
}

// If-else
if ($nilai >= 80) {
    echo "Lulus dengan baik";
} else {
    echo "Perlu belajar lebih giat";
}

// If-elseif-else
if ($nilai >= 90) {
    $grade = "A+";
} elseif ($nilai >= 80) {
    $grade = "A";
} elseif ($nilai >= 70) {
    $grade = "B";
} elseif ($nilai >= 60) {
    $grade = "C";
} else {
    $grade = "D";
}

echo "Grade Anda: " . $grade;
?>

<?php
$hari = date('N'); // 1=Senin, 7=Minggu

switch ($hari) {
    case 1:
        $nama_hari = "Senin";
        $motivasi = "Semangat memulai minggu baru!";
        break;
    case 2:
        $nama_hari = "Selasa";
        $motivasi = "Terus berjuang!";
        break;
    case 3:
        $nama_hari = "Rabu";
        $motivasi = "Pertengahan minggu, jangan menyerah!";
        break;
    case 4:
        $nama_hari = "Kamis";
        $motivasi = "Hampir weekend!";
        break;
    case 5:
        $nama_hari = "Jumat";
        $motivasi = "Last push sebelum weekend!";
        break;
    case 6:
    case 7:
        $nama_hari = ($hari == 6) ? "Sabtu" : "Minggu";
        $motivasi = "Waktunya istirahat dan refreshing!";
        break;
    default:
        $nama_hari = "Unknown";
        $motivasi = "Hari yang aneh...";
}

echo "<h3>Hari ini: {$nama_hari}</h3>";
echo "<p>{$motivasi}</p>";
?>

<?php
// Array sederhana
$buah = ["Apel", "Jeruk", "Mangga", "Pisang"];

echo "<h4>Daftar Buah:</h4><ul>";
foreach ($buah as $item) {
    echo "<li>" . $item . "</li>";
}
echo "</ul>";

// Array dengan key dan value
$mahasiswa = [
    "nama" => "Andi Susanto",
    "nim" => "12345678",
    "jurusan" => "Informatika",
    "semester" => 5
];

echo "<h4>Data Mahasiswa:</h4><dl>";
foreach ($mahasiswa as $key => $value) {
    echo "<dt>" . ucfirst($key) . ":</dt>";
    echo "<dd>" . $value . "</dd>";
}
echo "</dl>";
?>

<?php
// Database connection
$host = "localhost";
$username = "root";
$password = "";
$database = "belajar_php";

// Membuat koneksi
$conn = new mysqli($host, $username, $password, $database);

// Cek koneksi
if ($conn->connect_error) {
    die("Koneksi gagal: " . $conn->connect_error);
}

echo "Koneksi database berhasil!";

// Jangan lupa tutup koneksi
$conn->close();
?>

<?php
// Koneksi database (sama seperti di atas)
$conn = new mysqli("localhost", "root", "", "belajar_php");

// Insert data
$nama = "Budi Santoso";
$email = "budi@email.com";
$umur = 25;

$sql = "INSERT INTO users (nama, email, umur) VALUES (?, ?, ?)";
$stmt = $conn->prepare($sql);
$stmt->bind_param("ssi", $nama, $email, $umur);

if ($stmt->execute()) {
    echo "Data berhasil ditambahkan! ID: " . $conn->insert_id;
} else {
    echo "Error: " . $stmt->error;
}

$stmt->close();
$conn->close();
?>

<?php
$conn = new mysqli("localhost", "root", "", "belajar_php");

// Select all data
$sql = "SELECT id, nama, email, umur, created_at FROM users ORDER BY created_at DESC";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    echo "<h3>Daftar Users:</h3>";
    echo "<table border='1' style='border-collapse: collapse; width: 100%;'>";
    echo "<tr><th>ID</th><th>Nama</th><th>Email</th><th>Umur</th><th>Tanggal</th></tr>";
    
    while ($row = $result->fetch_assoc()) {
        echo "<tr>";
        echo "<td>" . $row["id"] . "</td>";
        echo "<td>" . $row["nama"] . "</td>";
        echo "<td>" . $row["email"] . "</td>";
        echo "<td>" . $row["umur"] . "</td>";
        echo "<td>" . date("d/m/Y", strtotime($row["created_at"])) . "</td>";
        echo "</tr>";
    }
    echo "</table>";
} else {
    echo "Tidak ada data ditemukan.";
}

$conn->close();
?>