paparpeserta.php

<?php

echo"


<!DOCTYPE html>
<html>
<head>
<title>Sistem Pengurusan Pendaftaran Peserta Olahraga Rumah Sukan Zubair </title>
</head>
<body bgcolor='#FF4646'>
<table align='center'width='50%''>
<tr>
<td><img src='izzham.jpg'</td>
</tr>
<tr>
<td bgcolor='#00FF00' align='left'>";include('masa.php');echo"</td>

</tr>
<tr height='180'valign = 'top' align='center'>
<td>
";
?>
<?php require_once('Connections/connection.php'); ?>
<?php
$maxRows_q_paparpeserta = 10;
$pageNum_q_paparpeserta = 0;
if (isset($_GET['pageNum_q_paparpeserta'])) {
  $pageNum_q_paparpeserta = $_GET['pageNum_q_paparpeserta'];
}
$startRow_q_paparpeserta = $pageNum_q_paparpeserta * $maxRows_q_paparpeserta;

mysql_select_db($database_connection, $connection);
$query_q_paparpeserta = "SELECT peserta.idpeserta, peserta.nama, peserta.nokp, peserta.kelas, peserta.jantina, kelas.namakelas
FROM peserta
INNER JOIN kelas ON peserta.kelas = kelas.idkelas ";
$query_limit_q_paparpeserta = sprintf("%s LIMIT %d, %d", $query_q_paparpeserta, $startRow_q_paparpeserta, $maxRows_q_paparpeserta);
$q_paparpeserta = mysql_query($query_limit_q_paparpeserta,$connection ) or die(mysql_error());
$row_q_paparpeserta = mysql_fetch_assoc($q_paparpeserta);

if (isset($_GET['totalRows_q_paparpeserta'])) {
  $totalRows_q_paparpeserta = $_GET['totalRows_q_paparpeserta'];
} else {
  $all_q_paparpeserta = $q_paparpeserta;
  $totalRows_q_paparpeserta = mysql_num_rows($all_q_paparpeserta);
}


$totalPages_q_paparpeserta = ceil($totalRows_q_paparpeserta/$maxRows_q_paparpeserta)-1;
?><!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>
<style type="text/css">
<!--
.style1 {font-size: 18px}
body {
    background-image: url(bgkelas.jpg);
}
.style2 {color: #FFFFFF}
.style3 {color: #FFFF00}
.style4 {color: #33FF66}
.style5 {color: #00FF99}
-->
</style>
</head>

<body>
<div align="center" class="style1">
  <p class="style2">SENARAI NAMA PELAJAR YANG TELAH DIDAFTAR</p>
  <table width="833" border="1" bordercolor="#FF9999" bgcolor="#666699">
    <tr>
      <td width="40"><span class="style4">Bil</span></td>
      <td width="144"><span class="style4">Nama</span></td>
      <td width="109"><span class="style4">No.KP </span></td>
      <td width="59"><span class="style4">Kelas</span></td>
      <td width="50"><span class="style4">Jantina</span></td>

      <td colspan="3"><div align="center"><a href="daftarpeserta.php" class="style4">Tambah</a></div></td>
    </tr>
    <tr>
      <?php $bil = 0 ?>
      <?php do { ?> <tr>
      <?php $bil+=1 ?>
        <td><?php echo $bil ; ?></td>
        <td><span class="style3"><?php echo $row_q_paparpeserta['nama'];; ?></span></td>
        <td><span class="style3"><?php echo $row_q_paparpeserta['nokp']; ?></span></td>
        <td><span class="style3"><?php echo $row_q_paparpeserta['namakelas']; ?></span></td>
        <td><div align="center" class="style3"><?php echo $row_q_paparpeserta['jantina']; ?></div></td>

        <td width="67"><div align="center"><a href="lihatpeserta.php" class="style4">Lihat</a></div></td>
        <td width="51"><div align="center"><a href="editpeserta.php?idpeserta=" class="style4">Edit</a></div></td>
        <td width="70"><div align="center"><a href="sahpadampeserta.php?idpeserta=" class="style4">Hapus</a></div></td>
        <?php } while ($row_q_paparpeserta = mysql_fetch_assoc($q_paparpeserta)); ?></tr>
  </table>

  <p><a href="senaraisemua.php" class="style5">Kembali</a></p>
</div>
</body>
</html>
<?php
mysql_free_result($q_paparpeserta);
?>