<?php
    $servername = "localhost";
    $username = "root";
    $password = "";
    $database="rivistaculinaria";

    // Create connection
    $conn = new mysqli($servername, $username, $password,$database);

    // Check connection
    if ($conn->connect_error) die("Connection failed: " . $conn->connect_error);
    else echo "Connected successfully";


    //Costruzione del comando INSERT


            $sql = "INSERT INTO utente (Matricola,Cognome,Nome,Profilo,Email,Password)VALUES ('$_POST[matr]','$_POST[cognome]','$_POST[nome]',1,'$_POST[email]','$_POST[psw]')";
            if($_POST['button']==1)
            {
            if ($conn->query($sql) === TRUE) echo "New record created successfully";
            else echo "Error: " . $sql . "<br>" . $conn->error;
            header("Location: registrazione.html#tabs-2");
            }

            else if($_POST['button']==2)
            {
                $sql1 = "INSERT INTO autore (Utente,Indirizzo,Cap,Città,TelAbitazione,TelCellulare,DataNascita,Liberatoria)VALUES ('$_POST[matr]','$_POST[ind]','$_POST[cap]',1,'$_POST[citta]','$_POST[telab]','$_POST[telcell]','$_POST[dat]','S')";
            if ($conn->query($sql1) === TRUE) echo "New record created successfully";
            else echo "Error: " . $sql1 . "<br>" . $conn->error;
            header("Location: registrazione.html#tabs-3");
            }

            $conn->close();