<?php
                // Connect to the database
                $username="root";$password="test";$database="products";

                // Connect to the MySQL server and select the required database
                $connection = new mysqli("localhost",$username,$password, $database);

                $sql = "";

                $sql = "SELECT * FROM products";

                $ID = isset($row['ID']) ? $row['ID'] : '';{
                $query = mysqli_query($connection, "DELETE FROM products WHERE ID=$ID");
                }

                $result = $connection->query($sql);

                if ($result->num_rows > 0) {
                    while ($row = $result->fetch_assoc()) {
                        echo "<tr>n";
                        echo "<td>" . $row['Name'] . "</td>n";
                        echo "<td>" . $row['Description'] . "</td>n";
                        echo "<td>" . $row['Price'] . "</td>n";
                        echo "<td>" . $row['Cost_Price'] . "</td>n";
                        echo "<td>" . $row['Stock'] . "</td>n";
                        echo "<td>" . $row['EAN'] . "</td>n";
                        ?>
                        <td><a href="?mode=delete&ID=<?php echo $row["ID"]; ?>"
                           title="Delete <?php echo $row["ID"]; ?>">Delete</a></td>
                        <?php

                        echo "</tr>n";
                    }
                }

            $stmt = $connection->prepare('SELECT * FROM products WHERE name = ?');
            $stmt->bind_param('s', $name);

            $stmt->execute();

            $result = $stmt->get_result();

            $connection->close();

                ?>