Registration Page for private servers

**mesoalt** · 09-29-2008

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!

**Sounddead** · 09-29-2008

Pretty sure this isn't a guide. Post it in the questions forum please.

**mesoalt** · 09-29-2008

lol sorry :[

**~~Erase~~** · 10-02-2008

Wrong section.

Shout-Out

User Tag List

Thread: Registration Page for private servers

Thread Tools

Search Thread

Registration Page for private servers

woops

Similar Threads

[Help] Registration page for private server (Ascent)

Working Tele/Speed/Wall Climb/No Fall Damage Hack +more for Private servers

Looking for private server

WoW account for private server

Need some stuff for private server

OwnedCore Forums

casino

CoreCoins

My OwnedCore

About Us

Casino