//TAMPIL PEGAWAIII
<!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>Untitled Document</title>
</head>
<body>
<?php
$host="localhost";
$user="root";
$pass="";
//koneksi kedatabase server
$konekds=mysql_select_db($db,$user,$pass) or die
("koneksi ke database server gagal");
$db="dbtoko";
//koneksi ke database dbtoko
$konekdb=mysql_select_db($db,$konekds) or die
("koneksi ke database server gagal");
//buat perintah sql untuk menampilkan data pegawai
$sql="select * from tblpegawai";
//eksekusi perintah sql
$hasil=mysql_query($db,$konekds) or die
("koneksi ke database server gagal");
//uji apakah da record di tabel pegawai
if (mysql_num_rows($hasil)<1)
{
die("tabel pegawai masih kosong");
}
//tampilkan rekord pegwai dalam format table
echo "<table align = center>";
echo
"<tr><td>kode</td><td>nama</td><td>alamat</td><td>tempat
lahir</td>";
echo "<td>tanggal
lahir</td><td>agama</td><td>jenis
kelamin</td><td>telepon</td>";
echo "<td></td></tr>";
while ($baris=mysql_fetch_row($hasi))
{
echo
"<tr><td>$baris[0]</td><td>$baris[0]</td><td>$baris[0]</td><td>$baris[0]</td>";
echo
"<td>$baris[0]</td><td>$baris[0]</td><td>$baris[0]</td><td>$baris[0]</td>";
echo "<a
href=editpegawai.php"?kodepegawai=$baris[0]>edit</a>
echo "<a href=hapuspegawai.php"?kodepegawai=$baris[0]>hapus</a></tr>;
}
echo "</table>";
?>
</body>
</html>
0 comments:
Post a Comment