Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2017
143
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.97 KB | None | 0 0
  1. // 1 plik
  2.  
  3. $hostName = 'localhost';
  4. $userName = 'root';
  5. $password = 'coderslab';
  6. $dataBase = 'exercises_db';
  7. $conn = new mysqli($hostName, $userName, $password, $dataBase);
  8.  
  9. if ($conn->connect_error) {
  10. die("Connection Error! " . $conn->connect_error);
  11. }
  12.  
  13. $sql = "SELECT * FROM product";
  14. $result = $conn->query($sql);
  15.  
  16. foreach ($result as $product) {
  17. echo("nazwa: " . $product["name"]) . " opis: " . $product["description"] . " cena: " . $product["price"] . "<br>";
  18. echo "<a href='delete.php?id= $product[id]&tablica=product'>Delete " . $product["name"] . "</a> <br>";
  19. }
  20.  
  21. $conn->close();
  22.  
  23. // 2 plik
  24.  
  25. <?php
  26.  
  27. $hostName = 'localhost';
  28. $userName = 'root';
  29. $password = 'coderslab';
  30. $dataBase = 'exercises_db';
  31. $conn = new mysqli($hostName, $userName, $password, $dataBase);
  32.  
  33. if ($conn->connect_error) {
  34. die("Connection Error! " . $conn->connect_error);
  35. }
  36.  
  37. $tabela =($_GET['tablica']);
  38. $id =($_GET['id']);
  39.  
  40.  
  41.  
  42. $sql = "DELETE FROM $tabela WHERE $id";
  43.  
  44. $result = $conn->query($sql);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement