Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html lang="en">
- <head>
- <meta charset="UTF-8">
- <title>Document</title>
- <!-- Jquery -->
- <script src="https://code.jquery.com/jquery-2.2.4.js" integrity="sha256-iT6Q9iMJYuQiMWNd9lDyBUStIq/8PuOW33aOqmvFpqI=" crossorigin="anonymous"></script>
- <!-- Bootstrap -->
- <script src="smart/node_modules/bootstrap/dist/js/bootstrap.js"></script>
- <link rel="stylesheet" href="../disc/smart/node_modules/bootstrap/dist/css/bootstrap.css">
- <link rel="stylesheet" href="../disc/smart/node_modules/bootstrap/dist/css/bootstrap-theme.css">
- <style type="text/css">
- #discideas caption
- {
- text-align: center;
- font-weight: bold;
- }
- #discideas
- {
- width: 500px;
- }
- #edit
- {
- text-align: center;
- width: 500px;
- }
- #wat
- {
- width: 500px;
- }
- </style>
- </head>
- <body>
- <?php
- $servername = "localhost";
- $username = "root";
- $password = "Mustkohv11";
- $dbname = "discgolf";
- $mysqli = new mysqli("$servername", "$username", "$password", "$dbname");
- if ($mysqli->connect_error)
- {
- die("Connection failed: " . $mysqli->connect_error);
- }
- $stmt = $mysqli->prepare("SELECT * FROM discideas;");
- $stmt->bind_result($id, $type, $brand, $name, $plastic);
- $stmt->execute();
- ?>
- <table class="table" border="1" id="discideas">
- <caption>Disc ideas</caption>
- <th>Type</th>
- <th>Brand</th>
- <th>Name</th>
- <th>Plastic</th>
- <?php
- while($stmt->fetch())
- {
- echo
- "<tr>
- <td>$type</td>
- <td>$brand</td>
- <td>$name</td>
- <td>$plastic</td>
- </tr>
- ";
- }
- $mysqli->close();
- ?>
- </table>
- <div id="edit">
- <input type="button" name="edittable" value="Edit">
- </div>
- <br>
- <p id="wat">
- Vajutad Edit nuppu, Edit nupu asemele tekib sama koha peale nupp Save.
- 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.
- </p>
- <p>Panin siia mingi asja, mis tegime kunagi Romiliga, aga ma ei suuda läbi hammustada ja järgi teha.</p>
- <a href="recipes.7z">recipes.7z</a>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement