<?php
class Option
{
  public $conn;
 
    public function __construct()
    {
      $this->DbConnectAndSelect();
    }
 
    protected function DbConnectAndSelect()
    {
      //include_once "db_config.php";
      //$this->conn = mysql_connect($db_host,$username,$password);
      $this->conn = pg_connect("host=**** port=**** user=**** password=**** dbname=****");
      //mysql_select_db($db_name, $this->conn);
      return TRUE;
    }
 
    public function ShowContinenti()
    {
      echo 'Seleziona un continente:<br>';
      echo '<select id="sel_continenti" name="sel_continenti"><option value="no">Scegli...</option>';
 
      $sql = "SELECT * FROM continenti";
      //$res = mysql_query($sql,$this->conn);
      $res = pg_query($this->conn,$sql);
 
        while($row = pg_fetch_row($res))
        {
          echo '<option value="' . $row[0] . '">' . $row[1] . '</option>';
        }
 
      echo '</select>';
    }
 
    /*public function ShowNazioni()
    {
      if($_POST['id_cont'] == "no")
      {
        die;
      }
       //echo 'Seleziona una nazione:<br>';
      //echo '<select id="sel_nazioni" name="sel_nazioni">';
       $id_cont = $_POST['id_cont'];
      $sql = "SELECT * FROM nazioni WHERE id_cont=$id_cont";
      $res = pg_query($this->conn,$sql);
        //echo'<option value="no">Scegli...</option>';
        while($row = pg_fetch_row($res))
        {
          echo '<option value="' . $row[0] . '">' . $row[2] . '</option>';
        }
       //echo '</select>';
 
    }*/
    
    public function ShowNazioni()
    {
      if($_POST['id_cont'] == "no")
      {
        die;
      }
       echo 'Seleziona una nazione:<br>';
      echo '<select id="sel_nazioni" name="sel_nazioni">';
       $id_cont = $_POST['id_cont'];
      $sql = "SELECT * FROM nazioni WHERE id_cont=$id_cont";
      $res = pg_query($this->conn,$sql);
      echo'<option value="no">Scegli...</option>';
      while($row = pg_fetch_row($res)) {
        echo '<option value="' . $row[0] . '">' . $row[2] . '</option>';
      }
      echo '</select>';
    }
 
    public function ShowResult()
    {
      echo "dentro shoresult()";
      if($_POST['id'] == "no")
      {
        echo "post id=no";
        die;
      }
      echo '<br><br>Hai scelto la nazione: ';
      $id = $_POST['id'];
      $sql = "SELECT * FROM nazioni WHERE id=$id";
      $res = pg_query($this->conn,$sql);
      $row = pg_fetch_row($res);
 
      echo 'id: '.$row[0].' id_cont: '.$row[1].' nazione: '.$row[2];
    }
}
 
?>