<?php

$host='52.40.52.130:3306';
$user='root';
$password='sitem123!';

$connection = mysqli_connect($host,$user,$password, "AromaDB");

$CustName = $_POST["CName"];
$CustSurname = $_POST['CSurn'];
$CustCellphone = $_POST['CCell'];
$CustEmail = $_POST["CEmail"];
$CustPoint = 0;
$CustCredit = 0;



if(!$connection){
    die('Connection Failed');
}
else {
    //$dbconnect = @mysqli_select_db($connection,'AromaDB');


    //if(!$dbconnect){
        //die('Could not connect to Database');
    //}
    //else{
        $sql = "INSERT INTO Customer (CName, CSurname, CCellphone, CEmail, CPoint_Total, CCredit_Total) VALUES ('"
            . $CustName . "', '" . $CustSurname . "', '" . $CustCellphone . "', '" . $CustEmail . "', " . $CustPoint . ", " . $CustCredit . ");";
        $Cust = mysqli_query($connection, $sql) or die(mysql_error());

        //$Cust = mysql_query("CALL sp_Insert_Customer('$CustName','$CustSurname','$CustCellphone','$CustEmail',$CustPoint,$CustCredit);") or die(mysql_error());


        echo 'Customer Successfully added.';
        mysqli_close($connection);
        //echo $Cust;
    //}
}