<?php
//20190614 - created db connection file - trevor
include_once('projectfunctions.php');

//print_rr($_SERVER);

$serverHost = "";
$userName ="";
$password="";
$dbName="";

switch ($_SERVER["SERVER_NAME"]) {
  case 'localhost':
    $serverHost = "localhost";
    $userName ="root";
    $password="Vodacom@25";
    $dbName="db_clientmodule";
    break;

  case 'lamp':
  default:
    $serverHost = "lamp";
    $userName ="root";
    $password="123ert";
    $dbName="db_clientmodule";
    break;
}


// Create connection
$conn = new mysqli($serverHost, $userName, $password, $dbName);

// Check connection
if ($conn->connect_error == true ) {
    die("Connection failed: " . $conn->connect_error);
}else {
  print_r("connection successful \n");
}

//$conn->close();

// $con = mysql_connect("localhost","root","Vodacom@25","client_module");
// if (!$con)
//   {
//     die('Could not connect: ' . mysql_error());
//   }
//   mysql_select_db("client_module", $con);
//   $sql="INSERT INTO clients (FirstName, LastName,SAID)
// VALUES
// ('$_POST[FirstName]','$_POST[LastName]','$_POST[SAID]')";
// if (!mysql_query($sql,$con))
//   {
//   die('Error: ' . mysql_error());
//   }
// echo "1 record added";
// mysql_close($con)
?>