Untitled

<?php
	session_start();

	$_SESSION['username'] = $_POST['username'];

	$servername = "5bi_s01078";
	$username = "root";
	$password = "";

	// Create connection
	$conn = mysqli_connect("localhost", $username, $password, $servername);

	// Check connection
	if (!$conn) {
	  die("Connection failed: " . mysqli_connect_error());
	}
?>

<html>

<head>
  <title>Home</title>

  <style>
  ul {
    list-style-type: none;
    margin: 0;
    padding: 0;
    overflow: hidden;
    background-color: #ffd9b3;
}

li {
    float: left;
}

li a, .dropbtn {
    display: inline-block;
    color: black;
    text-align: center;
    padding: 14px 16px;
    text-decoration: none;
}

li a:hover, .dropdown:hover .dropbtn {
    background-color: orange;
}

li.dropdown {
    display: inline-block;
}

.dropdown-content {
    display: none;
    position: absolute;
    background-color: #ffd9b3;
    min-width: 160px;
    box-shadow: 0px 8px 16px 0px rgba(0,0,0,0.2);
    z-index: 1;
}

.dropdown-content a {
    color: black;
    padding: 12px 16px;
    text-decoration: none;
    display: block;
    text-align: left;
}

.dropdown-content a:hover {background-color: #ffd9b3}

.dropdown:hover .dropdown-content {
    display: block;
}

table
{
  width: 30%;
  text-align: center;
  vertical-align: middle;
  /*border: 1px solid black;*/
}

th
{
  height: 20px;
  background: orange;
  padding: 5px;
  border: 1px solid black;
}

td
{
  height: 10px;
  padding: 5px;
  border: 1px solid black;
}

tr:hover {background-color: #ffd9b3;}
  </style>

  <script type="text/javascript" language="javascript">
    function validaForm() {
	  //funzione che controlla parzialmente i dati inseriti
		if (document.submit.citta.value=="") {
			alert("Inserire città.");
			return false;
    }
    //alert("Dati inseriti correttamente");
    return true;
   }
  </script>
</head>

<body>

  <ul>
    <li><a href="home.php">Home</a></li>
    <li><a href="listasale.php">Cerca sala</a></li>
    <li><a href="listaattori.php">Cerca attore</a></li>
    <li><a href="listaregisti.php">Cerca regista</a></li>
    <li><a href="listaproiezioni.php">Cerca proiezione</a></li>
    <?php
    echo "<li class=\"dropdown\">";
    echo "<a href=\"javascript:void(0)\" class=\"dropbtn\">Benevuto " . $_SESSION['username'] . "</a>";
    echo "<div class=\"dropdown-content\">";
      echo "<a href=\"logout.php\">Logout</a>";
    echo "</div>";
    echo "</li>";
    ?>
 </ul>

  <?php

    echo "<form action=\"#\" name=\"submit\" method=\"post\" onSubmit=\"return validaForm();\">";
    echo "<br /><br /><h3>Cerca le sale nella tua città: </h3>";
    echo "<input type=\"text\" name=\"citta\" value=\"\">";
    echo "<input type=\"submit\" value=\"Cerca\">";

    $citta = $_POST[citta];

    $sql = "SELECT Nome, Posti
            FROM 240118Sala
            WHERE Citta = '".$citta."'";

    $result = mysqli_query($conn, $sql);

    if ($result->num_rows > 0)
    {
      echo "<table>";
      echo "<tr>";
        echo "<th><b><center>Nome</center></b></th>";
        echo "<th><b><center>Posti</center></b></th>";
      echo "</tr>";
      // output data of each row
      while($row = $result->fetch_assoc())
      {
        echo "<tr>";
          echo "<td><center>" . $row["Nome"] . "</center></td>";
          echo "<td><center>" . $row["Posti"] . "</center></td>";
        echo "</tr>";
      }

      echo "</table><br />";
    }
    else
    {
        echo "0 results<br /><br />";
    }

  ?>

</body>

</html>