GA Programming for Non-programmers POST Form Handler

post-form-handler.php

<?php
  $servername = "example.org";
  $database = "your_db_name";
  $username = "your_username";
  $password = "your_password";

  try {
    $conn = new PDO("mysql:host=$servername;dbname=$database", $username, $password);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    /* INSERT */
    $sql = "INSERT INTO users (first_name, last_name, email, bio)
    VALUES (:first_name, :last_name, :email, :bio)";

    $prep = $conn->prepare($sql);
    $prep->execute(array(
      ':first_name' => $_POST['first_name'],
      ':last_name' => $_POST['last_name'],
      ':email' => $_POST['email'],
      ':bio' => $_POST['bio']
    ));

    echo "New record created successfully";
  } catch(PDOException $error) {
      echo "Connection failed: " . $error->getMessage();
  }
?>