php - 使用从我的选项标签中检索到的信息来查询我的数据库以获取更多信息

Question

因为我在后端不是很好，所以现在已经在这里存货了几个小时。我想在做出选择后立即在我的输入字段中自动显示信息。但是只有当我将它一起显示在选择标签中时它才会出现。

<table class="table table-striped">
                            <tfoot>
                                <tr>  
                                    <th width="40%">
                                        <ul class="list-unstyled"> 
                                             <label for="doctor_id" class=" col-form-label">Enter ID</label>    
                                              <div class="form-group row">

                                <div class="col-xs-9">
                                   <select name="patid" class="chosen form-control">
                                        <option value="" selected="selected">Select Patient</option>
                                        <?php 
                include '../db/db_connect.php';    

 $exp = "select * from addpat";      
 $expend = $connect->query($exp); 

while ($row=$expend->fetch_assoc())
{
echo " <option>" . $row['username'] ."</option>";
" <option>" . $row['fullname'] ."</option>";

}
?>


</select>
                                </div>
                            </div>
<script type="text/javascript">
$(".chosen").chosen();
</script>                                            


                <li><label for="doctor_id" class=" col-form-label">Fullname</label>
                    <input name="fullname"  type="text" class="form-control" placeholder="Patient Name" value="">
                </li>  
                                            <li> 
                                            <label for="doctor_id" class=" col-form-label">Address</label>
                                                <input name="address"  type="text" class="form-control" placeholder="Address">
                                            </li>  
                                        </ul>
                                    </th>  
                                    <th width="20%" class="text-center"> 
                                        <strong style="border:1px solid #ccc;line-height:60px;padding:5px 10px;">Invoice</strong> 
                                    </th>  
                                    <th width="40%">
                                        <h4>
                                            Date :  
                                            <input name="dob" id="txtDate" data-provide="datepicker" data-date-format="yyyy-mm-dd"  placeholder="Date Of Birth"><br> 
                                            Amazing Grace<br> 
                                            98 Green rooad adad</h4>
                                    </th> 
                                </tr>
                            </tfoot>
                        </table>

标签： phphtmlmysqlajax