<?php


    $strClasse    = $_REQUEST['classe'];
    $strSPw       = $_REQUEST['spw'];
    $strMateria   = $_REQUEST['selMaterie'];
    $strArgomento = $_REQUEST['selArgomenti'];
    $iNumAlunni   = $_REQUEST['alunni'];
    $strUsername  = $_SESSION['utente'];

    include('connessione.php');

    $strSQL   = "SELECT professori.codice from professori WHERE username = '$strUsername'"; //'$strUsername'";
    $queryRis = pg_exec($connessione, $strSQL);
    $vetRis   = pg_fetch_array($queryRis, 0);

    $iCodProf  = $vetRis['codice'];

    $strSQL   = "SELECT test.codice from test WHERE test.codprof = $iCodProf AND argomento = '$strArgomento'";

    $queryRis = pg_exec($connessione, $strSQL);
    $vetRis   = pg_fetch_array($queryRis, 0);

    $iCodTest = $vetRis['codice'];

    $strSQL   = "SELECT MAX(sessioni.codice) AS massimo from sessioni";
    $queryRis = pg_exec($connessione, $strSQL);
    $vetRis   = pg_fetch_array($queryRis);

    if (is_null($vetRis['massimo']))
        $iCodice  = 0;
    else
        $iCodice = $vetRis['massimo'] + 1;

    $strSQL = "SELECT CURRENT_DATE, CURRENT_TIME;";
    $queryRis = pg_exec($connessione, $strSQL);
    $vetRis = pg_fetch_array($queryRis);

    $data = $vetRis['date'];
    $orario = $vetRis['timetz'];

$strSQL = "INSERT INTO sessioni VALUES('".$iCodice."', '".$iCodTest."', '".$iCodProf."', '".$strSPw."', '".$iNumAlunni."', '".$data."','".$orario."'";
    if ($strClasse != "")
        $strSQL .= ", '".$strClasse."'";

    $strSQL .= ")";
    pg_exec($connessione, $strSQL) or die("Errore: Impossibile creare una sessione");

    echo "<table>\n";
    echo "<tr><td><b>Codice sessione:</b></td><td>$iCodice</td></tr>\n";
    echo "<tr><td><b>Materia:</b></td><td>$strMateria</td></tr>\n";
    echo "<tr><td><b>Argomento:</b></td><td>$strArgomento</td></tr>\n";
    echo "<tr><td><b>Password:</b></td><td>$strSPw</td></tr>\n";
    echo "<tr><td><b>Alunni:</b></td><td>$iNumAlunni</td></tr>\n";
    echo "</table>";
    unset($_REQUEST);
?>