Membuat Aplikasi Database Sederhana - Riwayat revisi

Robie pada 14 November 2024 07.34

2024-11-14T07:34:52Z

← Revisi sebelumnya		Revisi per 14 November 2024 07.34
Baris 567:		Baris 567:
	('Oki Satria', 'XII TKJ 3', '081234567804', 'OSIS, Paskibra', 'Ketua', '2021/2022');		('Oki Satria', 'XII TKJ 3', '081234567804', 'OSIS, Paskibra', 'Ketua', '2021/2022');
	lalu tekan enter		lalu tekan enter


			Jika sudah sampai tahap ini silakan akses '''ip_address_ct/aplikasi'''

Robie: /* Siapkan Database */

2024-11-14T07:08:29Z

Siapkan Database

← Revisi sebelumnya		Revisi per 14 November 2024 07.08
Baris 15:		Baris 15:
	=Siapkan Database=		=Siapkan Database=
	masuk ke mariadb		masuk ke mariadb

	lalu ketikkan perintah berikut		lalu ketikkan perintah berikut

			mariadb (enter)
	CREATE DATABASE organisasi_siswa;		CREATE DATABASE organisasi_siswa;
	CREATE USER 'siswa'@'localhost' IDENTIFIED BY '12345';		CREATE USER 'siswa'@'localhost' IDENTIFIED BY '12345';

Robie: /* Download file css dan js */

2024-11-12T07:38:46Z

Download file css dan js

← Revisi sebelumnya		Revisi per 12 November 2024 07.38
Baris 535:		Baris 535:
	download file css js dengan mengetikkan perintah		download file css js dengan mengetikkan perintah

	wget https://cdn.jsdelivr.net/npm/bootstrap@4.6.2/dist/css/bootstrap.min.css enter		<code>wget https://cdn.jsdelivr.net/npm/bootstrap@4.6.2/dist/css/bootstrap.min.css</code> enter

	file js		file js

	wget https://cdn.jsdelivr.net/npm/jquery@3.5.1/dist/jquery.slim.min.js enter		<code>wget https://cdn.jsdelivr.net/npm/jquery@3.5.1/dist/jquery.slim.min.js</code> enter

	wget https://cdn.jsdelivr.net/npm/bootstrap@4.6.2/dist/js/bootstrap.bundle.min.js enter		<code>wget https://cdn.jsdelivr.net/npm/bootstrap@4.6.2/dist/js/bootstrap.bundle.min.js</code> enter

	= Menambahkan Data baru ke Database =		= Menambahkan Data baru ke Database =

Robie: /* Buat file tambah.php */

2024-11-12T07:38:13Z

Buat file tambah.php

← Revisi sebelumnya		Revisi per 12 November 2024 07.38
Baris 125:		Baris 125:


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

	</head>		</head>
Baris 249:		Baris 249:
	<nowiki></div></nowiki>		<nowiki></div></nowiki>

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

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

	</body>		</body>
Baris 306:		Baris 306:
	<title>Tambah Data Siswa</title>		<title>Tambah Data Siswa</title>

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

	</head>		</head>
Baris 374:		Baris 374:
	<nowiki></div></nowiki>		<nowiki></div></nowiki>

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

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

	</body>		</body>
Baris 442:		Baris 442:
	<code> <title>Edit Data Siswa</title></code>		<code> <title>Edit Data Siswa</title></code>

	<code> <link rel="stylesheet" href="~~https://cdn.jsdelivr.net/npm/bootstrap@4.6.2/dist/css/~~bootstrap.min.css~~" integrity="sha384-xOolHFLEh07PJGoPkLv1IbcEPTNtaed2xpHsD9ESMhqIYd0nLMwNLD69Npy4HI+N" crossorigin="anonymous~~"></code>		<code> <link rel="stylesheet" href="bootstrap.min.css"></code>

	<code></head></code>		<code></head></code>
Baris 510:		Baris 510:
	<code><nowiki></div></nowiki></code>		<code><nowiki></div></nowiki></code>

	<code><script src="~~https://cdn.jsdelivr.net/npm/jquery@3.5.1/dist/~~jquery.slim.min.js~~" integrity="sha384-DfXdz2htPH0lsSSs5nCTpuj/zy4C+OGpamoFVy38MVBnE+IbbVYUew+OrCXaRkfj" crossorigin="anonymous~~"></script></code>		<code><script src="jquery.slim.min.js"></script></code>

	<code><script src="~~https://cdn.jsdelivr.net/npm/bootstrap@4.6.2/dist/js/~~bootstrap.bundle.min.js~~" integrity="sha384-Fy6S3B9q64WdZWQUiU+q4/2Lc9npb8tCaSX9FK7E8HnRr0Jz8D6OP9dO5Vg3Q9ct" crossorigin="anonymous~~"></script></code>		<code><script src="bootstrap.bundle.min.js"></script></code>

	<code></body></code>		<code></body></code>
Baris 529:		Baris 529:
	header("Location: index.php");		header("Location: index.php");
	?>		?>

			= Download file css dan js =
			masih di folder xitkj1.web1

			download file css js dengan mengetikkan perintah

			wget https://cdn.jsdelivr.net/npm/bootstrap@4.6.2/dist/css/bootstrap.min.css enter

			file js

			wget https://cdn.jsdelivr.net/npm/jquery@3.5.1/dist/jquery.slim.min.js enter

			wget https://cdn.jsdelivr.net/npm/bootstrap@4.6.2/dist/js/bootstrap.bundle.min.js enter

	= Menambahkan Data baru ke Database =		= Menambahkan Data baru ke Database =

Robie: /* Buat file hapus.php */

2024-11-12T07:19:43Z

Buat file hapus.php

← Revisi sebelumnya		Revisi per 12 November 2024 07.19
Baris 246:		Baris 246:

	</nav>		</nav>

			<nowiki></div></nowiki>

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

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

			</body>

			</html>

			= Buat file tambah.php =
			<?php

			include 'config.php';

			// Jika form disubmit, tambahkan data siswa baru

			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'];

			// Insert data siswa baru

			$stmt = $pdo->prepare("INSERT INTO siswa (nama, kelas, no_hp, riwayat_organisasi, jabatan, tahun_ajaran) VALUES (?, ?, ?, ?, ?, ?)");

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

			// Redirect ke halaman utama setelah penambahan

			header("Location: index.php");

			exit();

			}

			?>

			<!DOCTYPE html>

			<html lang="id">

			<head>

			<meta charset="UTF-8">

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

			<title>Tambah Data Siswa</title>

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

			</head>

			<body>

			<nowiki><div class="container mt-5"></nowiki>

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

			<form method="POST">

			<nowiki><div class="mb-3"></nowiki>

			<label>Nama</label>

			<input type="text" name="nama" class="form-control" required>

			<nowiki></div></nowiki>

			<nowiki><div class="mb-3"></nowiki>

			<label>Kelas</label>

			<input type="text" name="kelas" class="form-control" required>

			<nowiki></div></nowiki>

			<nowiki><div class="mb-3"></nowiki>

			<label>No HP</label>

			<input type="text" name="no_hp" class="form-control" required>

			<nowiki></div></nowiki>

			<nowiki><div class="mb-3"></nowiki>

			<label>Riwayat Organisasi</label>

			<textarea name="riwayat_organisasi" class="form-control" required></textarea>

			<nowiki></div></nowiki>

			<nowiki><div class="mb-3"></nowiki>

			<label>Jabatan</label>

			<input type="text" name="jabatan" class="form-control" required>

			<nowiki></div></nowiki>

			<nowiki><div class="mb-3"></nowiki>

			<label>Tahun Ajaran</label>

			<input type="text" name="tahun_ajaran" class="form-control" required>

			<nowiki></div></nowiki>

			<button type="submit" class="btn btn-primary">Tambah Siswa</button>

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

			</form>

	<nowiki></div></nowiki>		<nowiki></div></nowiki>

Robie: /* Menambahkan Data baru ke Database */

2024-11-12T07:09:49Z

Menambahkan Data baru ke Database

← Revisi sebelumnya		Revisi per 12 November 2024 07.09
Baris 406:		Baris 406:

	= Menambahkan Data baru ke Database =		= Menambahkan Data baru ke Database =
	masuk ke mariadb lalu ketikkan perintah berikut		masuk ke mariadb lalu isi data ke dalam tabel siswa dengan ketikkan perintah berikut

	USE organisasi_siswa;		USE organisasi_siswa;

Robie pada 12 November 2024 07.05

2024-11-12T07:05:23Z

← Revisi sebelumnya		Revisi per 12 November 2024 07.05
Baris 1:		Baris 1:
	Sebelum memulai pastikan apache2, mariadb, dan php, dan virtualhost sudah terinstall dengan baik		Sebelum memulai pastikan

			apache2 <code>apt install apache2</code>

			mariadb <code>apt install mariadb-server</code>

			dns server <code>apt install bind9</code>

			dan

			php <code>apt install php php-{fpm,common,mbstring,xmlrpc,soap,gd,xml,intl,mysql,cli,mcrypt,ldap,zip,curl} -y</code>

			, dan virtualhost sudah terinstall dengan baik

	=Siapkan Database=		=Siapkan Database=

Robie pada 12 November 2024 06.40

2024-11-12T06:40:53Z

← Revisi sebelumnya		Revisi per 12 November 2024 06.40
Baris 1:		Baris 1:
	Sebelum memulai pastikan apache2, mariadb, dan php sudah terinstall dengan baik		Sebelum memulai pastikan apache2, mariadb, dan php, dan virtualhost sudah terinstall dengan baik


	=Siapkan Database=		=Siapkan Database=
Baris 19:		Baris 18:
	tahun_ajaran VARCHAR(9) NOT NULL		tahun_ajaran VARCHAR(9) NOT NULL
	);		);
	masuk ke folder var/www/html lalu,		masuk ke folder var/www/html/xitkj1.web1 lalu,

	=Buaf file config.php=		=Buaf file config.php=

Robie: /* Menambahkan Data baru ke Database */

2024-11-12T03:52:47Z

Menambahkan Data baru ke Database

Robie: /* Siapkan Database */

2024-11-12T03:49:08Z

Siapkan Database

← Revisi sebelumnya		Revisi per 12 November 2024 03.49
Baris 13:		Baris 13:
	id INT AUTO_INCREMENT PRIMARY KEY,		id INT AUTO_INCREMENT PRIMARY KEY,
	nama VARCHAR(100) NOT NULL,		nama VARCHAR(100) NOT NULL,
	kelas VARCHAR(15) NOT NULL,		kelas VARCHAR(25) NOT NULL,
	no_hp VARCHAR(15) NOT NULL,		no_hp VARCHAR(15) NOT NULL,
	riwayat_organisasi TEXT NOT NULL,		riwayat_organisasi TEXT NOT NULL,

← Revisi sebelumnya		Revisi per 12 November 2024 03.52
Baris 400:		Baris 400:

	INSERT INTO siswa (nama, kelas, no_hp, riwayat_organisasi, jabatan, tahun_ajaran) VALUES		INSERT INTO siswa (nama, kelas, no_hp, riwayat_organisasi, jabatan, tahun_ajaran) VALUES
	('Andi Pratama', '~~10 IPA~~ 1', '081234567890', 'OSIS, Pramuka', 'Ketua', '2023/2024'),		('Andi Pratama', 'X TKJ 1', '081234567890', 'OSIS, Pramuka', 'Ketua', '2023/2024'),
	('Budi Santoso', '~~11 IPA~~ 2', '081234567891', 'Basket, OSIS', 'Anggota', '2022/2023'),		('Budi Santoso', 'XI TKJ 2', '081234567891', 'Basket, OSIS', 'Anggota', '2022/2023'),
	('Citra Dewi', '~~12 IPS~~ 1', '081234567892', 'Paskibra, OSIS', 'Wakil Ketua', '2021/2022'),		('Citra Dewi', 'XII TKJ 1', '081234567892', 'Paskibra, OSIS', 'Wakil Ketua', '2021/2022'),
	('Dewi Sartika', '~~10 IPS~~ 2', '081234567893', 'Pramuka', 'Anggota', '2023/2024'),		('Dewi Sartika', 'X TKR 2', '081234567893', 'Pramuka', 'Anggota', '2023/2024'),
	('Eko Wibowo', '~~11 IPA~~ 1', '081234567894', 'Basket, OSIS', 'Sekretaris', '2022/2023'),		('Eko Wibowo', 'XI TBO 1', '081234567894', 'Basket, OSIS', 'Sekretaris', '2022/2023'),
	('Fitri Nurjanah', '~~12 IPA~~ 2', '081234567895', 'Karate, OSIS', 'Anggota', '2021/2022'),		('Fitri Nurjanah', 'XII TPL 2', '081234567895', 'Karate, OSIS', 'Anggota', '2021/2022'),
	('Gilang Saputra', '~~10 IPA~~ 3', '081234567896', 'Karate, Pramuka', 'Ketua', '2023/2024'),		('Gilang Saputra', 'X TPL 3', '081234567896', 'Karate, Pramuka', 'Ketua', '2023/2024'),
	('Hana Pertiwi', '~~11 IPS~~ 1', '081234567897', 'Paskibra, OSIS', 'Bendahara', '2022/2023'),		('Hana Pertiwi', 'XI TPL 1', '081234567897', 'Paskibra, OSIS', 'Bendahara', '2022/2023'),
	('Irfan Maulana', '~~12 IPA~~ 1', '081234567898', 'Basket, OSIS', 'Anggota', '2021/2022'),		('Irfan Maulana', 'XII APAT 1', '081234567898', 'Basket, OSIS', 'Anggota', '2021/2022'),
	('Joko Sugiarto', '~~10 IPS~~ 3', '081234567899', 'Karate', 'Anggota', '2023/2024'),		('Joko Sugiarto', 'X PROFI 3', '081234567899', 'Karate', 'Anggota', '2023/2024'),
	('Kartika Dewi', '~~11 IPA~~ 3', '081234567800', 'Paskibra, OSIS', 'Sekretaris', '2022/2023'),		('Kartika Dewi', 'XI PROFI 3', '081234567800', 'Paskibra, OSIS', 'Sekretaris', '2022/2023'),
	('Lina Suharti', '~~12 IPS~~ 2', '081234567801', 'Pramuka, OSIS', 'Bendahara', '2021/2022'),		('Lina Suharti', 'XII TPL 2', '081234567801', 'Pramuka, OSIS', 'Bendahara', '2021/2022'),
	('Maman Firmansyah', '~~10 IPA~~ 2', '081234567802', 'Basket', 'Anggota', '2023/2024'),		('Maman Firmansyah', 'X TKR 2', '081234567802', 'Basket', 'Anggota', '2023/2024'),
	('Nina Kusuma', '~~11 IPS~~ 2', '081234567803', 'Pramuka, Karate', 'Wakil Ketua', '2022/2023'),		('Nina Kusuma', 'XI TBO 2', '081234567803', 'Pramuka, Karate', 'Wakil Ketua', '2022/2023'),
	('Oki Satria', '~~12 IPA~~ 3', '081234567804', 'OSIS, Paskibra', 'Ketua', '2021/2022');		('Oki Satria', 'XII TKJ 3', '081234567804', 'OSIS, Paskibra', 'Ketua', '2021/2022');
	lalu tekan enter		lalu tekan enter