Crecket

Untitled

Mar 24th, 2015
281
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.29 KB | None | 0 0
  1.     <form class="defaultform" method="post" action="cijferinvoer.php" >
  2.         <input id="reloadresults" type="submit" name="Loadresults" value="Laad de resultaten">
  3.        
  4.     </form>
  5.     <?php
  6.     if(isset($_POST['Loadresults'])){
  7.         $sqlselect = "SELECT * FROM resultaat";
  8.         $resultselect = $conn->query($sqlselect);
  9.         echo '<table style="padding:10px">';
  10.         echo '
  11.             <tr >
  12.                 <td style="padding:6px;  border: 1px solid black;">ID: </td>
  13.                 <td style="padding:6px;  border: 1px solid black;">Tijdstip:</td>
  14.                 <td style="padding:6px;  border: 1px solid black;">Leerling id:</td>
  15.                 <td style="padding:6px;  border: 1px solid black;">Vak id:</td>
  16.                 <td style="padding:6px;  border: 1px solid black;">Cijfer:</td>
  17.             </tr>';
  18.         while($row = mysqli_fetch_array($resultselect, MYSQLI_BOTH)) {
  19.         $temp = $row['tijdstip'];
  20.         echo '
  21.             <tr >
  22.                 <td style="padding:6px;  border: 1px solid black;"> ' . $row['id'] . '   </td>
  23.                 <td style="padding:6px;  border: 1px solid black;"> ' . $temp . '   </td>
  24.                 <td style="padding:6px;  border: 1px solid black;"> ' . $row['leerling_id'] . ' </td>
  25.                 <td style="padding:6px;  border: 1px solid black;"> ' . $row['vak_id'] . ' </td>
  26.                 <td style="padding:6px;  border: 1px solid black;"> ' . $row['cijfer'] . ' </td>
  27.             </tr>';
  28.    
  29.         }
  30.         echo '</table>';
  31.     }
  32.         ?>
Advertisement
Add Comment
Please, Sign In to add comment