Hello everyone. I am in dire need to figure this problem out. I have my own domain name, Wofa.us, and i have a home page, connection info, forums, all these are working fine, but i need to know why my registration page is not working. Here are my codes for the register.php, register.html, and the error im getting.
Register.php:
<html>
<body>
<?php
$pass1 = $_GET["pass"];
$pass2 = $_GET["pass2"];
$user = $_GET["user"];
$connection = mysql_connect("127.0.0.1", "root", "1234");
if (!$connection)
{
die('Unable to connect to server: ' . mysql_error());
}
mysql_select_db("character",$connection);
//Check the inputs arent blank
if ($user == "" or $pass1 == "" or pass2 == "")
{
die('You did not complete all of the required fields');
}
//See if that user exists already
$check = mysql_query("SELECT username FROM users WHERE username = '$user");
if ($check2 != 0)
{
die('Sorry, the username '.$user.' is already in use.');
}
//password verification check
if ($pass1 != $pass2)
{
die('Your passwords did not match. ');
}
//encrypt and add slashes
$md5pass = md5($pass1);
if (!get_magic_quotes_gpc())
{
$md5pass = addslashes($md5pass);
$user = addslashes($user);
}
//add entry to sql database
$insert = "INSERT INTO users (username, password)
VALUES ('".$user."', '".$md5pass."')";
$add_member = mysql_query($insert);
echo "Congratulations, User: $user has been registered successfully";
//mysql_close($connection);
?>
</body>
</html>
Register.html:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Warriors of Flaming Anarchy</title>
<link rel="stylesheet" type="text/css" href="style.css" />
</head>
<body>
<div id="container">
<div id="header">
<img src="Banner.jpg" height="239px" width="930px" />
</div>
<div id="nav">
<ul>
<br /><br />
<li><a href="index.html">Home</a></li>
<br /><br />
<li><a href="connect.html">Connection Info</a></li>
<br /><br />
<li><a href="register.html">Register</a></li>
<br /><br />
<li><a href="forums">Forums</a></li>
<br /><br />
<br /><br />
<br /><br />
</ul>
</div>
<div id="content">
<h2>Create an account!</h2>
<p> </p>
<p> </p>
<form action="register.php" method="get">
<table border="0">
<tr>
<td>Username:</td>
<td><input type="text" name="user" maxlength="12"></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>
</div>
</div>
</body>
</html>
Error i get when i go to the link:
Warning: mysql_connect(): Lost connection to MySQL server during query in /home/content/r/u/s/russellsite/html/wofa/register.php on line 7
Unable to connect to server: Lost connection to MySQL server during query
Please do try to help me if you have any knowlage as to why this is happening. Give me a suggestion, etc and if you even attempt to actually help, and are not just lazy, saying something like you hav e the wrong coding or something, than i will +Rep for sure. Thanks everyone!