<?php
class SelectList
{

	protected $conn;

		public function __construct()
		{
			$this->DbConnect();
		}

		protected function DbConnect()
		{
			include "db_config.php";

			$this->conn = mysql_connect($host,$user,$password) OR die("Impossibile connettersi al database");
			mysql_select_db($db,$this->conn) OR die("Impossibile selezionare il database $db");

			return TRUE;
		}

		public function ShowRegioni()
		{
			$sql = "SELECT * FROM regioni";
			$res = mysql_query($sql,$this->conn);
			$regioni = '<option value="0">scegli...</option>';

				while($row = mysql_fetch_array($res))
				{
					$regioni .= '<option value="' . $row['id_regioni'] . '">' . utf8_encode($row['nome_regioni']) . '</option>';
				}

			return $regioni;
		}

		public function ShowProvince()
		{
			$sql = "SELECT * FROM provincie WHERE fk_regioni=$_POST[id_regioni]";
			$res = mysql_query($sql,$this->conn);
			$province = '<option value="0">scegli...</option>';

				while($row = mysql_fetch_array($res))
				{
					$province .= '<option value="' . $row['id_provincie'] . '">' . utf8_encode($row['nome_provincie']) . '</option>';
				}

			return $province;
		}

		public function ShowComuni()
		{
			$sql = "SELECT * FROM comuni WHERE fk_provincie=$_POST[id_provincie]";
			$res = mysql_query($sql,$this->conn);
			$comuni = '<option value="0">scegli...</option>';

				while($row = mysql_fetch_array($res))
				{
					$comuni .= '<option value="' . $row['id_comuni'] . '">' . utf8_encode($row['nome_comuni']) . '</option>';
				}

			return $comuni;
		}

        public function ShowIstituti()
		{
			$sql = "SELECT * FROM istituti WHERE fk_comuni=$_POST[id_comuni]";
			$res = mysql_query($sql,$this->conn);
			$istituti = '<option value="0">scegli...</option>';

				while($row = mysql_fetch_array($res))
				{
					$istituti .= '<option value="' . $row['id_istituti'] . '">' . utf8_encode($row['nome_istituti']) . '</option>';
				}

			return $istituti;
		}

          public function ShowScuole()
		{
			$sql = "SELECT * FROM scuole WHERE fk_istituti=$_POST[id_istituti]";
			$res = mysql_query($sql,$this->conn);
			$scuole = '<option value="0">scegli...</option>';

				while($row = mysql_fetch_array($res))
				{
					$scuole .= '<option value="' . $row['id_scuole'] . '">' . utf8_encode($row['denominazione']) . '</option>';
				}

			return $scuole;
		}

          public function ShowPlessi()
		{
			$sql = "SELECT * FROM plessi WHERE fk_scuole=$_POST[id_scuole]";
			$res = mysql_query($sql,$this->conn);
			$plessi = '<option value="0">scegli...</option>';

				while($row = mysql_fetch_array($res))
				{
					$plessi .= '<option value="' . $row['id_plessi'] . '">' . utf8_encode($row['nome_plessi']) . '</option>';
				}

			return $plessi;
		}

}

?>