Revisi per 7 November 2024 07.14

Sebelum memulai pastikan apache2, mariadb, dan php sudah terinstall dengan baik

Siapkan Database

masuk ke mariadb lalu ketikkan perintah berikut

CREATE DATABASE organisasi_siswa;
CREATE USER 'siswa'@'localhost' IDENTIFIED BY '12345';
GRANT ALL PRIVILEGES ON organisasi_siswa.* TO 'siswa'@'localhost';
USE organisasi_siswa;
CREATE TABLE siswa (
    id INT AUTO_INCREMENT PRIMARY KEY,
    nama VARCHAR(100) NOT NULL,
    kelas VARCHAR(15) NOT NULL,
    no_hp VARCHAR(15) NOT NULL,
    riwayat_organisasi TEXT NOT NULL,
    jabatan VARCHAR(50) NOT NULL,
    tahun_ajaran VARCHAR(9) NOT NULL
);

Buaf file config.php

isi dengan kode berikut

<?php
// config.php
$host = 'localhost';
$dbname = 'organisasi_siswa';
$username = 'siswa'; // sesuaikan dengan username MariaDB Anda
$password = '12345';     // sesuaikan dengan password MariaDB Anda

try {
    $pdo = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
    die("Koneksi gagal: " . $e->getMessage());
}
?>

Buat file index.php

<?php

include 'config.php';

// Mendapatkan kata kunci dari form pencarian jika ada

$search = isset($_GET['search']) ? $_GET['search'] : '';

// Tentukan berapa banyak data yang ditampilkan per halaman

$limit = 5;

// Dapatkan halaman saat ini dari URL, jika tidak ada, default ke 1

$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;

$offset = ($page - 1) * $limit;

// Query untuk menghitung total data

$totalQuery = $pdo->query("SELECT COUNT(*) FROM siswa" . ($search ? " WHERE nama LIKE '%$search%' OR kelas LIKE '%$search%'" : ""));

$totalData = $totalQuery->fetchColumn();

$totalPages = ceil($totalData / $limit);

// Query untuk mengambil data siswa dengan paginasi

if ($search) {

$query = $pdo->prepare("SELECT * FROM siswa WHERE nama LIKE ? OR kelas LIKE ? LIMIT :limit OFFSET :offset");

$query->bindValue(1, "%$search%");

$query->bindValue(2, "%$search%");

$query->bindValue(':limit', $limit, PDO::PARAM_INT);

$query->bindValue(':offset', $offset, PDO::PARAM_INT);

$query->execute();

} else {

$query = $pdo->prepare("SELECT * FROM siswa LIMIT :limit OFFSET :offset");

$query->bindValue(':limit', $limit, PDO::PARAM_INT);

$query->bindValue(':offset', $offset, PDO::PARAM_INT);

$query->execute();

}

$siswa = $query->fetchAll(PDO::FETCH_ASSOC);

?>

<!DOCTYPE html>

<head>

<title>Data Siswa Organisasi</title>

</head>

<body>

<h2 class="mb-4">Data Siswa Organisasi</h2>

<?php if (isset($_GET['success']) && $_GET['success'] == 1): ?>

alert("Data berhasil ditambahkan!");

</script>

<?php endif; ?>

<a href="index.php" class="btn btn-secondary ms-2">Reset</a>

</form>

<a href="tambah.php" class="btn btn-primary mb-3">Tambah Siswa</a>

<thead>

<tr>

<th>Kelas</th>

<th>Riwayat Organisasi</th>

<th>Jabatan</th>

<th>Tahun Ajaran</th>

</tr>

</thead>

<tbody>

<?php foreach ($siswa as $row): ?>

<tr>

<td>

<a href="edit.php?id=<?= $row['id']; ?>" class="btn btn-warning btn-sm">Edit</a>

<a href="hapus.php?id=<?= $row['id']; ?>" class="btn btn-danger btn-sm" onclick="return confirm('Yakin ingin menghapus data?');">Hapus</a>

</td>

</tr>

<?php endforeach; ?>

</tbody>

</table>

<nav>

<?php for ($i = 1; $i <= $totalPages; $i++): ?>

<a class="page-link" href="?page=<?= $i; ?>&search=<?= urlencode($search); ?>"><?= $i; ?></a>

</li>

<?php endfor; ?>

</ul>

</nav>

</div>

</body>

</html>

Buat file edit.php

<?php

include 'config.php';

// Ambil ID dari URL

$id = $_GET['id'];

// Ambil data siswa dari database

$stmt = $pdo->prepare("SELECT * FROM siswa WHERE id = ?");

$stmt->execute([$id]);

$siswa = $stmt->fetch();

// Jika form disubmit, update data siswa

if ($_SERVER['REQUEST_METHOD'] == 'POST') {

$nama = $_POST['nama'];

$kelas = $_POST['kelas'];

$no_hp = $_POST['no_hp'];

$riwayat_organisasi = $_POST['riwayat_organisasi'];

$jabatan = $_POST['jabatan'];

$tahun_ajaran = $_POST['tahun_ajaran'];

// Update data siswa

$stmt = $pdo->prepare("UPDATE siswa SET nama = ?, kelas = ?, no_hp = ?, riwayat_organisasi = ?, jabatan = ?, tahun_ajaran = ? WHERE id = ?");

$stmt->execute([$nama, $kelas, $no_hp, $riwayat_organisasi, $jabatan, $tahun_ajaran, $id]);

// Redirect ke halaman utama setelah update

header("Location: index.php");

}

?>

<!DOCTYPE html>

<html lang="id">

<head>

<meta charset="UTF-8">

<meta name="viewport" content="width=device-width, initial-scale=1.0">

<title>Edit Data Siswa</title>

<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/bootstrap.min.css" integrity="sha384-xOolHFLEh07PJGoPkLv1IbcEPTNtaed2xpHsD9ESMhqIYd0nLMwNLD69Npy4HI+N" crossorigin="anonymous">

</head>

<body>

<div class="container mt-5">

<h2 class="mb-4">Edit Data Siswa</h2>

<form method="POST">

<div class="mb-3">

<label>Nama</label>

<input type="text" name="nama" class="form-control" value="<?= htmlspecialchars($siswa['nama']); ?>" required>

</div>

<div class="mb-3">

<label>Kelas</label>

<input type="text" name="kelas" class="form-control" value="<?= htmlspecialchars($siswa['kelas']); ?>" required>

</div>

<div class="mb-3">

<label>No HP</label>

<input type="text" name="no_hp" class="form-control" value="<?= htmlspecialchars($siswa['no_hp']); ?>" required>

</div>

<div class="mb-3">

<label>Riwayat Organisasi</label>

<textarea name="riwayat_organisasi" class="form-control" required><?=htmlspecialchars($siswa['riwayat_organisasi']); ?></textarea>

</div>

<div class="mb-3">

<label>Jabatan</label>

<input type="text" name="jabatan" class="form-control" value="<?= htmlspecialchars($siswa['jabatan']); ?>" required>

</div>

<div class="mb-3">

<label>Tahun Ajaran</label>

<input type="text" name="tahun_ajaran" class="form-control" value="<?= htmlspecialchars($siswa['tahun_ajaran']); ?>" required>

</div>

<button type="submit" class="btn btn-primary">Simpan Perubahan</button>

<a href="index.php" class="btn btn-secondary">Batal</a>

</form>

</div>

<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/jquery.slim.min.js" integrity="sha384-DfXdz2htPH0lsSSs5nCTpuj/zy4C+OGpamoFVy38MVBnE+IbbVYUew+OrCXaRkfj" crossorigin="anonymous"></script>

<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/js/bootstrap.bundle.min.js" integrity="sha384-Fy6S3B9q64WdZWQUiU+q4/2Lc9npb8tCaSX9FK7E8HnRr0Jz8D6OP9dO5Vg3Q9ct" crossorigin="anonymous"></script>

</body>

</html>

Buat file hapus.php

<?php
include 'config.php';

$id = $_GET['id'];
$stmt = $pdo->prepare("DELETE FROM siswa WHERE id = ?");
$stmt->execute([$id]);

header("Location: index.php");
?>

Membuat Aplikasi Database Sederhana: Perbedaan antara revisi

Revisi per 7 November 2024 07.14

Daftar isi

Siapkan Database

Buaf file config.php

Buat file index.php

Buat file edit.php

Buat file hapus.php

Menu navigasi

Membuat Aplikasi Database Sederhana: Perbedaan antara revisi

Revisi per 7 November 2024 07.14

Siapkan Database

Buaf file config.php

Buat file index.php

Buat file edit.php

Buat file hapus.php

Menu navigasi

Pencarian