code-boxx · August 18, 2023 02:36 · equiline · Aug 14, 2023 · code-boxx · Aug 18, 2023
diff --git a/0-PHP-SAVE-FORM-MYSQL.MD b/0-PHP-SAVE-FORM-MYSQL.MD
diff --git a/1-dummy.sql b/1-dummy.sql
 CREATE TABLE `survey` (
  `email` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `color` varchar(128) NOT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 ALTER TABLE `survey`
  ADD PRIMARY KEY (`email`);
diff --git a/2-form.php b/2-form.php
 <!DOCTYPE html>
 <html>
  <head>
    <meta charset="utf-8">
    <title>Favorite Color Survey</title>
    <link rel="stylesheet" href="x-dummy.css">
  </head>
  <body>
    <?php
    // (A) SAVE SURVEY FORM ON SUBMIT
    if (isset($_POST["email"])) { require "3-save.php"; }
    ?>

    <!-- (B) SURVEY FORM -->
    <form method="post">
      <label>Email</label>
      <input type="email" name="email" required>
      <label>Name</label>
      <input type="text" name="name" required>
      <label>Favorite Color</label>
      <input type="text" name="color" required>
      <input type="submit" value="Go!">
    </form>
  </body>
 </html>
diff --git a/3-save.php b/3-save.php
 <?php
 // (A) DATABASE CREDENTIALS - CHANGE TO YOUR OWN!
 define("DB_HOST", "localhost");
 define("DB_NAME", "test");
 define("DB_CHARSET", "utf8mb4");
 define("DB_USER", "root");
 define("DB_PASSWORD", "");

 // (B) CONNECT TO DATABASE
 $pdo = new PDO(
  "mysql:host=".DB_HOST.";charset=".DB_CHARSET.";dbname=".DB_NAME,
  DB_USER, DB_PASSWORD, [
  PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
  PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
 ]);

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

 /* (X) SEND EMAIL
 $message = "";
 foreach ($_POST as $k=>$v) { $message .= "$k : $v\r\n"; }
 mail("[email protected]", "Survey Received", $message);
 */

 // (D) RESULTS
 echo "OK";
diff --git a/x-dummy.css b/x-dummy.css
 /* (X) NOT IMPORTANT - COSMETICS */
 * {
  font-family: Arial, Helvetica, sans-serif;
  box-sizing: border-box;
 }
 form {
  width: 400px;
  padding: 20px;
  border: 1px solid #f1f1f1;
  background: #f5f5f5;
 }
 label, input {
  display: block;
  width: 100%;
 }
 label { margin: 10px 0; }
 label:first-child { margin-top: 0; }
 input {
  border: 1px solid #e7e7e7;
  padding: 10px;
 }
 input[type=submit] {
  margin-top: 20px;
  border: 0;
  color: #fff;
  background: #1766c9;
  cursor: pointer;
 }
	CREATE TABLE `survey` (
	`email` varchar(255) NOT NULL,
	`name` varchar(255) NOT NULL,
	`color` varchar(128) NOT NULL
	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

	ALTER TABLE `survey`
	ADD PRIMARY KEY (`email`);
	<!DOCTYPE html>
	<html>
	<head>
	<meta charset="utf-8">
	<title>Favorite Color Survey</title>
	<link rel="stylesheet" href="x-dummy.css">
	</head>
	<body>
	<?php
	// (A) SAVE SURVEY FORM ON SUBMIT
	if (isset($_POST["email"])) { require "3-save.php"; }
	?>

	<!-- (B) SURVEY FORM -->
	<form method="post">
	<label>Email</label>
	<input type="email" name="email" required>
	<label>Name</label>
	<input type="text" name="name" required>
	<label>Favorite Color</label>
	<input type="text" name="color" required>
	<input type="submit" value="Go!">
	</form>
	</body>
	</html>
	<?php
	// (A) DATABASE CREDENTIALS - CHANGE TO YOUR OWN!
	define("DB_HOST", "localhost");
	define("DB_NAME", "test");
	define("DB_CHARSET", "utf8mb4");
	define("DB_USER", "root");
	define("DB_PASSWORD", "");

	// (B) CONNECT TO DATABASE
	$pdo = new PDO(
	"mysql:host=".DB_HOST.";charset=".DB_CHARSET.";dbname=".DB_NAME,
	DB_USER, DB_PASSWORD, [
	PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
	PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
	]);

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

	/* (X) SEND EMAIL
	$message = "";
	foreach ($_POST as $k=>$v) { $message .= "$k : $v\r\n"; }
	mail("[email protected]", "Survey Received", $message);
	*/

	// (D) RESULTS
	echo "OK";
	/* (X) NOT IMPORTANT - COSMETICS */
	* {
	font-family: Arial, Helvetica, sans-serif;
	box-sizing: border-box;
	}
	form {
	width: 400px;
	padding: 20px;
	border: 1px solid #f1f1f1;
	background: #f5f5f5;
	}
	label, input {
	display: block;
	width: 100%;
	}
	label { margin: 10px 0; }
	label:first-child { margin-top: 0; }
	input {
	border: 1px solid #e7e7e7;
	padding: 10px;
	}
	input[type=submit] {
	margin-top: 20px;
	border: 0;
	color: #fff;
	background: #1766c9;
	cursor: pointer;
	}