select_class.php

<?php

class SelectList
{

protected $conn;

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

protected function DbConnect()
{
include "dbrpc_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 login.regioni";
$res = mysql_query($sql,$this->conn);
$regioni = '<option value="0">Scegli...</option>';

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

return $regioni;
}

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

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

return $province;
}

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

while($row = mysql_fetch_array($res))
{
$comuni .= '<option value="' . $row['id_com'] . '">' . $row['cap'] . ' - ' . utf8_encode($row['comune']) . '</option>';
}

return $comuni;
}

public function ShowScuole()
{
$sql = "SELECT * FROM login.scuole WHERE id_com=$_POST[id_com] ";

$res = mysql_query($sql,$this->conn);
$scuole = '<option value="0">Scegli...</option>';

while($row = mysql_fetch_array($res))

{


$scuole .= '<option value="' . $row['id_com'] . '">' . utf8_encode($row['des_tipo_scuola']) . '</option>';


}

return $scuole;
}
}


?>