<?

function showCust(){
    $servername = getenv('IP');
    $username = getenv('C9_USER');
    $password = "";
    $database = "c9";
    $dbport = 3306;
    $con = new mysqli($servername, $username, $password, $database, $dbport);
    if ($con->connect_error) {
        die("Connection failed: " . $con->connect_error);
    }
    $result = mysqli_query($con,"SELECT * FROM CUSTOMERS");
    echo "<table><tr><th>ID</th><th>First Name</th><th>Surname</th><th>Address</th><th>Phone</th></tr>";
    while($row = mysqli_fetch_array($result)) {
        echo "<tr><td>".$row["CUSTID"]."</td><td>".$row["FIRSTNAME"]."</td><td>".$row["LASTNAME"]."</td><td>".$row["ADDRESS"]."</td><td>".$row["PHONE"]."</td>";
    }
}

function loadProducts($searchTerm) {
    $servername = getenv('IP');
    $username = getenv('C9_USER');
    $password = "";
    $database = "c9";
    $dbport = 3306;
    $con = new mysqli($servername, $username, $password, $database, $dbport);
    if($searchTerm != null) {
        $result = mysqli_query($con,"SELECT * FROM PRODUCTS WHERE BRAND LIKE '%$searchTerm%' OR MODEL LIKE '%$searchTerm%' OR PRICE LIKE '%$searchTerm%'");
    } else {
        $result = mysqli_query($con,"SELECT * FROM PRODUCTS");
    }
    while($row = mysqli_fetch_array($result)) {
        echo '<div id="content"><div id="product"><div id="product-img"><img src="../images/' . $row['IMAGE'] . '"></div><div id="product-button">Buy Now</div><div id="product-brand"><a>' . $row['BRAND'] . '</a></div><div id="product-model"><a>' . $row['MODEL'] . '</a></div><div id="product-price"><a>$' . $row['PRICE'] . '</a></div></div></div>';
    }
}

function addCust($id, $firstname, $lastname, $address, $phone) {
    $servername = getenv('IP');
    $username = getenv('C9_USER');
    $password = "";
    $database = "c9";
    $dbport = 3306;
    $con = new mysqli($servername, $username, $password, $database, $dbport);
    if($firstname != null and $lastname != null and $address != null and $phone != null) {
        $result = mysqli_query($con,"INSERT INTO CUSTOMERS VALUES ('$id', '$firstname', '$lastname', '$address', '$phone')");
    }
}

?>