data-siswa

    <?php
    include_once "library/inc.sesadmin.php";
    include_once "library/inc.library.php";
    $folder = "upload/";
    # UNTUK PAGING (PEMBAGIAN HALAMAN)
    $row = 20;
    $hal = isset($_GET['hal']) ? $_GET['hal'] : 0;
    $pageSql = "SELECT * FROM siswa";
    $pageQry = mysql_query($pageSql, $koneksidb) or die ("error paging: ".mysql_error());
    $jml     = mysql_num_rows($pageQry);
    $max     = ceil($jml/$row);
    ?>
    <table width="700" border="0" cellpadding="2" cellspacing="1" class="table-border">
      <tr>
        <td colspan="2" align="right"><h1><b>DATA SISWA </b></h1></td>
      </tr>
      <tr>
        <td colspan="2"><a href="?page=Add-Siswa" target="_self"><img src="images/btn_add_data2.png" height="25" border="0" /></a></td>
      </tr>
      <tr>
        <td colspan="2">&nbsp;</td>
      </tr>
      <tr>
        <td colspan="2">
            <table class="table-list" width="100%" border="0" cellspacing="1" cellpadding="2">
          <tr>
            <th width="26" align="center"><b>No</b></th>
            <th width="224"><b>NISN </b></th>
                    <th width="224"><b>Kode Komp</b></th>
                    <th width="224"><b>Nama</b></th>
            <th width="320"><b>Alamat</b></th>
                     <th width="50"><b>Foto</b></th>
            <td width="49" align="center" bgcolor="#CCCCCC"><b>Edit</b></td>
            <td width="49" align="center" bgcolor="#CCCCCC"><b>Delete</b></td>
          </tr>
          <?php
            $dataSql = "SELECT * FROM siswa ORDER BY NISN ASC LIMIT $hal, $row";
            $dataQry = mysql_query($dataSql, $koneksidb)  or die ("Query siswa salah : ".mysql_error());
            $nomor  = 0;
            while ($dataRow = mysql_fetch_array($dataQry)) {
            $nomor++;
            $Kode = $dataRow['NISN'];
            ?>
          <tr>
            <td align="center"><b><?php echo $nomor; ?></b></td>
            <td><?php echo $dataRow['NISN']; ?></td>
            <td><?php echo $dataRow['KKomp']; ?></td>
            <td><?php echo $dataRow['Nama']; ?></td>
            <td><?php echo $dataRow['Alamat']; ?></td>
            <?php echo '<td style="border:1px solid #000000;" align="center">
                <img src="'.$folder.''.$dataRow['foto'].'" width="100" height="80" />';?>
            <td align="center"><a href="?page=Edit-Siswa&amp;Kode=<?php echo $Kode; ?>" target="_self" alt="Edit Data"><img src="images/btn_edit.png" width="20" height="20" border="0" /></a></td>
            <td align="center"><a href="?page=Delete-Siswa&amp;Kode=<?php echo $Kode; ?>" target="_self" alt="Delete Data" onclick="return confirm('ANDA YAKIN AKAN MENGHAPUS DATA PENTING INI ... ?')"><img src="images/btn_delete.png" width="20" height="20"  border="0"  alt="Delete Data" /></a></td>
          </tr>
          <?php } ?>
        </table></td>
      </tr>
      <tr>
        <td><b>Jumlah Data :</b> <?php echo $jml; ?> </td>
        <td align="right"><b>Halaman ke :</b>
            <?php
            for ($h = 1; $h <= $max; $h++) {
                    $list[$h] = $row * $h - $row;
                    echo " <a href='?page=Data-Siswa&hal=$list[$h]'>$h</a> ";
            }
            ?>
            </td>
      </tr>
    </table>