发送数据到bootstrap模式并执行mysql查询


Send data to bootstrap modal and perform a mysql query

    while($row = mysqli_fetch_array($result_from_query)){   
     <a class="modal-trigger" href="#basicModal" data-toggle="modal" data-target="#basicModal" data-id="<?php echo $row['invoice_no']; ?>"><?php echo $row['invoice_no']; ?>
        </a>
}
<div class="modal fade" id="basicModal" tabindex="-1" role="dialog" aria-labelledby="basicModal" aria-hidden="true">
            <div class="modal-dialog">
                <div class="modal-content">
                    <div class="modal-header">
                    <h5 class="modal-title" id="myModalLabel">Invoice Item</h4>
                    </div>
                    <div class="modal-body">
                        <input type="text" name="invoice" id="invoice" value=""/>
                    </div>
                    <div class="modal-footer">
                        <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
                    </div>
                </div>
          </div>
        </div>
 <script type="text/javascript">
            $(document).on("click", ".modal-trigger", function () {
             var invoiceNO = $(this).data('id');
             $(".modal-body #invoice").val( invoiceNO );
        });
        </script>

所以我有这个代码发送数据到模态,并把它放在一个<input name="invoice" />现在我的问题是我想把它放在一个php变量使用它在#basicModaldiv内的查询。像这样

<div class="modal fade" id="basicModal" tabindex="-1" role="dialog" aria-labelledby="basicModal" aria-hidden="true">
            <div class="modal-dialog">
                <div class="modal-content">
                    <div class="modal-header">
                    <h5 class="modal-title" id="myModalLabel">Invoice Item</h4>
                    </div>
                    <div class="modal-body">
                        <?php 
                             $result = mysqli_query($conn, 'SELECT item from invoice_tab where invoice no = ' $invoice_no);
                             $data = mysqli_fetch_assoc($result);
                             echo $data['item'];
                        ?>
                    </div>
                    <div class="modal-footer">
                        <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
                    </div>
                </div>
          </div>
        </div>

,但我不知道如何把数据在PHP变量…

你为什么不使用你的:

$row['invoice_no'];

在您的第一个示例中填充SQL查询的模式?