Jump to content

Register Script

Daney11

By Daney11
in PHP Coding Help

Recommended Posts

Daney11 Regular Member

Daney11

Posted
Posted

Hi guys, ive coded this Register script but when i click on submit it does nothing. Doesnt show any of my errors or anything. I cannot see where im going wrong.

 

Coder is below.

 

Thanks guy

 

<?php

session_start();

$alpha = "AaBcCcDdEeFfGgHhIiJjKkLlMmNnOoPpQqRrSsTtUuVvWwXxYyZz0123456789";
$randcode = substr(str_shuffle($alpha), 0, 7);
$member_password = make_Random_Password();

if (isset($_POST['member_email'])) {

$error = false;

  if (!$_POST['member_email']) {
    $error = '<script type="text/javascript">alert("You Have Not Entered A Email Address")</script>';
  }

  if (!$_POST['member_firstname']) {
    $error = '<script type="text/javascript">alert("You Have Not Entered A First Name")</script>';
  }
  
  if (!$_POST['member_username']) {
    $error = '<script type="text/javascript">alert("You Have Not Entered A Username")</script>';
  }
  
  if (!$_POST['member_lastname']) {
    $error = '<script type="text/javascript">alert("You Have Not Entered A Last Name")</script>';
  }
  
  if (!$_POST['member_code']) {
    $error = '<script type="text/javascript">alert("You Have Not Entered A Code")</script>';
  }


// CHECK USERNAME IN THE DATABASE
$checkQuery1 = "SELECT * FROM members WHERE member_username = '$member_username'";
$checkresult1 = mysql_query($checkQuery1, $connect) or die(mysql_error());

$check = mysql_num_rows($checkresult1);
if ($check == 1) {

echo(" <strong>The Username $member_username Already Exists In The Database</strong></td>");

} 
// END CHECK USERNAME IN THE DATABASE

// CHECK EMAIL ADDRESS IN THE DATABASE
$checkQuery2 = "SELECT * FROM members WHERE member_email = '$member_email'";
$checkresult2 = mysql_query($checkQuery2, $connect) or die(mysql_error());

$check = mysql_num_rows($checkresult2);
if ($check == 1) {

echo(" <strong>The Email Address $member_email Already Exists In The Database</strong></td>");

} 
// END CHECK EMAIL ADDRESS IN THE DATABASE

// CHECK EMAILS ENTERED IN FORM
else {

if ($member_email != $member_email2) {

echo(" <strong>The Email Address Was Not The Same. Try Again</strong></td>");

}
// END CHECK EMAILS ENTERED IN FORM


// CHECK IF THE CODE IS INCORRECT
else {

if ($member_code != $rancode) {

echo(" <strong>The Code You Entered Was Incorrect</strong></td>");

}
// END CHECK IF THE CODE IS INCORRECT

if (!$error) {

// START REGISTRATION

$member_signup= time();
$member_ip = $_SERVER['REMOTE_ADDR'];

        $insertresult = "INSERT INTO `members` 
          (
           member_id, 
           member_firstname, 
           member_lastname, 
           member_username, 
           member_location, 
           member_email, 
           member_password,
           member_code)
      )";

        $insertresult .= " VALUES 
          (
	   'NULL',
           '$_POST[member_firstname]',
           '$_POST[member_lastname]',
           '$_POST[member_username]',
           '$_POST[member_location]',
	   '$_POST[member_email]',
	   '$_POST$member_password]',
           '$_POST[member_code]'
           )";
	   
mysql_query($insertresult,$connect) or die(mysql_error());

$signupemail = "[email protected]";
$message = "Welcome To $team_name, Below Is Your Username and Password\n";
$message .= "\n";
$message .= "\n";
$message .= "Username: $member_username\n";
$message .= "Password: $member_password\n";
$message .= "\n";
$message .= "\n";
$message .= "Thanks, $team_name\n";
$message .= "http://website.com\n";

if(!mail($member_email, "User Information", $message)){
echo("Failed\n");
}

echo(" <strong>Thankyou, You Are Now Registered To The Website<br>Please Check Your Email And Login</strong></td>");

// END REGISTRATION

}

}

}

}

?>
<link href="style/layout1_style.css" rel="stylesheet">
<table width="489" height="5" cellpadding="0" cellspacing="0" border="0" align="center">
<tr>
<td><img src="images/spacer.gif" height="5"></td>
</tr>
</table>
<table width="489" cellpadding="0" cellspacing="0" border="0" align="center" class="abouttable">
<form method="post" action="register.php">
<tr>
<td><img src="images/spacer.gif" height="5"></td>
</tr>
<tr>
<td width="489" height="19" align="left" colspan="2" class="text">
<table width="470" cellpadding="0" cellspacing="0" border="0" align="center">
<tr>
<td>Please enter all your information. Your password will be mailed to your email
  address so make sure your email address is valid.</td>
</tr>
</table>
</td>
</tr>
<tr>
<td><img src="images/spacer.gif" height="5"></td>
</tr>
<tr>
<td width="150" height="19"> First Name:*</td>
<td width="339" height="19"><input name="member_firstname" type="text" /></td>
</tr>
<tr>
<td width="150" height="19"> Last Name:*</td>
<td width="339" height="19"><input name="member_lastname" type="text" /></td>
</tr>
<tr>
<td width="150" height="19"> Username:*</td>
<td width="339" height="19"><input name="member_username" type="text" /></td>
</tr>
<tr>
<td width="150" height="19"> Location:*</td>
<td width="339" height="19"><select name="member_location" id="countrySelect">
					<option>---</option>
					<option value="AF">Afghanistan</option>
					<option value="AL">Albania</option>
					<option value="DZ">Algeria</option>
					<option value="AS">American Samoa</option>
					<option value="AD">Andorra</option>
					<option value="AO">Angola</option>
					<option value="AI">Anguilla</option>
					<option value="AG">Antigua and Barbuda</option>
					<option value="AR">Argentina</option>
					<option value="AM">Armenia</option>
					<option value="AW">Aruba</option>
					<option value="AU">Australia</option>
					<option value="AT">Austria</option>
					<option value="AZ">Azerbaijan</option>
					<option value="BS">Bahamas</option>
					<option value="BH">Bahrain</option>
					<option value="BD">Bangladesh</option>
					<option value="BB">Barbados</option>
					<option value="BY">Belarus</option>
					<option value="BE">Belgium</option>
					<option value="BZ">Belize</option>
					<option value="BJ">Benin</option>
					<option value="BM">Bermuda</option>
					<option value="BT">Bhutan</option>
					<option value="BO">Bolivia</option>
					<option value="BA">Bosnia and Herzegovina</option>
					<option value="BW">Botswana</option>
					<option value="BV">Bouvet Island</option>
					<option value="BR">Brazil</option>
					<option value="IO">British Indian Ocean Territory</option>
					<option value="VG">British Virgin Islands</option>
					<option value="BN">Brunei</option>
					<option value="BG">Bulgaria</option>
					<option value="BF">Burkina Faso</option>
					<option value="BI">Burundi</option>
					<option value="KH">Cambodia</option>
					<option value="CM">Cameroon</option>
					<option value="CA">Canada</option>
					<option value="CV">Cape Verde</option>
					<option value="KY">Cayman Islands</option>
					<option value="CF">Central African Republic</option>
					<option value="TD">Chad</option>
					<option value="CL">Chile</option>
					<option value="CN">China</option>
					<option value="CX">Christmas Island</option>
					<option value="CC">Cocos (Keeling) Islands</option>
					<option value="CO">Colombia</option>
					<option value="KM">Comoros</option>
					<option value="CG">Congo</option>
					<option value="CD">Congo - Democratic Republic of</option>
					<option value="CK">Cook Islands</option>
					<option value="CR">Costa Rica</option>
					<option value="CI">Cote d'Ivoire</option>
					<option value="HR">Croatia</option>
					<option value="CU">Cuba</option>
					<option value="CY">Cyprus</option>
					<option value="CZ">Czech Republic</option>
					<option value="DK">Denmark</option>
					<option value="DJ">Djibouti</option>
					<option value="DM">Dominica</option>
					<option value="DO">Dominican Republic</option>
					<option value="TP">East Timor</option>
					<option value="EC">Ecuador</option>
					<option value="EG">Egypt</option>
					<option value="SV">El Salvador</option>
					<option value="GQ">Equitorial Guinea</option>
					<option value="ER">Eritrea</option>
					<option value="EE">Estonia</option>
					<option value="ET">Ethiopia</option>
					<option value="FK">Falkland Islands (Islas Malvinas)</option>
					<option value="FO">Faroe Islands</option>
					<option value="FJ">Fiji</option>
					<option value="FI">Finland</option>
					<option value="FR">France</option>
					<option value="GF">French Guyana</option>
					<option value="PF">French Polynesia</option>
					<option value="TF">French Southern and Antarctic Lands</option>
					<option value="GA">Gabon</option>
					<option value="GM">Gambia</option>
					<option value="GZ">Gaza Strip</option>
					<option value="GE">Georgia</option>
					<option value="DE">Germany</option>
					<option value="GH">Ghana</option>
					<option value="GI">Gibraltar</option>
					<option value="GR">Greece</option>
					<option value="GL">Greenland</option>
					<option value="GD">Grenada</option>
					<option value="GP">Guadeloupe</option>
					<option value="GU">Guam</option>
					<option value="GT">Guatemala</option>
					<option value="GN">Guinea</option>
					<option value="GW">Guinea-Bissau</option>
					<option value="GY">Guyana</option>
					<option value="HT">Haiti</option>
					<option value="HM">Heard Island and McDonald Islands</option>
					<option value="VA">Holy See (Vatican City)</option>
					<option value="HN">Honduras</option>
					<option value="HK">Hong Kong</option>
					<option value="HU">Hungary</option>
					<option value="IS">Iceland</option>
					<option value="IN">India</option>
					<option value="ID">Indonesia</option>
					<option value="IR">Iran</option>
					<option value="IQ">Iraq</option>
					<option value="IE">Ireland</option>
					<option value="IL">Israel</option>
					<option value="IT">Italy</option>
					<option value="JM">Jamaica</option>
					<option value="JP">Japan</option>
					<option value="JO">Jordan</option>
					<option value="KZ">Kazakhstan</option>
					<option value="KE">Kenya</option>
					<option value="KI">Kiribati</option>
					<option value="KW">Kuwait</option>
					<option value="KG">Kyrgyzstan</option>
					<option value="LA">Laos</option>
					<option value="LV">Latvia</option>
					<option value="LB">Lebanon</option>
					<option value="LS">Lesotho</option>
					<option value="LR">Liberia</option>
					<option value="LY">Libya</option>
					<option value="LI">Liechtenstein</option>
					<option value="LT">Lithuania</option>
					<option value="LU">Luxembourg</option>
					<option value="MO">Macau</option>
					<option value="MK">Macedonia - The Former Yugoslav Republic of</option>
					<option value="MG">Madagascar</option>
					<option value="MW">Malawi</option>
					<option value="MY">Malaysia</option>
					<option value="MV">Maldives</option>
					<option value="ML">Mali</option>
					<option value="MT">Malta</option>
					<option value="MH">Marshall Islands</option>
					<option value="MQ">Martinique</option>
					<option value="MR">Mauritania</option>
					<option value="MU">Mauritius</option>
					<option value="YT">Mayotte</option>
					<option value="MX">Mexico</option>
					<option value="FM">Micronesia - Federated States of</option>
					<option value="MD">Moldova</option>
					<option value="MC">Monaco</option>
					<option value="MN">Mongolia</option>
					<option value="MS">Montserrat</option>
					<option value="MA">Morocco</option>
					<option value="MZ">Mozambique</option>
					<option value="MM">Myanmar</option>
					<option value="NA">Namibia</option>
					<option value="NR">Nauru</option>
					<option value="NP">Nepal</option>
					<option value="NL">Netherlands</option>
					<option value="AN">Netherlands Antilles</option>
					<option value="NC">New Caledonia</option>
					<option value="NZ">New Zealand</option>
					<option value="NI">Nicaragua</option>
					<option value="NE">Niger</option>
					<option value="NG">Nigeria</option>
					<option value="NU">Niue</option>
					<option value="NF">Norfolk Island</option>
					<option value="MP">Northern Mariana Islands</option>
					<option value="KP">North Korea</option>
					<option value="NO">Norway</option>
					<option value="OM">Oman</option>
					<option value="PK">Pakistan</option>
					<option value="PW">Palau</option>
					<option value="PA">Panama</option>
					<option value="PG">Papua New Guinea</option>
					<option value="PY">Paraguay</option>
					<option value="PE">Peru</option>
					<option value="PH">Philippines</option>
					<option value="PN">Pitcairn Islands</option>
					<option value="PL">Poland</option>
					<option value="PT">Portugal</option>
					<option value="PR">Puerto Rico</option>
					<option value="QA">Qatar</option>
					<option value="RE">Reunion</option>
					<option value="RO">Romania</option>
					<option value="RU">Russia</option>
					<option value="RW">Rwanda</option>
					<option value="KN">Saint Kitts and Nevis</option>
					<option value="LC">Saint Lucia</option>
					<option value="VC">Saint Vincent and the Grenadines</option>
					<option value="WS">Samoa</option>
					<option value="SM">San Marino</option>
					<option value="ST">Sao Tome and Principe</option>
					<option value="SA">Saudi Arabia</option>
					<option value="SN">Senegal</option>
					<option value="CS">Serbia and Montenegro</option>
					<option value="SC">Seychelles</option>
					<option value="SL">Sierra Leone</option>
					<option value="SG">Singapore</option>
					<option value="SK">Slovakia</option>
					<option value="SI">Slovenia</option>
					<option value="SB">Solomon Islands</option>
					<option value="SO">Somalia</option>
					<option value="ZA">South Africa</option>
					<option value="GS">South Georgia and the South Sandwich Islands</option>
					<option value="KR">South Korea</option>
					<option value="ES">Spain</option>
					<option value="LK">Sri Lanka</option>
					<option value="SH">St. Helena</option>
					<option value="PM">St. Pierre and Miquelon</option>
					<option value="SD">Sudan</option>
					<option value="SR">Suriname</option>
					<option value="SJ">Svalbard</option>
					<option value="SZ">Swaziland</option>
					<option value="SE">Sweden</option>
					<option value="CH">Switzerland</option>
					<option value="SY">Syria</option>
					<option value="TW">Taiwan</option>
					<option value="TJ">Tajikistan</option>
					<option value="TZ">Tanzania</option>
					<option value="TH">Thailand</option>
					<option value="TG">Togo</option>
					<option value="TK">Tokelau</option>
					<option value="TO">Tonga</option>
					<option value="TT">Trinidad and Tobago</option>
					<option value="TN">Tunisia</option>
					<option value="TR">Turkey</option>
					<option value="TM">Turkmenistan</option>
					<option value="TC">Turks and Caicos Islands</option>
					<option value="TV">Tuvalu</option>
					<option value="UG">Uganda</option>
					<option value="UA">Ukraine</option>
					<option value="AE">United Arab Emirates</option>
					<option selected value="GB">United Kingdom</option>
					<option value="US">United States</option>
					<option value="VI">United States Virgin Islands</option>
					<option value="UY">Uruguay</option>
					<option value="UZ">Uzbekistan</option>
					<option value="VU">Vanuatu</option>
					<option value="VE">Venezuela</option>
					<option value="VN">Vietnam</option>
					<option value="WF">Wallis and Futuna</option>
					<option value="PS">West Bank</option>
					<option value="EH">Western Sahara</option>
					<option value="YE">Yemen</option>
					<option value="ZM">Zambia</option>
					<option value="ZW">Zimbabwe</option>
				</select></td>
</tr>
<tr>
<td width="150" height="19"> Email Address:*</td>
<td width="339" height="19"><input name="member_email" type="text" /></td>
</tr>
<tr>
<td width="150" height="19"> Email Address Repeat:*</td>
<td width="339" height="19"><input name="member_email2" type="text" /></td>
</tr>
<tr>
<td width="150" height="19"> Enter Code:*</td>
<td width="339" height="19"><input name="member_code" type="text" /></td>
</tr>
<tr>
<td width="150" height="19"> Verification Code:</td>
<td width="339" height="19"><?php echo $randcode ?></td>
</tr>
<tr>
<td width="489" height="19" align="right" colspan="2"><input name="registersubmit" type="submit" value="submit"/> </td>
</tr>
<tr>
<td><img src="images/spacer.gif" height="5"></td>
</tr>
<tr>
<td width="489" height="19" align="left" colspan="2" class="text">
</form>
<table width="470" cellpadding="0" cellspacing="0" border="0" align="center">
<tr>
<td>Please note that all * fields are required. By pressing submit you agree
  to the <a href="termsandconditions.php" class="boldtext">Terms and Conditions</a> that are followed on this website.</td>
</tr>
</table>
</td>
</tr>
<tr>
<td><img src="images/spacer.gif" height="5"></td>
</tr>
</table>

Link to comment
https://forums.phpfreaks.com/topic/78676-register-script/
Share on other sites
Wes1890 Member

Wes1890

Posted
Posted 

// CHECK USERNAME IN THE DATABASE
$checkQuery1 = "SELECT * FROM members WHERE member_username = '$member_username'";
$checkresult1 = mysql_query($checkQuery1, $connect) or die(mysql_error());

 

$member_username isn't defined before then. I'm still looking for errors.. gimme a second

 

The same goes for when you were SELECTing $member_email

 

You need to do something like $member_username = $_POST['member_username'].  be sure to sanitize it of course (you know, addslashes, htmspecialchars etc)

Link to comment
https://forums.phpfreaks.com/topic/78676-register-script/#findComment-398103
Share on other sites

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.