`Uniserver apache logs error: PHP Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ','',,'2015-03-20',,'','Lunedi')'
$nome = $_POST['nome1'];$cognome = $_POST['cognome1'];$utente = $_POST['user1'];$email = $_POST['email1'];$provincia = $_POST['prov1'];$citta = $_POST['cit1'];$cap = $_POST['cap1'];$via = $_POST['via1'];$civ= $_POST['civ1'];$tel = $_POST['tel1'];$passw = $_POST['passw1']; $sql = "INSERT INTO docenti (nome, cognome, utente, email, provincia, citta, cap, via, civico, nascita, telefono, password, libero)VALUES ('$nome','$cognome','$utente','$email','$provincia','$citta',$cap,'$via',$civ,'2015-03-20',$tel,'$passw','Lunedi')";
if(mysqli_query($conn, $sql)){echo ("query eseguita");} else{echo "ERROR: $sql. " . mysqli_error($conn)`;}mysqli_close($conn);
(it turns out to be a fatigue problem…i can’t solve tips??; should insert the values into a ‘docenti’ table.There is also a IDdocente (Primary Key autoincremental integer type) but which I have not entered in the query, is that correct??)