Kyaria

Untitled

Mar 9th, 2018
460
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.21 KB | None | 0 0
  1. <form class="Speichern" action = "" method = "POST">
  2. <?php
  3.  
  4.     while ($zeile = mysqli_fetch_array($db_aus))
  5.     {
  6.         $zähler++;
  7.         $name = "selectfield$zähler";
  8.  
  9.         echo "<tr>";
  10.         echo "<td>". $zeile['S_Vorname'] ."</td>";
  11.         echo "<td>". $zeile['S_Nachname'] . "</td>";
  12.         echo "<td><select name='$name'>";
  13.         echo "<option value='1'>Ja</option>";
  14.         echo "<option value='2'>Nein</option>";
  15.         echo "</select> </td>";
  16.         echo "</tr>";  
  17.     }
  18.     echo "</table>";
  19. ?>
  20. <input type = "submit" value = "Speichern" name ="2"/>
  21. <?php
  22.  
  23.     mysqli_free_result($db_aus);
  24.     mysqli_free_result($db_class);
  25.    
  26.     if(isset($_POST['2']))
  27.     {
  28.         for($i = 1;$i <= $zähler; $i++)
  29.         {
  30.             $namen = "selectfield$i";
  31.             if($_POST[$namen] == 2)
  32.             {
  33.                 $füg = "INSERT INTO anwesenheit(A_ID,A_Fehlend,A_Entschuldigt,A_Datum,A_S_ID) VALUES ('null','1','null','$date','$i')";
  34.                
  35.                 if($db->multi_query($füg) !== TRUE)
  36.                 {
  37.                     echo "Error: " . $füg . "<br>" . $db->error;
  38.                 }
  39.                
  40.             }
  41.         }
  42.  
  43.     }
  44.  
  45. ?>
  46. </form>
Advertisement
Add Comment
Please, Sign In to add comment