Advertisement
Guest User

Toms problem

a guest
Nov 8th, 2017
133
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.44 KB | None | 0 0
  1.         if (isset($_POST['datum'])) {              
  2.             $new_date = date('Y-m-d', strtotime($_POST['datum']));
  3.             echo $new_date;
  4.            
  5.         if ( $userr == 'CL-Horst') {
  6.             $sql = "SELECT Personeelsnummer, Werkdatum, Kaart FROM beoordeling WHERE VestID = '1' AND Werkdatum = '$new_date'";
  7.             $stmt = sqlsrv_query($conn,$sql);
  8.         }
  9.         if ( $userr == 'CL-Melderslo') {
  10.             $sql = "SELECT Personeelsnummer, Werkdatum, Kaart FROM beoordeling WHERE VestID = '2' AND Werkdatum = '$new_date'";
  11.             $stmt = sqlsrv_query($conn,$sql);
  12.         }
  13.         if ( $userr == 'CL-Merselo') {
  14.             $sql = "SELECT Personeelsnummer, Werkdatum, Kaart FROM beoordeling WHERE VestID = '3' AND Werkdatum = '$new_date'";
  15.             $stmt = sqlsrv_query($conn,$sql);
  16.         }
  17.         if ( $userr == 'CL-Overloon') {
  18.             $sql = "SELECT Personeelsnummer, Werkdatum, Kaart FROM beoordeling WHERE VestID = '4' AND Werkdatum = '$new_date'";
  19.             $stmt = sqlsrv_query($conn,$sql);
  20.         }
  21.            
  22.         ?>     
  23. <div class="form-group pull-right">
  24.     <input type="text" id="styleme" class="search form-control" placeholder="Search by name..">
  25. </div>
  26. <table id="example" class="display" cellspacing="0" width="100%">
  27. <thead>
  28.     <tr>
  29.       <th>Rating</th>
  30.           <th>KaartNr</th>
  31.           <th>PersoneelID</th>
  32.       <th>Naam</th>
  33.       <th>Werkdatum</th>
  34.     </tr>
  35.   </thead>
  36.  <form name="myForm" method="post">
  37. <?php
  38. while($row = sqlsrv_fetch_array($stmt)){   //Creates a loop to loop through results
  39. echo "<tr>
  40. <td><input type='range' name='data[]' value='0' id='myRange' class='slider' min='0' max='7' data-show-value='true'></td>
  41. <td>" . $row['Kaart'] . "</td><td>" . $row['Personeelsnummer'] . "</td>
  42. <td>" . 'Piet' . ' ' . 'Janssen' . "</td><td>" . $row['Werkdatum']->format('Y-m-d') . "</td>
  43. </tr>";
  44. }
  45.  
  46. echo "</table>"; //Close the table
  47. ?>
  48. <input type="submit" name="send" value="send"/>
  49. </form>
  50. <?php
  51. if (isset($_POST['send'])) {
  52.     if (!empty($_POST['data'])) {
  53.         foreach($_POST["data"] as $data)
  54.         {
  55.             echo $data;
  56.             $sql = "insert into beoordeling(Beoordelingnumeriek) values ('$data')";
  57.         }
  58.     }
  59. }
  60. ?>
  61. <script>
  62. $(document).ready(function(){
  63.     $('.search').on('keyup',function(){
  64.         var searchTerm = $(this).val().toLowerCase();
  65.         $('#example tbody tr').each(function(){
  66.             var lineStr = $(this).text().toLowerCase();
  67.             if(lineStr.indexOf(searchTerm) === -1){
  68.                 $(this).hide();
  69.             }else{
  70.                 $(this).show();
  71.             }
  72.         });
  73.     });
  74. });
  75. </script>
  76. <?php } ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement