php插入单选按钮值仅适用于移动设备

Question

我有一个表格，前一天还可以使用，现在只能在我的 iPhone 上使用。我的 mySQL 有 4 列，id，submissiondate，housenumber，answer，hostname

从我的 iPhone 提交时它们都可以工作。

如果您在桌面上尝试，“答案”(3 个单选按钮)不起作用，并且会插入一条空白记录。

想知道是否有人遇到过这种情况。

if (isset($_POST["submit"])) {

    $Answer = $_POST['Answer'];

    if ($_POST['housenumber'] == "") {
        echo "<div class='container' style='text-align:left'><div role='alert' class='alert alert-danger'>
<p class='lead'><strong>ERROR!</strong> All fields are required</p></div></div>";
    } else {
        $hostname='XXXXXXXXXXX';
        $username='XXXXXXXXXXX';
        $password='XXXXXXXXXXX';
        try {
            $dbh = new PDO("mysql:host=$hostname;dbname=qlfence",$username,$password);

            $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // <== add this line
            $sql = "INSERT INTO qlfence (id, SubmissionDate, housenumber, Answer, hostname)

VALUES ('id', NOW(),'".$_POST["housenumber"]."','".$_POST["Answer"]."','".$_POST["hostname"]."')";

            if ($dbh->query($sql)) {
                echo "<div class='container' style='text-align:left'><div class='alert alert-success' role='alert'><p class='lead'><strong>Awesome!</strong> Thanks for your input.</p></div></div>";
            }
            else{
                echo "<script type= 'text/javascript'>alert('Opps, something went wrong. We will loo into');</script>";
            }
            header('Location: /index.php');
            $dbh = null;
        }
        catch(PDOException $e)
        {
            echo $e->getMessage();
        }
    }
}

?>
<form action="#" method="post"  class="" id="sendmessage" name="sendmessage" >
    <input type="hidden" class="form-control" id="hostname" name="hostname" readonly value="<?php echo $hostname; ?>" >
    <div class="row">
        <div class="col-md-2">&nbsp;</div>
        <div class="col-md-2"><center><input type="text" class="form-control" id="housenumber" name="housenumber" style="width: 35%; border: 2px solid black;"></center></div>
        <div class="col-md-6"><label for="housenumber"><span class="lead" >Quarrie Lane #</span></label> </div>
        <div class="col-md-2">&nbsp;</div>
        <br>
        <br><br>
    </div>
    <div class="row">
        <div class="col-md-2">&nbsp;</div>
        <div class="col-md-2"><input type="radio" id="a1" name="Answer" class="form-control" value="I am Willing to do the fence as soon as everyone is ready."></div>
        <div class="col-md-6"><label for="a1"><p class="lead">Willing to do the fence as soon as everyone is ready.</p></label></div>
        <div class="col-md-2">&nbsp;</div>
    </div>
    <div class="row">
        <div class="col-md-2">&nbsp;</div>
        <div class="col-md-2"><input type="radio" id="a2" name="Answer" class="form-control" value="I would rather wait until next summer."></div>
        <div class="col-md-6"><label for="a2"><p class="lead">I would rather wait until next summer.</p></label></div>
        <div class="col-md-2">&nbsp;</div>
    </div>
    <div class="row">
        <div class="col-md-2">&nbsp;</div>
        <div class="col-md-2"><input type="radio" id="a3" name="Answer" class="form-control" value="I am not the owner."></div>
        <div class="col-md-6"><label for="a3"><p class="lead">Not the owner.</p></label></div>
        <div class="col-md-2">&nbsp;</div>
    </div>
    <input name="submit" id="submit" type="submit" value="Submit Answer" class="btn btn-lg btn-primary btn-block"></input>
</form>

Answer 1

您没有收到 $_POST['Answer'] 的唯一原因是您在提交表单之前没有检查任何答案单选。

除了安全问题之外，您的代码还可以正常工作。但您应该考虑为您的 sql 查询添加更多安全性。

作为解决方法，您可以默认检查其中一个 radio ，如下所示:

<input checked="true" type="radio" id="a3" name="Answer" class="form-control" value="I am not the owner." />

在这种情况下，您将始终收到 $_POST['Answer']。