php - while循环多次显示一条记录php和mysql问题

Question

我正在尝试从数据库中获取数据。但是 while 循环正在执行并多次显示数据。请查看屏幕截图

<?php
$conn = mysqli_connect("localhost", "root", "","midata");
$sql = "SELECT * FROM campaign_profile ORDER BY id DESC"; 
?>
<div class="modal-body">
<form>
    <?php 
    $result = mysqli_query($conn,$sql);
    while($row = mysqli_fetch_array($result)) 
    { 
        $name= $row['campaign_name'];
        $issues= $row['issue_name'];
        $ename= $row['unused_elements'];
        $uquantity= $row['unused_number'];
        $descript= $row['experience']; ?>

        <div class="form-group">
            <label for="recipient-name" class="control-label">Campaign Name:</label>
            <input type="text" class="form-control c-square" id="recipient-name" value="<?php echo  $row['campaign_name'];?>">  
        </div>
        <div class="form-group">
            <label for="recipient-name" class="control-label">Issues:</label>
            <input type="text" class="form-control c-square" id="recipient-name" value="<?php echo $row['issue_name'];?>"> 
        </div>
        <div class="row col-md-12">
            <div class="form-group col-md-6">
                <label for="recipient-name" class="control-label">Element Name:</label>
                <input type="text" class="form-control c-square" id="recipient-name" class="col-md-6" value="<?php echo $row['unused_elements'];?>">
            </div>
            <div class="form-group col-md-6">
                <label for="recipient-name" class="control-label">Unused Quantity:</label>
                <input type="text" class="form-control c-square" id="recipient-name" class="col-md-6" value="<?php echo $row['unused_number'];?>"> 
            </div>
        </div>
        <div class="form-group">
            <label for="message-text" class="control-label">Description:</label>
            <textarea class="form-control  c-square" id="message-text" value="<?php echo $row['experience'];?>"></textarea>
        </div>

    <?php } ?>
</form>
</div>

我不明白为什么会发生这种情况。请让我知道需要做什么

Answer 1

可能您的表的行数超出您的预期。

使用此限制您的查询。

$sql = "SELECT * FROM campaign_profile ORDER BY id DESC limit 1";

或者尝试使用 id 或主键获取数据。

或更改下面给出的代码。

<?php
$conn = mysqli_connect("localhost", "root", "","midata");
$sql = "SELECT * FROM campaign_profile ORDER BY id DESC"; 
?>
<div class="modal-body">
<form>
    <?php 

        $name= "";
        $issues= "";
        $ename= "";
        $uquantity= "";
        $descript= ""; 

    $result = mysqli_query($conn,$sql);
    while($row = mysqli_fetch_array($result)) 
    { 
        $name= $row['campaign_name'];
        $issues= $row['issue_name'];
        $ename= $row['unused_elements'];
        $uquantity= $row['unused_number'];
        $descript= $row['experience']; 


 } ?>
   <div class="form-group">
            <label for="recipient-name" class="control-label">Campaign Name:</label>
            <input type="text" class="form-control c-square" id="recipient-name" value="<?php echo  $row['campaign_name'];?>">  
        </div>
        <div class="form-group">
            <label for="recipient-name" class="control-label">Issues:</label>
            <input type="text" class="form-control c-square" id="recipient-name" value="<?php echo $row['issue_name'];?>"> 
        </div>
        <div class="row col-md-12">
            <div class="form-group col-md-6">
                <label for="recipient-name" class="control-label">Element Name:</label>
                <input type="text" class="form-control c-square" id="recipient-name" class="col-md-6" value="<?php echo $row['unused_elements'];?>">
            </div>
            <div class="form-group col-md-6">
                <label for="recipient-name" class="control-label">Unused Quantity:</label>
                <input type="text" class="form-control c-square" id="recipient-name" class="col-md-6" value="<?php echo $row['unused_number'];?>"> 
            </div>
        </div>
        <div class="form-group">
            <label for="message-text" class="control-label">Description:</label>
            <textarea class="form-control  c-square" id="message-text" value="<?php echo $row['experience'];?>"></textarea>
        </div>
</form>
</div>