Need help on this Reg Error

Results 1 to 5 of 5
  1. 26-06-11 #1
    SimZero
    Apprentice SimZero is offline
    MemberRank
    Jan 2010 Join Date
    20Posts

    config Need help on this Reg Error

    Lets start things off by saying my register page works 100% Well not mine it was posted on Ragezone so im useing a basic one that some one scripted

    My problem is it shows Notice: Undefined variable: error in C:\wamp\www\index.php on line 22 and
    Notice: Undefined variable: error in C:\wamp\www\index.php on line 18

    1.Users can register just fine

    2.i even tryed ntwdblib.dll

    3.Im useing WampServer

    4.register Code look it over

    Code:
    <?php 
$dns="GunzDB";
$user="sa";
$pass="MYPASS";
$connect=odbc_connect($dns, $user, $pass) or die ("Couldn't connect to the database, we're sorry...");
odbc_exec($connect,"use GunzDB");

function antisql($bericht){
$bericht = stripslashes($bericht); 
$bericht = htmlspecialchars($bericht); 
$bericht = nl2br($bericht); 
return $bericht;
}

if(isset($_GET['action']) AND $_GET['action'] == "register"){

if(empty($_POST['username'])){
$error.="No username filled!<br>";
}

if(empty($_POST['password'])){
$error.="No password filled!<br>";
}

if(empty($_POST['email'])){
$error.="No e-mail filled!<br>";
}

if(empty($_POST['name'])){
$error.="No name filled!<br>";
}

if(empty($_POST['age'])){
$error.="No age filled!<br>";
}

if($error == TRUE){
echo "<br><br><center>There are some troubles while registering your account:<br>".$error."</center><br>";
die();
}

else
{
$regdate = date("Y-m-d H:i:s");
$email = antisql($_POST['email']);
$reg = "INSERT INTO Account (UserID, UGradeID, PGradeID, RegDate, Email, Age, Name) VALUES ('".antisql($_POST['username'])."', '1', '1', '$regdate', '$email', '".antisql($_POST['age'])."', '".antisql($_POST['name'])."')";
$query = odbc_exec($connect,$reg);
$gebruiker1 = "SELECT AID FROM Account WHERE UserID='".antisql($_POST['username'])."'";
$gebruiker = odbc_exec($connect,$gebruiker1);
$i=1;
while (odbc_fetch_row($gebruiker, $i)){
$aid = odbc_result($gebruiker, 'AID');
$i++;
}
if (!$aid)
{
die ("Oeps, something's wrong with the database");
}
$reg2 = "INSERT INTO Login (UserID, AID, Password) VALUES ('".antisql($_POST['username'])."', '$aid', '".antisql($_POST['password'])."')";
$query = odbc_exec($connect,$reg2);
print ("<center>Your account is succesfully created!</center>");
}
}
?><style type="text/css">
<!--
body {
	background-color: #000099;
	background-image: url(http://rpgwallpaper.com/wallpapers/gunz-online-3-1280x1024.jpg);
	background-repeat: repeat-x;
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
}
body,td,th {
	color: #E56717;
	font-size: large;
}
.top {
	background-position: top;
}
.style1 {
	background-image: url(http://up201.siz.co.il/up1/mz3wugdn2tmy.jpg);
	background-repeat: repeat;
	background-position: center top;
	height: 414px;
	width: 248px;
	clear: none;
	float: none;
	font-size: 18px;
}
.style2 {font-size: 18px}
-->
</style>

<center>
<div align="center" class="style2"><b>Gunz Register Page:</b><br>
  <strong>Have Fun In Gunz</strong><br>
  <?php echo "<form action='".$_SERVER['PHP_SELF']."?action=register' method='POST'>"; ?></div>
<tr>
<td height='24' align=center class="style2">&nbsp;&nbsp;</td>
</tr><tr><td height='24' align=center class="style2">&nbsp;</td>
<td height='24' align=center class="style2">&nbsp;</td>
</tr>
<span class="style2"><br>
</span>
<tr>
<td height='24' align=center class="style2"></td>
<td height='24' align=center class="style2"></td>
</tr>
<span class="style2"><br>
</span>
<tr>
<td height='24' align=center class="style2"></td>
<td height='24' align=center class="style2"></td>
</tr>
<table width="220" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td height="424" align="center" class="style1"><p><br />
      Username</p>
        <p>  
          <input type='text' name='username' />
                </p>
      <p>Password</p>
        <p>    
          <input type='password' name='password' />
                </p>
      <p>E-mail</p>
        <p>   
          <input type='text' name='email' />
                </p>
      <p>Name</p>
        <p>   
          <input type='text' name='name' />
                </p>
      <p>Age</p>
        <p>          
          <input type='text' name='age' />
                </p>
        <p>&nbsp;</p></td>
  </tr>
</table>
<p align="center" class="style2">
  <input type='submit' value='Register!' />
</p>
<p align="center" class="style2"></p>
    Last edited by SimZero; 26-06-11 at 05:03 AM.
    Reply With Quote Reply With Quote
  2. Check out our sponsor
    Need help on this Reg Error
  3. 26-06-11 #2
    Military
    Doggie And Rice. Military is offline
    MemberRank
    Jun 2009 Join Date
    Here and AboutLocation
    3,302Posts

    Re: Need help on this Reg Error

    you are missing the instance server.
    Reply With Quote Reply With Quote
  4. 26-06-11 #3
    SimZero
    Apprentice SimZero is offline
    MemberRank
    Jan 2010 Join Date
    20Posts

    Re: Need help on this Reg Error

    how do i go about doing/getting/fixing that?
    Last edited by SimZero; 26-06-11 at 08:21 AM.
    Reply With Quote Reply With Quote
  5. 26-06-11 #4
    Joe9099
    I am THE DON Joe9099 is offline
    MemberRank
    Jan 2007 Join Date
    England, UkLocation
    3,655Posts

    Re: Need help on this Reg Error

    is $error defined in functions?
    Reply With Quote Reply With Quote
  6. 26-06-11 #5
    Dave
    Pee Aitch Pee Dave is offline
    MemberRank
    Mar 2011 Join Date
    The NetherlandsLocation
    722Posts

    Re: Need help on this Reg Error

    The following works on my localhost with XAMPP. (ODBC connect part wasn't right I guess.)

    PHP Code:
    <?php
    $host       = 'PCNAME\SQLEXPRESS'; //host
    $dbname = 'GunzDB';           //db name
    $user   = '';                //username
    $pass   = '';               //password
    $connect = odbc_connect("Driver={SQL Server}; Server={$host}; Database={$dbname}", $user, $pass) or die("Cannot Connect to MSSQL Server Please check config settings");

    function     antisql($bericht)
    {
          $bericht = stripslashes($bericht);
          $bericht = htmlspecialchars($bericht);
          $bericht = nl2br($bericht);
      return     $bericht;
    }

    if(isset(    $_GET['action']) AND $_GET['action'] == "register"){

    if(empty(    $_POST['username'])){
    $error.="No username filled!<br>";
    }

    if(empty(    $_POST['password'])){
    $error.="No password filled!<br>";
    }

    if(empty(    $_POST['email'])){
    $error.="No e-mail filled!<br>";
    }

    if(empty(    $_POST['name'])){
    $error.="No name filled!<br>";
    }

    if(empty(    $_POST['age'])){
    $error.="No age filled!<br>";
    }

    if(    $error == TRUE){
    echo     "<br><br><center>There are some troubles while registering your account:<br>".$error."</center><br>";
    die();
    }

    else
    {
    $regdate = date("Y-m-d H:i:s");
    $email = antisql($_POST['email']);
    $reg = "INSERT INTO Account (UserID, UGradeID, PGradeID, RegDate, Email, Age, Name) VALUES ('".antisql($_POST['username'])."', '1', '1', '$regdate', '$email', '".antisql($_POST['age'])."', '".antisql($_POST['name'])."')";
    $query = odbc_exec($connect,$reg);
    $gebruiker1 = "SELECT AID FROM Account WHERE UserID='".antisql($_POST['username'])."'";
    $gebruiker = odbc_exec($connect,$gebruiker1);
    $i=1;
    while (    odbc_fetch_row($gebruiker, $i)){
    $aid = odbc_result($gebruiker, 'AID');
    $i++;
    }
    if (!    $aid)
    {
    die (    "Oeps, something's wrong with the database");
    }
    $reg2 = "INSERT INTO Login (UserID, AID, Password) VALUES ('".antisql($_POST['username'])."', '$aid', '".antisql($_POST['password'])."')";
    $query = odbc_exec($connect,$reg2);
    print (    "<center>Your account is succesfully created!</center>");
    }
    }
    ?><style type="text/css">
    <!--
    body {
        background-color: #000099;
        background-image: url(http://rpgwallpaper.com/wallpapers/gunz-online-3-1280x1024.jpg);
        background-repeat: repeat-x;
        margin-left: 0px;
        margin-top: 0px;
        margin-right: 0px;
        margin-bottom: 0px;
    }
    body,td,th {
        color: #E56717;
        font-size: large;
    }
    .top {
        background-position: top;
    }
    .style1 {
        background-image: url(http://up201.siz.co.il/up1/mz3wugdn2tmy.jpg);
        background-repeat: repeat;
        background-position: center top;
        height: 414px;
        width: 248px;
        clear: none;
        float: none;
        font-size: 18px;
    }
    .style2 {font-size: 18px}
    -->
    </style>

    <center>
    <div align="center" class="style2"><b>Gunz Register Page:</b><br>
      <strong>Have Fun In Gunz</strong><br>
      <?php echo "<form action='".$_SERVER['PHP_SELF']."?action=register' method='POST'>"; ?></div>
    <tr>
    <td height='24' align=center class="style2">&nbsp;&nbsp;</td>
    </tr><tr><td height='24' align=center class="style2">&nbsp;</td>
    <td height='24' align=center class="style2">&nbsp;</td>
    </tr>
    <span class="style2"><br>
    </span>
    <tr>
    <td height='24' align=center class="style2"></td>
    <td height='24' align=center class="style2"></td>
    </tr>
    <span class="style2"><br>
    </span>
    <tr>
    <td height='24' align=center class="style2"></td>
    <td height='24' align=center class="style2"></td>
    </tr>
    <table width="220" border="0" align="center" cellpadding="0" cellspacing="0">
      <tr>
        <td height="424" align="center" class="style1"><p><br />
          Username</p>
            <p>
              <input type='text' name='username' />
                    </p>
          <p>Password</p>
            <p>
              <input type='password' name='password' />
                    </p>
          <p>E-mail</p>
            <p>
              <input type='text' name='email' />
                    </p>
          <p>Name</p>
            <p>
              <input type='text' name='name' />
                    </p>
          <p>Age</p>
            <p>
              <input type='text' name='age' />
                    </p>
            <p>&nbsp;</p></td>
      </tr>
    </table>
    <p align="center" class="style2">
      <input type='submit' value='Register!' />
    </p>
    <p align="center" class="style2"></p>
    Reply With Quote Reply With Quote


« Previous Thread | Next Thread »

Advertisement