AleksandarH

Y2S2 - MySQLi/PHP (delete.php)

May 15th, 2022 (edited)
287
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.80 KB | None | 0 0
  1. <?php
  2. include "config.php";
  3. $query = "SELECT * FROM books WHERE publisher = 'Просвета'";
  4. $result = mysqli_query($dbConn, $query);
  5. $count = mysqli_num_rows($result);
  6. if ($count > 0)
  7. {
  8.     echo "<table border'2'><tr><th>Номер</th><th>Заглавие</th><th>Автор></th><th>Издателство</th><th>Година на издаване</th></tr";
  9.     while ($row = mysqli_fetch_array($result))
  10.     {
  11.         echo "<bd><tr><td>" . $row['id'] . "</td><td>" . $row['title'] . "</td><td>" . $row['author'] . "</td><td>" . $row['publisher'] . "</td><td>" . $row['year'] . "</td></tr>";
  12.     }
  13.     echo "<tr><td align='center' colspan='5'><a href='delete1.php'>Изтриване</a></td></tr></table>";
  14. }
  15. else
  16. {
  17.     echo "Няма книги от издателство: Просвета";
  18. }
Add Comment
Please, Sign In to add comment