Codice PHP:
<?php
include ('questionario.php');
$db=mysql_connect('localhost','root','') or die ('Impossibile connettersi al database:' . mysql_error());
mysql_select_db('my_tesistipoliba',$db);
if(isset($_POST["Submit"]))
{
//Dati
$nomex=$_POST["nomex"];
$aziendax=$_POST["aziendax"];
mysql_query("INSERT INTO dati(id,nome,azienda) VALUES ('','$nomex','$aziendax')",$db);
$id = mysql_insert_id();
//Domanda 1
$Domanda1 = $_POST["Domanda1"];
mysql_query("INSERT INTO d1(id_dati,risp) VALUES ('$id','$Domanda1')",$db);
//Domanda 2
if (isset($_POST["cb21"]))
$cb21 = $_POST["cb21"];
else $cb21 = "";
if (isset($_POST["cb22"]))
$cb22 = $_POST["cb22"];
else $cb22 = "";
if (isset($_POST["cb23"]))
$cb23 = $_POST["cb23"];
else $cb23 = "";
if (isset($_POST["cb24"]))
$cb24 = $_POST["cb24"];
else $cb24 = "";
if (isset($_POST["cb25"]))
$cb25 = $_POST["cb25"];
else $cb25 = "";
if (isset($_POST["cb26"]))
$cb26 = $_POST["cb26"];
else $cb26 = "";
if (isset($_POST["cb27"]))
$cb27 = $_POST["cb27"];
else $cb27 = "";
if (isset($_POST["cb28"]))
$cb28 = $_POST["cb28"];
else $cb28 = "";
if (isset($_POST["cb29"]))
$cb29 = $_POST["cb29"];
else $cb29 = "";
mysql_query("INSERT INTO d2(id_dati,risp) VALUES ('$id','$cb21')", $db);
mysql_query("INSERT INTO d2(id_dati,risp) VALUES ('$id','$cb22')", $db);
mysql_query("INSERT INTO d2(id_dati,risp) VALUES ('$id','$cb23')", $db);
mysql_query("INSERT INTO d2(id_dati,risp) VALUES ('$id','$cb24')", $db);
mysql_query("INSERT INTO d2(id_dati,risp) VALUES ('$id','$cb25')", $db);
mysql_query("INSERT INTO d2(id_dati,risp) VALUES ('$id','$cb26')", $db);
mysql_query("INSERT INTO d2(id_dati,risp) VALUES ('$id','$cb27')", $db);
mysql_query("INSERT INTO d2(id_dati,risp) VALUES ('$id','$cb28')", $db);
mysql_query("INSERT INTO d2(id_dati,risp) VALUES ('$id','$cb29')", $db);
//Domanda 3
$Domanda3 = $_POST["Domanda3"];
mysql_query("INSERT INTO d3(id_dati,risp) VALUES ('$id','$Domanda3')",$db);
//Domanda 4
$sito1ax=$_POST["sito1ax"];
$sito2ax=$_POST["sito2ax"];
$sito3ax=$_POST["sito3ax"];
$sito1bx=$_POST["sito1bx"];
$sito2bx=$_POST["sito2bx"];
$sito3bx=$_POST["sito3bx"];
mysql_query("INSERT INTO d4a(id_dati,risp) VALUES ('$id','$sito1ax')",$db);
mysql_query("INSERT INTO d4a(id_dati,risp) VALUES ('$id','$sito2ax')",$db);
mysql_query("INSERT INTO d4a(id_dati,risp) VALUES ('$id','$sito3ax')",$db);
mysql_query("INSERT INTO d4b(id_dati,risp) VALUES ('$id','$sito1bx')",$db);
mysql_query("INSERT INTO d4b(id_dati,risp) VALUES ('$id','$sito2bx')",$db);
mysql_query("INSERT INTO d4b(id_dati,risp) VALUES ('$id','$sito3bx')",$db);
//Domanda 5
if (isset($_POST["cb51"]))
$cb51 = $_POST["cb51"];
else $cb51 = "";
if (isset($_POST["cb52"]))
$cb52 = $_POST["cb52"];
else $cb52 = "";
if (isset($_POST["cb53"]))
$cb53 = $_POST["cb53"];
else $cb53 = "";
if (isset($_POST["cb54"]))
$cb54 = $_POST["cb54"];
else $cb54 = "";
if (isset($_POST["cb55"]))
$cb55 = $_POST["cb55"];
else $cb55 = "";
if (isset($_POST["cb56"]))
$cb56 = $_POST["cb56"];
else $cb56 = "";
mysql_query("INSERT INTO d5(id_dati,risp) VALUES ('$id','$cb51')", $db);
mysql_query("INSERT INTO d5(id_dati,risp) VALUES ('$id','$cb52')", $db);
mysql_query("INSERT INTO d5(id_dati,risp) VALUES ('$id','$cb53')", $db);
mysql_query("INSERT INTO d5(id_dati,risp) VALUES ('$id','$cb54')", $db);
mysql_query("INSERT INTO d5(id_dati,risp) VALUES ('$id','$cb55')", $db);
mysql_query("INSERT INTO d5(id_dati,risp) VALUES ('$id','$cb56')", $db);
//Domanda 6
$Domanda6a = $_POST["Domanda6a"];
$Domanda6b = $_POST["Domanda6b"];
$Domanda6c = $_POST["Domanda6c"];
$Domanda6d = $_POST["Domanda6d"];
mysql_query("INSERT INTO d6(id_dati,rispa) VALUES ('$id','$Domanda6a')",$db);
mysql_query("INSERT INTO d6(id_dati,rispb) VALUES ('$id','$Domanda6b')",$db);
mysql_query("INSERT INTO d6(id_dati,rispc) VALUES ('$id','$Domanda6c')",$db);
mysql_query("INSERT INTO d6(id_dati,rispd) VALUES ('$id','$Domanda6d')",$db);
//Domanda 7
$Domanda7a = $_POST["Domanda7a"];
$Domanda7b = $_POST["Domanda7b"];
$Domanda7c = $_POST["Domanda7c"];
$Domanda7d = $_POST["Domanda7d"];
mysql_query("INSERT INTO d7(id_dati,rispa) VALUES ('$id','$Domanda7a')",$db);
mysql_query("INSERT INTO d7(id_dati,rispb) VALUES ('$id','$Domanda7b')",$db);
mysql_query("INSERT INTO d7(id_dati,rispc) VALUES ('$id','$Domanda7c')",$db);
mysql_query("INSERT INTO d7(id_dati,rispd) VALUES ('$id','$Domanda7d')",$db);
//Domanda 8
if (isset($_POST["cb81"]))
$cb81 = $_POST["cb81"];
else $cb81 = "";
if (isset($_POST["cb82"]))
$cb82 = $_POST["cb82"];
else $cb82 = "";
if (isset($_POST["cb83"]))
$cb83 = $_POST["cb83"];
else $cb83 = "";
if (isset($_POST["cb84"]))
$cb84 = $_POST["cb84"];
else $cb84 = "";
mysql_query("INSERT INTO d8(id_dati,risp) VALUES ('$id','$cb81')", $db);
mysql_query("INSERT INTO d8(id_dati,risp) VALUES ('$id','$cb82')", $db);
mysql_query("INSERT INTO d8(id_dati,risp) VALUES ('$id','$cb83')", $db);
mysql_query("INSERT INTO d8(id_dati,risp) VALUES ('$id','$cb84')", $db);
//Domanda 9
$Domanda9 = $_POST["Domanda9"];
mysql_query("INSERT INTO d9(id_dati,risp) VALUES ('$id','$Domanda9')",$db);
//Domanda 10
$Domanda10 = $_POST["Domanda10"];
mysql_query("INSERT INTO d10(id_dati,risp) VALUES ('$id','$Domanda10')",$db);
//Domanda 11
$Domanda11 = $_POST["Domanda11"];
mysql_query("INSERT INTO d11(id_dati,risp) VALUES ('$id','$Domanda11')",$db);
}
?>