PageRenderTime 26ms CodeModel.GetById 14ms RepoModel.GetById 0ms app.codeStats 0ms

/view/listmhs.php

https://gitlab.com/nova0893/androidevelop
PHP | 161 lines | 117 code | 42 blank | 2 comment | 9 complexity | e4827e39bb1db478b099fd7175d956f3 MD5 | raw file
    

  1. <?php
    2. 

  2. 

  3. include('../config/koneksi.php');
    4. 

  4. 

  5. 

  6. //for total count data
    7. 

  7. $query = $pdo->prepare( "SELECT COUNT(oid) FROM ms_mhs");  
    8. 

  8. $query->execute(); 
    9. 

  9. 

  10. while($r = $query->fetch()) {
    11. 

  11.    $total_records = $r[0];
    12. 

  12.  } 
    13. 

  13.   
    14. 

  14. $total_pages = ceil($total_records / $limit);
    15. 

  15. 

  16. //for first time load data
    17. 

  17. if (isset($_GET["page"])) { $page  = $_GET["page"]; } else { $page=1; };  
    18. 

  18. $start_from = ($page-1) * $limit; 
    19. 

  19. 

  20. 

  21. $query = $pdo->prepare ("SELECT * FROM ms_mhs ORDER BY `str_nm_mhs` ASC LIMIT $start_from, $limit");  
    22. 

  22. $query->execute(); 
    23. 

  23. ?>
    24. 

  24. 

  25. <?php include('header.php');?>
    26. 

  26. 

  27. <!DOCTYPE html>
    28. 

  28. <html>
    29. 

  29. <head>
    30. 

  30. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    31. 

  31. <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.0/css/bootstrap.min.css">
    32. 

  32. <script type="text/javascript" charset="utf8" src="http://ajax.aspnetcdn.com/ajax/jQuery/jquery-2.0.3.js"></script>
    33. 

  33. <script type="text/javascript" src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/js/bootstrap.min.js"></script>
    34. 

  34. <link rel="stylesheet" href="dist/simplePagination.css" />
    35. 

  35. <script src="dist/jquery.simplePagination.js"></script>
    36. 

  36. 

  37. 

  38. <title></title>
    39. 

  39. <script>
    40. 

  40. </script>
    41. 

  41. </head>
    42. 

  42. <body>
    43. 

  43. 

  44. 

  45. <div class="container" >
    46. 

  46. 

  47. <h1>Daftar Mahasiswa</h1>
    48. 

  48. 

  49.   <form action="" method="get">
    50. 

  50.             <input type="text" class="form-control input-sm" maxlength="8" name="search" required autocomplete="off" placeholder="Cari Berdasarkan NPM/Nama">
    51. 

  51. </br>                   
    52. 

  52. 

  53. 

  54.           <div class='fa fa-search'>
    55. 

  55.                     <div class="col-sm-12">
    56. 

  56.                         <button type="submit" class="btn btn-success"><i class="fa fa-search"></i> Cari Data</button>
    57. 

  57.                     </div>
    58. 

  58.                   </div>
    59. 

  59.                   </br></br>
    60. 

  60.           </form>
    61. 

  61. 

  62. 

  63. <table class="table table-bordered table-striped">  
    64. 

  64. <thead>  
    65. 

  65. <tr>  
    66. 

  66. <th>No</th>  
    67. 

  67. <th>NPM</th>
    68. 

  68. <th>Nama</th>
    69. 

  69. <th>Alamat</th>
    70. 

  70. <th align="center">Akses</th> 
    71. 

  71. </tr>  
    72. 

  72. </thead>  
    73. 

  73. <tbody id="target-content">
    74. 

  74. 

  75. 

  76.  <?php 
    77. 

  77.  $no = 1;
    78. 

  78. 

  79.        
    80. 

  80.       if(isset($_GET['search'])){
    81. 

  81.                         
    82. 

  82.                            $param = $_GET['search'];
    83. 

  83.                            $query = $pdo->prepare("SELECT * FROM ms_mhs  WHERE  `str_npm` LIKE :param  OR `str_nm_mhs` LIKE :param ORDER BY `str_nm_mhs` LIMIT $start_from, $limit" );
    84. 

  84.                            $query->bindValue(':param', '%'.$param.'%', PDO::PARAM_STR);
    85. 

  85.                            $query->execute();
    86. 

  86.                            if($query->rowCount() > 0 ){
    87. 

  87.                                 
    88. 

  88.                                $no=1;
    89. 

  89.                                while ($r = $query->fetch()) {
    90. 

  90.                                     
    91. 

  91.                                    echo '<tr>
    92. 

  92.                                             
    93. 

  93.                                             <td>'.$no.'</td>
    94. 

  94.                                             <td>'.$r['str_npm'].'</td>
    95. 

  95.                                             <td>'.$r['str_nm_mhs'].'</td>
    96. 

  96.                                             <td>'.$r['str_almt_rmh'].'</td>
    97. 

  97.                                              <td align="center"> <a href="vdetail/detailmhs.php?str_npm='.$r['str_npm'].'">'.'Lihat Detail </a>'.'</td> 
    98. 

  98.                       
    99. 

  99.                                          </tr>';
    100. 

  100.                                     
    101. 

  101.                                    ++$no;
    102. 

  102.                     
    103. 

  103.                                 }//end while
    104. 

  104.                                 
    105. 

  105.                             }else{
    106. 

  106.                                 
    107. 

  107.                                 echo "<tr><td colspan=\"4\">Not Found</td></tr>";
    108. 

  108.                             }
    109. 

  109.                             
    110. 

  110.                         }//end if
    111. 

  111. 

  112.                                while ($r = $query->fetch()) {
    113. 

  113.                                     
    114. 

  114.                                    echo '<tr>
    115. 

  115.                                             <td>'.$no.'</td>
    116. 

  116.                                             <td>'.$r['str_npm'].'</td>
    117. 

  117.                                             <td>'.$r['str_nm_mhs'].'</td>
    118. 

  118.                                             <td>'.$r['str_almt_rmh'].'</td>
    119. 

  119.                                             <td align="center"> <a href="vdetail/detailmhs.php?str_npm='.$r['str_npm'].'">'.'Lihat Detail </a>'.'</td>                                        
    120. 

  120.                                          </tr>';
    121. 

  121.                                     
    122. 

  122.                                    ++$no;
    123. 

  123.                     
    124. 

  124.                                 }//end while
    125. 

  125.                                 
    126. 

  126.                     
    127. 

  127.                     
    128. 

  128.                     ?>
    129. 

  129. 

  130. 

  131. </tbody> 
    132. 

  132. </table>
    133. 

  133. <nav><ul class="pagination">
    134. 

  134. <?php if(!empty($total_pages)):for($i=1; $i<=$total_pages; $i++):  
    135. 

  135.             if($i == 1):?>
    136. 

  136.             <li class='active'  id="<?php echo $i;?>"><a href='vpagination/pagination.php?page=<?php echo $i;?>'><?php echo $i;?></a></li> 
    137. 

  137.             <?php else:?>
    138. 

  138.             <li id="<?php echo $i;?>"><a href='vpagination/pagination.php?page=<?php echo $i;?>'><?php echo $i;?></a></li>
    139. 

  139.         <?php endif;?>          
    140. 

  140. <?php endfor;endif;?>
    141. 

  141. </ul></nav>
    142. 

  142. </div>
    143. 

  143. </body>
    144. 

  144. <script type="text/javascript">
    145. 

  145. $(document).ready(function(){
    146. 

  146. $('.pagination').pagination({
    147. 

  147.         items: <?php echo $total_records;?>,
    148. 

  148.         itemsOnPage: <?php echo $limit;?>,
    149. 

  149.         cssStyle: 'light-theme',
    150. 

  150.     currentPage : 1,
    151. 

  151.     onPageClick : function(pageNumber) {
    152. 

  152.       jQuery("#target-content").html('loading...');
    153. 

  153.       jQuery("#target-content").load("vpagination/pagination.php?page=" + pageNumber);
    154. 

  154.     }
    155. 

  155.     });
    156. 

  156. });
    157. 

  157. </script>
    158. 

  158. 

  159. <?php
    160. 

  160. include('footer.php');
    161. 

  161. ?>
    162.