Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $user =
- $pass =
- $db = new PDO('dblib:host=your_hostname;dbname=your_db;charset=UTF-8', $user, $pass)
- if (isset($_POST["fragen"])) {
- // check dass titel != leer
- if (!$_POST["frage"]) {
- echo '<span style="color:red;">Bitte gebe einen Fragetitel ein!</span>';
- }
- //check dass a1 != leer
- if (!$_POST["a1"]) {
- echo '<span style="color:red;"> Bitte gebe Mindestens eine Antwort an!</span>';
- }
- // eingaben in variablen
- $fragetitel = $_POST["frage"];
- $a1 = $_POST["a1"];
- $a2 = $_POST["a2"];
- $a3 = $_POST["a3"];
- $a4 = $_POST["a4"];
- //mysql insert in datenbank
- $statement = $db->prepare("INSERT INTO
- testtable(Frage, Antwort1, Antwort2, Antwort3, Antwort4,FrageID)
- VALUES(':frage',':a1',':a2',':a3',':a4',:ID)");
- $statement->execute(array(
- "frage" => "$fragetitel",
- "a1" => "$a1",
- "a2" => "$a2",
- "a3" => "$a3",
- "a4" => "$a4",
- "ID" => "$id"
- ));
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement