数据库中的空值

我的 SQL 配置:

即使我没有在数据库中设置空值，但我得到的是空结果，是否可以停止刷新时重新提交表单，从而导致空结果被输入到数据库中.我将输入一些表单验证以阻止将来将空结果传递到 post 脚本，但刷新页面仍然会发送空结果.

您的列名包含大小写混合的字母(Cats 和 cats 不一样)

我编辑了我的答案，从那里我改变了它:

到

我也犯了一个错误，因为 if(empty($_POST['email'] 缺少 ) 已修复.

还请确保，您的列名确实被称为 Email Type Cats 而不是 email type cats 将其更改为您数据库中的字母大小写.

您的表的原始结构:(

请参阅以下代码中的其余部分.

正如我在您的原始问题下的评论中所述，已为您整理了这些内容.

• 不要使用这种方法 VALUES ('$_POST[email]','$_POST[type]','$_POST[cats]') 你愿意接受SQL 注入

• 为避免重新提交导致空条目，您可以使用 header() 重定向到另一个页面，或使用 AJAX

但是，我确信在查询本身中还有其他方法可以做到这一点，我现在不记得如何了.

即:代替 echo 添加 1 条记录"；

你可以做 header("Location: added.php");exit();

您也可以使用条件语句:

尝试以下操作.它将检查空字段，并检查是否设置了upload提交类型按钮.

另外，我修改了您的查询方式，将 POST 变量替换为 mysqli_real_escape_string()

脚注:

只是说，以下:

应该是:

但是，正如我已经提到的，强烈不鼓励使用这种方法.

I am trying to make a VERY simple PHP form that posts a form to MySQL Database, however I am having some issues, and would welcome a simple fix for this if possible:

My PHP:

My HTML:

My SQL Configuration:

Even though I have not null set in the DB I am getting empty results, is it possible to stop the form resubmitting on refresh causing null results be entered into the DB. I will enter some form validation to stop null results passing into the post script in the future but refreshing the page still sends over null results.

Edit:

Your column names have mixed-case letters (Cats and cats are not the same)

I edited my answer, where I changed it from:

to

I also made a mistake with a missing ) for if(empty($_POST['email'] which has been fixed.

Please make sure also, that your column names are indeed called Email Type Cats and not email type cats Change it to the letter-case that is in your DB.

Your table's original structure: (larger image)

• You should have talked to me first, instead of posting a new question with my code

See the rest below in the code.

As I stated in my comments under your original question, have put this together for you.

• Don't use this method VALUES ('$_POST[email]','$_POST[type]','$_POST[cats]') you're open to SQL injection

• To avoid re-submissions causing an empty entry, you can use a header() to redirect to another page, or use AJAX

However, I am sure there are other ways of doing this in the query itself, I just don't remember how right now.

I.e.: In place of where you have echo "1 record added";

you can do header("Location: added.php"); exit();

You can also use a conditional statement:

Try the following. It will check for empty fields, as well as check if the upload submit-type button is set.

Plus, I modified the way your query was done, replacing POST variables with mysqli_real_escape_string()

Footnotes:

Just saying, the following:

should have been:

However, using this method is highly discouraged, as I already mentioned.