PHP MYSQL
(quick guide & example)
ID | NAME | EMAIL |
INTEGER PRIMARY VARCHAR VARCHAR
<form method="post"> <input type="text" name="search"> <input type="submit" value="Search"> </form>
CONNECT TO DATABASE $pdo = new PDO("mysql:host=HOST; dbname=NAME;charset=utf8mb4", USER, PASSWORD);
SEARCH DATABASE $stmt = $pdo->prepare("SELECT * FROM `users` WHERE `name` LIKE ? OR `email` LIKE ?"); $stmt->execute(["%".$_POST["search"]."%", "%".$_POST["search"]."%"]); $results = $stmt->fetchAll();
OUTPUT RESULTS foreach ($results as $r) { echo "<div>{$r["NAME"]} {$r["EMAIL]}"</div>"; }