问如何通过在下拉列表中选择一个选项来从另一个php文件中获取数据？

EN

<?php
include 'dbcontroller.php';
$sql = "SELECT * FROM requests where status='approved' ORDER by date DESC";
$result = $conn->query($sql);

?>
<table>
    <thead>
        <tr>
            <th>Name</th>
            <th>Batch Year</th>
            <th>Section</th>
            <th>Action</th>
        </tr>
    </thead>
       <tbody>
        <?php
            if ($result->num_rows > 0) {
                // output data of each row
                while($row = $result->fetch_assoc()) {
                    echo '<tr>';
                    echo '<td>'.$row['firstname'].' '.$row['lastname'].' </td>';
                    echo '<td>'.$row['batchYr'].'</td>';
                    echo '<td>'.$row['section'].'</td>'; 

                 }                   
            }
            else {
                echo "No records found.";
            }
            $conn->close();         
        ?>  
    </tbody>
</table>

$sql = "SELECT * FROM requests where status='pending' ORDER by date DESC";