INSERT IND在phpMyAdmin中工作，但在PHP中不起作用 - INSERT INTO works in phpMyAdmin but not in PHP

INSERT INTO works in phpMyAdmin but not in PHP

我正在尝试在 php 中运行查询，如下所示：

<?php
        $email = mysql_real_escape_string($_POST['email']);
        if(isset($_POST['savedata'])){
            $sql = "INSERT INTO registered (email)
                    VALUES (
                        '$email'
                    )";
            $result = mysql_query($sql);
            if(!$result){
                echo 'something went wrong, please try again.';
                echo mysql_error();
            } else {
                echo '<meta http-equiv="refresh" content="2; url = subscribed.php" />';
            }
        }
    ?>

执行触发器来自以下形式：

<form action="" method="post">
    <div class="form-group">
        <label class="sr-only" for="exampleInputEmail2">Email address</label>
        <input type="email" name="email" id="email" class="form-control transparent" placeholder="Your email here...">
    </div>
    <input type="submit" name="submit" class="btn btn-warning btn-fill">Notify Me</input>
    <input type="hidden" name="savedata" value="savedata"/>
</form>

这在phpMyAdmin中运行良好（当然，我将$email更改为真实地址），但是除了刷新之外，php中没有任何反应。数据库没有更新，我检查了连接 - 它正在工作。请指教。谢谢！

尝试以下查询：

$sql = "INSERT INTO registered (email)
                    VALUES (
                        '".$email."'
                    )";