program menampilkan data menggunakan PHP

Masih menggunakan data yang telah kita input pada contoh program input data yang telah kita buat.


view.php
<?
//masukkan perintah koneksi yang
//ada di file koneksi.inc.php
include "koneksi.php";
$query = "SELECT * FROM pegawai2";
$result = mysql_query($query) or die('Error');

    $duplicates = mysql_num_rows($result);
    if ($duplicates < 1)
    {   
    echo "Data di tabel masih kosong <a href='input.php'>KLIK</a> disini untuk Input Data baru...";
    }
   
$warnaGenap = "#CCFFFF";   // warna abu-abu
$warnaGanjil = "#FFFFCC";  // warna putih
$warnaHeading = "#FF9900"; // warna merah untuk heading tabel

?>

<h2>Daftar Pegawai</h2>
<table width="100%" border="0" align="center" bordercolor="#FFFFFF">
  <tr bgcolor=<? echo "$warnaHeading" ?> valign="middle">
    <th width="2%" height="35" align="center" valign="middle">No</th>
    <th width="5%" align="center" valign="middle">NIP</th>
    <th width="26%" align="center" valign="middle">Nama Pegawai</th>
    <th width="25%" align="center" valign="middle">Alamat Lengkap</th>
    <th width="2%" align="center" valign="middle">JK</th>   
    <th width="5%" align="center" valign="middle">Aksi</th>
  </tr>
<?
$counter = 1;
$no=0;
while($data = mysql_fetch_row($result))
{
if ($counter % 2 == 0) $warna = $warnaGenap;
else $warna = $warnaGanjil;
$no++
?>
  <tr bgcolor=<? echo "$warna" ?>>
    <td align="center" valign="middle"><? echo "$no"; ?></td>
    <td align="center" valign="middle"><? echo "$data[1]"; ?></td>
    <td align="left" valign="middle"><? echo "$data[2]"; ?></td>
    <td align="left" valign="middle"><? echo "$data[3]"; ?></td>
    <td align="left" valign="middle"><? echo "$data[4]"; ?></td>
    <td align="center" valign="middle">
    <a href="input.php"><img src="add.png" width="20" height="20" border="0" /></a>&nbsp;&nbsp;
    <a href="edit1.php?id=<? echo "$data[0]"; ?>"><img src="edit.png" width="20" height="20" border="0" /></a>&nbsp;&nbsp;
    <a href="lat_delet.php?id=<? echo "$data[0]"; ?>"><img src="del.png" width="20" height="20" border="0" /></a>
    </td>
  </tr>
<?
$counter++; // menambah counter
} //end while

echo "</table><br><br>";
?>

hasil program :