Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- <body>
- <title>Wettbewerb</title>
- <form action="mysqldatenbank.php" method="post"/>
- <h1>Formular</h1>
- Text l: <input type="text" name="text1"/><br/>
- Text 2: <input type="text" name="text2"/><br/>
- Text 3: <input type="text" name="text3"/><br/>
- Text 4: <input type="text" name="text4"/><br/>
- Text 5: <input type="text" name="text5"/><br/>
- Text 6: <input type="text" name="text6"/><br/>
- Text 7: <input type="text" name="text7"/><br/>
- <br></br>
- Datum von:<input type="date" name= "datumvon"/><br/>
- Zeit bis: <input type="time" name="zeitbis"/><br/>
- <br></br>
- Wochentag MO: Ja: <input type="radio" name="wochentagmo" checked="checked" value="Ja"/>
- Nein: <input type="radio" name="wochentagmo" value="Nein" /><br/>
- Wochentag DI: Ja: <input type="radio" name="wochentagdi" checked="checked" value="Ja"/>
- Nein: <input type="radio" name="wochentagdi" value="Nein" /><br/>
- Wochentag MI: Ja: <input type="radio" name="wochentagmi" checked="checked" value="Ja"/>
- Nein: <input type="radio" name="wochentagmi" value="Nein" /><br/>
- Wochentag Don: Ja: <input type="radio" name="wochentagdon" checked="checked" value="Ja"/>
- Nein: <input type="radio" name="wochentagdon" value="Nein" /><br/>
- Wochentag FR: Ja: <input type="radio" name="wochentagfr" checked="checked" value="Ja"/>
- Nein: <input type="radio" name="wochentagfr" value="Nein" /><br/>
- Wochentag SA: Ja: <input type="radio" name="wochentagsa" checked="checked" value="Ja"/>
- Nein: <input type="radio" name="wochentagsa" value="Nein" /><br/>
- Wochentag SO: Ja: <input type="radio" name="wochentagso" checked="checked" value="Ja"/>
- Nein: <input type="radio" name="wochentagso" value="Nein" /><br/>
- <br></br>
- Station 1: Ja: <input type="radio" name="station1" checked="checked" value="Ja"/>
- Nein: <input type="radio" name="station1" value="Nein" /><br/>
- Station 2: Ja: <input type="radio" name="station2" checked="checked" value="Ja"/>
- Nein: <input type="radio" name="station2" value="Nein" /><br/>
- Station 3: Ja: <input type="radio" name="station3" checked="checked" value="Ja"/>
- Nein: <input type="radio" name="station3" value="Nein" /><br/>
- Station 4: Ja: <input type="radio" name="station4" checked="checked" value="Ja"/>
- Nein: <input type="radio" name="station4" value="Nein" /><br/>
- Station 5: Ja: <input type="radio" name="station5" checked="checked" value="Ja"/>
- Nein: <input type="radio" name="station5" value="Nein" /><br/>
- Station 6: Ja: <input type="radio" name="station6" checked="checked" value="Ja"/>
- Nein: <input type="radio" name="station6" value="Nein" /><br/>
- Station 7: Ja: <input type="radio" name="station7" checked="checked" value="Ja"/>
- Nein: <input type="radio" name="station7" value="Nein" /><br/>
- Station 8: Ja: <input type="radio" name="station8" checked="checked" value="Ja"/>
- Nein: <input type="radio" name="station8" value="Nein" /><br/>
- Station 9: Ja: <input type="radio" name="station9" checked="checked" value="Ja"/>
- Nein: <input type="radio" name="station9" value="Nein" /><br/>
- <br></br>
- Bild: <input type="file" name="datei"/><br/>
- <br></br>
- <input type="submit" value="Absenden"/>
- </form>
- </body>
- </html>
- <?php
- $link = mysqli_connect("localhost", "root", "", "pistache");
- if ($link == false){
- die("Konnte nicht verbinden" . mysqli_connect_error());
- }
- $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_ice (Test1, Test2, Test3, Test4, Test5, Test6, Test7, `Datum von`, `Zeit bis`, `Wochentag MO`, `Wochentag DI`, `Wochentag MI`, `Wochentag Don`, `Wochentag FR`, `Wochentag SA`, `Wochentag SO`, `Test17`, `Station 2`, `Test19`, `Station 4`, `Station 5`, `Test22`, `Station 7`, `Station 8`, `Test25`)
- VALUES ('$text1', '$text2', '$text3', '$text4', '$text5', '$text6', '$text7', '$datumvon', '$zeitbis', '$wochentagmo', '$wochentagdi', '$wochentagmi', '$wochentagdon', '$wochentagfr', '$wochentagsa', '$wochentagso', '$station1', '$station2', '$station3', '$station4', '$station5', '$station6', '$station7', '$station8', '$station9')";
- //Diese Variable bindet MySQL Code mit dem PHP Script indem sie den Code in einer Variable speichert.
- if(mysqli_query($link, $sql)){
- echo "Hat funktioniert";
- echo "Hat nicht geklappt. Hier liegt der Fehler: " . mysqli_error($link);
- }
- mysqli_close($link);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement