同一表单中的多个单选按钮评级

Question

我试图搜索，但我无法找到我正在寻找帮助我。我正在做一个评级表单，使用单选按钮星形评级，我正在使用mysqli_fetch_assoc的while循环从下面显示的database.As中拉取日期

<?php
    $sql = "SELECT * FROM orderdetail,orderuser,food WHERE orderuser.CustomerID=orderdetail.CustomerID AND orderuser.OrderID=orderdetail.OrderID AND orderdetail.FoodID=food.FoodID AND orderuser.confirmstatus=1";
    $result = $conn->query($sql) or die($conn->error);


    while($colum = mysqli_fetch_assoc($result))
    {
?>
<img src="../php/<?php echo $colum['Foodphoto'];?>" style="height:150px;width:150px">
<br>
<?php echo $colum['FoodName'];?>
<br>
<div class="stars">
    <form action="">
        <input class="star star-5" id="rate-5[]" type="radio" name="rate[]" />
        <label class="star star-5" for="rate-5[]"></label>
        <input class="star star-4" id="rate-4[]" type="radio" name="rate[]" />
        <label class="star star-4" for="rate-4[]"></label>
        <input class="star star-3" id="rate-3[]" type="radio" name="rate[]" />
        <label class="star star-3" for="rate-3[]"></label>
        <input class="star star-2" id="rate-2[]" type="radio" name="rate[]" />
        <label class="star star-2" for="rate-2[]"></label>
        <input class="star star-1" id="rate-1[]" type="radio" name="rate[]" />
        <label class="star star-1" for="rate-1[]"></label>
    </form>
</div>
<hr>
<?php
    }
?>

但是第二个结果的评分不起作用，我发现这是由于名称的问题，但我试图通过添加数组来编辑它仍然不起作用。我如何使用php将它们存储到mysql中?这些教程我只使用ajax或jquery找到，我需要在用户提交表单后提交评分。

Answer 1

我认为问题是您无法将提交的表单与记录相关联，因此任何更新都不会按预期工作。要实现这一点，最简单的方法之一就是使用一个带有记录ID的隐藏字段--该ID可以用在update语句中-即：(伪sql update )

update orderdetail set rating=$rate where ID=$id

因此，可以为每个表单添加一个隐藏字段，如下所示

    while($colum = mysqli_fetch_assoc($result)){
?>

<img src='../php/<?php echo $colum['Foodphoto'];?>' style='height:150px;width:150px'>
<br>
<?php echo $colum['FoodName'];?>
<br>

<div class='stars'>
  <form action=''>
    <input class='star star-5' type='radio' id='rate-5' name='rate' />
    <label class='star star-5' for='rate-5'></label>

    <input class='star star-4' type='radio' id='rate-4' name='rate' />
    <label class='star star-4' for='rate-4'></label>

    <input class='star star-3' type='radio' id='rate-3' name='rate' />
    <label class='star star-3' for='rate-3'></label>

    <input class='star star-2' type='radio' id='rate-2' name='rate' />
    <label class='star star-2' for='rate-2'></label>

    <input class='star star-1' type='radio' id='rate-1' name='rate' />
    <label class='star star-1' for='rate-1'></label>
    <!--
        HIDDEN FIELD WITH ID
    -->
    <input type='hidden' name='id' value='<?php echo $colum['id'];?>' />
  </form>
</div>
<hr>