Advertisement
Guest User

Untitled

a guest
May 10th, 2019
132
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.60 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <?php include "date.php";?>
  3. <html lang="en" dir="ltr">
  4. <head>
  5. <meta charset="utf-8">
  6. <title> </title>
  7. <link rel="stylesheet" href="Main.css">
  8. </head>
  9. <body>
  10. <?php
  11. $servername= "localhost";
  12. $databasename= "db_level2_eindopr";
  13. $username= "root";
  14. $password="";
  15.  
  16. $conn=new mysqli($servername, $username, $password, $databasename);
  17.  
  18.  
  19. if ($conn->connect_error) {
  20. die("Connection failed: " . $conn->connect_error);
  21. }
  22. echo "Connected successfully";
  23. echo "<br>"." <br>";
  24.  
  25.  
  26. $sql="SELECT * FROM `verjaardagen`";
  27.  
  28. $rs=$conn->query($sql);
  29.  
  30. ?>
  31.  
  32. <table>
  33.  
  34. <tr>
  35. <th>ID</th>
  36. <th>Voornaam</th>
  37. <th>Achternaam</th>
  38. <th>Geboortedatum</th>
  39. <th>Livetime day counter</th>
  40. <th>Update</th>
  41. <th>Delete</th>
  42. </tr>
  43. <?php while ($row = $rs->fetch_assoc()) { ?>
  44. <tr>
  45. <td><?php echo $row['id'];?></td>
  46. <td><?php echo $row['voornaam'];?></td>
  47. <td> <?php echo $row['achternaam'];?></td>
  48. <td> <?php echo $row['geboortedatum'];?></td>
  49. <td><?php echo calcAge($row['geboortedatum']);?></td>
  50.  
  51. <td> <a href="updateA.php?id=<?php echo $row['id']; ?>" id="UPDATE" >UPDATE</a> </td>
  52. <td> <a href="delete.php?id=<?php echo $row['id']; ?>" id="UPDATE" >DELETE</a> </td>
  53.  
  54. </tr>
  55.  
  56. <?php } ?>
  57. </table>
  58.  
  59. <?php $conn->close(); ?>
  60. <form class="" action="insert.php" method="post">
  61.  
  62. <button id= "Return" type="submit" name="button">INSERT</button>
  63. </form>
  64.  
  65.  
  66. </body>
  67. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement