Persist message

gistfile1.php

<?php
  //start a session -- needed for Securimage Captcha check
  session_start();

  //add you e-mail address here
  define("MY_EMAIL", "jmb@jonbake.com");
  define("EMAIL_SUBJECT", "Feedback Form Results");

  //a map of fields to include in email, along with if they are required or not
  //aparently in PHP, arrays (maps) can't be constants?
  $fields_req =  array("name" => true, "title" => false, "company" => false, "company" => false,
    "website" => false, "phone" => true, "message" => true);

  /**
   * Sets error header and json error message response.
   *
   * @param  String $messsage error message of response
   * @return void
   */
  function errorResponse ($messsage) {
    header('HTTP/1.1 500 Internal Server Error');
    die(json_encode(array('message' => $messsage)));
  }

  /**
   * Pulls posted values for all fields in $fields_req array.
   * If a required field does not have a value, an error response is given.
   *
   * @param [Array] $fields_req a map of field name to required
   */
  function setMessageBody ($fields_req) {
    $message_body = "";
    foreach ($fields_req as $name => $required) {
      if ($required && empty($name)) {
        errorResponse("$name is empty.");
      } else {
        $message_body .= ucfirst($name) . ":  " . $_POST[$name] . "\n";
      }
    }
    return $message_body;
  }

  function persistMessage ($msgBody, $address) {
    $db_handle = new mysqli('127.0.0.1', 'jbake', 'pass', 'feedback');

    /* check connection */
    if (mysqli_connect_errno()) {
      errorResponse(sprintf("Connect failed: %s\n", mysqli_connect_error()));
    }

    /* prepare and execute insert statement */
    $stmt = $db_handle->prepare("INSERT INTO emails VALUES (?, ?)");
    $stmt->bind_param('ss', $msgBody, $address);
    $stmt->execute();
  
    if ($stmt->error) {
      errorResponse(sprintf("Error while executing statement: %s\n", $stmt->error));
    }

    /* close statement and connection */
    $stmt->close();
    $db_handle->close();
    return true;
  }

  $email = $_POST['email']; 

  header('Content-type: application/json');
  //do some simple validation. this should have been validated on the client-side also
  if (empty($email)) {
  	errorResponse('Email or message is empty.');
  }

  //do Captcha check, make sure the submitter is not a robot:)...
  include_once './vender/securimage/securimage.php';
  $securimage = new Securimage();
  if (!$securimage->check($_POST['captcha_code'])) {
    errorResponse('Invalid Security Code');
  }

  //try to send the message
  persistMessage(setMessageBody($fields_req), $email);
  if(mail(MY_EMAIL, EMAIL_SUBJECT, setMessageBody($fields_req), "From: $email")) {
  	echo json_encode(array('message' => 'Your message was successfully submitted.'));
  } else {
  	header('HTTP/1.1 500 Internal Server Error');
  	echo json_encode(array('message' => 'Unexpected error while attempting to send e-mail.'));
  }
?>