<?php

$conn = @pg_connect("dbname=postgres user=postgres password=123456789");

if(!$conn) {
    die('Connessione fallita !<br />');
} else {
    echo 'Richiesta Effettuata !<br />';
}

// Richiedente
$name = $_POST['name'];
$surname = $_POST['surname'];
$email = $_POST['email'];
$testo = $_POST['testo'];
$str_data = $_POST['datepicker']; // data
$str_hour_s = $_POST['hour']; // Orario di inizio
$str_hour_e = $_POST['end']; // Orario di fine


//inserting data order
$query1 = "INSERT INTO prenotazione (nome_rich, cogn_rich, email_rich,oggetto_rich,data_richiesta,orario_richiesta,orario_fine) VALUES ('$name','$surname', '$email','$testo','$str_data', '$str_hour_s','$str_hour_e')";
//execute the query here
$result = pg_query($conn, $query1 ); //if you are using pg_query and $conn is the connection resource
// Interni
$query = "";
if( !empty( $_POST['iname'] ) ) {

    foreach( $_POST['iname'] as $key => $iname ) {

        $isurname = empty( $_POST[$key]['isurname'] ) ? NULL : $_POST[$key]['isurname'];
        $iemail = empty( $_POST[$key]['iemail'] ) ? NULL : $_POST[$key]['iemail'];
        if ($query != "" ) {
            $query .= ",";
        }
        $query .= " ( '$iname', '$isurname', '$iemail' ) ";
    }
}
if( !empty( $query ) ) {

    $query2 = "INSERT INTO interni (nome_int, cogn_int, email_int) VALUES ".$query;
    $result = pg_query($conn, $query2 ); //if you are using pg_query and $conn is the connection resource
}
// Esterni
$query = "";
if( !empty( $_POST['ename'] ) ) {
    foreach( $_POST['ename'] as $key => $ename ) {
        $esurname = empty( $_POST[$key]['esurname'] ) ? NULL : $_POST[$key]['esurname'];
        $eemail = empty( $_POST[$key]['eemail'] ) ? NULL : $_POST[$key]['eemail'];
         if ($query != "" ) {
            $query .= ",";
        }
        $query .= " ( '$ename', '$esurname', '$eemail' ) ";
    }
}

if( !empty( $query ) ) {

    $query3 =  "INSERT INTO esterni  (nome_est, cogn_est, email_est) VALUES  " . $query;
    $result = pg_query($conn, $query3 ); //if you are using pg_query and $conn is the connection resource
}

// Calendario

/*
  $str_data = addslashes($_POST['datepicker']);
  $str_hour = addslashes($_POST['hour']);

  $sql = "INSERT INTO appuntamenti (str_data,hour ) VALUES ('$str_data', '$str_hour')";
 */

?>