API tools faq
paste
Advertisement
Guest User

AI_1

a guest
Jan 18th, 2020
124
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.85 KB | None | 0 0
raw download clone embed print report
  1. <html>
  2. <head>
  3. <meta name="viewport" content="width=device-width, initial-scale=1.0">
  4. <title>
  5. Animalopocalypse
  6. </title>
  7. </head>
  8. <body>
  9. <p>Enter something. The system will find every person that has what you have entered in their name.</p>
  10. <form action="/animal_insertion.php" method="GET">
  11. <input type="text" name="name" value="">
  12. <input type="submit" value="Submit">
  13. </form>
  14. <p></p>
  15. <p>If you know your IP-address, use the following form instead. Enter your IP-address there as well</p>
  16. <form action="/animal_insertion.php" method="GET">
  17. Name: <input type="text" name="name" value="">
  18. <p></p>
  19. IP-address: <input type="number" name="ip1" min="0" max="255" maxlength="3" required>
  20. <input type="number" name="ip2" min="0" max="255" maxlength="3" required>
  21. <input type="number" name="ip3" min="0" max="255" maxlength="3" required>
  22. <input type="number" name="ip4" min="0" max="255" maxlength="3" required>
  23. <input type="submit" value="Submit">
  24. </form>
  25. <?php
  26. ob_start();
  27. $time_start_global = microtime(true);
  28. $link = new mysqli("127.0.0.1", "root", "", "test");
  29. if ($link->connect_error) {
  30. die("NOOOOOOOOOOoooooooooo.....");
  31. }
  32. if (isset($_GET["name"])) {
  33. if (isset($_GET['ip1']) && isset($_GET['ip2']) && isset($_GET['ip3']) && isset($_GET['ip4'])) {
  34. $ip_link = new mysqli("127.0.0.1", "root", "", "geoip");
  35. $ip_total = ($_GET['ip1'] * 16777216) + ($_GET['ip2'] * 65536) + ($_GET['ip3'] * 256) + $_GET['ip4'];
  36. $ip_major_query = $ip_link->prepare("SELECT country FROM (SELECT country, e_con FROM `dbip_edu` WHERE s_con < ?) AS tab WHERE e_con > ? LIMIT 1");
  37. $ip_major_query->bind_param('ii', $ip_total, $ip_total);
  38. $ip_major_query->execute();
  39. $ip_major_result = $ip_major_query->get_result();
  40. $cuntry = $ip_major_result->fetch_row();
  41. $ip_major_result->close();
  42. echo "Zdravíme návštěvníka z <strong>" . $cuntry[0] . "</strong>";
  43. echo "<p>";
  44. }
  45. if (isset($_GET['insert'])) {
  46. $insertion = $link->prepare("INSERT INTO osetruje (osetrovatel, zvire) VALUES (?, ?)");
  47. $insertion->bind_param('ii', $_GET['id'], $_GET['insert']);
  48. $insertion->execute();
  49. $insertion->close();
  50. $log_query = $link->prepare("SELECT osetrovatele.jmeno, zvirata.jmeno, druhy.nazev FROM osetrovatele JOIN osetruje ON osetrovatele.id = osetruje.osetrovatel JOIN zvirata ON zvirata.id = osetruje.zvire JOIN druhy ON zvirata.druh = druhy.id WHERE osetruje.osetrovatel = ? AND osetruje.zvire = ?");
  51. $log_query->bind_param('ii', $_GET['id'], $_GET['insert']);
  52. $log_query->execute();
  53. $log_result = $log_query->get_result();
  54. $log_data = $log_result->fetch_row();
  55. $log_query->close();
  56. unset($_GET['insert']);
  57. unset($_GET['id']);
  58. $file = fopen('C:\Users\HP\Desktop\logs.txt', 'a');
  59. $datetime = date("d.m.Y H:i:s");
  60. fwrite($file, '[' . $datetime . ']' . ' - Zvíře ' . $log_data[1] . ' (' . $log_data[2] . ')' . ' bylo svěřeno do ošetrování ošetrovateli ' . $log_data[0] . "\n");
  61. fclose($file);
  62. } elseif (isset($_GET['delete'])) {
  63. $log_query = $link->prepare("SELECT osetrovatele.jmeno, zvirata.jmeno, druhy.nazev FROM osetrovatele JOIN osetruje ON osetrovatele.id = osetruje.osetrovatel JOIN zvirata ON zvirata.id = osetruje.zvire JOIN druhy ON druhy.id = zvirata.druh WHERE osetruje.osetrovatel = ? AND osetruje.zvire = ?");
  64. $log_query->bind_param('ii', $_GET['id'], $_GET['delete']);
  65. $log_query->execute();
  66. $log_result = $log_query->get_result();
  67. $log_data = $log_result->fetch_row();
  68. $log_query->close();
  69. $deletion = $link->prepare("DELETE FROM osetruje WHERE osetruje.osetrovatel = ? AND osetruje.zvire = ?");
  70. $deletion->bind_param('ii', $_GET['id'], $_GET['delete']);
  71. $deletion->execute();
  72. $deletion->close();
  73. unset($_GET['delete']);
  74. unset($_GET['id']);
  75. $file = fopen('C:\Users\HP\Desktop\logs.txt', 'a');
  76. $datetime = date("d.m.Y H:i:s");
  77. fwrite($file, '[' . $datetime . ']' . ' - Zvíře ' . $log_data[1] . ' (' . $log_data[2] . ')' . ' bylo odebráno ošetrovateli ' . $log_data[0] . "\n");
  78. fclose($file);
  79. }
  80. ?>
  81. <table width="100%" border="5">
  82. <tr>
  83. <th>Ošetrovatel</th>
  84. <th>Koho zatím neošetruje</th>
  85. <th>Koho již ošetruje</th>
  86. </tr>
  87. <?php
  88. $name = $_GET['name'];
  89. $find_osetrovatel_query = $link->prepare("SELECT id, jmeno FROM `osetrovatele` WHERE jmeno LIKE CONCAT('%', ?, '%') ORDER BY jmeno LIMIT 100");
  90. $find_osetrovatel_query->bind_param('s', $name);
  91. $find_osetrovatel_query->execute();
  92. $find_osetrovatel_result = $find_osetrovatel_query->get_result();
  93. $find_osetrovatel_query->close();
  94. $result = 0;
  95. $select_neosetrovany_query = $link->prepare("SELECT z.id, z.jmeno, d.nazev FROM zvirata AS z JOIN druhy AS d ON z.druh = d.id LEFT JOIN osetruje AS o ON z.id = o.zvire AND o.id = ? WHERE o.id IS NULL ORDER BY z.jmeno");
  96. $select_osetrovany_query = $link->prepare("SELECT z.id, z.jmeno FROM `zvirata` AS z JOIN osetruje AS o ON (o.zvire = z.id) WHERE o.osetrovatel = ? ORDER BY z.jmeno");
  97. while ($row1 = $find_osetrovatel_result->fetch_row()) {
  98. ?>
  99. <tr>
  100. <td>
  101. <?php
  102. echo $row1[1];
  103. ?>
  104. </td>
  105. <td>
  106. <form action="/animal_insertion.php" method="GET">
  107. <input type="hidden" name="name" value="<?php echo $name ?>">
  108. <input type="hidden" name="id" value="<?php echo $row1[0] ?>">
  109. <select name="insert">
  110. <?php
  111. //$time_query_start = microtime(true);
  112. $select_neosetrovany_query->bind_param('i', $row1[0]);
  113. $select_neosetrovany_query->execute();
  114. $select_neosetrovany_result = $select_neosetrovany_query->get_result();
  115. while ($row2 = $select_neosetrovany_result->fetch_row()) {
  116. ?>
  117. <option value="<?php echo $row2[0] ?>"><?php echo utf8_encode($row2[1] . " (" . $row2[2] . ")") ?></option>
  118. <?php
  119. }
  120. ?>
  121. </select>
  122. <input type="submit" value="Přidat">
  123. </form>
  124. </td>
  125. <td>
  126. <?php
  127. $select_osetrovany_query->bind_param('i', $row1[0]);
  128. $select_osetrovany_query->execute();
  129. $select_osetrovany_result = $select_osetrovany_query->get_result();
  130. while ($row3 = $select_osetrovany_result->fetch_row()) {
  131. ?>
  132. <form action="/animal_insertion.php" method="GET"><?php echo utf8_encode($row3[1]) ?>
  133. <input type="hidden" name="name" value="<?php echo $name ?>">
  134. <input type="hidden" name="delete" value="<?php echo $row3[0] ?>">
  135. <input type="hidden" name="id" value="<?php echo $row1[0] ?>">
  136. <input type="submit" value="Odebrat">
  137. </form>
  138. <?php } ?>
  139. </td>
  140. </tr>
  141. <?php }
  142. $select_neosetrovany_query->close();
  143. $select_osetrovany_query->close();
  144. ?>
  145. </table>
  146. <?php }
  147. echo "Stránka vygenerována za " . (microtime(true) - $time_start_global) . " ms";
  148. ob_end_flush() ?>
  149. </body>
  150. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!