Advertisement
Guest User

Untitled

a guest
Jul 1st, 2016
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.18 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html lang="en">
  3. <head>
  4. <meta charset="UTF-8">
  5. <title>Document</title>
  6. <!-- Jquery -->
  7. <script src="https://code.jquery.com/jquery-2.2.4.js" integrity="sha256-iT6Q9iMJYuQiMWNd9lDyBUStIq/8PuOW33aOqmvFpqI=" crossorigin="anonymous"></script>
  8. <!-- Bootstrap -->
  9. <script src="smart/node_modules/bootstrap/dist/js/bootstrap.js"></script>
  10. <link rel="stylesheet" href="../disc/smart/node_modules/bootstrap/dist/css/bootstrap.css">
  11. <link rel="stylesheet" href="../disc/smart/node_modules/bootstrap/dist/css/bootstrap-theme.css">
  12. <style type="text/css">
  13.  
  14. #discideas caption
  15. {
  16. text-align: center;
  17. font-weight: bold;
  18. }
  19.  
  20. #discideas
  21. {
  22. width: 500px;
  23. }
  24.  
  25. #edit
  26. {
  27. text-align: center;
  28. width: 500px;
  29. }
  30.  
  31. #wat
  32. {
  33. width: 500px;
  34. }
  35. </style>
  36. </head>
  37. <body>
  38.  
  39. <?php
  40.  
  41. $servername = "localhost";
  42. $username = "root";
  43. $password = "Mustkohv11";
  44. $dbname = "discgolf";
  45. $mysqli = new mysqli("$servername", "$username", "$password", "$dbname");
  46. if ($mysqli->connect_error)
  47. {
  48. die("Connection failed: " . $mysqli->connect_error);
  49. }
  50. $stmt = $mysqli->prepare("SELECT * FROM discideas;");
  51. $stmt->bind_result($id, $type, $brand, $name, $plastic);
  52. $stmt->execute();
  53.  
  54. ?>
  55.  
  56. <table class="table" border="1" id="discideas">
  57. <caption>Disc ideas</caption>
  58. <th>Type</th>
  59. <th>Brand</th>
  60. <th>Name</th>
  61. <th>Plastic</th>
  62. <?php
  63.  
  64. while($stmt->fetch())
  65. {
  66. echo
  67. "<tr>
  68. <td>$type</td>
  69. <td>$brand</td>
  70. <td>$name</td>
  71. <td>$plastic</td>
  72. </tr>
  73. ";
  74. }
  75.  
  76. $mysqli->close();
  77. ?>
  78. </table>
  79. <div id="edit">
  80. <input type="button" name="edittable" value="Edit">
  81. </div>
  82.  
  83. <br>
  84.  
  85. <p id="wat">
  86. Vajutad Edit nuppu, Edit nupu asemele tekib sama koha peale nupp Save.
  87. Tabeli ridadele, kus on tekst, tekib teksti asemele input field ja sinna sisse jääb see sama väärtus, mis enne tabelis oli. Muudad teksti input fieldis ja vajutad nuppu save, uuendab baasis andmed ära ja kuvab uusi andmeid.
  88. </p>
  89. <p>Panin siia mingi asja, mis tegime kunagi Romiliga, aga ma ei suuda läbi hammustada ja järgi teha.</p>
  90. <a href="recipes.7z">recipes.7z</a>
  91.  
  92. </body>
  93. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement