Register form help

[bremen1984]

Hi all i have a Register form that is driving me crazy, i have been working on this for 2 days now and not getting any where.

it keeps running this code:

} else { // If it did not run OK.

            echo '<p class="error">You could not be registered due to a system error. We apologize for any inconvenience.</p>';

 

and i do not get why. here is the full code hope some one can help. thanks

<?php
# Script 16.6 - register.php
// This is the registration page for the site.

require_once ('includes/config.inc.php');
$page_title = 'Register';
include ('includes/header.html');

if (isset($_POST['submitted'])) { // Handle the form.

   require_once (MYSQL);
   
   // Trim all the incoming data:
   $trimmed = array_map('trim', $_POST);
   
   // Assume invalid values:
   $cn = $lc = $fn = $ln = $e = $p = FALSE;
   
      // Check for a Company Name:
   if (preg_match ('/^[A-Z \'.-]{2,20}$/i', $trimmed['company_name'])) {
      $cn = mysqli_real_escape_string ($dbc, $trimmed['company_name']);
   } else {
      echo '<p class="error">Please enter your Company name!</p>';
   }
   
      // Check for a location:
   if (preg_match ('/^[A-Z \'.-]{2,20}$/i', $trimmed['location'])) {
      $lc = mysqli_real_escape_string ($dbc, $trimmed['location']);
   } else {
      echo '<p class="error">Please enter your State and City!</p>';
   }
   
   // Check for a first name:
   if (preg_match ('/^[A-Z \'.-]{2,20}$/i', $trimmed['first_name'])) {
      $fn = mysqli_real_escape_string ($dbc, $trimmed['first_name']);
   } else {
      echo '<p class="error">Please enter your first name!</p>';
   }
   
   // Check for a last name:
   if (preg_match ('/^[A-Z \'.-]{2,40}$/i', $trimmed['last_name'])) {
      $ln = mysqli_real_escape_string ($dbc, $trimmed['last_name']);
   } else {
      echo '<p class="error">Please enter your last name!</p>';
   }
   
   // Check for an email address:
   if (preg_match ('/^[\w.-]+@[\w.-]+\.[A-Za-z]{2,6}$/', $trimmed['email'])) {
      $e = mysqli_real_escape_string ($dbc, $trimmed['email']);
   } else {
      echo '<p class="error">Please enter a valid email address!</p>';
   }
   

   // Check for a password and match against the confirmed password:
   if (preg_match ('/^\w{4,20}$/', $trimmed['password1']) ) {
      if ($trimmed['password1'] == $trimmed['password2']) {
         $p = mysqli_real_escape_string ($dbc, $trimmed['password1']);
      } else {
         echo '<p class="error">Your password did not match the confirmed password!</p>';
      }
   } else {
      echo '<p class="error">Please enter a valid password!</p>';
   }
   
   if ($cn && $lc && $fn && $ln && $e && $p) { // If everything's OK...

      // Make sure the email address is available:
      $q = "SELECT user_id FROM users WHERE email='$e'";
      $r = mysqli_query ($dbc, $q) or trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($dbc));
      
      if (mysqli_num_rows($r) == 0) { // Available.
      
         // Create the activation code:
         $a = md5(uniqid(rand(), true));
      
         // Add the user to the database:
         $q = "INSERT INTO users (company_name, location, email, pass, first_name, last_name, active, registration_date,  ) VALUES ('$e', SHA1('$p'), '$cn', '$lc', '$fn', '$ln', '$a', NOW() )";
         $r = mysqli_query ($dbc, $q) or trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($dbc));

         if (mysqli_affected_rows($dbc) == 1) { // If it ran OK.
         
            // Send the email:
            $body = "Thank you for registering at <Eclipse Media>. To activate your account, please click on this link:\n\n";
            $body .= BASE_URL . 'activate.php?x=' . urlencode($e) . "&y=$a";
            mail($trimmed['email'], 'Registration Confirmation', $body, 'From: info@eclipsemedia.us');
            
            // Finish the page:
            echo '<h3>Thank you for registering! A confirmation email has been sent to your address. Please click on the link in that email in order to activate your account.</h3>';
            include ('includes/footer.html'); // Include the HTML footer.
            exit(); // Stop the page.
            
         } else { // If it did not run OK.
            echo '<p class="error">You could not be registered due to a system error. We apologize for any inconvenience.</p>';
         }
         
      } else { // The email address is not available.
         echo '<p class="error">That email address has already been registered. If you have forgotten your password, use the link at right to have your password sent to you.</p>';
      }
      
   } else { // If one of the data tests failed.
      echo '<p class="error">Please re-enter your passwords and try again.</p>';
   }

   mysqli_close($dbc);

} // End of the main Submit conditional.
?>
   
<h1>Register</h1>
<form action="register.php" method="post">
   <fieldset>
   
      <p><b>Company Name:</b> <input type="text" name="company_name" size="20" maxlength="20" value="<?php if (isset($trimmed['company_name'])) echo $trimmed['company_name']; ?>" /></p>
      
      <p><b>State City:</b> <input type="text" name="location" size="20" maxlength="20" value="<?php if (isset($trimmed['location'])) echo $trimmed['location']; ?>" /></p>
        
   <p><b>First Name:</b> <input type="text" name="first_name" size="20" maxlength="20" value="<?php if (isset($trimmed['first_name'])) echo $trimmed['first_name']; ?>" /></p>
   
   <p><b>Last Name:</b> <input type="text" name="last_name" size="20" maxlength="40" value="<?php if (isset($trimmed['last_name'])) echo $trimmed['last_name']; ?>" /></p>
   
   <p><b>Email Address:</b> 
    <input type="text" name="email" size="30" maxlength="80" value="<?php if (isset($trimmed['email'])) echo $trimmed['email']; ?>" /></p>
    
      
    <p><b>Password:</b> 
      <input type="password" name="password1" size="20" maxlength="20" /> 
     <small>Use only letters, numbers, and the underscore. Must be between 4 and 20 characters long.</small></p>
   <p><b>Confirm Password:</b> <input type="password" name="password2" size="20" maxlength="20" /></p>
   </fieldset>
   
   <div align="center"><input type="submit" name="submit" value="Register" /></div>
   <input type="hidden" name="submitted" value="TRUE" />

</form>


<?php // Include the HTML footer.
include ('includes/footer.html'); ?>

 

MOD EDIT: code tags added

[Pikachu2000]

When posting code, please enclose it within the forum's

 . . . 

BBCode tags.

[PFMaBiSmAd]

Is error_reporting set to E_ALL and display_errors set to ON so that the or trigger_error() logic would actually do anything?