Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // 1 plik
- $hostName = 'localhost';
- $userName = 'root';
- $password = 'coderslab';
- $dataBase = 'exercises_db';
- $conn = new mysqli($hostName, $userName, $password, $dataBase);
- if ($conn->connect_error) {
- die("Connection Error! " . $conn->connect_error);
- }
- $sql = "SELECT * FROM product";
- $result = $conn->query($sql);
- foreach ($result as $product) {
- echo("nazwa: " . $product["name"]) . " opis: " . $product["description"] . " cena: " . $product["price"] . "<br>";
- echo "<a href='delete.php?id= $product[id]&tablica=product'>Delete " . $product["name"] . "</a> <br>";
- }
- $conn->close();
- // 2 plik
- <?php
- $hostName = 'localhost';
- $userName = 'root';
- $password = 'coderslab';
- $dataBase = 'exercises_db';
- $conn = new mysqli($hostName, $userName, $password, $dataBase);
- if ($conn->connect_error) {
- die("Connection Error! " . $conn->connect_error);
- }
- $tabela =($_GET['tablica']);
- $id =($_GET['id']);
- $sql = "DELETE FROM $tabela WHERE $id";
- $result = $conn->query($sql);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement