PHP MYSQL

SEARCH & DISPLAY RESULTS FROM DATABASE

(quick guide & example)

ID          | NAME   | EMAIL   |

DUMMY USERS TABLE

01

INTEGER PRIMARY VARCHAR VARCHAR

<form method="post">   <input type="text" name="search">   <input type="submit" value="Search"> </form>

HTML SEARCH FORM

02

CONNECT TO DATABASE $pdo = new PDO("mysql:host=HOST; dbname=NAME;charset=utf8mb4", USER, PASSWORD);

PHP-MYSQL SEARCH (A)

03

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>"; }

PHP-MYSQL SEARCH (B)

03