请通过此错误注册表格帮助我 [英] Please help me with this error registration form

问题描述

嘿，
请任何人可以帮助我解决此错误

hey,
please can anyone help me with this error

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in

这是我的代码

and here is my code

<<pre lang="xml">?
$conn = mysql_connect("localhost",XXXX","XXXX");
mysql_select_db("users");
if($_POST[''submit'']) {
$username = $_POST[''username''];
$password = $_POST[''password''];
$checkUserQuery = mysql_query("SELECT * FROM users WHERE username=''$username''");
if (!$username OR !$password){
echo("ERROR: Please enter a username and password");
}
elseif(mysql_num_rows($checkUserQuery) > 0) {
echo("ERROR:Username already exists");
}
else{
$query = mysql_query("INSERT INTO users VALUES ('''', ''$username'',''$password'')");
echo ("Sign Up Succcessful");
}
}
?>
<form method="POST" action="">
Username: <input type="text" name="username"><br>
Password: <input type="password" name="password"<br>
<input type="submit" name="submit" value="Sign Up!!"

>

谁能帮我
在此先感谢

>

Please can anyone help me
Thanks in Advance

推荐答案

conn = mysql_connect("localhost"，XXXX，" XXXX); mysql_select_db(用户"); if(

conn = mysql_connect("localhost",XXXX","XXXX"); mysql_select_db("users"); if(

_POST [''submit'']){

_POST[''submit'']) {

用户名=

这篇关于请通过此错误注册表格帮助我的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！