kalo yg ni gan script buat menampilkan data dari database
<?php
<?php
include ("config.php");
$sql = "SELECT * FROM mhs order by id desc";
$hasil = mysql_query($sql);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Halaman Penampilan Data</title>
</head>
<body>
<table width="772" border="1" align="center" cellpadding="1" cellspacing="0">
<tr>
<td width="31">No</td>
<td width="109">Nim</td>
<td width="142">Nama</td>
<td width="89">Jenis Kelamin</td>
<td width="91">Jurusan</td>
<td width="172">Tempat Lahir </td>
<td width="122">Tgl Lahir </td>
</tr>
<?php
$no=1;
$counter=1;
while ($row =mysql_fetch_array($hasil))
{
?>
<tr>
<td><?php echo $no ?></td>
<td><?php echo $row ['nim']?></td>
<td><?php echo $row ['nama']?></td>
<td><?php echo $row ['jkl']?> </td>
<td><?php echo $row ['jurusan']?></td>
<td><?php echo $row ['tmpt_lahir']?></td>
<td><?php echo $row ['tgl_lahir']?> <?php echo $row ['bln_lahir']?> <?php echo $row ['thn_lahir']?></td>
</tr>
<?php
$no++;
$counter++;
}
?>
</table>
</body>
</html>
Gambar Tampilan Halaman view.php
Tidak ada komentar:
Posting Komentar