Jump to content

Recommended Posts

I am getting error "Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/a6743732/public_html/sign_up.php on line 46" and "Query was empty". Code is:

 

<?php

include('config.php');

?>

<!DOCTYPE html>

<html>

<meta name="viewport" content="width=device-width">

<link rel="stylesheet" type="text/css" href="style.css">

<head>

<title>PokeVille</title>

</head>

<body>

<div id="header">

<center><img src="http://s13.postimage.org/citvl9c9f/Poke_Ville_Index_Sprite.png" alt="PokeVille Logo" width="240" height="100"></center>

<center><a href="sign_up.php">Register</a> |

<a href="connexion.php">Login</a></center>

</div>

<br>

<?php

//We check if the form has been sent

if(isset($_POST['username'], $_POST['password'], $_POST['passverif'], $_POST['email'], $_POST['avatar']) and $_POST['username']!='')

{

//We remove slashes depending on the configuration

if(get_magic_quotes_gpc())

{

$_POST['username'] = stripslashes($_POST['username']);

$_POST['password'] = stripslashes($_POST['password']);

$_POST['passverif'] = stripslashes($_POST['passverif']);

$_POST['email'] = stripslashes($_POST['email']);

$_POST['avatar'] = stripslashes($_POST['avatar']);

}

//We check if the two passwords are identical

if($_POST['password']==$_POST['passverif'])

{

//We check if the password has 6 or more characters

if(strlen($_POST['password'])>=6)

{

//We check if the email form is valid

if(preg_match('#^(([a-z0-9!\#$%&\\\'*+/=?^_`{|}~-]+\.?)*[a-z0-9!\#$%&\\\'*+/=?^_`{|}~-]+)@(([a-z0-9-_]+\.?)*[a-z0-9-_]+)\.[a-z]{2,}$#i',$_POST['email']))

{

//We protect the variables

$username = mysql_real_escape_string($_POST['username']);

$password = mysql_real_escape_string($_POST['password']);

$email = mysql_real_escape_string($_POST['email']);

$avatar = mysql_real_escape_string($_POST['avatar']);

//We check if there is no other user using the same username

$dn = mysql_num_rows(mysql_query('select id from users where username="'.$username.'"'));

$ret = mysql_query($query) or die(mysql_error());

if($dn==0)

{

//We count the number of users to give an ID to this one

$dn2 = mysql_num_rows(mysql_query('select id from users'));

$id = $dn2+1;

//We save the informations to the databse

if(mysql_query('insert into users(id, username, password, email, avatar, signup_date) values ('.$id.', "'.$username.'", "'.$password.'", "'.$email.'", "'.$avatar.'", "'.time().'")'))

{

//We dont display the form

$form = false;

?>

<div class="message">You have successfuly been signed up. You can log in.<br />

<a href="connexion.php">Log in</a></div>

<?php

}

else

{

//Otherwise, we say that an error occured

$form = true;

$message = 'An error occurred while signing up.';

}

}

else

{

//Otherwise, we say the username is not available

$form = true;

$message = 'The username you want to use is not available, please choose another one.';

}

}

else

{

//Otherwise, we say the email is not valid

$form = true;

$message = 'The email you entered is not valid.';

}

}

else

{

//Otherwise, we say the password is too short

$form = true;

$message = 'Your password must contain at least 6 characters.';

}

}

else

{

//Otherwise, we say the passwords are not identical

$form = true;

$message = 'The passwords you entered are not identical.';

}

}

else

{

$form = true;

}

if($form)

{

//We display a message if necessary

if(isset($message))

{

echo '<div class="message">'.$message.'</div>';

}

//We display the form

?>

<div class="content">

<form action="sign_up.php" method="post">

Please fill the following form to sign up:<br />

<div class="center">

<label for="username">Username</label><input type="text" name="username" value="<?php if(isset($_POST['username'])){echo htmlentities($_POST['username'], ENT_QUOTES, 'UTF-8');} ?>" /><br />

<label for="password">Password<span class="small">(6 characters min.)</span></label><input type="password" name="password" /><br />

<label for="passverif">Password<span class="small">(verification)</span></label><input type="password" name="passverif" /><br />

<label for="email">Email</label><input type="text" name="email" value="<?php if(isset($_POST['email'])){echo htmlentities($_POST['email'], ENT_QUOTES, 'UTF-8');} ?>" /><br />

<label for="avatar">Avatar<span class="small">(optional)</span></label><input type="text" name="avatar" value="<?php if(isset($_POST['avatar'])){echo htmlentities($_POST['avatar'], ENT_QUOTES, 'UTF-8');} ?>" /><br />

<input type="submit" value="Sign up" />

</div>

</form>

</div>

<?php

}

?>

<div class="foot"><a href="<?php echo $url_home; ?>">Go Home</a> - <a href="http://www.webestools.com/">Webestools</a></div>

</body>

</html>

Link to comment
https://forums.phpfreaks.com/topic/271847-having-trouble-with-php-and-mysql-code/
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.