Advertisement
Guest User

Untitled

a guest
Mar 29th, 2017
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.06 KB | None | 0 0
  1. <?php
  2. $user =
  3. $pass =
  4.  
  5.  
  6. $db = new PDO('dblib:host=your_hostname;dbname=your_db;charset=UTF-8', $user, $pass)
  7.  
  8. if (isset($_POST["fragen"])) {
  9.         // check dass titel != leer
  10.         if (!$_POST["frage"]) {
  11.             echo '<span style="color:red;">Bitte gebe einen Fragetitel ein!</span>';
  12.         }
  13.         //check dass a1 != leer
  14.         if (!$_POST["a1"]) {
  15.             echo '<span style="color:red;"> Bitte gebe Mindestens eine Antwort an!</span>';
  16.         }
  17.         // eingaben in variablen
  18.         $fragetitel = $_POST["frage"];
  19.         $a1 = $_POST["a1"];
  20.         $a2 = $_POST["a2"];
  21.         $a3 = $_POST["a3"];
  22.         $a4 = $_POST["a4"];
  23.         //mysql insert in datenbank
  24.   $statement = $db->prepare("INSERT INTO
  25.  testtable(Frage, Antwort1, Antwort2, Antwort3, Antwort4,FrageID)
  26.        VALUES(':frage',':a1',':a2',':a3',':a4',:ID)");
  27.  
  28.   $statement->execute(array(
  29.     "frage" => "$fragetitel",
  30.     "a1" => "$a1",
  31.     "a2" => "$a2",
  32.     "a3" => "$a3",
  33.     "a4" => "$a4",
  34.     "ID" => "$id"
  35. ));
  36.  
  37.        
  38.        
  39.  
  40. }  
  41.  
  42. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement