开发者

How do you fix the username not showing up in mysql?

im creating a registry for my website, and so far its all good, but when you register, it doesnt put the username into the database, its puts the password and email though

<?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);
?>

Thank you for your help in advance :D


Are you sure that you have the correct name of the element in your form? And that you are POST'ing the form and not using GET? Also, you shouldn't be inserting passwords into the DB in plain text, but use MySQL's password function, nor should you be forming your mysql statement like that as it leaves your DB open to SQL injection. Try this:

$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')";
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜