<?php
		require_once "connect.php";
		//DB details
		$host="localhost";
		$db_user ="root";
		$db_password="";
		$db_name="exampledatabase";

		//Create connection and select DB
		$connection= @new mysqli($host, $db_user, $db_password, $db_name);

		if ($connection->connect_error) {
			die("Unable to connect database: " . $connection->connect_error);
		}
		$userID=$_SESSION['id'];
		$query="SELECT role FROM shoppingcart s, users u, cms_content c WHERE username='$userID'";
		$result1=mysqli_query($connection, $query);
		$amount_of_users=$result1->num_rows;
		$role='user';
		if($amount_of_users>0) {
			$row=$result1->fetch_assoc();
			$role=$row['role'];
		}

		$admin='admin';
		$user='user';

			$query="SELECT * FROM shoppingcart s, users u, cms_content c WHERE s.id='$userID'";
			$result=mysqli_query($connection, $query) or die("Bad Query: $query");
			echo "<table border='1'>";
			echo "<tr><th>ID transakcji</th><th>Nazwa przedmiotu</th><th>Kategoria</th><th>Cena przedmiotu</th></tr>";
			while($row=mysqli_fetch_assoc($result)) {
			echo "<tr><td>{$row['id']}</td><td>{$row['title']}</td><td>{$row['category']}</td><td>{$row['price']}</td></tr>";
			}
			echo "</table>";

	?>