Advertisement
AleksandarH

Y2S2 - MySQLi/PHP (delete1.php)

May 15th, 2022
1,011
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.57 KB | None | 0 0
  1. <?php
  2. include "config.php";
  3. $query = "DELETE FROM books WHERE publisher = 'Просвета'";
  4. mysqli_query($dbConn, $query);
  5. $query = "SELECT * FROM books";
  6. $result = mysqli_query($dbConn, $query);
  7. if ($result)
  8. {
  9.     echo "<ul>";
  10.     while ($row = mysqli_fetch_array($result))
  11.     {
  12.         echo "<il>" . $row['title'] . ", " . $row['author'] . ", " . $row['publisher'] . ", " . $row['year'] . "</li>";
  13.     }
  14.     echo "</ul>";
  15. }
  16. else
  17. {
  18.     echo "Няма налични данни!";
  19. }
  20. echo "<br><br><a href ='index.php'>Начална страница</а>";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement