你如何解决在mysql中不显示的用户名?
问题描述:
IM创造了我的网站上注册,到目前为止,它的一切都很好,但是当你注册,它不把用户名到数据库中,它会将密码和电子邮件虽然你如何解决在mysql中不显示的用户名?
<?php
@mysql_connect("localhost", "user", "pass") or die("Cannot connect to DB!");
@mysql_select_db("") or die("Cannot select DB!");
$sql= "INSERT INTO member (username, password, email) VALUES('$loginid','$password','$email')";
$r = mysql_query($sql);
if(!$r) {
$err=mysql_error();
print $err;
exit();
}
$insert_query = 'insert into member (username,password,email) values("' . $_POST['username'] . '","' . $_POST['password'] . '","' . $_POST['email'] . '")';
mysql_query($insert_query);
?>
谢谢您的帮助提前:D
答
您确定您的表单中元素的名称是否正确?而且你在POST表单而不使用GET?此外,您不应该以纯文本形式将密码插入数据库,而是使用MySQL的password
函数,也不应该像这样形成mysql语句,因为它会将数据库打开为SQL注入。试试这个:
$username = mysql_real_escape_string($_POST['username']);
$password = mysql_real_escape_string($_POST['password']);
$email = mysql_real_escape_string($_POST['email']);
$insert_query = "insert into member (username,password,email) values('$username', PASSWORD('$password'), '$email')";
导致mysql中没有任何东西显示 – Mason 2011-02-07 23:24:25