Creating a username and password on my reg page.

jasonhardwick · May 20, 2008

I have a few questions regarding my registration page.

1: how can I restrict the username so that you cant put in spaces or any other special characters.

2: requier a password walue of 6-8 characters and again no spaces or special characters.

Here is my code can anyone give me some ideas.

<?php 

if(isset($_POST['Submit'])){
//NEED TO CHECK IF FIELDS ARE FILLED IN
if( empty($_POST['name']) && (empty($_POST['email']))){
header("Location:Messages.php?msg=3"); 
exit();
}
if( empty($_POST['pw1']) && (empty($_POST['pw2']))){
header( "Location:Messages.php?msg=4" ); 
exit();
}
$name=$_POST['name'];
$email=$_POST['email'];
$f_name=$_POST['f_name'];
$l_name=$_POST['l_name'];
$zip_code=$_POST['zip_code'];
$e_private=$_POST['e_private'];
$country=$_POST['country'];
$bio=$_POST['bio'];
$occupation=$_POST['occupation'];
$occupation_other=$_POST['occupation_other'];
$website=$_POST['website'];
$date_joined=date("D, F jS, Y \@ g:i a T"); //create date time
$user_image=$_POST['user_image'];

$pw1=$_POST['pw1'];
$pw2=$_POST['pw2'];

if("$pw1" !== "$pw2"  ){
header( "Location:Messages.php?msg=5" ); 
exit();
}
$ip = $_SERVER['REMOTE_ADDR'];

//connect to the db server , check if uname exist
include('config.php');
$query=("Select * from user where uname='$name'");
$result= mysql_query($query); 
$num=mysql_num_rows($result);
if ($num > 0) {//Username already exist
header( "Location:Messages.php?msg=6" ); 
exit();
}else{
//if username does not exist insert user details
$query=( "INSERT INTO user (f_name,l_name,zip_code,e_private,country,bio,occupation,occupation_other,website,uname,pw,email,date_joined,user_image,ip,level) VALUES ('$f_name','$l_name','$zip_code','$e_private','$country','$bio','$occupation','$occupation_other','$website','$name','$pw1','$email','$date_joined','$user_image','$ip','Normal')");
if (@mysql_query ($query)) {
header("location:login.php?reg=1");
exit;
}
}
mysql_close();
}
?>

<!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>My Creative Process - Register</title>
<style type="text/css">
<!--
.style1 {color: #666666}
-->
</style>
<link href="/css/style.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.style2 {	color: #f73602;
font-weight: bold;
}
.style3 {
color: #FFFFFF
}
.style4 {color: #F15A25}
-->
</style>
</head>

<body>
<table width="972" border="0" align="center" cellpadding="5" cellspacing="0">
  <tr>
    <td><div align="right">Not logged in</div></td>
  </tr>
</table>
<table width="972" border="1" align="center" cellpadding="5" cellspacing="0" bordercolor="#F73602" id="frame">
  <tr bordercolor="#F15A25">
    <td colspan="4"><div align="center">
      <p><img src="/images/header.jpg" width="942" height="84" /></p>
      <table width="902" border="0" cellspacing="0" cellpadding="5">
        <tr>
          <td width="728"><p><span class="style1"><a href="/index.php">home</a> | <a href="/main_forum.php">review</a> | <a href="/create_topic.php">post</a> | <a href="/mindgames.php">mindgames</a> | <a href="/archive.php">archive</a> | <a href="/brainstorm.php">brainstorm</a> | <a href="/my_profile.php">my profile</a> | <a href="user_network">my network</a> | <a href="/suggestion_box.php">suggestion box</a></span></p>            </td>
          <td colspan="-1"> </td>
        </tr>
      </table>
      <table width="902" border="0" cellspacing="0" cellpadding="5">
        <tr>
          <td width="728" rowspan="2" valign="top">
          <script type="text/javascript"><!--
google_ad_client = "pub-3297649199554245";
/* 728x90, created 5/13/08 */
google_ad_slot = "2051664931";
google_ad_width = 728;
google_ad_height = 90;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>

<table width="100%" border="0" cellspacing="0" cellpadding="5">
  <tr>
    <td bgcolor="#EAEBEB" class="title_dark"><span class="style4">| </span>Register</td>
  </tr>
</table>
<br />
            <form name="form1" action="register.php" method="post">
          <table width="100%" border="0" cellspacing="0" cellpadding="5">
                <tr>
                  <td width="100" valign="top">First Name:</td>
                  <td><input name="f_name" type="text" id="f_name" size="40" /></td>
                </tr>
                <tr>
                  <td valign="top">Last Name:</td>
                  <td><input name="l_name" type="text" id="l_name" size="40" /></td>
                </tr>
                <tr>
                  <td valign="top"> </td>
                  <td><legend></legend>                    </td>
                </tr>
                <tr>
                  <td valign="top">Email:</td>
                  <td><input name="email" type="text" size="40" /></td>
                </tr>
                <tr>
                  <td valign="top">Keep: my email private</td>
                  <td><label>
                    <input name="e_private" type="checkbox" id="e_private" value="Private" />
                  </label></td>
                </tr>
                <tr>
                  <td valign="top">Zip Code:</td>
                  <td><label>
                    <input name="zip_code" type="text" id="zip_code" size="40" maxlength="5" />
                  </label></td>
                </tr>
                <tr>
                  <td valign="top"><span class="form-item">Country:</span></td>
                  <td><span class="form-item">
                    <select name="country" class="form-select required" id="edit-profile-country" >
                      <option value="United States">United States</option>
                      <option value="Canada">Canada</option>
                      <option value="United Kingdom">United Kingdom</option>
                      <option value="Australia">Australia</option>
                      <option value="New Zealand">New Zealand</option>
                      <option value="--------------">--------------</option>
                      <option value="Afghanistan">Afghanistan</option>
                      <option value="Albania">Albania</option>
                      <option value="Algeria">Algeria</option>
                      <option value="American Samoa">American Samoa</option>
                      <option value="Andorra">Andorra</option>
                      <option value="Angola">Angola</option>
                      <option value="Anguilla">Anguilla</option>
                      <option value="Antarctica">Antarctica</option>
                      <option value="Antigua and Barbuda">Antigua and Barbuda</option>
                      <option value="Argentina">Argentina</option>
                      <option value="Armenia">Armenia</option>
                      <option value="Aruba">Aruba</option>
                      <option value="Austria">Austria</option>
                      <option value="Azerbaijan">Azerbaijan</option>
                      <option value="Bahamas">Bahamas</option>
                      <option value="Bahrain">Bahrain</option>
                      <option value="Bangladesh">Bangladesh</option>
                      <option value="Barbados">Barbados</option>
                      <option value="Belarus">Belarus</option>
                      <option value="Belgium">Belgium</option>
                      <option value="Belize">Belize</option>
                      <option value="Benin">Benin</option>
                      <option value="Bermuda">Bermuda</option>
                      <option value="Bhutan">Bhutan</option>
                      <option value="Bolivia">Bolivia</option>
                      <option value="Bosnia and Herzegowina">Bosnia and Herzegowina</option>
                      <option value="Botswana">Botswana</option>
                      <option value="Bouvet Island">Bouvet Island</option>
                      <option value="Brazil">Brazil</option>
                      <option value="British Indian Ocean Territory">British Indian Ocean Territory</option>
                      <option value="Brunei Darussalam">Brunei Darussalam</option>
                      <option value="Bulgaria">Bulgaria</option>
                      <option value="Burkina Faso">Burkina Faso</option>
                      <option value="Burundi">Burundi</option>
                      <option value="Cambodia">Cambodia</option>
                      <option value="Cameroon">Cameroon</option>
                      <option value="Cape Verde">Cape Verde</option>
                      <option value="Cayman Islands">Cayman Islands</option>
                      <option value="Central African Republic">Central African Republic</option>
                      <option value="Chad">Chad</option>
                      <option value="Chile">Chile</option>
                      <option value="China">China</option>
                      <option value="Christmas Island">Christmas Island</option>
                      <option value="Cocos (Keeling) Islands">Cocos (Keeling) Islands</option>
                      <option value="Colombia">Colombia</option>
                      <option value="Comoros">Comoros</option>
                      <option value="Congo">Congo</option>
                      <option value="the Democratic Republic of the">the Democratic Republic of the</option>
                      <option value="Cook Islands">Cook Islands</option>
                      <option value="Costa Rica">Costa Rica</option>
                      <option value="Cote d'Ivoire">Cote d&#039;Ivoire</option>
                      <option value="Croatia (Hrvatska)">Croatia (Hrvatska)</option>
                      <option value="Cuba">Cuba</option>
                      <option value="Cyprus">Cyprus</option>
                      <option value="Czech Republic">Czech Republic</option>
                      <option value="Denmark">Denmark</option>
                      <option value="Djibouti">Djibouti</option>
                      <option value="Dominica">Dominica</option>
                      <option value="Dominican Republic">Dominican Republic</option>
                      <option value="East Timor">East Timor</option>
                      <option value="Ecuador">Ecuador</option>
                      <option value="Egypt">Egypt</option>
                      <option value="El Salvador">El Salvador</option>
                      <option value="Equatorial Guinea">Equatorial Guinea</option>
                      <option value="Eritrea">Eritrea</option>
                      <option value="Estonia">Estonia</option>
                      <option value="Ethiopia">Ethiopia</option>
                      <option value="Falkland Islands (Malvinas)">Falkland Islands (Malvinas)</option>
                      <option value="Faroe Islands">Faroe Islands</option>
                      <option value="Fiji">Fiji</option>
                      <option value="Finland">Finland</option>
                      <option value="France">France</option>
                      <option value="Metropolitan">Metropolitan</option>
                      <option value="French Guiana">French Guiana</option>
                      <option value="French Polynesia">French Polynesia</option>
                      <option value="French Southern Territories">French Southern Territories</option>
                      <option value="Gabon">Gabon</option>
                      <option value="Gambia">Gambia</option>
                      <option value="Georgia">Georgia</option>
                      <option value="Germany">Germany</option>
                      <option value="Ghana">Ghana</option>
                      <option value="Gibraltar">Gibraltar</option>
                      <option value="Greece">Greece</option>
                      <option value="Greenland">Greenland</option>
                      <option value="Grenada">Grenada</option>
                      <option value="Guadeloupe">Guadeloupe</option>
                      <option value="Guam">Guam</option>
                      <option value="Guatemala">Guatemala</option>
                      <option value="Guinea">Guinea</option>
                      <option value="Guinea-Bissau">Guinea-Bissau</option>
                      <option value="Guyana">Guyana</option>
                      <option value="Haiti">Haiti</option>
                      <option value="Heard and Mc Donald Islands">Heard and Mc Donald Islands</option>
                      <option value="Holy See (Vatican City State)">Holy See (Vatican City State)</option>
                      <option value="Honduras">Honduras</option>
                      <option value="Hong Kong">Hong Kong</option>
                      <option value="Hungary">Hungary</option>
                      <option value="Iceland">Iceland</option>
                      <option value="India">India</option>
                      <option value="Indonesia">Indonesia</option>
                      <option value="Iran (Islamic Republic of)">Iran (Islamic Republic of)</option>
                      <option value="Iraq">Iraq</option>
                      <option value="Ireland">Ireland</option>
                      <option value="Israel">Israel</option>
                      <option value="Italy">Italy</option>
                      <option value="Jamaica">Jamaica</option>
                      <option value="Japan">Japan</option>
                      <option value="Jordan">Jordan</option>
                      <option value="Kazakhstan">Kazakhstan</option>
                      <option value="Kenya">Kenya</option>
                      <option value="Kiribati">Kiribati</option>
                      <option value="Korea">Korea</option>
                      <option value="Democratic People's Republic of">Democratic People&#039;s Republic of</option>
                      <option value="Republic of">Republic of</option>
                      <option value="Kuwait">Kuwait</option>
                      <option value="Kyrgyzstan">Kyrgyzstan</option>
                      <option value="Lao People's Democratic Republic">Lao People&#039;s Democratic Republic</option>
                      <option value="Latvia">Latvia</option>
                      <option value="Lebanon">Lebanon</option>
                      <option value="Lesotho">Lesotho</option>
                      <option value="Liberia">Liberia</option>
                      <option value="Libyan Arab Jamahiriya">Libyan Arab Jamahiriya</option>
                      <option value="Liechtenstein">Liechtenstein</option>
                      <option value="Lithuania">Lithuania</option>
                      <option value="Luxembourg">Luxembourg</option>
                      <option value="Macau">Macau</option>
                      <option value="Macedonia">Macedonia</option>
                      <option value="The Former Yugoslav Republic of">The Former Yugoslav Republic of</option>
                      <option value="Madagascar">Madagascar</option>
                      <option value="Malawi">Malawi</option>
                      <option value="Malaysia">Malaysia</option>
                      <option value="Maldives">Maldives</option>
                      <option value="Mali">Mali</option>
                      <option value="Malta">Malta</option>
                      <option value="Marshall Islands">Marshall Islands</option>
                      <option value="Martinique">Martinique</option>
                      <option value="Mauritania">Mauritania</option>
                      <option value="Mauritius">Mauritius</option>
                      <option value="Mayotte">Mayotte</option>
                      <option value="Mexico">Mexico</option>
                      <option value="Micronesia">Micronesia</option>
                      <option value="Federated States of">Federated States of</option>
                      <option value="Moldova">Moldova</option>
                      <option value="Monaco">Monaco</option>
                      <option value="Mongolia">Mongolia</option>
                      <option value="Montserrat">Montserrat</option>
                      <option value="Morocco">Morocco</option>
                      <option value="Mozambique">Mozambique</option>
                      <option value="Myanmar">Myanmar</option>
                      <option value="Namibia">Namibia</option>
                      <option value="Nauru">Nauru</option>
                      <option value="Nepal">Nepal</option>
                      <option value="Netherlands">Netherlands</option>
                      <option value="Netherlands Antilles">Netherlands Antilles</option>
                      <option value="New Caledonia">New Caledonia</option>
                      <option value="Nicaragua">Nicaragua</option>
                      <option value="Niger">Niger</option>
                      <option value="Nigeria">Nigeria</option>
                      <option value="Niue">Niue</option>
                      <option value="Norfolk Island">Norfolk Island</option>
                      <option value="Northern Mariana Islands">Northern Mariana Islands</option>
                      <option value="Norway">Norway</option>
                      <option value="Oman">Oman</option>
                      <option value="Pakistan">Pakistan</option>
                      <option value="Palau">Palau</option>
                      <option value="Panama">Panama</option>
                      <option value="Papua New Guinea">Papua New Guinea</option>
                      <option value="Paraguay">Paraguay</option>
                      <option value="Peru">Peru</option>
                      <option value="Philippines">Philippines</option>
                      <option value="Pitcairn">Pitcairn</option>
                      <option value="Poland">Poland</option>
                      <option value="Portugal">Portugal</option>
                      <option value="Puerto Rico">Puerto Rico</option>
                      <option value="Qatar">Qatar</option>
                      <option value="Reunion">Reunion</option>
                      <option value="Romania">Romania</option>
                      <option value="Russian Federation">Russian Federation</option>
                      <option value="Rwanda">Rwanda</option>
                      <option value="Saint Kitts and Nevis">Saint Kitts and Nevis</option>
                      <option value="Saint LUCIA">Saint LUCIA</option>
                      <option value="Saint Vincent and the Grenadines">Saint Vincent and the Grenadines</option>
                      <option value="Samoa">Samoa</option>
                      <option value="San Marino">San Marino</option>
                      <option value="Sao Tome and Principe">Sao Tome and Principe</option>
                      <option value="Saudi Arabia">Saudi Arabia</option>
                      <option value="Senegal">Senegal</option>
                      <option value="Seychelles">Seychelles</option>
                      <option value="Sierra Leone">Sierra Leone</option>
                      <option value="Singapore">Singapore</option>
                      <option value="Slovakia (Slovak Republic)">Slovakia (Slovak Republic)</option>
                      <option value="Slovenia">Slovenia</option>
                      <option value="Solomon Islands">Solomon Islands</option>
                      <option value="Somalia">Somalia</option>
                      <option value="South Africa">South Africa</option>
                      <option value="South Georgia and the South Sandwich Islands">South Georgia and the South Sandwich Islands</option>
                      <option value="Spain">Spain</option>
                      <option value="Sri Lanka">Sri Lanka</option>
                      <option value="St. Helena">St. Helena</option>
                      <option value="St. Pierre and Miquelon">St. Pierre and Miquelon</option>
                      <option value="Sudan">Sudan</option>
                      <option value="Suriname">Suriname</option>
                      <option value="Svalbard and Jan Mayen Islands">Svalbard and Jan Mayen Islands</option>
                      <option value="Swaziland">Swaziland</option>
                      <option value="Sweden">Sweden</option>
                      <option value="Switzerland">Switzerland</option>
                      <option value="Syrian Arab Republic">Syrian Arab Republic</option>
                      <option value="Taiwan">Taiwan</option>
                      <option value="Province of China">Province of China</option>
                      <option value="Tajikistan">Tajikistan</option>
                      <option value="Tanzania">Tanzania</option>
                      <option value="United Republic of">United Republic of</option>
                      <option value="Thailand">Thailand</option>
                      <option value="Togo">Togo</option>
                      <option value="Tokelau">Tokelau</option>
                      <option value="Tonga">Tonga</option>
                      <option value="Trinidad and Tobago">Trinidad and Tobago</option>
                      <option value="Tunisia">Tunisia</option>
                      <option value="Turkey">Turkey</option>
                      <option value="Turkmenistan">Turkmenistan</option>
                      <option value="Turks and Caicos Islands">Turks and Caicos Islands</option>
                      <option value="Tuvalu">Tuvalu</option>
                      <option value="Uganda">Uganda</option>
                      <option value="Ukraine">Ukraine</option>
                      <option value="United Arab Emirates">United Arab Emirates</option>
                      <option value="United States Minor Outlying Islands">United States Minor Outlying Islands</option>
                      <option value="Uruguay">Uruguay</option>
                      <option value="Uzbekistan">Uzbekistan</option>
                      <option value="Vanuatu">Vanuatu</option>
                      <option value="Venezuela">Venezuela</option>
                      <option value="Viet Nam">Viet Nam</option>
                      <option value="Virgin Islands (British)">Virgin Islands (British)</option>
                      <option value="Virgin Islands (U.S.)">Virgin Islands (U.S.)</option>
                      <option value="Wallis and Futuna Islands">Wallis and Futuna Islands</option>
                      <option value="Western Sahara">Western Sahara</option>
                      <option value="Yemen">Yemen</option>
                      <option value="Yugoslavia">Yugoslavia</option>
                      <option value="Zambia">Zambia</option>
                      <option value="Zimbabwe">Zimbabwe</option>
                    </select>
                  </span></td>
                </tr>
                <tr>
                  <td valign="top"> </td>
                  <td> </td>
                </tr>
                <tr>
                  <td valign="top"><p>My Biography:</p>
                    <p>(Just a little about yourself for others to read.)</p></td>
                  <td><textarea name="bio" cols="38" rows="7" id="bio"></textarea></td>
                </tr>
                <tr>
                  <td valign="top">Occupation:</td>
                  <td><span class="form-item">
                    <select name="occupation" class="form-select required" id="edit-profile-jobdescription" >
                      <option value="Art Director">Art Director</option>
                      <option value="Creative Director">Creative Director</option>
                      <option value="Editor">Editor</option>
                      <option value="Graphic Designer">Graphic Designer</option>
                      <option value="Hobbyist">Hobbyist</option>
                      <option value="Marketing/Public Relations">Marketing/Public Relations</option>
                      <option value="Photographer">Photographer</option>
                      <option value="Student">Student</option>
                      <option value="Web Designer">Web Designer</option>
                      <option value="Web Programmer">Web Programmer</option>
                      <option value="Other">Other (please describe)</option>
                    </select>
                  </span></td>
                </tr>
                <tr>
                  <td valign="top"><p>If Other:</p>                    </td>
                  <td><input name="occupation_other" type="text" id="occupation_other" size="40" /></td>
                </tr>
                <tr>
                  <td valign="top">Website:</td>
                  <td><input name="website" type="text" id="website" size="40" /></td>
                </tr>
                <tr>
                  <td valign="top"> </td>
                  <td> </td>
                </tr>
                <tr>
                  <td valign="top">Username:</td>
                  <td><input name="name" type="text" size="40" /></td>
                </tr>
                <tr>
                  <td valign="top">Password:</td>
                  <td><input name="pw1" type="password" size="40" /></td>
                </tr>
                <tr>
                  <td valign="top">Confirm Password:</td>
                  <td><input name="pw2" type="password" size="40" /></td>
                </tr>
                <tr>
                  <td valign="top"> </td>
                  <td> </td>
                </tr>
                <tr>
                  <td colspan="2" valign="top"><span class="form-item">
                    <label class="option">
                    <input type="checkbox" name="legal_accept" id="edit-legal-accept" value="1"   class="form-checkbox required" />
I Accept The <a href="/terms.php" target="_blank">Terms & Conditions of Use</a> <span class="form-required">*</span></label>
                                    </span></td>
                  </tr>
                <tr>
                  <td valign="top"><input type="hidden" name="user_image" value="default.jpg" /></td>
                  <td> </td>
                </tr>
                <tr>
                  <td colspan="2" valign="top"><input name="Submit" type="submit" class="button_orange" value="Register Now" id="Submit" /></td>
                  </tr>
              </table>
          </form>
            </p>
            <p> </p>
            <p> </p></td>
          <td valign="top"><table width="150" border="1" align="right" cellpadding="5" cellspacing="0" bordercolor="#F73602">
              <tr bordercolor="#F15A25" bgcolor="#CCCCCC">
                <td bordercolor="#F15A25" bgcolor="#F15A25"><p align="right" class="style2 style3 style1 style3">Sponsored Links</p></td>
              </tr>
              <tr bordercolor="#F15A25" bgcolor="#CCCCCC">
                <td bordercolor="#F15A25" bgcolor="#EAEBEB"><p align="right"><a href="/links/schools.php" target="_blank">Creative Schools</a></p>
                    <p align="right"><a href="/links/careers.php" target="_blank">Creative Careers</a></p>
                  <p align="right"><a href="/links/publications.php" target="_blank">Creative Publications</a></p>
                  <p align="right"><a href="/links/professionals.php" target="_blank">Creative Professionals</a></p>
                  <p align="right"><a href="/links/creative.php" target="_blank">General Creative Links</a></p>
                  <p align="right"><a href="/links/photography.php" target="_blank">Photography Links</a></p>
                  <p align="right"><a href="/links/art.php" target="_blank">Art Links</a></p>
                  <p align="right"><a href="/links/design.php" target="_blank">Design links</a></p>
                  <p align="right"><a href="/links/illustration.php" target="_blank">Illustration Links</a></p>
                  <p align="right"><a href="/links/web.php" target="_blank">Web Links</a></p>
                  <p align="right"><a href="/links/3d.php" target="_blank">3D Design Links</a></p>
                  <p align="right"><a href="/links/id.php" target="_blank">Interior Design Links</a></p></td>
              </tr>
          </table></td>
        </tr>
        <tr>
          <td valign="top"><table width="150" border="1" align="right" cellpadding="5" cellspacing="0" bordercolor="#F73602">
              <tr bordercolor="#F15A25" bgcolor="#CCCCCC">
                <td bordercolor="#F15A25" bgcolor="#F15A25"><p align="right" class="style2 style3 style1 style3">Stock Photos</p></td>
              </tr>
              <tr bordercolor="#F15A25" bgcolor="#CCCCCC">
                <td bordercolor="#F15A25" bgcolor="#EAEBEB"><p align="right">
                    <script type="text/javascript"><!--
google_ad_client = "pub-3297649199554245";
/* 120x240 Stock Photos */
google_ad_slot = "2792032096";
google_ad_width = 120;
google_ad_height = 240;
//-->
          </script>
                    <script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
          </script>
                </p></td>
              </tr>
          </table></td>
          </tr>
      </table>
      <p> </p>
      <p> </p>
    </div></td>
  </tr>
</table>
<p> </p>
</body>
</html>

technotool · May 20, 2008

This will get you going in the right direction:

if(
ctype_alnum($password) // numbers & digits only
&& strlen($password)>6 // at least 7 chars
&& strlen($password)<21 // at most 20 chars
&& preg_match('`[A-Z]`',$password) // at least one upper case
&& preg_match('`[a-z]`',$password) // at least one lower case
&& preg_match('`[0-9]`',$password) // at least one digit
){
// valid
}else{
// not valid
}

untested

technotool

jasonhardwick · May 20, 2008

thanks for the suggesion, i took it and put it in my code but it still doesnt work... any ideas why?

<?php 

if(isset($_POST['Submit'])){
//NEED TO CHECK IF FIELDS ARE FILLED IN
if( empty($_POST['name']) && (empty($_POST['email']))){
header("Location:Messages.php?msg=3"); 
exit();
}

if( empty($_POST['pw1']) && (empty($_POST['pw2']))){
header( "Location:Messages.php?msg=4" ); 
exit();
}

if(
ctype_alnum($pw1) // numbers & digits only
&& strlen($pw1)>6 // at least 7 chars
&& strlen($pw1)<21 // at most 20 chars
){
// valid
}else{
header( "Location:Messages.php?msg=12" );
}

if(
ctype_alnum($name) // numbers & digits only
&& strlen($name)>6 // at least 7 chars
&& strlen($name)<21 // at most 20 chars
){
// valid
}else{
header( "Location:Messages.php?msg=12" );
}

$name=$_POST['name'];
$email=$_POST['email'];
$f_name=$_POST['f_name'];
$l_name=$_POST['l_name'];
$zip_code=$_POST['zip_code'];
$e_private=$_POST['e_private'];
$country=$_POST['country'];
$bio=$_POST['bio'];
$occupation=$_POST['occupation'];
$occupation_other=$_POST['occupation_other'];
$website=$_POST['website'];
$date_joined=date("D, F jS, Y \@ g:i a T"); //create date time
$user_image=$_POST['user_image'];

$pw1=$_POST['pw1'];
$pw2=$_POST['pw2'];

if("$pw1" !== "$pw2"  ){
header( "Location:Messages.php?msg=5" ); 
exit();
}
$ip = $_SERVER['REMOTE_ADDR'];

//connect to the db server , check if uname exist
include('config.php');
$query=("Select * from user where uname='$name'");
$result= mysql_query($query); 
$num=mysql_num_rows($result);
if ($num > 0) {//Username already exist
header( "Location:Messages.php?msg=6" ); 
exit();
}else{
//if username does not exist insert user details
$query=( "INSERT INTO user (f_name,l_name,zip_code,e_private,country,bio,occupation,occupation_other,website,uname,pw,email,date_joined,user_image,ip,level) VALUES ('$f_name','$l_name','$zip_code','$e_private','$country','$bio','$occupation','$occupation_other','$website','$name','$pw1','$email','$date_joined','$user_image','$ip','Normal')");
if (@mysql_query ($query)) {
header("location:login.php?reg=1");
exit;
}
}
mysql_close();
}
?>

jasonhardwick · May 20, 2008

ok.. i figgured most of it out, including forcing only numbers and letters and specifing an ammount of characters.

but now if everything is filled out correctly it dosent process my form it just takes me right bact to an empty registration form and dosent put anything into my sql database ???

here is my revised code:

<?php 

if(isset($_POST['Submit'])){
//NEED TO CHECK IF FIELDS ARE FILLED IN
if( empty($_POST['name'])){
header("Location:Messages1.php?msg=17"); 
exit();
}

if( empty($_POST['email'])){
header("Location:Messages1.php?msg=16"); 
exit();
}

if( empty($_POST['pw1']) && (empty($_POST['pw2']))){
header( "Location:Messages1.php?msg=4" ); 
exit();
}

if( empty($_POST['f_name']) && (empty($_POST['l_name']))){
header( "Location:Messages1.php?msg=15" ); 
exit();
}

if( empty($_POST['legal_accept'])){
header( "Location:Messages1.php?msg=14" ); 
exit();
}

if(
ctype_alnum($pw1) // numbers & digits only
&& strlen($pw1)>6 // at least 7 chars
&& strlen($pw1)<21 // at most 20 chars
){
// valid
}else{
header( "Location:Messages1.php?msg=12" );
}

if(
ctype_alnum($name) // numbers & digits only
&& strlen($name)>6 // at least 7 chars
&& strlen($name)<21 // at most 20 chars
){
// valid
}else{
header( "Location:Messages1.php?msg=13" );
}

$name=$_POST['name'];
$email=$_POST['email'];
$f_name=$_POST['f_name'];
$l_name=$_POST['l_name'];
$zip_code=$_POST['zip_code'];
$e_private=$_POST['e_private'];
$country=$_POST['country'];
$bio=$_POST['bio'];
$occupation=$_POST['occupation'];
$occupation_other=$_POST['occupation_other'];
$website=$_POST['website'];
$date_joined=date("D, F jS, Y \@ g:i a T"); //create date time
$user_image=$_POST['user_image'];
$legal_accept=$_POST['legal_accept'];

$pw1=$_POST['pw1'];
$pw2=$_POST['pw2'];

if("$pw1" !== "$pw2"  ){
header( "Location:Messages1.php?msg=5" ); 
exit();
}
$ip = $_SERVER['REMOTE_ADDR'];

//connect to the db server , check if uname exist
include('config.php');
$query=("Select * from user where uname='$name'");
$result= mysql_query($query); 
$num=mysql_num_rows($result);
if ($num > 0) {//Username already exist
header( "Location:Messages1.php?msg=6" ); 
exit();
}else{
//if username does not exist insert user details
$query=( "INSERT INTO user (f_name,l_name,zip_code,e_private,country,bio,occupation,occupation_other,website,uname,pw,email,date_joined,user_image,legal_accept,ip,level) VALUES ('$f_name','$l_name','$zip_code','$e_private','$country','$bio','$occupation','$occupation_other','$website','$name','$pw1','$email','$date_joined','$user_image','$legal_accept','$ip','Normal')");
if (@mysql_query ($query)) {
header("location:login.php?reg=1");
exit;
}
}
mysql_close();
}
?>

revraz · May 20, 2008

Echo your $query to make sure it looks right.

Use mysql_error() after your mysql_query to see what errors are being generated.

Get rid of the @ as well.

Sign In

Creating a username and password on my reg page.

Recommended Posts

jasonhardwick

Link to comment

Share on other sites

technotool

Link to comment

Share on other sites

jasonhardwick

Link to comment

Share on other sites

jasonhardwick

Link to comment

Share on other sites

revraz

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information