Advertisement
Guest User

Untitled

a guest
Jan 24th, 2020
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.53 KB | None | 0 0
  1. if(isset($_POST['saugoti'])) {
  2. $pavadinimas = $_POST['paieskosTerminas'];
  3. try {
  4. $conn = new mysqli($host, $username, $password, $db);
  5. if ($conn) {
  6. try {
  7. $sql = "SELECT * FROM filmai WHERE pavadinimas LIKE '$pavadinimas'";
  8. var_dump($sql);
  9. $result = $conn->query($sql);
  10. if ($result->num_rows > 0) {
  11. ?>
  12. <table class="table table-bordered">
  13. <tr>
  14. <td>ID</td>
  15. <td>Pavadinimas</td>
  16. <td>Režisierius</td>
  17. <td>Metai</td>
  18. <td>Reitingas</td>
  19. <td>Aprašymas</td>
  20. <td>Žanras</td>
  21. </tr>
  22. <tr>
  23. <?php
  24. $row = $result->fetch_assoc();
  25. foreach ($row as $row1) {
  26. echo "<td>" . $row1 . "</td>";
  27. }
  28. ?>
  29. </tr>
  30. </table>
  31. <?php
  32. } else {
  33. echo "<h2>" . "Rezultatu Nerasta" . "</h2>";
  34. }
  35. } catch (PDOException $e) {
  36. echo $e->getMessage();
  37. }
  38. }
  39. } catch (PDOException $e) {
  40. echo $e->getMessage();
  41. }
  42. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement