PHP MYSQL HTML
(quick guide & example)
SIMPLE "SURVEY" TABLE email | VARCHAR PRIMARY KEY name | VARCHAR color | VARCHAR
<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);
INSERT INTO DATABASE $stmt = $pdo->prepare("INSERT INTO `survey`(`email`, `name`, `color`) VALUES (?, ?, ?)"); $stmt->execute([$_POST["email"], $_POST["name"], $_POST["color"]]);