<?php // config.php - File containing database connection settings $servername = "localhost"; $username = "root"; $password = ""; $dbname = "mydatabase"; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } // search.php - File that handles user input and executes SQL query $search_term = $_GET['q']; if ($stmt = $conn->prepare("SELECT id, name FROM mytable WHERE name LIKE ?")) { $param = "%$search_term%"; $stmt->bind_param("s", $param); $stmt->execute(); $stmt->bind_result($id, $name); while ($stmt->fetch()) { echo "id: $id - Name: $name<br>"; } $stmt->close(); } else { echo "0 results"; } $conn->close(); ?>