Pemrograman Web : CRUD PHP MySQLi #Part 1

Posted on by

index.php 

DATA MAHASISWA

tabel Data mahasiswa

Desain Database :

Screen Shot 2019-12-05 at 10.35.53 PM

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;


Berikut Kode php halaman index.php

<?php
include 'koneksi.php';
?>
<!DOCTYPE html>
<html>
<head>
<title>DATA MAHASISWA</title>
</head>
<body>
<h3>Data Mahasiswa</h3>
<a href="form_tambah.php"> + Tambah Data</a> <p></p>
<table border="1" width="100%" cellpadding="3" cellspacing="0">
<tr>
<th>No</th>
<th>NPM</th>
<th>Nama Mahasiswa</th>
<th>J.Kelamin</th>
<th>Jurusan</th>
<th>Aksi</th>
</tr>
<?php
$sql = "SELECT * FROM mahasiswa";
$query = mysqli_query($koneksi, $sql);
if(!$query){
die('Error : '.mysqli_error($koneksi));
}
$n=1; while ($data = mysqli_fetch_array($query)) { ?>
<tr>
<td><?php echo $n++; ?></td>
<td><?php echo $data['mhs_npm']; ?></td>
<td><?php echo $data['mhs_nama']; ?></td>
<td><?php echo $data['mhs_jk']; ?></td>
<td><?php echo $data['mhs_jurusan']; ?></td>
<td>
<a href="#">edit</a> | <a href="delete.php?id=<?php echo $data['mhs_id']; ?>">delete</a>
</td>
</tr>
<?php } ?>
</table>
</body>
</html>