<link rel="stylesheet" property="stylesheet" type="text/css"
href="css/stylesheet.css">
<?php
session_name('Website');
session_start();
$dbuser = 'hgolmaeq';
$dbpass = 'mir20E90mJCkD49TkhCBjndqAMXdFZq9';
$host = 'qdjjtnkv.db.elephantsql.com';
$dbname = 'hgolmaeq';
try {
 $conn = new PDO("pgsql:host=$host;dbname=$dbname", $dbuser, $dbpass);
}
catch (PDOException $e) {
 echo "Error : " . $e->getMessage() . "<br/>";
 die();
}
/*
$sql = 'SELECT * FROM users';
echo "status_id - status_name - db_time_stamp - created_by<br>";
foreach ($conn->query($sql) as $row) {
 echo $row[0].' - '.$row[1].' - '.$row[2].' - ';
}
*/
$navigation = <<<END
 <nav>
  <a href="index.php">Home</a>
  <a href="about.php">About</a>
  <a href="products.php">Products</a>
  <a href="login.php">Login</a>
END;

 if (isset($_SESSION['username']))
 {

		 $navigation .= <<<END
		  <a href="register.php">Register</a>
		  <a href="add_product.php">Add a product</a>
		  <a href="logout.php">Logout</a>
		 Logged in as {$_SESSION['username']}
END;

 }
 else
 {
 $navigation .= <<<END
END;
 }
 $navigation .= '</nav>';
 ?>