PHP - Help With Php Registration/contact Pages

I've only modified the code below for the query, I just removed that to make it shorter, the query works fine. I've added human verification to the script and it displays the image and numbers fine, I also echo'd out the variables and they match using SHA1(). My captcha script is displaying the image properly and sets the $_SESSION['pass_phrase'] variable fine.

It isn't throwing any errors or creating the account.

As of right now I have a headache and figured I could use some help here. Let me know if you spot the error.

<?php
  error_reporting(E_ALL);
  require_once('cons.php');
   // Get the variable sent by AJAX script if it is typed in
  // Connect to the database
  $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
if (isset($_REQUEST['username'])) {
$ok = 'okay';
$den = 'denied';

   // Secure the information
$passname = mysqli_real_escape_string($dbc, trim($_REQUEST['username']));
   // Lookup the username in the database
      $query = "SELECT username FROM info WHERE username = '$passname'";
      $data = mysqli_query($dbc, $query);
   // Allow some time to get the response
 sleep(3);
   // If 1 is returned that name exsists, if 0 then we can move forward
      if (mysqli_num_rows($data) == 0) {
   // Send okay back to the ajax script so it knows to stop bothering the user
echo $ok;
return $ok;
} else {
   // Send denied back to the ajax script so the user knows that name is taken
echo $den;
return $den;
} // Close If / Else statement
  } // Close (isset($_REQUEST['username'])) {

  // Start of Main Submit Function Script
   session_start();
  require_once('aprs.php');

  if (isset($_POST['submit'])) {
    // Grab the profile data from the POST and secure it

    $avatar = mysqli_real_escape_string($dbc, trim($_POST['avatar']));
    $usern = mysqli_real_escape_string($dbc, trim($_POST['username1']));
    $password1 = mysqli_real_escape_string($dbc, trim($_POST['password1']));
    $password2 = mysqli_real_escape_string($dbc, trim($_POST['password2']));
    $email = mysqli_real_escape_string($dbc, trim($_POST['email']));
    $side = mysqli_real_escape_string($dbc, trim($_POST['side']));
    $class = mysqli_real_escape_string($dbc, trim($_POST['class']));
    $vercap = mysqli_real_escape_string($dbc, trim($_POST['verify']));

// convert username to all lowercase

$userna = strtolower($usern);
$username = stripslashes($userna);

// Check the CAPTCHA pass-phrase for verification
$phrase = SHA1($vercap);
if ($_SESSION['pass_phrase'] == $phrase) {

// Expression for validating the username is properly formatted.
if (preg_match('/[^0-9A-Za-z]/',$username)) {  

// Expression for validating the e-mail is properly formatted.
if (preg_match('/^[^@]+@[a-zA-Z0-9._-]+\.[a-zA-Z]+$/', $email)){  

// Check to make sure all the form fields are filled in 
if (!empty($avatar) && !empty($username1) && !empty($password1) && !empty($password2) && ($password1 == $password2) && !empty($email) && !empty($side) && !empty($class)) {

// If all the fields are filled in correctly then we can check the username to see if it's registered
// Make sure someone isn't already registered using this username
      $query = "SELECT * FROM info WHERE username = '$username'";
      $data = mysqli_query($dbc, $query);
      if (mysqli_num_rows($data) == 0) {
// The username is unique, so insert the data into the database
$hash = md5( rand(0,1000) );
        $query = "INSERT INTO";
        mysqli_query($dbc, $query);

// Confirm success with the user
 echo '<div id="signconf">';
        echo '<p>Your new account has been successfully created. Please check your Email for the final verification.';
 echo '</div>';

// Send the registration e-mail so the user can activate thier account
$to = $email; // Send email to our user
$subject = 'Signup | Verification'; // Give the email a subject
$message = '

Thanks for signing up!
Your account has been created, you can login with the following credentials after you have activated your account by clicking the url below.

------------------------
Username: '.$username.'
Password: '.$password1.'
------------------------

Please click this link to activate your account:

http://www.mydomain.com/verify.php?email='.$email.'&hash='.$hash.'

'; // Our message above including the link

$headers = 'From:me@mydomain.com' . "\r\n"; // Set from headers
mail($to, $subject, $message, $headers); // Send our email

       mysqli_close($dbc);
       exit();

// If there was an issue with the username already taken, display an error
} else {
 echo '<div id="signconf">';
        echo '<p class="error">An account already exists for this username. Please use a different address.</p>';
 echo '</div>';
        $username = "";
} // End the if(mysqli_num_rows($data) == 0) { check
// If there was an issue with the user not filling in the form correctly we post an error
} else {
echo '<div id="signconf">';
       echo '<p class="error">You must enter all of the sign-up data, including the desired password twice.</p>';
echo '</div>';
} // End the if(mysqli_num_rows($data) == 0) { check
// If there was an error with the e-mail address entered we need to post an error
} else {
echo '<div id="signconf">';
echo 'The email you have entered is invalid, please try again.';  
echo '</div>';
} // End the if(mysqli_num_rows($data) == 0) { check
// If there was an error with the format of the username we need to post an error
} else {
echo '<div id="signconf">';
echo 'The email you have entered is invalid, please try again.';  
echo '</div>';
} // End the if(mysqli_num_rows($data) == 0) { check
// If there was an error with the captcha not matching we post an error
} else {
 echo '<div id="signconf">';   
        echo "The verification text didn't match the picture.";
 echo '</div>';
} // End else for Captcha check
}  // End the if(mysqli_num_rows($data) == 0) { check

// Connection to the database is no longer needed so we can close it
mysqli_close($dbc);

// We no longer need php so let's close that and start the submit form
?>
<!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> Registration</title>
 <link type="text/css" rel="stylesheet" href="tlstyle.css" />
 <script src="scripts/utils.js" type ="text/javascript"></script>
 <script src="scripts/validation.js" type="text/javascript"></script>
</head>
<body>
<div id="csignup">
<div id="signform"> 
 <p>Please enter all the information below to sign up.</p>
  <form enctype="multipart/form-data" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
     <label for="username1">Username:</label>
     <input type="text" id="username1" name="username1" value="<?php if (!empty($username1)) echo $username; ?>" maxlength = "7" /><br />
     <label>Password:</label>
     <input type="password" id="password1" name="password1" value="<?php if (!empty($password1)) echo $password1; ?>" class="jcinput"/><br />
     <label>Password (retype):</label>
     <input type="password" id="password2" name="password2" value="<?php if (!empty($password2)) echo $password2; ?>" class="jcinput"/><br />
     <label>E-Mail Address:</label>
     <input type="text" id="email" name="email" value="<?php if (!empty($email)) echo $email; ?>" class="jcinput"/><br />
     <label for="verify">Verification:</label>
     <img src="captcha.php" alt="Verification" /><br />
     <label for="verify">Verification:</label>
     <input type="text" id="verify" name="verify" class="jcinput" /><br />
     <label>Choose Your Avatar:</label>
<input type="radio" name="avatar" value="/images/smile.png" /> <img src="/images/smile.png" alt="1" />
<input type="radio" name="avatar" value="/mages/smile.png" /> <img src="/images/smile.png" alt="1" />
<input type="radio" name="avatar" value="/mages/smile.png" /> <img src="/images/smile.png" alt="1" />
<input type="radio" name="avatar" value="/images/smile.png" /> <img src="/images/smile.png" alt="1" /><br />
     <label>Choose Your Side:</label>
<input type="radio" name="side" value="A" />A
<input type="radio" name="side" value="B" />B
<div id="signclassb">
<div id="signclass">
Choose a Class:
<ul><li><input type="radio" name="class" value="A" /> A</li>
<li><input type="radio" name="class" value="B" /> B</li>
<li><input type="radio" name="class" value="C" /> C</li></ul>
</div>
</div>
    <input type="submit" value="Sign Up" name="register" class="signsub" />
  </form>

</div>
</div>
</body> 
</html>

Hi, I wonder whether someone may be able to help me please.

I'm fairly new to PHP so please bear with me.

I'm trying to put together a script which bascially creates a hierarchical tree of folders upon a new account being created by a user.

I would like to take the 'username' that the user registers with to use as the name for the first folder, then, create a folder at the second level called 'images' and then finally, a folder within that called 'thumbs'.

From the research that I've done, I believe that I need to use the 'mkdir' command, but I can't find a very straight forward tutorial.

I just wondered whether someone could perhaps please help me out with this, so that I at least have a good solid starting point.

New to php and starting to feel way in over my head. Please help, point me in the right direction here. How do i create a new folder with a index.html like (www.mydomain.com/NEWUSER/index.html) when a user registers for my site and have it do live check for AVAILABILITY?

I want to give my users a unique url for there profile. how then do i automate the creation of x.com/newuser/index.html and write it with the users input from my database at the same time?

I'm making a registration form and i want to add a user when i click the registration button, but the user can not already be in the database, i set  the user to be unique inside of the database and when i try to add a new user it gives an error message, but instead of that error message i would like to input please enter another user-name or user already exist something like that the error message says duplicate entry 'username' inside of db basically...
can someone help me with this ?

Im trying to build mysql php user registration. For some reason i cannot insert values into my database.

Code: [Select]
<?php

$submit = $_POST['submit'];
$fullname = strip_tags($_POST['fullname']);
$username = strip_tags($_POST['username']);
$password = strip_tags($_POST['password']);

// Connect the database

$connection = mysql_connect("bla", "bla", "bla") or die ("Could not connect");
mysql_select_db("my_db", $connection);

// mysql query
$query = "INSERT INTO users VALUES (''. 'fullname', 'username', 'password')";

mysql_query($query);

echo "You have successfully registered";
?>
Any help spotting the error would be appreciated!

I have a page for event registration and I have subevents that will have a check mark by them.  how do i make it so that a check mark only appears if a subevent is present?

I'm using an open source registration and login validation system. I've got it working well, apart from I've discovered when adding check if username is taken, it has broken the script and allows duplicate usernames and email addresses:

Code: [Select]
<?php

include ('database_connection.php');
if (isset($_POST['formsubmitted'])) {
    $error = array();//Declare An Array to store any error message  
    if (empty($_POST['name'])) {//if no name has been supplied 
        $error[] = 'Please Enter a name ';//add to array "error"
    } else {
        $name = $_POST['name'];//else assign it a variable
    }

    if (empty($_POST['e-mail'])) {
        $error[] = 'Please Enter your Email ';
    } else {


        if (preg_match("/^([a-zA-Z0-9])+([a-zA-Z0-9\._-])*@([a-zA-Z0-9_-])+([a-zA-Z0-9\._-]+)+$/", $_POST['e-mail'])) {
           //regular expression for email validation
            $Email = $_POST['e-mail'];
        } else {
             $error[] = 'Your EMail Address is invalid  ';
        }


    }


    if (empty($_POST['Password'])) {
        $error[] = 'Please Enter Your Password ';
    } else {
        $Password = $_POST['Password'];
    }


    if (empty($error)) //send to Database if there's no error '

    { // If everything's OK...

        // Make sure the email address is available:
        $query_verify_email = "SELECT * FROM members  WHERE Email ='$Email'";
        $result_verify_email = mysqli_query($dbc, $query_verify_email);
        if (!$result_verify_email) {//if the Query Failed ,similar to if($result_verify_email==false)
            echo ' Database Error Occured ';
        }
    if (mysqli_num_rows($result_verify_email) == 0) { // IF no previous user is using this email .

// Make sure the user is available:
        $query_verify_user = "SELECT * FROM members  WHERE Username ='$name'";
        $result_verify_user = mysqli_query($dbc, $query_verify_user);
        if (!$result_verify_user) {
            echo ' Database Error Occured ';
        }
}
    if (mysqli_num_rows($result_verify_user) == 0) { // IF no previous user is using this user .

            // Create a unique  activation code:
            $activation = md5(uniqid(rand(), true));


            $query_insert_user = "INSERT INTO `members` ( `Username`, `Email`, `Password`, `Activation`, `res1`, `res2`, `ounit1`, `dunit1`) VALUES ( '$name', '$Email', '$Password', '$activation', '50000', '50000', '100', '100')";


            $result_insert_user = mysqli_query($dbc, $query_insert_user);
            if (!$result_insert_user) {
                echo 'Query Failed ';
            }

            if (mysqli_affected_rows($dbc) == 1) { //If the Insert Query was successfull.


                // Send the email:
                $message = " To activate your account, please click on this link:\n\n";
                $message .= WEBSITE_URL . '/activate.php?email=' . urlencode($Email) . "&key=$activation";
                mail($Email, 'Registration Confirmation', $message, 'From: Admin@TheGameCo.Com');

                // Flush the buffered output.


                // Finish the page:
                echo '<div class="success">Thank you for
registering! A confirmation email
has been sent to '.$Email.' Please click on the Activation Link to Activate your account </div>';


            } else { // If it did not run OK.
                echo '<div class="errormsgbox">You could not be registered due to a system
error. We apologize for any
inconvenience.</div>';
            }

        } else { // The email address is not available.
            echo '<div class="errormsgbox" >That email
address or username has already been registered.
</div>';
        }

    } else {//If the "error" array contains error msg , display them
        
        

echo '<div class="errormsgbox"> <ol>';
        foreach ($error as $key => $values) {
            
            echo ' <li>'.$values.'</li>';


       
        }
        echo '</ol></div>';

    }
  
    mysqli_close($dbc);//Close the DB Connection

} // End of the main Submit conditional.



?>
<!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>Game Name - Home</title>
<link rel="stylesheet" type="text/css" href="style.css" />
</head>
<body>

<div id="container">
<div id="header">
<?php include("includes/header.php"); ?>
</div>
<div id="nav">
<?php include("includes/nav.php"); ?>

</div>
<div id="content">
<form action="index.php" method="post" class="registration_form">
  <fieldset>
    <legend>Registration Form</legend>

    <p>Create A new Account<br />Already a member? <a href="login.php">Log in</a></p>
   
    <div class="elements">
      <label for="name">Username:</label>
      <input type="text" id="name" name="name" size="25" />
    </div>
    <div class="elements">
      <label for="e-mail">E-mail:</label>
      <input type="text" id="e-mail" name="e-mail" size="25" />
    </div>
    <div class="elements">
      <label for="Password">Password:</label>
      <input type="password" id="Password" name="Password" size="25" />
    </div>
    <div class="submit">
     <input type="hidden" name="formsubmitted" value="TRUE" />
      <input type="submit" value="Register" />
    </div>
  </fieldset>
</form>
</div>
<div id="footer">
<?php include("includes/footer.php"); ?>
</div>
</div>
</body>
</html>

To add user verification I simply duplicated the email verification:

Code: [Select]
// Make sure the user is available:
        $query_verify_user = "SELECT * FROM members  WHERE Username ='$name'";
        $result_verify_user = mysqli_query($dbc, $query_verify_user);
        if (!$result_verify_user) {
            echo ' Database Error Occured ';
        }
}
    if (mysqli_num_rows($result_verify_user) == 0) { // IF no previous user is using this user .
Can anyone see where I've gone wrong?

This is related to my post http://www.phpfreaks.com/forums/index.php/topic,307907.msg1455208.html#msg1455208

I have never programmed using OOP, and I am unsure where to start.

All of the tutorials and books I have read use stupid examples that don't seem to help you "in the real world"?!   

So I want to write my first bit of PHP OOP to register Customers for my website.

I think having a "Registration" class makes sense, but I'm not sure how to tie that to my website.

If I write an HTML webpage and on it I have a Form where users can enter registration info, then how do I tie that "static" and/or "procedural" code to my OOP?

I was thinking of having it so that when a user clicks the "Register" button that I call a PHP file that has my Registration class and I first instantiate it so that the user has his/her own "Registration object".

From there, maybe I could call a method in Registration that actually registers the user.  (Or maybe I can just do that during instantiation?!)

Can someone help me out here?


TomTees

Hey guys! I'm sorry if this wrong section to post this, but this one was the most reasonable to ask.   So I'm looking for a guy who could program a system for my website. It's gonna be a site where people can register and join the raffles. The raffles will work on a ticket system where you have to buy a ticket to join a competition. The registration has to be safe and same as raffle without any bugs etc..   Will give more info when you write me down!     If you are intrested you can add me on skype: mikinjsh95 Or send an email on: miks.silins@outlook.com   I will pay for the code, no doubt! Will pay half money and when the script is done will pay the rest!    

Hi Guys,

This is really stumping me here lol i have set my registration page code to email me when a user signs up (once its entered in the database)

code:

Code: [Select]
<?php
if (isset($_POST['submitSignUp']))
{
   // Errors array()
   $errors = array();

   // POST vars
   $fName = mysql_real_escape_string($_POST['fname']);
   $lName = mysql_real_escape_string($_POST['lname']); 
   $email = mysql_real_escape_string($_POST['email']); 
   $pass1 = mysql_real_escape_string($_POST['pass1']); 
   $pass2 = mysql_real_escape_string($_POST['pass2']); 
   $cntry = mysql_real_escape_string($_POST['cntry']); 
   
   // Does passwords match
   if ($pass1 != $pass2)
   {
      $errors[] = "Your passwords don't match."; 
   }
   
   // Potential errors 
   // Empty fields
   if (empty($fName) || empty($lName) || empty($email) || empty($pass1) || empty($pass2)) { 
        $errors[] = "You never filled in all the fields."; 
   } else {
    
       // Does user exist? 
       $result = mysql_query("SELECT * FROM `dig_customers` WHERE `email`='$email' LIMIT 1"); 
       if (mysql_num_rows($result) > 0) {    
          $errors[] = "The e-mail address <b>$email</b> has already been registered.";  
       } else {

       // Empty for now...

       }
   }  
   
   // display errors if any exist
   if (count($errors) > 0) 
   { 
       print "<div id=\"errorMsg\"><h3>Ooops! There was error(s)</h3><ol>"; 
       foreach($errors as $error) 
       { 
          print "<li>$error</li>"; 
       }
       print "</ol></div>";
   } else {
       print "<div id=\"okMsg\"><p>All done :) you can now sign in.</p></div>";
       
         // Encrypt the password before insertion
         $encPass = md5($pass1);

         // Insert into the database
         $q = mysql_query("INSERT INTO `dig_customers` 
         
         (`id`,
          `password`,
          `password_unencrypted`,
          `gender`,
          `title`,
          `first_name`,
          `last_name`,
          `address`,
          `city`,
          `state_county`,
          `post_zip_code`,
          `country`,
          `email`,
          `home_number`,
          `mobile_number`,
          `news_letter`,
          `special_offers`,
          `admin_level`,
          `registered`) 
         
           VALUES 
          
          ('',
          '$encPass',
          '$pass1',
          'NULL',
          'NULL',
          '$fName',
          '$lName',
          'NULL',
          'NULL',
          'NULL',
          'NULL',
          '$cntry',
          '$email',
          'NULL',
          'NULL',
          'NULL',
          'NULL',
          'N',
           NOW())");

          if ($q)
          {

            // Alert on signup
            send_graham_email("User Has Signed Up!");
          
          }
       
   }

}
?>

When i do a test signup on: http://www.digicures.com/sign-up.php everything works great i get an email and the entry is saved in the database, over the paste week or so i have had about 8 emails saying people have signed up but when i check the database there nothing there!

i can't understand it, only when the insert query is true should it send me the mail eh?

can anyone see any problems with the code at all?

cheers guys

Graham

Hello i have this registration script. I need help adding mybb forum user check to here. That script checks your insterted user and pw is it correct.   Script attached. Attached Files  rega.php   9.52KB   2 downloads

Currently I'm trying to get a registration form to work adding a username and password into a database. That bit I understand and have managed to do aswell as getting the password to hash using  the line below:

$hashed = password_hash($password, PASSWORD_DEFAULT);

 

What I'm trying to do now is have the passwords check to see if they are the same, if so the user is able to register, if not they are sent back to the registration page(which was working before I started tampering with the next bit). I also want to checkto see if the username is taken, the following code is what I have so far:

<?php
session_start();

/* Attempt MySQL server connection. Assuming you are running MySQL
server with default setting (user 'root' with no password) */
$link = mysqli_connect("localhost", "root", "", "rockinrochester");
 
// Check connection
if($link === false){
    die("ERROR: Could not connect. " . mysqli_connect_error());
}
 
$sql= mysql_query("SELECT FROM register (username, password) WHERE username=$username");
 if(mysql_num_rows($sql)>=1)
   {
    echo"name already exists";
   }
 else
    {
   	$username = $_POST['username'];
	$password = $_POST['password'];
	$password2 = $_POST['password2'];
	$hashed = password_hash($password, PASSWORD_DEFAULT);
	
if($password != $password2) {   //checks to see if passwords match, if they don't it redirects person back to registration form
		header('Location: register.php');
		echo "passwords didn't match";
	    
}
else {
	
 $sql = "INSERT INTO register (username, password) VALUES ( '$username','$hashed')"; // if passwords match inputs them into database
	
}

if(mysqli_query($link, $sql)){
   header('Location: registered.php'); // if it works relocated person to registered.html
} else{
    echo "ERROR: Could not able to execute $sql. " . mysqli_error($link); // if it fails it prints an error message
}
 
// Close connection
mysqli_close($link);
    }


?>

<?php
session_start();

/* Attempt MySQL server connection. Assuming you are running MySQL
server with default setting (user 'root' with no password) */
$link = mysqli_connect("localhost", "root", "", "rockinrochester");
 
// Check connection
if($link === false){
    die("ERROR: Could not connect. " . mysqli_connect_error());
}
 

	$username = $_POST['username'];
	$password = $_POST['password'];
	$password2 = $_POST['password2'];
	$hashed = password_hash($password, PASSWORD_DEFAULT);

$sql = mysql_query("SELECT FROM register(username, password, ) WHERE username=$username");

 if(mysql_num_rows($sql)>=1)
   {
    echo"name already exists";
   }
 else{

if($password != $password2) {   //checks to see if passwords match, if they don't it redirects person back to registration form
		header('Location: register.php');
		echo "passwords didn't match";
	     }


else {
	
    $sql = "INSERT INTO register (username, password) VALUES ( '$username','$hashed')"; // if passwords match inputs them into database
	
}

if(mysqli_query($link, $sql)){
   header('Location: registered.php'); // if it works relocated person to registered.html
} else{
    echo "ERROR: Could not able to execute $sql. " . mysqli_error($link); // if it fails it prints an error message
}
 
// Close connection
mysqli_close($link);

    }


?>

at the minute It's throwing back the following error

Quote

Fatal error: Uncaught Error: Call to undefined function mysql_query() in D:\xampp\htdocs\final\registerscript.PHP:19 Stack trace: #0 {main} thrown in D:\xampp\htdocs\final\registerscript.PHP on line 19

 

Edited April 4, 2019 by dylfs
changing code

Hi. I'm trying to build a sort of blog where users have to register to post questions/comments. My problem is with the registration part. Here is part of the code:

Code: [Select]
<form name="registration" method="post" action="registration.php">
<tr><td align="left">Nume</td>
<td align="right"><input type="text" name="name" onKeyUp="validare()"></td></tr>
<tr><td align="left">Email</td>
<td align="right"><input type="text" name="email" onKeyUp="validare()"></td></tr>
<tr><td align="left">Username</td>
<td align="right"><input type="text" name="username" onKeyUp="validare()"></td></tr>
<tr><td align="left">Parola</td>
<td align="right"><input type="password" name="password" onKeyUp="validare()"></td></tr>
<tr><td align="left">Confirmare parola</td>
<td align="right"><input type="password" name="pass_conf" onKeyUp="validare()"></td></tr>
<tr><td align="left">Anti-spam</td>
<td><script type="text/javascript">DrawBotBoot()</script></td></tr>
<tr><td></td><td><input type="submit" name="register" value="Inregistreaza-te" disabled="true"></td></tr>
</form>...
</html>
Code: [Select]
<?php
$host="mysql3.***************";
$username="a7129718_root";
$password="hello2";
$db_name="a7129718_site";
$tbl_name="members";
// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT MAX(id) AS Maxa_id FROM $tbl_name";
$result=mysql_query($sql);
$rows=mysql_fetch_array($result);

if ($rows) {
$Max_id = $rows['Maxa_id']+1;}
else {
$Max_id = 1;}

$name=$_POST['name'];
$email=$_POST['email'];
$user=$_POST['username'];
$pass=$_POST['password'];

$sql2="INSERT INTO $tbl_name(id, name, email, username, password)VALUES('$Max_id', '$name', '$email', '$user', '$pass')";
$result2=mysql_query($sql2);

if($result2){
header("location:login.html");}
else{
echo "cannot insert into table";}}
?>
The problem is: there is no error message. The server just redirects me to their error page, which doesn't contain any error code, just some ads. Can you tell me what the problem might be? Thank you in advance. Bye."

Hey,

I have written an external login script for my PHPBB3 forums but I am having trouble writing the script to allow the user to register and have their information added into the table phpbb_users which stores the phpbb account details.

I have tried some code and written my own but I cannot seem to get it to input the data into the tables.

Has anyone written a script for this or know of a place that I can learn how to do it???

Regards,

Mathew Hood