Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if (isset($_POST['datum'])) {
- $new_date = date('Y-m-d', strtotime($_POST['datum']));
- echo $new_date;
- if ( $userr == 'CL-Horst') {
- $sql = "SELECT Personeelsnummer, Werkdatum, Kaart FROM beoordeling WHERE VestID = '1' AND Werkdatum = '$new_date'";
- $stmt = sqlsrv_query($conn,$sql);
- }
- if ( $userr == 'CL-Melderslo') {
- $sql = "SELECT Personeelsnummer, Werkdatum, Kaart FROM beoordeling WHERE VestID = '2' AND Werkdatum = '$new_date'";
- $stmt = sqlsrv_query($conn,$sql);
- }
- if ( $userr == 'CL-Merselo') {
- $sql = "SELECT Personeelsnummer, Werkdatum, Kaart FROM beoordeling WHERE VestID = '3' AND Werkdatum = '$new_date'";
- $stmt = sqlsrv_query($conn,$sql);
- }
- if ( $userr == 'CL-Overloon') {
- $sql = "SELECT Personeelsnummer, Werkdatum, Kaart FROM beoordeling WHERE VestID = '4' AND Werkdatum = '$new_date'";
- $stmt = sqlsrv_query($conn,$sql);
- }
- ?>
- <div class="form-group pull-right">
- <input type="text" id="styleme" class="search form-control" placeholder="Search by name..">
- </div>
- <table id="example" class="display" cellspacing="0" width="100%">
- <thead>
- <tr>
- <th>Rating</th>
- <th>KaartNr</th>
- <th>PersoneelID</th>
- <th>Naam</th>
- <th>Werkdatum</th>
- </tr>
- </thead>
- <form name="myForm" method="post">
- <?php
- while($row = sqlsrv_fetch_array($stmt)){ //Creates a loop to loop through results
- echo "<tr>
- <td><input type='range' name='data[]' value='0' id='myRange' class='slider' min='0' max='7' data-show-value='true'></td>
- <td>" . $row['Kaart'] . "</td><td>" . $row['Personeelsnummer'] . "</td>
- <td>" . 'Piet' . ' ' . 'Janssen' . "</td><td>" . $row['Werkdatum']->format('Y-m-d') . "</td>
- </tr>";
- }
- echo "</table>"; //Close the table
- ?>
- <input type="submit" name="send" value="send"/>
- </form>
- <?php
- if (isset($_POST['send'])) {
- if (!empty($_POST['data'])) {
- foreach($_POST["data"] as $data)
- {
- echo $data;
- $sql = "insert into beoordeling(Beoordelingnumeriek) values ('$data')";
- }
- }
- }
- ?>
- <script>
- $(document).ready(function(){
- $('.search').on('keyup',function(){
- var searchTerm = $(this).val().toLowerCase();
- $('#example tbody tr').each(function(){
- var lineStr = $(this).text().toLowerCase();
- if(lineStr.indexOf(searchTerm) === -1){
- $(this).hide();
- }else{
- $(this).show();
- }
- });
- });
- });
- </script>
- <?php } ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement