<?php
  /*
   * Week 9: PHP and SQL Connections
   * Configuration/common file for the Bricker and Morter Store API 
   */

  # These two statements are needed to properly set strict error-reporting on MAMP servers
  error_reporting(E_ALL);
  ini_set('display_errors', 1);

  /**
   * Returns a PDO object connected to the bmstore database. Throws
   * a PDOException if an error occurs when connecting to database.
   * @return {PDO}
   */
  function get_PDO() {
    # Variables for connections to the database. 
    $host =  "localhost";
    $port = "8889"; # Make sure this matches your server (e.g. MAMP) port
    $user = "root";
    $password = "root";
    $dbname = "bmstore";

    # Make a data source string that will be used in creating the PDO object
	  $ds = "mysql:host={$host}:{$port};dbname={$dbname};charset=utf8";

    try {
      $db = new PDO($ds, $user, $password);
      $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
      return $db;
    } catch (PDOException $ex) {
      handle_error("Can not connect to the database. Please try again later.", $ex);
    }
  }

  /**
   * Prints out a plain text 400 error message given $msg. If given a second (optional) argument as
   * an PDOException, prints details about the cause of the exception.
   * @param $msg {string} - Plain text 400 message to output
   * @param $ex {PDOException} - (optional) Exception object with additional exception details 
   */
  function handle_error($msg, $ex=NULL) { 
    # in practice, 503 is a better database (internal) error code, but we only ask you to
    # use 400 for the scope of this course
    header("HTTP/1.1 400 Invalid Request"); 
    header("Content-type: text/plain");
    if ($ex) {
      # Note that in practice, you probably don't want to print details about your
      # database errors in a response to a client. But for testing your code, this can
      # help pinpoint bugs in your PDO functions/database connections.
      echo ("Error details: $ex \n");
    }
    die ("{$msg}\n");
  }
    
?>