PHP and MySQL help! my registration won't store on mySQL database can you please tell...

W

worriedMe08

New member
...me what is wrong? <?php
include("conf.inc.php"); // Includes the db and form info.
session_start(); // Starts the session.
if (!isset($_POST['submit'])) { // If the form has not been submitted.
echo "<form action=\"register.php\" method=\"POST\">";
echo "<table>";
echo "<tr>";
echo "<td colspan=\"2\">Register:</td>";
echo "</tr>";
echo "<tr>";
echo "<td width=\"50%\">Username:</td><td width=\"50%\"><input name=\"username\" size=\"18\" type=\"text\" />";
echo "</tr>";
echo "<tr>";
echo "<td width=\"50%\">Password:</td><td width=\"50%\"><input name=\"password\" size=\"18\" type=\"\" />";
echo "</tr>";
echo "<tr>";
echo "<td width=\"50%\">Email:</td><td width=\"50%\"><input name=\"email\" size=\"18\" type=\"text\" />";
echo "</tr>";
echo "<tr>";
echo "<td colspan=\"2\"><input type=\"submit\" name=\"submit\" value=\"submit\"</td>";
echo "</tr>";
echo "</table>";
echo "</form>";
} else { // The form has been submitted.
$username = form($_POST['username']);
$password = md5($_POST['password']); // Encrypts the password.
$email = form($_POST['email']);

if (($username == "") || ($password == "") || ($email == "")) { // Checks for blanks.
exit("There was a field missing, please correct the form.");
}


$q = mysql_query("SELECT * FROM `users` WHERE username = '$username' OR email = '$email'") or die (mysql_error()); // mySQL Query
$r = mysql_num_rows($q); // Checks to see if anything is in the db.

if ($r > 0) { // If there are users with the same username/email.
exit("That username/email is already registered!");
} else {

mysql_query("INSERT INTO `users` (username,password,email) VALUES ('$username','$password','$email')") or die (mysql_error()); // Inserts the user.
header("Location: login.php"); // Back to login.

}
}
mysql_close($db_connect); // Closes the connection.
?>
 
include("conf.inc.php"); // Includes the db and form info.
It says includes the INFO so there is a possibility that you are trying to do mysql queries without being connected to mysql.
Check the conf.inc.php file for
1)mysql_connect($host, $user, $pass);
2)mysql_select_db($database);
The variable names could be different.
 
Back
Top