Statusanzeige, Statusänderung mit php

<table class='table table-dark'>
<thead><tr>
<th>Bestelldatum</th>
<th>Kundennr</th>
<th>Pizza</th>
<th>Zusatzbelag</th>
<th>Status</th>
<th>inarbeit</th>
<th>Update Data</th>


</tr></thead>
<tbody>
<?php foreach ($ergebnisPizzabestellung as $zeile): ?>
<tr>
<td><?= $zeile ['created_at'] ?> </td>
<td><?= $zeile ['Kundennr'] ?> </td>
<td><?= $zeile['Pizza'] ?> </td>
<td><?= $zeile['Belag'] ?> </td>
<td><?= $zeile['inarbeit'] ?> </td>

<!--<form method="POST" class="form-inline">-->
<form method="post"action="<?php echo htmlspecialchars($_SERVER['PHP_SELF']); ?>">
<td><div class="form-check">
<input class="form-check-input" type="checkbox" name="inarbeit" value ="inarbeit" id="flexCheckDefault"/>
<label class="form-check-label" for="flexCheckDefault">
</label>
</div></td>
<td>              
<input type="hidden" name="id" value=<?= $zeile['id'] ?>>

<button type="submit" class="btn btn-success" value='submit' name="submit">Update Data</button></td>
</form>
</tr>
<?php endforeach; ?>
</tbody>
</table>

if($_SERVER["REQUEST_METHOD"] == "POST"){
    
       
  $stmt = $verbindung->prepare("UPDATE Datenbankbsp.pizzabestellung SET inarbeit = ? WHERE id = ?");
   
  $stmt->execute([$inarbeit,$id]);

      
     
      $verbindung = null;

}
 
?>

try{
    $verbindung = new PDO($server, $username,$passwort);
}
catch(Exception $fehler){
    print $fehler->getMessage();
}

 //Bestelldaten aus der Datenbank abfragen
 $sqlBefehlPizzabestellung = "SELECT * from bspdb.pizzabestellung ORDER BY created_at DESC";
 $abfragePizzabestellung = $verbindung->prepare($sqlBefehlPizzabestellung);
 $abfragePizzabestellung->execute();
 $ergebnisPizzabestellung = $abfragePizzabestellung->fetchAll(); 
 
 
  $inarbeit = $_POST["inarbeit"];
  $id=$_POST['id'];

  if($_SERVER["REQUEST_METHOD"] == "POST"){
  
  $stmt = $verbindung->prepare("UPDATE bspdb.pizzabestellung SET inarbeit = ? WHERE id = ?");
   

  $stmt->execute([$inarbeit,$id]);
      
     
  $verbindung = null;


}
?>

<?php include "pizzaactionupdatedb.php"; 

?>

<table class='table table-dark'>
<thead><tr>
<th>Bestelldatum</th>
<th>Kundennr</th>
<th>Pizza</th>
<th>Zusatzbelag</th>
<th>Status</th>
<th>inarbeit</th>
<th>Update Data</th>


</tr></thead>

<tbody>
<?php foreach ($ergebnisPizzabestellung as $zeile): ?>
<tr>
<td><?= $zeile ['created_at'] ?> </td>
<td><?= $zeile ['Kundennr'] ?> </td>
<td><?= $zeile['Pizza'] ?> </td>
<td><?= $zeile['Belag'] ?> </td>
<td><?= $zeile['inarbeit'] ?> </td>

<!--<form method="POST" class="form-inline">-->
<form method="post"action="<?php echo htmlspecialchars($_SERVER['PHP_SELF']); ?>">
<td><div class="form-check">
<input class="form-check-input" type="checkbox" name="inarbeit" value ="inarbeit" id="flexCheckDefault"/>
<label class="form-check-label" for="flexCheckDefault">
</label>
</div></td>


<td>              
<input type="hidden" name="id" value=<?= $zeile['id'] ?>>

<button type="submit" class="btn btn-success" value='submit' name="submit">Update Data</button></td>


</form>

</tr>
<?php endforeach ?>

</tbody>
</table>

<script
src="https://code.jquery.com/jquery-3.3.1.js"integrity="sha256-2Kok7MbOyxpgUVvAk/HJ2jigOSYS2auK4Pfzbm7uH60="crossorigin="anonymous"></script>

<?php 
$username = 'xx';
$passwort = 'xx';
$server = 'xxxxcharset=utf8mb4';

try{
    $verbindung = new PDO($server, $username,$passwort);
}
catch(Exception $fehler){
    print $fehler->getMessage();
}

if(isset($_POST['update'] )){

foreach($_POST['check'] as $key=> $value){

$stmt = $verbindung->prepare("UPDATE xxx.pizzabestellung SET inarbeit = 0 WHERE id = :id LIMIT 1");
$stmt->bindParam('id',$value);

$stmt->execute();  

}
}
?>

<script>
$(document). ready (function(){
$("#form1 #select-all"). click (function(){
$("#form1 input[type='checkbox']").prop('checked',this.checked);
});
});
</script>

<form id="form1" method="POST">

<table class='table table-dark'>
<th>Bestelldatum</th>
<th>Kundennr</th>
<th>Pizza</th>
<th>Zusatzbelag</th>
<th>Status</th>
<th><input type="checkbox" id="select-all"/></th>

<?php $sqlBefehlPizzabestellung = "SELECT id,created_at,Kundennr,Pizza,Belag,inarbeit from xxx.pizzabestellung ORDER BY created_at DESC";
$abfragePizzabestellung = $verbindung->prepare($sqlBefehlPizzabestellung);
$abfragePizzabestellung->execute();

 while($row = $abfragePizzabestellung->fetch()){
 $cd = $row['created_at'];
 $Kundennr = $row['Kundennr'];
 $Pizza = $row['Pizza'];
 $Belag = $row['Belag'];
 $inarbeit = $row['inarbeit'];
 $id = $row['id'];

 echo "<tr>   
 <td> $cd </td>
 <td>$Kundennr </td>
 <td> $Pizza </td>
 <td>$Belag </td>
 <td>$inarbeit</td>
 <td><input type='checkbox' name='check[]' value='$id'</td>
 </tr>";
 }
 ?>

<td><button type="SUBMIT" class="btn btn-success" value="updatedata" name='update'>Update Data</button></td>
</table>  
</form>