<?php
//20181210 - Connect to DB using variables declared above, otherwise error - Rachel
//20181210 -  Declared $DBH as the web database - Rachel
//20190701 - Added settings for xampp. - Gael

try {

   //Neil 20171107 - added lamp details
    // $host = "localhost";
    // $user = "sabullio_dev";
    // $pass = "vUC=6DJDzb59";
    // $dbname = "sabullio_sabulli1_web_db";

   switch($_SERVER["SERVER_NAME"])
   {
      //20190701 - Added settings for xampp. - Gael
      case "localhost":
         $hostname = "localhost";
         $username = "root";
         $password = "";
         $database = "sabullio_accessdb";

         $hostname_web = "localhost";
         $username_web = "root";
         $password_web = "";
         $database_web = "sabulli1_web_db";
         break;
      case "lamp":
         $hostname = "lamp";
         $username = "root";
         $password = "123ert";
         $database = "sabullio_accessDB";

         $hostname_web = "lamp";
         $username_web = "root";
         $password_web = "123ert";
         $database_web = "sabullio_sabulli1_web_db";
         break;

      case "dev.overdrive.co.za":
         //20181211 - PHP7 Conversion issue - Change hostname from localhost to actual DB host - Rachel
      // SQLSTATE[HY000] [2002] No such file or directory
      // $hostname = "41.185.64.177";
      // $username = "sabullio_nadier";
      // $password = "hB!HMls]1Kax";
      // $database = "sabullio_accessDB";

      // $hostname_web = "41.185.64.177"; 
      // $username_web = "sabullio_dev";
      // $password_web = "vUC=6DJDzb59";
      // $database_web = "sabullio_sabulli1_web_db";

      $hostname = "sql8.jnb1.host-h.net";
      $username = "devovvbypb_9";
      $password = "A9nGn5SskY7Jti3P85eZ";
      $database = "sa_bullion";

      $hostname_web = "sql38.jnb1.host-h.net"; 
      $username_web = "devovvbypb_11";
      $password_web = "h1w55LeY1a87b5K7d48L";
      $database_web = "sabulli1_web_db";
         break;

      case "sabullion.overdriveqa.co.za";
         $hostname = "sql26.cpt3.host-h.net";//"sql26.cpt3.host-h.net";
         $username = "sabulakceb_2";
         $password = "3no8Kl6FP41H85v4Y63Q";
         $database = "sab_accessDB_2018";

         $hostname_web = "sql26.cpt3.host-h.net";//"sql26.cpt3.host-h.net"; 
         $username_web = "sabulakceb_1";
         $password_web = "i44uqmieaAwt2tpPLdD8";
         $database_web = "sabulli1_web_db";
         break;

    case "sabullion-staging.overdriveqa.co.za";
      $hostname = "sql29.cpt3.host-h.net";//"sql26.cpt3.host-h.net";
      $username = "sabulakceb_4";
      $password = "5sRf1vZMeX0ql6fG93Yy";
      $database = "sabullio_accessDB";

      $hostname_web = "sql26.cpt3.host-h.net";//"sql26.cpt3.host-h.net"; 
      $username_web = "sabulakceb_1";
      $password_web = "g8d5z9SCyRysBmn9kN4m";
      $database_web = "sabulli1_web_db";
      break;

      case "sabullion.co.za":
         $hostname = "dedi773.jnb3.host-h.net";
         $username = "sabulydmyt_2";
         $password = "hB!HMls]1Kax";
         $database = "sabullio_accessDB";

         $hostname_web = "dedi773.jnb3.host-h.net";
         $username_web = "sabulydmyt_3";
         $password_web = "hB!HMls]1Kax";
         $database_web = "sabullio_web_db";
         break;
   }


   # MySQL with PDO_MYSQL
   //20181210 - Connect to DB using variables declared above, otherwise error - Rachel
   //PHP7 needs password to connect
   // $SA = new PDO("mysql:host=$host;dbname=$dbname", $user, $pass);

   $SA = new PDO("mysql:host=$hostname;dbname=$database", $username, $password);
   $SA->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // <== add this line

//20181210 -  Declared $DBH as the web database - Rachel

  $DBH = new PDO("mysql:host=$hostname_web;dbname=$database_web", $username_web, $password_web);
  $DBH->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // <== add this line

}
catch(PDOException $e) {
    echo $e->getMessage();
}

?>