API tools faq
paste
Advertisement
Haezz

papargame.php

Haezz
Jul 25th, 2019
142
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 6.28 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2.  
  3. echo"
  4.  
  5.  
  6. <!DOCTYPE html>
  7. <html>
  8. <head>
  9. <title>Sistem Pengurusan Pendaftaran Peserta Olahraga Rumah Sukan Zubair </title>
  10. </head>
  11. <body bgcolor='#FF4646'>
  12. <table align='center'width='50%''>
  13. <tr>
  14. <td><img src='izzham.jpg'</td>
  15. </tr>
  16. <tr>
  17. <td bgcolor='#00FF00' align='left'>";include('masa.php');echo"</td>
  18.  
  19. </tr>
  20. <tr height='180'valign = 'top' align='center'>
  21. <td>
  22. ";
  23. ?>
  24. <?php require_once('Connections/connection.php'); ?>
  25. <?php
  26. $maxRows_q_CARIpeserta = 10;
  27. $pageNum_q_CARIpeserta = 0;
  28. if (isset($_GET['pageNum_q_CARIpeserta'])) {
  29.   $pageNum_q_CARIpeserta = $_GET['pageNum_q_CARIpeserta'];
  30. }
  31. $startRow_q_CARIpeserta = $pageNum_q_CARIpeserta * $maxRows_q_CARIpeserta;
  32.  
  33. mysql_select_db($database_connection, $connection);
  34.  
  35. $query_rsAcara="SELECT * FROM acara";
  36. $rsAcara = mysql_query($query_rsAcara) or die(mysql_error());
  37. $row_rsAcara= mysql_fetch_assoc($rsAcara);
  38. $totalRows_rsAcara= mysql_num_rows($rsAcara);
  39. if ((isset($_POST['btnSelect'])) && ($_POST['btnSelect']=="CARI"))
  40. {
  41.     $acara= $_POST['acara'];
  42.     if ($acara=="all")
  43. {
  44.     $query_q_CARIpeserta = "SELECT *
  45. FROM  `daftar_acara`
  46. INNER JOIN peserta ON daftar_acara.idpeserta = peserta.idpeserta
  47. INNER JOIN kelas ON peserta.kelas = kelas.idkelas
  48. INNER JOIN acara ON daftar_acara.kodacara = acara.kodacara
  49. ORDER BY daftar_acara.kodacara ASC";
  50. $query_limit_q_CARIpeserta = sprintf("%s LIMIT %d, %d", $query_q_CARIpeserta, $startRow_q_CARIpeserta, $maxRows_q_CARIpeserta);
  51. $q_CARIpeserta = mysql_query($query_limit_q_CARIpeserta,$connection ) or die(mysql_error());
  52. $row_q_CARIpeserta = mysql_fetch_assoc($q_CARIpeserta);
  53.  
  54. }
  55.     else
  56.     {
  57. $query_q_CARIpeserta = "SELECT *
  58. FROM  `daftar_acara`
  59. INNER JOIN peserta ON daftar_acara.idpeserta = peserta.idpeserta
  60. INNER JOIN kelas ON peserta.kelas = kelas.idkelas
  61. INNER JOIN acara ON daftar_acara.kodacara = acara.kodacara
  62. where daftar_acara.kodacara=$acara";
  63. $query_limit_q_CARIpeserta = sprintf("%s LIMIT %d, %d", $query_q_CARIpeserta, $startRow_q_CARIpeserta, $maxRows_q_CARIpeserta);
  64. $q_CARIpeserta = mysql_query($query_limit_q_CARIpeserta,$connection ) or die(mysql_error());
  65. $row_q_CARIpeserta = mysql_fetch_assoc($q_CARIpeserta);
  66.  
  67.     }
  68. }
  69. else
  70. {
  71.     $acara= "";
  72. $query_q_CARIpeserta = "SELECT *
  73. FROM  `daftar_acara`
  74. INNER JOIN peserta ON daftar_acara.idpeserta = peserta.idpeserta
  75. INNER JOIN kelas ON peserta.kelas = kelas.idkelas
  76. INNER JOIN acara ON daftar_acara.kodacara = acara.kodacara
  77. ORDER BY daftar_acara.kodacara ASC";
  78. $query_limit_q_CARIpeserta = sprintf("%s LIMIT %d, %d", $query_q_CARIpeserta, $startRow_q_CARIpeserta, $maxRows_q_CARIpeserta);
  79. $q_CARIpeserta = mysql_query($query_limit_q_CARIpeserta,$connection ) or die(mysql_error());
  80. $row_q_CARIpeserta = mysql_fetch_assoc($q_CARIpeserta);
  81. }
  82. if (isset($_GET['totalRows_q_CARIpeserta'])) {
  83.   $totalRows_q_CARIpeserta = $_GET['totalRows_q_CARIpeserta'];
  84. } else {
  85.   $all_q_CARIpeserta = $q_CARIpeserta;
  86.   $totalRows_q_CARIpeserta = mysql_num_rows($all_q_CARIpeserta);
  87. }
  88.  
  89.  
  90. $totalPages_q_CARIpeserta = ceil($totalRows_q_CARIpeserta/$maxRows_q_CARIpeserta)-1;
  91. ?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  92. <html xmlns="http://www.w3.org/1999/xhtml">
  93. <head>
  94. <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
  95. <title>Untitled Document</title>
  96. <style type="text/css">
  97. <!--
  98. .style1 {font-size: 18px}
  99. .style2 {color: #66FF00}
  100. .style3 {color: #33FF66}
  101. body {
  102.     background-image: url(bgkelas.jpg);
  103. }
  104. .style4 {color: #FFFF00}
  105. .style5 {color: #00FF33}
  106. .style6 {color: #FFFFFF}
  107. -->
  108. </style>
  109. </head>
  110.  
  111. <body>
  112. <div align="center" class="style1">
  113.   <p class="style6">SENARAI NAMA PESERTA YANG TELAH DIDAFTAR UNTUK ACARA</p>
  114.   <table width="833" border="1" bordercolor="#FF9999" bgcolor="#666699">
  115.   <tr><td colspan="10"><form name="selectForm" method="post">
  116.         <span class="style3">Acara :</span>
  117.         <select name="acara" id="acara" >
  118.             <option value="all">Select:</option>
  119.             <option value="all">Semua</option>
  120.              <?php
  121.     do {  
  122. ?>
  123.               <option  value="<?php echo $row_rsAcara['kodacara']?>"><?php echo ($row_rsAcara['namaacara'])?></option>
  124.               <?php
  125.                } while ($row_rsAcara = mysql_fetch_assoc($rsAcara));
  126.     $rows = mysql_num_rows($rsAcara); ?>
  127.         </select>
  128.         <input type="submit" name="btnSelect" value="CARI" /></form></td></tr>
  129.     <tr>
  130.       <td width="40"><span class="style3">Bil</span></td>
  131.       <td width="144"><span class="style3">Nama</span></td>
  132.       <td width="109"><span class="style3">No.KP </span></td>
  133.       <td width="59"><span class="style3">Kelas</span></td>
  134.       <td width="50"><span class="style3">Acara</span></td>
  135.       <td width="50"><span class="style3">Jenis</span></td>
  136.       <td width="50"><span class="style3">Jantina</span></td>
  137.      
  138.       <td colspan="3"><div align="center"><a href="daftargame2.php" class="style3">Tambah</a></div></td>
  139.     </tr>
  140.     <tr>
  141.     <?php if ($totalRows_q_CARIpeserta >0)
  142.     { ?>
  143.       <?php $bil = 0 ?>
  144.       <?php do { ?> <tr>
  145.       <?php $bil+=1 ?>
  146.         <td><?php echo $bil ; ?> <span class="style4"></td>
  147.         <td><span class="style4"><?php echo $row_q_CARIpeserta['nama'];; ?></span></td>
  148.         <td><span class="style4"><?php echo $row_q_CARIpeserta['nokp']; ?></span></td>
  149.         <td><span class="style4"><?php echo $row_q_CARIpeserta['namakelas']; ?></span></td>
  150.         <td><span class="style4"><?php echo $row_q_CARIpeserta['namaacara']; ?></span></td>
  151.         <td><span class="style4"><?php echo $row_q_CARIpeserta['jenisacara']; ?></span></td>
  152.         <td><div align="center" class="style4"><?php echo $row_q_CARIpeserta['jantina']; ?></div></td>
  153.        
  154.         <td width="67"><div align="center"><a href="lihatgame.php?idpeserta=<?php echo $row_q_CARIpeserta['idpeserta']; ?>" class="style3">Lihat</a></div></td>
  155.         <td width="70"><div align="center"><a href="sahpadamgame.php?idpeserta=<?php echo $row_q_CARIpeserta['idpeserta']; ?>" class="style3">Hapus</a></div></td>
  156.         <?php } while ($row_q_CARIpeserta = mysql_fetch_assoc($q_CARIpeserta));  }?></tr>
  157.   </table>
  158.  
  159.   <p><a href="senaraisemua.php" class="style2">KEMBALI</a> <a href="cetakpeserta.php" class="style5">CETAK</a></p>
  160. </div>
  161. </body>
  162. </html>
  163. <?php
  164. mysql_free_result($q_CARIpeserta);
  165. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!