<?php
			$servername = "localhost";
			$username = "root";
			$password = "";
			$dbname = "teatro";

			// Create connection
			$conn = new mysqli($servername, $username, $password, $dbname);
			// Check connection
			if ($conn->connect_error) {
				die("Connection failed: " . $conn->connect_error);
			}

			$sql = "SELECT * FROM spettacoli";
			$result = $conn->query($sql);
			if ($result->num_rows > 0) {
				// output data of each row
				while($row = $result->fetch_assoc()) {
					?>
					<div id="spacesmall">
					<?php
					echo "<center><h3>" . $row["Titolo"];
					echo " <a href='Login.php?" . $row ["IDSpettacolo"] . "'><img src='data:image/jpeg; base64,".base64_encode( $row["Locandina"])."'/></a><br></center>";
					?></div>
					<?php
				}
			} else {
				echo "<center><h1>Nessuno spettacolo presente</h1></center>";
			}
			$conn->close();
		?>