<?php
function connectToDatabase()
{
    global $pdo;
    $serverIp = "localhost";
    $databaseName = "x";
    $username = "x";
    $password = "!";
    $pdo = new PDO("mysql:host=".$serverIp.";dbname=".$databaseName.";ConnectionPooling=0",   $username, $password, array(
        PDO::ATTR_EMULATE_PREPARES=>false,
        PDO::MYSQL_ATTR_DIRECT_QUERY=>false,
        PDO::ATTR_ERRMODE=>PDO::ERRMODE_EXCEPTION
    ));
}


function getProductTypes()
{
    global $pdo;
    $data = $pdo->query("SELECT type, icon FROM product_types");
    return $data->fetchAll();;
}



function getProducts($type)
{
    global $pdo;
    $data = $pdo->prepare ("SELECT id, naam, prijs, informatie, type FROM producten WHERE type = ?");
    $data -> execute(array($type));
    return $data->fetchAll();;
}
?>