<?php
    $servername = server;
    $username = username;
    $password = password;
    $dbname = databasename;

    $conn = new mysqli($servername, $username, $password, $dbname);

    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }
    else {
        echo "It worked!<br/><br/>";
    }

    if(mysqli_ping($conn) != null) {
        echo "Connection is open!<br/><br/>";

        $sql = "CALL GetUserTypes";

        $result = $conn->query("$sql");


        if ($result != null) {
            $i = 0;
            $row = mysqli_fetch_row($result);

            while ($row = $result->fetch_assoc()) {
                echo '<p>' . $row['id']. "      " . $row['type'] . '</p>';
                $i++;
            }
        }
        elseif (is_null($result)) {
            echo "Something broke...<br/>";
        }
        else {
            echo "Query did not work...<br/>";
        }

        $con->close();

    else {
        echo "No connection...";
    }
    ?>