PHP MYSQL HTML

SAVE HTML FORM INTO DATABASE

(quick guide & example)

SIMPLE "SURVEY" TABLE email | VARCHAR PRIMARY KEY name | VARCHAR color | VARCHAR

DATABASE TABLE

01

HTML FORM

02

<form method="post" action="save.php">   <input type="email" name="email">     <input type="text" name="name">    <input type="text" name="color">    <input type="submit" value="Go!"> </form>

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

PHP SAVE INTO DATABASE

03

INSERT INTO DATABASE $stmt = $pdo->prepare("INSERT INTO `survey`(`email`, `name`, `color`) VALUES (?, ?, ?)"); $stmt->execute([$_POST["email"], $_POST["name"], $_POST["color"]]);