blocks|key|4624620|text|VALUES('.$username.','.$mail.','.$region.','.md5($pass).')|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|4624621|您需要将这些值括在引号中。|unstyled|4624622|VALUES("'.$username.'","'.$mail.'","'.$region.'","'.md5($pass).'")|4624623|还要考虑清理您的查询。从用户输入向数据库添加数据是一个非常糟糕的想法。More+info+here|offset|length|4624624|从@Ohgodwhy的评论展开，为什么你实际上根本没有运行这个查询。|4624625|您还应该检查输入数据是否为is+set，否则您将在将来遇到错误。|4624626|entityMap|0|LINK|mutability|MUTABLE|url|http://en.wikipedia.org/wiki/SQL_injection|1|http://uk3.php.net/isset^0|0|0|0|Z|E|0|0|0|D|6|1|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|11|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|12|8|@]|9|@]|A|$B|C]]|$1|I|3|J|5|F|7|13|8|@]|9|@$K|14|L|15|1|16]]|A|$]]|$1|M|3|N|5|F|7|17|8|@]|9|@]|A|$]]|$1|O|3|P|5|F|7|18|8|@]|9|@$K|19|L|1A|1|1B]]|A|$]]|$1|Q|3|-4|5|F|7|1C|8|@]|9|@]|A|$]]]|R|$S|$5|T|U|V|A|$W|X]]|Y|$5|T|U|V|A|$W|Z]]]]

<pre><code>VALUES('.$username.','.$mail.','.$region.','.md5($pass).')
</code></pre>

You need to wrap those values in quotes.

<pre><code>VALUES("'.$username.'","'.$mail.'","'.$region.'","'.md5($pass).'")
</code></pre>

Also consider sanitizing your query. Adding data to the database from a user input is a very bad idea. <a href="http://en.wikipedia.org/wiki/SQL_injection" rel="nofollow noreferrer">More info here</a>

Expanding on the comment from @Ohgodwhy you aren't actually running the query at all.

You should also put in checks to see if the input data <a href="http://uk3.php.net/isset" rel="nofollow noreferrer">is set</a>, otherwise you will run into errors in the future.

blocks|key|118741|text|如果数据库连接没有问题，那么问题可能出在SQL上。如果您想要使用md5，只需设置上面的变量pass|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|118742|这是错误的：|118743|VALUES('.$username.','.$mail.','.$region.','.md5($pass).');|code-block|syntax|javascript|118744|这是正确的：|118745|$pass+=+md5($pass);
VALUES+('$username','$mail','$region','$pass|118746|entityMap^0|K|3|W|3|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]|$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|X|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|Y|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|Z|8|@]|D|@]|E|$]]|$1|O|3|P|5|J|7|10|8|@]|D|@]|E|$K|L]]|$1|Q|3|-4|5|6|7|11|8|@]|D|@]|E|$]]]|R|$]]

If theres nothing wrong with the database connection then the problem might be the <code>SQL</code>. Incase you want to use <code>md5</code> just set the variable pass above

This is wrong:

<pre><code>VALUES('.$username.','.$mail.','.$region.','.md5($pass).');
</code></pre>

This is right:

<pre><code>$pass = md5($pass);
VALUES ('$username','$mail','$region','$pass
</code></pre>

blocks|key|118859|text|您忘了执行查询。这里。试试这个：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|118860|<?php

/*+ESTABLISH+YOUR+CONNECTION+*/

$dbc=mysqli_connect("localhost","root","","GameStore");

if(mysqli_connect_errno()){

echo+"Error".mysqli_connect_error();
}

/*+YOU+MAY+WANT+TO+CONSIDER+ESCAPING+THE+VARIABLES+FIRST+BEFORE+USING+THEM+INTO+A+QUERY+*/

$username+=+mysqli_real_escape_string($dbc,$_POST['username']);
$mail+=+mysqli_real_escape_string($dbc,$_POST['email']);
$region+=+mysqli_real_escape_string($dbc,$_POST['region']);
$pass+=+mysqli_real_escape_string($dbc,$_POST['password']);
$pass+=+md5($pass);

$insert+=+"INSERT+INTO+user+(username,+email,+region,+pwd_hash)
VALUES('$username','$mail','$region','$pass')";

mysqli_query($dbc,$insert);+/*+EXECUTE+YOUR+QUERY.+THIS+IS+THE+PART+OF+YOUR+CODE+YOU+FORGOT+TO+INCLUDE+*/

?>+|code-block|syntax|javascript|118861|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You forgot to execute the query. Here. Try this:

<pre><code>&lt;?php

/* ESTABLISH YOUR CONNECTION */

$dbc=mysqli_connect("localhost","root","","GameStore");

if(mysqli_connect_errno()){

echo "Error".mysqli_connect_error();
}

/* YOU MAY WANT TO CONSIDER ESCAPING THE VARIABLES FIRST BEFORE USING THEM INTO A QUERY */

$username = mysqli_real_escape_string($dbc,$_POST['username']);
$mail = mysqli_real_escape_string($dbc,$_POST['email']);
$region = mysqli_real_escape_string($dbc,$_POST['region']);
$pass = mysqli_real_escape_string($dbc,$_POST['password']);
$pass = md5($pass);

$insert = "INSERT INTO user (username, email, region, pwd_hash)
VALUES('$username','$mail','$region','$pass')";

mysqli_query($dbc,$insert); /* EXECUTE YOUR QUERY. THIS IS THE PART OF YOUR CODE YOU FORGOT TO INCLUDE */

?&gt; 
</code></pre>

blocks|key|118885|text|在按如下方式设置$insert字符串之后，当您应该使用mysqli_query时，您实际上并没有运行查询：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|118886|$dbc+=+mysqli_connect('localhost','root','')
or+die(mysqli_error());
$db_select+=+mysqli_select_db($dbc,'GameStore');.

if+(!$db_select)+{
++++die("Database+selection+failed:+"+.+mysqli_error());
}

$username+=+$_POST['username'];
$mail+=+$_POST['email'];
$region+=+$_POST['region'];
$pass+=+$_POST['password'];
$insert+=+'INSERT+INTO+user+(username,+email,+region,+pwd_hash)
VALUES('.$username.','.$mail.','.$region.','.md5($pass).')';
mysqli_query($dbc,+$insert);|code-block|syntax|javascript|118887|也就是说，我会像这样重构你的代码。注意，我添加了注释，但也设置了一个简化的解析$_POST值的过程，方法是设置数组中的键，然后使用isset检查它们是否确实设置好了。如果不是，则将它们设置为null。我还为整个查询字符串设置了双引号，以便它可以处理字符串替换(双引号可以做到这一点)，但对'"+.+md5($password)+.+"'区域使用了串联，因为这是对函数的调用。|118888|//+Set+the+DB+connection.
$dbc+=+mysqli_connect('localhost','root','')+or+die(mysqli_error());

//+Select+the+DB.
$db_select+=+mysqli_select_db($dbc,'GameStore');.

//+Send+an+error+message+if+the+DB+select+failed.
if+(!$db_select)+{
++die("Database+selection+failed:+"+.+mysqli_error());
}

//+Set+an+array+for+'$_POST'+values+&+roll+through+them.
$post_array+=+array('username','email','region','password');
foreach($post_array+as+$post_key+=>+$post_value)+{
++$$post_key+=+isset($_POST[$post_key])+?+$_POST[$post_key]+:+null;
}

//+Set+the+insert+query.
$insert+=+"INSERT+INTO+user+(username,+email,+region,+pwd_hash)
VALUES('$username','$email','$region.','"+.+md5($password)+.+"')";

//+Run+the+insert+query.
$db_insert+=+mysqli_query($dbc,+$insert);

//+Send+an+error+message+if+the+query+failed.
if+(!$db_insert)+{
++die("Database+insert+failed:+"+.+mysqli_error());
}|118889|entityMap|0|LINK|mutability|MUTABLE|url|http://us1.php.net/mysqli_query^0|8|7|R|C|R|C|0|0|0|1T|5|2N|4|40|O|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@$9|X|A|Y|B|C]|$9|Z|A|10|B|C]]|D|@$9|11|A|12|1|13]]|E|$]]|$1|F|3|G|5|H|7|14|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|15|8|@$9|16|A|17|B|C]|$9|18|A|19|B|C]|$9|1A|A|1B|B|C]]|D|@]|E|$]]|$1|M|3|N|5|H|7|1C|8|@]|D|@]|E|$I|J]]|$1|O|3|-4|5|6|7|1D|8|@]|D|@]|E|$]]]|P|$Q|$5|R|S|T|E|$U|V]]]]

You are not actually running the query when you should use <a href="http://us1.php.net/mysqli_query" rel="nofollow"><code>mysqli_query</code></a> after you set the <code>$insert</code> string like this:

<pre><code>$dbc = mysqli_connect('localhost','root','')
or die(mysqli_error());
$db_select = mysqli_select_db($dbc,'GameStore');.

if (!$db_select) {
 die("Database selection failed: " . mysqli_error());
}

$username = $_POST['username'];
$mail = $_POST['email'];
$region = $_POST['region'];
$pass = $_POST['password'];
$insert = 'INSERT INTO user (username, email, region, pwd_hash)
VALUES('.$username.','.$mail.','.$region.','.md5($pass).')';
mysqli_query($dbc, $insert);
</code></pre>

That said I would refactor you code like this. Note I am adding comments but also setting a streamlined process of parsing the $_POST values by setting the keys in an array and then using <code>isset</code> to check of they are indeed set. If not, they are set to <code>null</code>. I also set double quotes for the whole query string so it can handle string substitution (double quotes can do that), but used concatenation for the <code>'" . md5($password) . "'</code> area since that is a call to a function.

<pre><code>// Set the DB connection.
$dbc = mysqli_connect('localhost','root','') or die(mysqli_error());

// Select the DB.
$db_select = mysqli_select_db($dbc,'GameStore');.

// Send an error message if the DB select failed.
if (!$db_select) {
 die("Database selection failed: " . mysqli_error());
}

// Set an array for '$_POST' values &amp; roll through them.
$post_array = array('username','email','region','password');
foreach($post_array as $post_key =&gt; $post_value) {
 $$post_key = isset($_POST[$post_key]) ? $_POST[$post_key] : null;
}

// Set the insert query.
$insert = "INSERT INTO user (username, email, region, pwd_hash)
VALUES('$username','$email','$region.','" . md5($password) . "')";

// Run the insert query.
$db_insert = mysqli_query($dbc, $insert);

// Send an error message if the query failed.
if (!$db_insert) {
 die("Database insert failed: " . mysqli_error());
}
</code></pre>

This code takes the user information and <code>insert</code>s it into the database as a new register. Unfortunately the data doesn't appear in the database after the code runs.

<pre><code>&lt;?php
 $dbc = mysqli_connect('localhost','root','')
 or die(mysqli_error());
 $db_select = mysqli_select_db($dbc,'GameStore');.

 if (!$db_select) {
 die("Database selection failed: " . mysqli_error());
 }

 $username = $_POST['username'];
 $mail = $_POST['email'];
 $region = $_POST['region'];
 $pass = $_POST['password'];
 $insert = 'INSERT INTO user (username, email, region, pwd_hash)
 VALUES('.$username.','.$mail.','.$region.','.md5($pass).')';
?&gt; 
</code></pre>

Insert Query PHP

数据库

这段代码接受用户信息，并将其作为新的注册表inserts到数据库中。不幸的是，在代码运行后，数据不会出现在数据库中。<?php $dbc = mysqli_connect('localhost','root','') or die(mysqli_error()); $db_select = mysql...

问插入查询PHP
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问插入查询PHPEN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问插入查询PHP
EN