Results 1 to 4 of 4
  1. #1
    New User

    Reputation
    2
    Join Date
    Jun 2007
    Posts
    47
    CoreCoins
    0

    Trade Feedbacks

    Status
    n/a
    Positive
    0 (0%)
    Negative
    0 (0%)

    Registration Page for private servers



    Donate to Remove Ads, Get ShoutBawx - Elite Forum Access
    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>&nbsp;</p>
    <p>&nbsp;</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!

  2. #2
    Contributor
    Sounddead's Avatar
    Reputation
    160
    Join Date
    Sep 2007
    Location
    Canada
    Posts
    1,132
    CoreCoins
    1

    Trade Feedbacks

    Status
    n/a
    Positive
    0 (0%)
    Negative
    0 (0%)
    Pretty sure this isn't a guide. Post it in the questions forum please.

    I live in a shoe

  3. #3
    New User

    Reputation
    2
    Join Date
    Jun 2007
    Posts
    47
    CoreCoins
    0

    Trade Feedbacks

    Status
    n/a
    Positive
    0 (0%)
    Negative
    0 (0%)

    woops

    lol sorry :[

  4. #4
    Banned
    Reputation
    229
    Join Date
    Jun 2008
    Location
    Denmark
    Posts
    993
    Blog Entries
    1
    CoreCoins
    0

    Trade Feedbacks

    Status
    n/a
    Positive
    0 (0%)
    Negative
    0 (0%)
    Wrong section.

 

 

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -4. The time now is 07:48 PM. Powered by vBulletin® Version 4.2.0
Copyright © 2014 vBulletin Solutions, Inc. All rights reserved. Resources saved on this page: MySQL 5.88%
vBulletin Optimisation provided by vB Optimise (Pro) - vBulletin Mods & Addons Copyright © 2014 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search