<html>
<head>
<title>Tampil Data Member</title>
<style type = "text/CSS">
table { border: 1px solid #C0C0C0;}
td { border: 1px solid #C0C0C0;}
</style>
</head>
<body>
<table width="600">
<tr bgcolor="#AA0CCC">
<td colspan="8"><b><p align="center">DAFTAR MEMBER</p></b></td>
</tr>
<tr bgcolor="#33F99F">
<td align="center" width="200"><b>NPM</b></td>
<td align="center" width="200"><b>Nama</b></td>
<td align="center" width="200"><b>Tempat Lahir</b></td>
<td align="center" width="150"><b>tgl lahir</b></td>
<td align="center" width="200"><b>Alamat</b></td>
</tr>
<?php
$koneksi=mysql_connect("localhost", "root", "")
or die ("Gagal konek server".mysql_error());
mysql_select_db("dbsiswa",$koneksi)
or die ("Database gagal dibuka".mysql_error());
$sql = "SELECT * FROM mahasiswa ";
$qry = mysql_query($sql, $koneksi)
or die ("Query Gagal ".mysql_error());
while($data=mysql_fetch_array($qry)){
?>
<tr>
<td><?php echo $data['npm']; ?></td>
<td><?php echo $data['nama']; ?></td>
<td align="center"><?php echo $data['tempat_lahir']; ?></td>
<td align="center"><?php echo $data['tgl_lahir']; ?></td>
<td><?php echo $data['alamat']; ?></td>
</tr>
<?php } ?>
</table>
<a href="index.php">Masukkan Data Baru</a>
</body>
</html>
Asmaul Husna
Langganan
Postingan
Komentar
0 komentar:
Posting Komentar