*************

PHP code: Copy Format Clear

<?php <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Product Search</title> </head> <body> <h2>Product Search</h2> <form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>" method="GET"> <label for="product_id">Enter Product ID:</label> <input type="text" id="product_id" name="product_id"> <button type="submit">Search</button> </form> <?php // Check if form is submitted if ($_SERVER["REQUEST_METHOD"] == "GET" && isset($_GET['product_id'])) { $product_id = $_GET['product_id']; // Prepare SQL query $sql = "SELECT * FROM products WHERE id = $product_id"; // Execute SQL query $result = mysqli_query($conn, $sql); if (mysqli_num_rows($result) > 0) { // Output data of each row while ($row = mysqli_fetch_assoc($result)) { echo "Product ID: " . $row["id"] . "<br>"; echo "Product Name: " . $row["name"] . "<br>"; echo "Product Price: " . $row["price"] . "<br>"; // Add more fields as needed } } else { echo "No product found with ID: $product_id"; } // Close connection mysqli_close($conn); } ?> </body> </html>

PHP version:

Show: Warnings Notice

Result: Copy Clear

PHPize Online / SQLize Online / SQLtest Online