当我单击表格表单中的特定行时,如何根据 id 进行调用


How do i call out according to the id when i click on specific row in my table form?

这是我选择按钮的代码,但即使我单击第二个id,它也会继续检索第一个id。

include "lib/mssql.connect.php";
    $sql = "SELECT * FROM tbl_adminip WHERE id =  id";
    // run the query
     $result = sqlsrv_query($conn, $sql);
     if($row = sqlsrv_fetch_array( $result, SQLSRV_FETCH_ASSOC))
        {
        ?>
        <div class="container">
            <div class="row">
                <div class=" col-md-12 col-lg-12 col-sm-12 col-lg-12">
                    <legend>Edit IP</legend>
                    <p id="details"></p>
                </div>
            </div>
        </div>
        <div class="modal fade"  id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
                <div class="modal-dialog">
                    <div class="modal-content">
                        <div class="modal-header">
                            <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
                            <h4 class="modal-title">Edit Duty Officer</h4>
                        </div>
                        <div class="modal-body">
                            <div id="display">
                            <label class="col-lg-2 control-label">ID</label>
                                <div class="col-lg-10">
                                    <input type="text" class="form-control" id="txtid" value="<?=$row['id'] ?>" disabled="">
                                </div>
                                <label for="inputIP" class="col-lg-2 control-label">IP Address</label>
                                <div id="ip" class="col-lg-10">
                                    <input type="text" class="form-control" id="txtName" value="<?=$row['adminip']; ?>" placeholder="IP" data-content="Please enter your IP Address" data-container="body" data-toggle="popover" data-placement="bottom">
                                </div>
                            </div>
                        </div>
                        <div class="modal-footer">
                            <button type="button" class="btn btn-default btn-sm" data-dismiss="modal">Cancel</button>
                            <button type="button" class="btn btn-danger btn-sm" onclick="AccountInfo()">Save</button>
                        </div>
                    </div>
                </div>
            </div>
        </div>

似乎您使用 if 语句而不是循环访问您从database获取的数据。试试这个

include "lib/mssql.connect.php";
$sql = "SELECT * FROM tbl_adminip WHERE id =  id";
// run the query
  $result = sqlsrv_query($conn, $sql);
 //if($row = sqlsrv_fetch_array( $result, SQLSRV_FETCH_ASSOC))
   while($row = sqlsrv_fetch_array( $result, SQLSRV_FETCH_ASSOC)) 
    {
    ?>
    <div class="container">
        <div class="row">
            <div class=" col-md-12 col-lg-12 col-sm-12 col-lg-12">
                <legend>Edit IP</legend>
                <p id="details"></p>
            </div>
        </div>
    </div>
    <div class="modal fade"  id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
            <div class="modal-dialog">
                <div class="modal-content">
                    <div class="modal-header">
                        <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
                        <h4 class="modal-title">Edit Duty Officer</h4>
                    </div>
                    <div class="modal-body">
                        <div id="display">
                        <label class="col-lg-2 control-label">ID</label>
                            <div class="col-lg-10">
                                <input type="text" class="form-control" id="txtid" value="<?=$row['id'] ?>" disabled="">
                            </div>
                            <label for="inputIP" class="col-lg-2 control-label">IP Address</label>
                            <div id="ip" class="col-lg-10">
                                <input type="text" class="form-control" id="txtName" value="<?=$row['adminip']; ?>" placeholder="IP" data-content="Please enter your IP Address" data-container="body" data-toggle="popover" data-placement="bottom">
                            </div>
                        </div>
                    </div>
                    <div class="modal-footer">
                        <button type="button" class="btn btn-default btn-sm" data-dismiss="modal">Cancel</button>
                        <button type="button" class="btn btn-danger btn-sm" onclick="AccountInfo()">Save</button>
                    </div>
                </div>
            </div>
        </div>
    </div>