Gravar valor do option no referente a linha

[kaiobaia 0]

foreach ($sql as $key => $item):
                            ?>                               
                            <tr>                                      
                                <th  class="small"><?php echo $item['ID']; ?></th> 
                                <th  class="small"><?php echo $item['CODFIL']; ?></th>
                                <th  class="small"><?php echo $item['NUMPED']; ?></th>
                                <th  class="small"><?php echo $item['CODPRO']; ?></th>
                                <th  class="small"><?php echo $item['NOMCLI']; ?></th>
                                <th  class="small"><?php echo $item['QTDFAT']; ?></th>
                                <th  class="small"><?php echo $item['CIDCLI']; ?></th>
                                <th  class="small"><?php echo $item['CPLIPD']; ?></th>
                                <th  class="small"><?php echo $item['NOMTRA']; ?></th>
                                <th  class="small"><?php echo $item['NOMMOT']; ?></th>   
                                <th  class="small"><input class="form-control form-control-sm" type="text" style="width: 60; text-align: center; margin-right: auto;  margin-left: auto"></th>   
                                <th  class="small">  
                                    <select class="form-control form-control-sm" id="poscar">
                                        <option><?php echo $item['POSCAR']; ?></option>
                                        <option value="D">D</option>
                                        <option value="C">C</option>
                                        <option value="L">L</option>
                                    </select>
                                </th>
                                <th  class="small"><?php echo $item['DATCHE']; ?></th>
                                <th> <input TYPE="submit" id="botao" value="Enviar" >
                                </th>
                            </tr>
 
                        <?php endforeach; ?>  

 

[Frank K Hosaka 0]

arquivo /astudy/index.php
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.2/dist/css/bootstrap.min.css" 
    rel="stylesheet">
<style>
    th {font-size: 12px} 
</style>
<table class='table table-striped'>
<tr><th>ID<th>FILIAL<th>NUMPED<th>CODPRO<th>NOME CLIENTE<th>QT M3<th>DESTINO
    <th>PRODUTO<th>TRANSPORTADORA<th>MOTORISTA<th>LITRAGEM A 20°.<th>POSICAO
    <th>DATA CHEGADA<th>OPÇÕES
<?php
$mysqli=new mysqli("localhost","root","","laravel");
if(isset($_GET['POSCAR'])){
    $poscar=$_GET['POSCAR'];
    $id=$_GET['ID'];
    $mysqli->query("update produto set POSCAR='$poscar' where id=$id");}
$query=$mysqli->query("select * from produto");
$sql=$query->fetch_all(MYSQLI_ASSOC);
foreach ($sql as $key=>$item): ?>
<form>
    <tr>                         
    <th><?=$item['ID']?><input type=hidden name=ID value=<?=$item['ID']?>>
    <th><?=$item['CODFIL']?>
    <th><?=$item['NUMPED']?>
    <th><?=$item['CODPRO']?>
    <th><?=$item['NOMCLI']?>
    <th><?=$item['QTDFAT']?>
    <th><?=$item['CIDCLI']?>
    <th><?=$item['CPLIPD']?>
    <th><?=$item['NOMTRA']?>
    <th><?=$item['NOMMOT']?>
    <th><input class="form-control" style=width:50px value=<?=$item['LITRAG']?>>
    <th> 
            <select class="form-select" name="POSCAR">
            <option><?=$item['POSCAR']?></option>
            <option value="D">D</option>
            <option value="C">C</option>
            <option value="L">L</option>
            </select>
            <th><?=date('d/m/y',strtotime($item['DATCHE']))?></th>
            <th> <input type=submit>
</form>
<?php endforeach; ?>  
</table>

arquivo /astudy/mysql
CREATE TABLE `produto` (
  `ID` int NOT NULL,
  `CODFIL` int NOT NULL,
  `NUMPED` int NOT NULL,
  `CODPRO` varchar(6) NOT NULL,
  `NOMCLI` varchar(45) DEFAULT NULL,
  `QTDFAT` int DEFAULT NULL,
  `CIDCLI` varchar(45) DEFAULT NULL,
  `CPLIPD` varchar(45) DEFAULT NULL,
  `NOMTRA` varchar(45) DEFAULT NULL,
  `NOMMOT` varchar(45) DEFAULT NULL,
  `LITRAG` float DEFAULT NULL,
  `POSCAR` varchar(1) DEFAULT NULL,
  `DATCHE` date DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
INSERT INTO `produto` VALUES (9,101,4950,'000620','IPIRANGA PRODUTOS DE PETROLEO SA',100,'GOIANIA','HIDRATADO','dalkjdlkasdka','dakjlsdkjlaskjldla',NULL,'F','2019-05-25'),
(8,101,4950,'000620','TESTE',10,'TESTE','HIDRATADO','dasdsfsd','dakjlsdkjlaskjldla',NULL,NULL,'2019-05-24'),
(6,101,4950,'000620','TESTE',20,'TESTE','HIDRTADO','TESTE','dakjlsdkjlaskjldla',NULL,'C','2019-05-24'),
(4,101,4950,'000620','TESTE',60,'TESTE',NULL,'TESTE','dakjlsdkjlaskjldla',NULL,NULL,'2019-05-24');