Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <form class="Speichern" action = "" method = "POST">
- <?php
- while ($zeile = mysqli_fetch_array($db_aus))
- {
- $zähler++;
- $name = "selectfield$zähler";
- echo "<tr>";
- echo "<td>". $zeile['S_Vorname'] ."</td>";
- echo "<td>". $zeile['S_Nachname'] . "</td>";
- echo "<td><select name='$name'>";
- echo "<option value='1'>Ja</option>";
- echo "<option value='2'>Nein</option>";
- echo "</select> </td>";
- echo "</tr>";
- }
- echo "</table>";
- ?>
- <input type = "submit" value = "Speichern" name ="2"/>
- <?php
- mysqli_free_result($db_aus);
- mysqli_free_result($db_class);
- if(isset($_POST['2']))
- {
- for($i = 1;$i <= $zähler; $i++)
- {
- $namen = "selectfield$i";
- if($_POST[$namen] == 2)
- {
- $füg = "INSERT INTO anwesenheit(A_ID,A_Fehlend,A_Entschuldigt,A_Datum,A_S_ID) VALUES ('null','1','null','$date','$i')";
- if($db->multi_query($füg) !== TRUE)
- {
- echo "Error: " . $füg . "<br>" . $db->error;
- }
- }
- }
- }
- ?>
- </form>
Advertisement
Add Comment
Please, Sign In to add comment