如何从数据库中捕获 ID 以更新状态？

Question

我正在尝试通过单击更新按钮将状态从待处理更新为“已批准”。但是，当我单击按钮时，它没有响应并更改状态。但是，如果我对 ID 进行硬编码，则状态可以更新。如何从数据库中获取 ID 捕获并在单击按钮后更新状态？

//edit1.php:

<?php

    $con= mysqli_connect('127.0.0.1','root','');

    if(!$con)

    {

        echo 'Not Connected To Server';

    }

    if(!mysqli_select_db($con,'satsform1'))

    {

        echo 'Database Not Selected';

    }

    $ID = 'ID';

    $sql = "update handover set status= 'Approved' where ID = '$ID'";

    if(!mysqli_query($con,$sql))

    {

        echo 'Not Submitted';

    }

    else

    {

        echo "<meta http-equiv='refresh' content='0;url=index3.php'>";

    }

?>

<?php

//fetch3.php

$connect = mysqli_connect('127.0.0.1','root','', 'satsform1');

$output = '';

if(isset($_POST["query"]))

{

 $search = mysqli_real_escape_string($connect, $_POST["query"]);

 $query = "

  SELECT * FROM handover 

  WHERE name LIKE '%".$search."%'

  OR staffno LIKE '%".$search."%' 

  OR date LIKE '%".$search."%'

  OR email LIKE '%".$search."%'

  OR mobno LIKE '%".$search."%'

  OR roles LIKE '%".$search."%'

  OR location LIKE '%".$search."%'

  OR flightno LIKE '%".$search."%'

  OR flightdate LIKE '%".$search."%'

  OR seatno LIKE '%".$search."%'

  OR class LIKE '%".$search."%'

 ";

}

else

{

 $query = "

  SELECT * FROM handover ORDER BY ID

 ";

}

$result = mysqli_query($connect, $query);

if(mysqli_num_rows($result) > 0)

{

 $output .= '

  <div class="table-responsive">

   <table class="table table bordered">

    <tr>

     <th>ID</th>

     <th>Staff Name</th>

     <th>Staff Number</th>

     <th> Status </th>

    </tr>

 ';

 while($row = mysqli_fetch_array($result))

 {

  $output .= '

   <tr>

    <td>'.$row["ID"].'</td>

    <td>'.$row["name"].'</td>

    <td>'.$row["staffno"].'</td>

    <td>'.$row["status"].'</td>

    // this is the update button where use the edit1.php to update the status by ID

    <td> <form action="edit1.php" method="GET">

            <button type="submit">update </button>

        </form>

    </td>

   </tr> 

  ';

 }

 echo $output;

}

else

{

 echo 'Data Not Found';

}

?>

我希望输出能够在单击更新按钮后将状态更新为“已批准”到数据库中。