<?php


$link = mysqli_connect("localhost", "root", "", "pistache");


if($link === false){
    die("Konnte nicht verbinden. " . mysqli_connect_error());
}

	if(isset($_POST["submit"])){

$Text1 = mysqli_real_escape_string($link, $_POST['Text1']);
$Text2 = mysqli_real_escape_string($link, $_POST['Text2']);
$Text3 = mysqli_real_escape_string($link, $_POST['Text3']);
$Text4 = mysqli_real_escape_string($link, $_POST['Text4']);
$Text5 = mysqli_real_escape_string($link, $_POST['Text5']);
$Text6 = mysqli_real_escape_string($link, $_POST['Text6']);
$Text7 = mysqli_real_escape_string($link, $_POST['Text7']);
$Datumvon = mysqli_real_escape_string($link, $_POST['Datumvon']);
$Zeitbis = mysqli_real_escape_string($link, $_POST['Zeitbis']);
$WochentagMO = mysqli_real_escape_string($link, $_POST['WochentagMO']);
$WochentagDI = mysqli_real_escape_string($link, $_POST['WochentagDI']);
$WochentagMI = mysqli_real_escape_string($link, $_POST['WochentagMI']);
$WochentagDon = mysqli_real_escape_string($link, $_POST['WochentagDon']);
$WochentagFR = mysqli_real_escape_string($link, $_POST['WochentagFR']);
$WochentagSA = mysqli_real_escape_string($link, $_POST['WochentagSA']);
$WochentagSO = mysqli_real_escape_string($link, $_POST['WochentagSO']);
$Station1 = mysqli_real_escape_string($link, $_POST['Station1']);
$Station2 = mysqli_real_escape_string($link, $_POST['Station2']);
$Station3 = mysqli_real_escape_string($link, $_POST['Station3']);
$Station4 = mysqli_real_escape_string($link, $_POST['Station4']);
$Station5 = mysqli_real_escape_string($link, $_POST['Station5']);
$Station6 = mysqli_real_escape_string($link, $_POST['Station6']);
$Station7 = mysqli_real_escape_string($link, $_POST['Station7']);
$Station8 = mysqli_real_escape_string($link, $_POST['Station8']);
$Station9 = mysqli_real_escape_string($link, $_POST['Station9']);



$sql = "INSERT INTO pistache ('Test1', 'Test2', 'Test3', 'Test4', 'Test5', 'Test6') VALUES ('$_POST[text1]', '$_POST[text2]', '$_POST[text3]', '$_POST[text4]', '$_POST[text5]', '$_POST[text6]')";

if(mysqli_query($link, $sql)){
    echo "Hat geklappt.";
} else{
    echo "Hat nicht geklappt und das hat nicht funktioniert: $sql. " . mysqli_error($link);
}

	}

mysqli_close($link);
?>