41 lines
1.0 KiB
PHP
41 lines
1.0 KiB
PHP
<?php include 'koneksi.php'; ?>
|
|
<!DOCTYPE html>
|
|
<html>
|
|
|
|
<head>
|
|
<title>Jadwal Kuliah</title>
|
|
</head>
|
|
|
|
<body>
|
|
<h2>Data Jadwal Kuliah</h2>
|
|
<a href="tambah.php">Tambah Jadwal</a>
|
|
<table border="1" cellpadding="8">
|
|
<tr>
|
|
<th>NID</th>
|
|
<th>Nama Dosen</th>
|
|
<th>Kode MK</th>
|
|
<th>Nama MK</th>
|
|
<th>Kode Kelas</th>
|
|
<th>Nama Kelas</th>
|
|
<th>Hari</th>
|
|
<th>Jam</th>
|
|
</tr>
|
|
<?php
|
|
$result = $conn->query("SELECT * FROM jadwal_kuliah ORDER BY hari, jam");
|
|
while ($row = $result->fetch_assoc()) {
|
|
echo "<tr>
|
|
<td>{$row['nid']}</td>
|
|
<td>{$row['nama_dosen']}</td>
|
|
<td>{$row['kode_mk']}</td>
|
|
<td>{$row['nama_mk']}</td>
|
|
<td>{$row['kode_kelas']}</td>
|
|
<td>{$row['nama_kelas']}</td>
|
|
<td>{$row['hari']}</td>
|
|
<td>{$row['jam']}</td>
|
|
</tr>";
|
|
}
|
|
?>
|
|
</table>
|
|
</body>
|
|
|
|
</html>
|