如何从不同的行从我的数据库中使用模态对话框回声不同的数据 - How to echo different data from different rows from my database using modal dialog?

How to echo different data from different rows from my database using modal dialog?

我有一个数据显示表，它有一个链接(服务器的配置文件)，弹出一个模态对话框，预计将显示基于每一行数据库的数据。在我的情况下，模态对话框显示在我的数据库的第一行上的数据，即使当我点击第二行和任何其他行的链接。

<tbody>       
    <?php
    $result = mysqli_query($con,"SELECT * FROM general_reservation ");
    $count = mysqli_num_rows($result);
echo "<b><center><h3>Cars Reserved By Districts</h3></center></b><br><br>";
while($row=mysqli_fetch_array($result)){
    ?>
    <tr>
         <td><center><input type="checkbox" name="check[<?php echo $row['reservation_id'];?>]" value="1" ></center> </td>
           <td><input type="" name="car_type[]" value="<?php echo $row['car_type'];?>" readonly></label></td>
            <td><input style="width: 100px" type="" name="trim[]" value="<?php echo $row['trim'];?>" readonly></label></td>
            <td><input style="width: 80px" type="" name="year_made[]" value="<?php echo $row['year_made'];?>" readonly></label></td>
            <td><input style="width: 80px" type="" name="km[]" value="<?php echo $row['km'];?>" readonly></label></td>
            <td><input style=" background-color:<?php echo $row['exterior_colour'];?>; width: 55px;" type="" name=" exterior_colour[]" value="" readonly></label></td>
            <td><input type="" name="options[]" value="<?php echo $row['options'];?>" readonly></label></td>
            <td><input style="width: 65px" type="" name="quantity[]" value="<?php echo $row['quantity'];?>" readonly></label></td>
            <td><input type="" name="time[]" value="<?php echo $row['time'];?>" readonly></label></td>
            <td><textarea  type="" name="comment[]" value="<?php echo $row['comment'];?>" readonly><?php echo $row['comment'];?></textarea></td>
            <td><a  type="submit"  class="btn btn-link" data-toggle="modal" data-target="#myModal" >Reserver's Profile</a></td>
  <div class="modal fade" id="myModal" role="dialog">
    <div class="modal-dialog modal-sm">
      <div class="modal-content">
        <div class="modal-header">
          <button type="button" class="close" data-dismiss="modal">&times;</button>
          <h4 class="modal-title"><center>Reserver</center></h4>
        </div>
        <div class="modal-body">
           <p >First Name: <?php echo $row['fname'];?> </p><br>
           <p >Last Name: <?php echo $row['lname'];?></p><br>
           <p >Mobile Number: <?php echo $row['mobile_number'];?></p>
        </div>
        <div class="modal-footer">
          <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
        </div>
      </div>
    </div> 
  </div>

    </tr>
    <?php } //end of while loop ?>
    </tbody>

你需要唯一的id为情态，然后更新:

 data-target="#myModal"

例如，在行循环上方创建一个变量:

$i = 0;
while ( ... )
    # increment the pointer in the loop:
    $modal_id = 'myModal' . $i;
    $i ++;

然后将这个唯一的id附加到每个模态

 data-target="#<?php echo $modal_id; ?>"

和

<div class="modal fade" id="<?php echo $modal_id; ?>" role="dialog">

注意:使用Ajax会更好，尽管它是更高级的技术。