Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- </head>
- <body background="https://carboncostume.com/wordpress/wp-content/uploads/2018/10/7granddad.jpg">
- <form method="post" >
- <table>
- <tr>
- <td>ID</td>
- <td><input type="text" name="id" /></td>
- </tr>
- <tr>
- <td>Gatunek</td>
- <td><input type="text" name="gatunek" /> </td>
- </tr>
- <tr>
- <td>Wiek</td>
- <td><input type="text" name="wiek" /> </td>
- </tr>
- <tr>
- <td>Imię</td>
- <td><input type="text" name="imie" /> </td>
- </tr>
- <tr>
- <td>Płeć</td>
- <td><input type="text" name="plec" /> </td>
- </tr>
- <tr>
- <td>Wybieg</td>
- <td><input type="text" name="wybieg" /> </td>
- </tr>
- <tr>
- <td>Numer klatki</td>
- <td><input type="text" name="klatka" /> </td>
- </tr>
- <tr>
- <td> </td>
- <td><input type="submit" /></td>
- </tr>
- </table>
- </form>
- <br>
- <?php
- $debug = true;
- $servername = "192.168.0.116";
- $username = "wario";
- $password = "Qwerty123";
- $database= "zoo";
- try {
- $conn = new PDO("mysql:host=$servername;dbname=zoo", $username, $password);
- $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- if($debug) echo "Connected successfully";
- foreach($conn->query('SELECT * from zoo ')as $row){
- echo "<br>";
- echo "<br>";
- printf("id: %s ", $row[0]);
- echo "<br>";
- printf("Gatunek: %s ", $row[1]);
- echo "<br>";
- printf("Wiek: %s ", $row[2]);
- echo "<br>";
- printf("Imie: %s ", $row[3]);
- echo "<br>";
- printf("Plec: %s ", $row[4]);
- echo "<br>";
- printf("Wybieg: %s ", $row[5]);
- echo "<br>";
- printf("Nrklatki: %s ", $row[6]);
- echo "<br>";
- }}
- catch(PDOException $e)
- {
- echo "Connection failed: " . $e->getMessage();
- }
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement