0

Using PHP on my registration page to register users on my site. Everything seems to be working properly from a PHP perspective. It even tells the user that they've been added. But when I view the table it only has one record which is the one that I created when testing the script. For some reason no other users are being added.

Does anyone have any ideas? I'm a newbie and have no clue. Thanks in advance!

Here is the PHP code if that helps at all.

<?php ob_start(); ?>
<html>
<head>
<title>Youth-Topia Registration</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000" background="yt_background.jpg">


<?php
// Connects to your Database
mysql_connect("localhost", "*****", "*****") or die(mysql_error());
mysql_select_db("alanos2_youthtopia_mbr") or die(mysql_error());

//This code runs if the form has been submitted
if (isset($_POST)) {

//This makes sure they did not leave any fields blank
if (!$_POST | !$_POST | !$_POST ) {
die('You did not complete all of the required fields');
}

// checks if the username is in use
if (!get_magic_quotes_gpc()) {
$_POST = addslashes($_POST);
}
$usercheck = $_POST;
$check = mysql_query("SELECT username FROM users WHERE username = '$usercheck'")
or die(mysql_error());
$check2 = mysql_num_rows($check);

//if the name exists it gives an error
if ($check2 != 0) {
die('Sorry, the username '.$_POST.' is already in use.');
}

// this makes sure both passwords entered match
if ($_POST != $_POST) {
die('Your passwords did not match.');
}

// here we encrypt the password and add slashes if needed
$_POST = md5($_POST);
if (!get_magic_quotes_gpc()) {
$_POST = addslashes($_POST);
$_POST = addslashes($_POST);
}

// now we insert it into the database
$insert = "INSERT INTO users (username, password)
VALUES ('".$_POST."', '".$_POST."')";
$add_member = mysql_query($insert);
?>
<h1>Registered</h1>
<p>Thank you, you have registered - you may now <a href="login.php">login</a>.</p>

<?php
}
else
{
?>


<form action="<?php echo $_SERVER; ?>" method="post">
<table border="0">
<tr><td>Username:</td><td>
<input type="text" name="username" maxlength="60">
</td></tr>
<tr><td>Password:</td><td>
<input type="password" name="pass" maxlength="10">
</td></tr>
<tr><td>Confirm Password:</td><td>
<input type="password" name="pass2" maxlength="10">
</td></tr>
<tr><th colspan=2><input type="submit" name="submit" value="Register"></th></tr> </table>
</form>

<?php
}
?>


</body>
</html>
<?php ob_flush(); ?><?php ob_start(); ?>
<html>
<head>
<title>Youth-Topia Registration</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000" background="yt_background.jpg">


<?php
// Connects to your Database
mysql_connect("mysql401.ixwebhosting.com", "alanos2_alanos", "rinker310") or die(mysql_error());
mysql_select_db("alanos2_youthtopia_mbr") or die(mysql_error());

//This code runs if the form has been submitted
if (isset($_POST)) {

//This makes sure they did not leave any fields blank
if (!$_POST | !$_POST | !$_POST ) {
die('You did not complete all of the required fields');
}

// checks if the username is in use
if (!get_magic_quotes_gpc()) {
$_POST = addslashes($_POST);
}
$usercheck = $_POST;
$check = mysql_query("SELECT username FROM users WHERE username = '$usercheck'")
or die(mysql_error());
$check2 = mysql_num_rows($check);

//if the name exists it gives an error
if ($check2 != 0) {
die('Sorry, the username '.$_POST.' is already in use.');
}

// this makes sure both passwords entered match
if ($_POST != $_POST) {
die('Your passwords did not match.');
}

// here we encrypt the password and add slashes if needed
$_POST = md5($_POST);
if (!get_magic_quotes_gpc()) {
$_POST = addslashes($_POST);
$_POST = addslashes($_POST);
}

// now we insert it into the database
$insert = "INSERT INTO users (username, password)
VALUES ('".$_POST."', '".$_POST."')";
$add_member = mysql_query($insert);
?>
<h1>Registered</h1>
<p>Thank you, you have registered - you may now <a href="login.php">login</a>.</p>

<?php
}
else
{
?>


<form action="<?php echo $_SERVER; ?>" method="post">
<table border="0">
<tr><td>Username:</td><td>
<input type="text" name="username" maxlength="60">
</td></tr>
<tr><td>Password:</td><td>
<input type="password" name="pass" maxlength="10">
</td></tr>
<tr><td>Confirm Password:</td><td>
<input type="password" name="pass2" maxlength="10">
</td></tr>
<tr><th colspan=2><input type="submit" name="submit" value="Register"></th></tr> </table>
</form>

<?php
}
?>


</body>
</html>
<?php ob_flush(); ?>

2
Contributors
1
Reply
2
Views
9 Years
Discussion Span
Last Post by phper
0

After this code@

// now we insert it into the database
$insert = "INSERT INTO users (username, password)
VALUES ('".$_POST."', '".$_POST."')";
$add_member = mysql_query($insert);

I would do this:

$check_add_member = mysql_affected_rows();

if($check_add_member==0){
// THE MEMBER NOT ADDED
// DO A MYSQL_ERROR TO SEE IF THERES AN ERROR SOMEWHERE
echo mysql_error();
}else{
echo "Member Added";
}

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.