Membuat Modul Delete data.
delete.php
<?php include 'koneksi.php'; $mhs_id = $_GET['id']; $sql = "DELETE FROM mahasiswa WHERE mhs_id = '$mhs_id' "; $query = mysqli_query($koneksi, $sql); if (!$query) { die('Query gagal : '.mysqli_error($koneksi)); }else{ header('location: index.php'); } ?>
tambah_save.php
<?php include 'koneksi.php'; $npm = $_POST['mhs_npm']; $nama = $_POST['mhs_nama']; $jk = $_POST['mhs_jk']; $jurusan = $_POST['mhs_jurusan']; $SQL = "INSERT INTO mahasiswa (mhs_npm, mhs_nama, mhs_jk, mhs_jurusan) VALUES ('$npm','$nama','$jk','$jurusan') "; $query = mysqli_query($koneksi, $SQL); if(!$query) { die('Query Gagal : '.mysqli_error($koneksi)); }else{ header('location: index.php'); } ?>
File : form_tambah.php
<form action="tambah_save.php" method="POST"> <h3>Tambah Mahasiswa</h3> <p>NPM : <input type="text" name="mhs_npm" required> </p> <p>Nama :<input type="text" name="mhs_nama" required></p> <p>Jenis Kelamin : <select name="mhs_jk" required> <option value="">--Pilih kelamin--</option> <option value="LK">LAKI-LAKI</option> <option value="PR">PEREMPUAN</option> </select> </p> <p>Jurusan : <input type="text" name="mhs_jurusan" required></p> <button type="submit" name="simpan">SIMPAN</button> </form>
CONTOH FILE KONEKSI. PHP
<?php $host = "localhost"; $user = "root"; $pass = ""; $database = "test"; $koneksi = mysqli_connect($host, $user, $pass, $database); if(!$koneksi){ die('Koneksi Gagal '.mysqli_error($koneksi)); } ?>
index.php
DATA MAHASISWA
Desain Database :
Script tabel Mahasiswa :
CREATE TABLE `mahasiswa` ( `mhs_id` int(11) NOT NULL, `mhs_npm` varchar(15) NOT NULL, `mhs_nama` varchar(50) NOT NULL, `mhs_jk` char(2) NOT NULL, `mhs_jurusan` varchar(50) NOT NULL, `mhs_foto_1` varchar(200) DEFAULT NULL, `mhs_foto_2` blob DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; ALTER TABLE `mahasiswa` ADD PRIMARY KEY (`mhs_id`); ALTER TABLE `mahasiswa` MODIFY `mhs_id` int(11) NOT NULL AUTO_INCREMENT; COMMIT;