Learn VBA & Macros in 1 Week!

PHP - Need Help With Registration Script

Full Excel VBA Course - Beginner to Expert

Need Help With Registration Script	View Content

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>

Full Excel VBA Course - Beginner to Expert

Registration Script

Similar Tutorials

PHP - Need Help With Registration Script

Need Help With Registration Script

Similar Tutorials

Registration Script

Registration Script Pronlem

Registration Script Not Adding Correctly To The Database.

Moved: Jpmaster77 Script - How To Add Additional Info On Registration Page - Help!

Registration Help

Registration Help Please

Registration Help

Help With Registration.php

User Registration And Log In .

Help With User Registration

User Registration

Registration Form Help

Registration Form Help

Mkdir Upon New Registration

Event Registration

Help With Registration Class

Help With A Registration Form

Registration & Raffle

User Registration

Registration Validation.