<?php
session_start();
if(!isset($_SESSION[userid]))
{ header("location:form_login.php");
}
elseif(isset($_SESSION[userid]) )
{
?>
<html>
<head>
<title>Tampil Data Mahasiswa</title>
</head>
<body bgcolor="#D9ECFF">
<h2 align="left">Data
Mahasiswa</h2><hr>
<table width="839" height="52"
border="2" cellpadding="2" cellspacing="2">
<tr>
<td>NIM</td>
<td>Nama Mahasiswa</td>
<td>Jenis Kelamin</td>
<td>Tanggal Lahir</td>
<td>Alamat</td>
<td>No Tlp</td>
<td>Action</td>
</tr>
<?php
include "koneksi.php";
$query="SELECT nim, nm_mhs, date_format(tgl_lahir,
'%d %M %Y') AS tgl, jk, alamat, tlp FROM mahasiswa";
$hasil=mysql_query($query);
while($row=mysql_fetch_array($hasil))
{ if($row['jk']=="p")
{ $jk="Pria";
}
else
{ $jk="Wanita";
}
echo "<tr>".
"<td>$row[nim]</td>".
"<td>$row[nm_mhs]</td>".
"<td>$jk</td>".
"<td>$row[tgl]</td>".
"<td>$row[alamat]</td>".
"<td>$row[tlp]</td>".
"<td><a
href='form_update_mahasiswa.php?id=$row[nim]' name='edit'>Edit</a> |
<a href='delete_mahasiswa.php?id=$row[nim]' name='delete'>Delete</a></td>"."</tr>";
}
?>
<tr>
<td colspan="7"
align="right"><a href="form_mahasiswa.php">input
Mahasiswa</a>
</table>
<a href="logout.php">Logout</a>
</body>
</html>
<?php
}
else
{ header("location:form_login.php");
}
?>
<?php
session_start();
if(!isset($_SESSION[userid]))
{ header("location:form_login.php");
}
elseif(isset($_SESSION[userid]) )
{
?>
<html>
<head>
<title>Tampil Data Mahasiswa</title>
</head>
<body bgcolor="#D9ECFF">
<h2 align="left">Data
Mahasiswa</h2><hr>
<table width="839" height="52"
border="2" cellpadding="2" cellspacing="2">
<tr>
<td>NIM</td>
<td>Nama Mahasiswa</td>
<td>Jenis Kelamin</td>
<td>Tanggal Lahir</td>
<td>Alamat</td>
<td>No Tlp</td>
<td>Action</td>
</tr>
<?php
include "koneksi.php";
$query="SELECT nim, nm_mhs, date_format(tgl_lahir,
'%d %M %Y') AS tgl, jk, alamat, tlp FROM mahasiswa";
$hasil=mysql_query($query);
while($row=mysql_fetch_array($hasil))
{ if($row['jk']=="p")
{ $jk="Pria";
}
else
{ $jk="Wanita";
}
echo "<tr>".
"<td>$row[nim]</td>".
"<td>$row[nm_mhs]</td>".
"<td>$jk</td>".
"<td>$row[tgl]</td>".
"<td>$row[alamat]</td>".
"<td>$row[tlp]</td>".
"<td><a
href='form_update_mahasiswa.php?id=$row[nim]' name='edit'>Edit</a> |
<a href='delete_mahasiswa.php?id=$row[nim]' name='delete'>Delete</a></td>"."</tr>";
}
?>
<tr>
<td colspan="7"
align="right"><a href="form_mahasiswa.php">input
Mahasiswa</a>
</table>
<a href="logout.php">Logout</a>
</body>
</html>
<?php
}
else
{ header("location:form_login.php");
}
?>
Tidak ada komentar:
Posting Komentar