สอบถามหน่อยค่ะ ส่งค่าไป Popup ยังไงคะ ให้ ดึงข้อมูลเฉพาะที่เราต้องการ ลอง echo ออกมามีค่า แต่ ทำไมพอโยนไปใส่ใน sql แล้วไม่มีข้อมูล รบกวนด้วยค่ะ

echo $_POST['deptcode'];

<?php

        echo $_POST['ut_deptcode'];
?>

                <div class="modal fade" id="popdept" name="popdept" role="dialog">
                  <div class="modal-dialog modal-lg">
                    <div class="modal-content">
                      <div class="modal-header">
                        <button type="button" class="close" data-dismiss="modal">&times;</button>
                             <p class="modal-title" style="font-size: 18px">Select Manager Check</p>
                      </div>
                        <div class="modal-body">
                          <p class="text-center" style="font-size: 16px">Please Select Manager Check</p>
                                <div class="row">
                                  <div class="table-responsive">
                                    <div class="col-sm-12">
                                     <table id="dept" name="dept" class="table table-striped table-bordered dt-responsive nowrap" cellspacing="0" width="100%">
                                          <thead>
                                            <tr>
                                              <th class="text-center">EMP_ID</th>
                                              <th class="text-center">EMP_NAME</th>
                                              <th class="text-center">DEPTCODE</th>
                                              <th class="text-center">DEPARTMENT</th>
                                              <th class="text-center">SELECT</th>
                                            </tr>
                                          </thead>
                                            <tbody>
                                            <?php  
 
             ini_set('display_errors', 1);
             error_reporting(~0);
     
             error_reporting(error_reporting() & ~E_NOTICE ); 
     
           
             $SVName = "localhost";
             $USName = "root";
             $USPassword = "1234";
             $DBName = "test";
     
             $conn = mysqli_connect($SVName, $USName, $USPassword, $DBName);
     
             if (mysqli_connect_error()) {
     
                 echo "DB Connect Fail.!" .mysqli_connect_error();
     
             } else {
                 //echo "DB Connect";
             }
  //$sql = "SELECT * FROM dept";

  $sql = "SELECT * FROM dept WHERE deptcode = '".$_POST['ut_deptcode']."'";

  $result = $conn->query($sql);
          
   while($row= $result->fetch_assoc()){

            $id = $row['id'];
            $name = $row['name'];
            $deptcode = $row['deptcode'];
            $dept = $row['dept'];

            
            // echo $id;
            // echo '<br>';
            // echo $name;
            // echo '<br>';
            // echo $deptcode;
            // echo '<br>';
            // echo $dept;
            // echo '<br>';
            // echo $position;
            // echo '<br>';
            // echo $email;
            // echo '<br>';
?>
                           

                                    <tr>
                                        <td class="text-center"><?php echo $id; ?></td>
                                        <td><?php echo $name; ?></td>
                                        <td><?php echo $dept; ?></td>
                                        <td><?php echo $deptcode; ?></td>
                                        <td class="text-center">
                                          <button class="btn btn-info btn-sm" id="BtnDept" name="BtnDept" type="button">
                                            <b>Select</b>
                                          </button>
                                        </td>
                                      </tr>
      <?php } ?>
                                    </tbody>
                                  </table>
                              </div>
                            </div>
                          </div>
                        </div>  
                          <div class="modal-footer"></div>
                      </div>
                    </div>
                  </div>
                </div>

               
                  <script>
                    $(document).ready(function() {
                        $('#dept').DataTable();
                    });

                  </script>

<script>

                 $('#BtnSel').click(function(){

                        var ut_deptcode = $('#ut_deptcode').val();

                                $.ajax({    
                                    url:"popupdept.php",
                                    method:"POST",  
                                    data:{ut_deptcode:ut_deptcode}, 
                                  success:function(ut_deptcode)  
                                    {  
                                       $('#popdept').html(ut_deptcode);  
                                 
                                      }  
                                    });  
                        
                                  console.log(ut_deptcode);
                                  
                                  var ut_deptcodeObj = document.getElementById('ut_deptcode');
                                        ut_deptcodeObj.value = ut_deptcode;

                            });

                        </script>