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);
//inizio controllo
if(isset($_POST["Submit"]))
{
//controllo dati (campi text)
if($_POST["aziendax"] == "")
$azerr = 1;
else $azerr = 0;
if($_POST["nomex"] == "")
$nomerr = 1;
else $nomerr = 0;
//controllo domanda 1 (radio button)
if (isset($_POST["Domanda1"]))
{
if ($_POST["Domanda1"] == "")
$d1err = 1;
else $d1err = 0;
}
else $d1err = 1;
//Controllo domanda 2 (checkbox)
if (!isset($_POST['cb21']) && !isset($_POST['cb22']) && !isset($_POST['cb23']) && !isset($_POST['cb24']) && !isset($_POST['cb25']) && !isset($_POST['cb26']) && !isset($_POST['cb27']) && !isset($_POST['cb28']) && !isset($_POST['cb29']))
$d2err = 1;
else $d2err = 0;
//Controllo domanda 3 (radio button)
if (isset($_POST["Domanda3"]))
{
if ($_POST["Domanda3"] == "")
$d3err = 1;
else $d3err = 0;
}
else $d3err = 1;
//Controllo domanda 4 (campo text): errore solo se i campi sono tutti vuoti
if($_POST["sito1ax"] == "" && $_POST["sito2ax"] == "" && $_POST["sito3ax"] == "")
$d4aerr = 1;
else $d4aerr = 0;
if($_POST["sito1bx"] == "" && $_POST["sito2bx"] == "" && $_POST["sito3bx"] == "")
$d4berr = 1;
else $d4berr = 0;
//Controllo domanda 5 (checkbox)
if (!isset($_POST['cb51']) && !isset($_POST['cb52']) && !isset($_POST['cb53']) && !isset($_POST['cb54']) && !isset($_POST['cb55']) && !isset($_POST['cb56']))
$d5err = 1;
else $d5err = 0;
//Controllo domanda 6 (radio button)
if (isset($_POST["Domanda6a"]))
{
if ($_POST["Domanda6a"] == "")
$d6aerr = 1;
else $d6aerr = 0;
}
else $d6aerr = 1;
if (isset($_POST["Domanda6b"]))
{
if ($_POST["Domanda6b"] == "")
$d6berr = 1;
else $d6berr = 0;
}
else $d6berr = 1;
if (isset($_POST["Domanda6c"]))
{
if ($_POST["Domanda6c"] == "")
$d6cerr = 1;
else $d6cerr = 0;
}
else $d6cerr = 1;
if (isset($_POST["Domanda6d"]))
{
if ($_POST["Domanda6d"] == "")
$d6derr = 1;
else $d6derr = 0;
}
else $d6derr = 1;
//Controllo domanda 7 (radio button)
if (isset($_POST["Domanda7a"]))
{
if ($_POST["Domanda7a"] == "")
$d7aerr = 1;
else $d7aerr = 0;
}
else $d7aerr = 1;
if (isset($_POST["Domanda7b"]))
{
if ($_POST["Domanda7b"] == "")
$d7berr = 1;
else $d7berr = 0;
}
else $d7berr = 1;
if (isset($_POST["Domanda7c"]))
{
if ($_POST["Domanda7c"] == "")
$d7cerr = 1;
else $d7cerr = 0;
}
else $d7cerr = 1;
if (isset($_POST["Domanda7d"]))
{
if ($_POST["Domanda7d"] == "")
$d7derr = 1;
else $d7derr = 0;
}
else $d7derr = 1;
//Controllo domanda 8 (checkbox)
if (!isset($_POST['cb81']) && !isset($_POST['cb82']) && !isset($_POST['cb83']) && !isset($_POST['cb84']))
$d8err = 1;
else $d8err = 0;
//Controllo domanda 9 (radio button)
if (isset($_POST["Domanda9"]))
{
if ($_POST["Domanda9"] == "")
$d9err = 1;
else $d9err = 0;
}
else $d9err = 1;
//Controllo domanda 10 (radio button)
if (isset($_POST["Domanda10"]))
{
if ($_POST["Domanda10"] == "")
$d10err = 1;
else $d10err = 0;
}
else $d10err = 1;
//Controllo domanda 11 (radio button)
if (isset($_POST["Domanda11"]))
{
if ($_POST["Domanda11"] == "")
$d11err = 1;
else $d11err = 0;
}
else $d11err = 1;
}
else {
$azerr = 1;
$nomerr = 1;
$d1err = 1;
$d2err = 1;
$d3err = 1;
$d4aerr = 1;
$d4berr = 1;
$d5err = 1;
$d6aerr = 1;
$d6berr = 1;
$d6cerr = 1;
$d6derr = 1;
$d7aerr = 1;
$d7berr = 1;
$d7cerr = 1;
$d7derr = 1;
$d8err = 1;
$d9err = 1;
$d10err = 1;
$d11err = 1;}
if ($azerr = 0 && $nomerr = 0 && $d1err = 0 && $d2err = 0 && $d3err = 0 && $d4aerr = 0 && $d4berr = 0 && $d5err = 0 && $d6aerr = 0 && $d6berr = 0 && $d6cerr = 0 && $d6derr = 0 && $d7aerr = 0 && $d7berr = 0 && $d7cerr = 0 && $d7derr = 0 && $d8err = 0 && $d9err = 0 && $d10err = 0 && $d11err = 0)
{
//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,r1,r2,r3,r4,r5,r6,r7,r8,r9) VALUES ('$id','$cb21','$cb22','$cb23','$cb24','$cb25','$cb26','$cb27','$cb28','$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,r1,r2,r3,r4,r5,r6) VALUES ('$id','$cb51','$cb52','$cb53','$cb54','$cb55','$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,r1,r2,r3,r4) VALUES ('$id','$cb81','$cb82','$cb83','$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);
}
else echo "Compila tutti i campi!"
?>