<?php

$servername = "108.174.148.87";
$username = "noduccom_treedat";
$password = "YXC2b!S0L#YgVjHC";


    try {
        $db = new PDO("mysql: host=$servername;dbname=noduccom_treedat", $username, $password);
        $db -> setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        echo "Connected successfully";

    } catch (PDOException $e) {
        echo "unable to connect" . " " . $e->getMessage();
        exit;
    }

    try {
        $db->query("SELECT title, category FROM Media");
    } catch (Exception $e) {
        echo "Bad query";
    }

?>