Advertisement
Guest User

Untitled

a guest
Mar 7th, 2019
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.00 KB | None | 0 0
  1. <html>
  2. <head>
  3. </head>
  4. <body background="https://carboncostume.com/wordpress/wp-content/uploads/2018/10/7granddad.jpg">
  5. <form method="post" >
  6. <table>
  7. <tr>
  8. <td>ID</td>
  9. <td><input type="text" name="id" /></td>
  10. </tr>
  11. <tr>
  12. <td>Gatunek</td>
  13. <td><input type="text" name="gatunek" /> </td>
  14. </tr>
  15. <tr>
  16. <td>Wiek</td>
  17. <td><input type="text" name="wiek" /> </td>
  18. </tr>
  19. <tr>
  20. <td>Imię</td>
  21. <td><input type="text" name="imie" /> </td>
  22. </tr>
  23. <tr>
  24. <td>Płeć</td>
  25. <td><input type="text" name="plec" /> </td>
  26. </tr>
  27. <tr>
  28. <td>Wybieg</td>
  29. <td><input type="text" name="wybieg" /> </td>
  30. </tr>
  31. <tr>
  32. <td>Numer klatki</td>
  33. <td><input type="text" name="klatka" /> </td>
  34. </tr>
  35. <tr>
  36. <td> </td>
  37. <td><input type="submit" /></td>
  38. </tr>
  39. </table>
  40.  
  41.  
  42.  
  43. </form>
  44. <br>
  45.  
  46. <?php
  47. $debug = true;
  48. $servername = "192.168.0.116";
  49. $username = "wario";
  50. $password = "Qwerty123";
  51. $database= "zoo";
  52.  
  53. try {
  54. $conn = new PDO("mysql:host=$servername;dbname=zoo", $username, $password);
  55.  
  56.  
  57. $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  58. if($debug) echo "Connected successfully";
  59. foreach($conn->query('SELECT * from zoo ')as $row){
  60. echo "<br>";
  61. echo "<br>";
  62. printf("id: %s ", $row[0]);
  63. echo "<br>";
  64. printf("Gatunek: %s ", $row[1]);
  65. echo "<br>";
  66. printf("Wiek: %s ", $row[2]);
  67. echo "<br>";
  68. printf("Imie: %s ", $row[3]);
  69. echo "<br>";
  70. printf("Plec: %s ", $row[4]);
  71. echo "<br>";
  72. printf("Wybieg: %s ", $row[5]);
  73. echo "<br>";
  74. printf("Nrklatki: %s ", $row[6]);
  75. echo "<br>";
  76. }}
  77. catch(PDOException $e)
  78. {
  79. echo "Connection failed: " . $e->getMessage();
  80. }
  81.  
  82.  
  83. ?>
  84. </body>
  85. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement