help me out with radio buttons and drop down menus
Posted: Thu Oct 15, 2009 4:05 pm
hi guys, i need help trying to validate what users click in the radio button menu and what they choose in the drop down menu. when a user choose one of the options and click submit i want the value to save in mysql database that i have created, and if possible if the user makes a mistake on the form it would be nice that the information they submit doesnt erase, that all he/she has to do is fix what was wrong. i got all the text area down pack, i am having problems with the drop down menu and the radio button. thx in advance for your help. now here is the code i have. sorry i am a newbie when it comes to PHP and forums.
for the record i have tried several things but nothing works, if anyone can tell me where to place the codes that they give me will be great help...
join_form.php
registar_parse.php
for the record i have tried several things but nothing works, if anyone can tell me where to place the codes that they give me will be great help...
join_form.php
Code: Select all
</head>
<body>
<table width="600" align="center" cellpadding="4">
<tr>
<td width="7%">REGISTER AS A MEMBER HERE </td>
</tr>
</table>
<table width="600" align="center" cellpadding="5">
<form action="register_parse.php" method="post" enctype="multipart/form-data">
<tr>
<td colspan="2"><font color="#FF0000"><?php print "$errorMsg"; ?></font></td>
</tr>
<tr>
<td width="163"><div align="right">First Name:<span class="redColor">*</span></div></td>
<td width="409"><input name="mem_firstname" type="text" value="<?php print "$firstname"; ?>" /></td>
</tr>
<tr>
<td><div align="right">Last Name:<span class="redColor">*</span></div></td>
<td><input name="mem_lastname" type="text" value="<?php print "$lastname"; ?>" /></td>
</tr>
<tr>
<td><div align="right">Gender:<span class="redColor">*</span></div></td>
<td> <input name="gender" type="radio" id="gender" value="female"> Female
<input name="gender" type="radio" id="gender" value="male"> Male
</td>
</tr>
<tr>
<td><div align="right">Date of Birth:<span class="redColor">*</span></div></td>
<td><select id="dateofbirth" name="dateofbirth" size="1">
<option value="-1"> Month </option>
<option value="1">January</option>
<option value="2">February</option>
<option value="3">March</option>
<option value="4">April</option>
<option value="5">May</option>
<option value="6">June</option>
<option value="7">July</option>
<option value="8">August</option>
<option value="9">September</option>
<option value="10">October</option>
<option value="11">November</option>
<option value="12">December</option>
</select>
<select id="Day" name="Day" size="1">
<option value="-1">Day</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
<select id="Year" name="Year" size="1">
<option value="-1">Year</option>
<option value="2009">2009</option>
<option value="2008">2008</option>
<option value="2007">2007</option>
<option value="2006">2006</option>
<option value="2005">2005</option>
<option value="2004">2004</option>
<option value="2003">2003</option>
<option value="2002">2002</option>
<option value="2001">2001</option>
<option value="2000">2000</option>
<option value="1999">1999</option>
<option value="1998">1998</option>
<option value="1997">1997</option>
<option value="1996">1996</option>
<option value="1995">1995</option>
<option value="1994">1994</option>
<option value="1993">1993</option>
<option value="1992">1992</option>
<option value="1991">1991</option>
<option value="1990">1990</option>
<option value="1989">1989</option>
<option value="1988">1988</option>
<option value="1987">1987</option>
<option value="1986">1986</option>
<option value="1985">1985</option>
<option value="1984">1984</option>
<option value="1983">1983</option>
<option value="1982">1982</option>
<option value="1981">1981</option>
<option value="1980">1980</option>
<option value="1979">1979</option>
<option value="1978">1978</option>
<option value="1977">1977</option>
<option value="1976">1976</option>
<option value="1975">1975</option>
<option value="1974">1974</option>
<option value="1973">1973</option>
<option value="1972">1972</option>
<option value="1971">1971</option>
<option value="1970">1970</option>
<option value="1969">1969</option>
<option value="1968">1968</option>
<option value="1967">1967</option>
<option value="1966">1966</option>
<option value="1965">1965</option>
<option value="1964">1964</option>
<option value="1963">1963</option>
<option value="1962">1962</option>
<option value="1961">1961</option>
<option value="1960">1960</option>
<option value="1959">1959</option>
<option value="1958">1958</option>
<option value="1957">1957</option>
<option value="1956">1956</option>
<option value="1955">1955</option>
<option value="1954">1954</option>
<option value="1953">1953</option>
<option value="1952">1952</option>
<option value="1951">1951</option>
<option value="1950">1950</option>
<option value="1949">1949</option>
<option value="1948">1948</option>
<option value="1947">1947</option>
<option value="1946">1946</option>
<option value="1945">1945</option>
<option value="1944">1944</option>
<option value="1943">1943</option>
<option value="1942">1942</option>
<option value="1941">1941</option>
<option value="1940">1940</option>
<option value="1939">1939</option>
<option value="1938">1938</option>
<option value="1937">1937</option>
<option value="1936">1936</option>
<option value="1935">1935</option>
<option value="1934">1934</option>
<option value="1933">1933</option>
<option value="1932">1932</option>
<option value="1931">1931</option>
<option value="1930">1930</option>
<option value="1929">1929</option>
<option value="1928">1928</option>
<option value="1927">1927</option>
<option value="1926">1926</option>
<option value="1925">1925</option>
<option value="1924">1924</option>
<option value="1923">1923</option>
<option value="1922">1922</option>
<option value="1921">1921</option>
<option value="1920">1920</option>
<option value="1919">1919</option>
<option value="1918">1918</option>
<option value="1917">1917</option>
<option value="1916">1916</option>
<option value="1915">1915</option>
<option value="1914">1914</option>
<option value="1913">1913</option>
<option value="1912">1912</option>
<option value="1911">1911</option>
<option value="1910">1910</option>
<option value="1909">1909</option>
</select>
</td>
</tr>
<tr>
<td><div align="right">Country:<span class="redColor">*</span></div></td>
<td><select name="country" size="1" class="countryWidth" id="country">
<option value="223" selected="selected" >United States</option>
<option value="38" >Canada</option>
<option value="223" selected="selected" >------------------</option>
<option value="1" >Afghanistan</option>
<option value="2" >Albania</option>
<option value="3" >Algeria</option>
<option value="4" >American Samoa</option>
<option value="5" >Andorra</option>
<option value="6" >Angola</option>
<option value="7" >Anguilla</option>
<option value="8" >Antarctica</option>
<option value="9" >Antigua and Barbuda</option>
<option value="10" >Argentina</option>
<option value="11" >Armenia</option>
<option value="12" >Aruba</option>
<option value="13" >Australia</option>
<option value="14" >Austria</option>
<option value="15" >Azerbaijan</option>
<option value="16" >Bahamas</option>
<option value="17" >Bahrain</option>
<option value="18" >Bangladesh</option>
<option value="19" >Barbados</option>
<option value="20" >Belarus</option>
<option value="21" >Belgium</option>
<option value="22" >Belize</option>
<option value="23" >Benin</option>
<option value="24" >Bermuda</option>
<option value="25" >Bhutan</option>
<option value="26" >Bolivia</option>
<option value="27" >Bosnia and Herzegowina</option>
<option value="28" >Botswana</option>
<option value="29" >Bouvet Island</option>
<option value="30" >Brazil</option>
<option value="31" >British Indian Ocean Territory</option>
<option value="32" >Brunei Darussalam</option>
<option value="33" >Bulgaria</option>
<option value="34" >Burkina Faso</option>
<option value="35" >Burundi</option>
<option value="36" >Cambodia</option>
<option value="37" >Cameroon</option>
<option value="38" >Canada</option>
<option value="39" >Cape Verde</option>
<option value="40" >Cayman Islands</option>
<option value="41" >Central African Republic</option>
<option value="42" >Chad</option>
<option value="43" >Chile</option>
<option value="44" >China</option>
<option value="45" >Christmas Island</option>
<option value="46" >Cocoa (Keeling) Islands</option>
<option value="47" >Colombia</option>
<option value="48" >Comoros</option>
<option value="49" >Congo</option>
<option value="50" >Cook Islands</option>
<option value="51" >Costa Rica</option>
<option value="52" >Cote Divoire</option>
<option value="53" >Croatia (Hrvatska)</option>
<option value="54" >Cuba</option>
<option value="55" >Cyprus</option>
<option value="56" >Czech Republic</option>
<option value="57" >Denmark</option>
<option value="58" >Djibouti</option>
<option value="240" >DoDDs Schools</option>
<option value="59" >Dominica</option>
<option value="60" >Dominican Republic</option>
<option value="61" >East Timor</option>
<option value="62" >Ecuador</option>
<option value="63" >Egypt</option>
<option value="64" >El Salvador</option>
<option value="65" >Equatorial Guinea</option>
<option value="66" >Eritrea</option>
<option value="67" >Estonia</option>
<option value="68" >Ethiopia</option>
<option value="69" >Falkland Islands (Malvinas)</option>
<option value="70" >Faroe Islands</option>
<option value="71" >Fiji</option>
<option value="72" >Finland</option>
<option value="236" >Former Yugoslavia</option>
<option value="73" >France</option>
<option value="78" >Gabon</option>
<option value="79" >Gambia</option>
<option value="80" >Georgia</option>
<option value="81" >Germany</option>
<option value="82" >Ghana</option>
<option value="83" >Gibraltar</option>
<option value="84" >Greece</option>
<option value="85" >Greenland</option>
<option value="86" >Grenada</option>
<option value="88" >Guam</option>
<option value="89" >Guatemala</option>
<option value="90" >Guinea</option>
<option value="91" >Guinea-Bissau</option>
<option value="92" >Guyana</option>
<option value="93" >Haiti</option>
<option value="94" >Heard and Mc Donald Islands</option>
<option value="95" >Honduras</option>
<option value="96" >Hong Kong</option>
<option value="97" >Hungary</option>
<option value="98" >Iceland</option>
<option value="99" >India</option>
<option value="100" >Indonesia</option>
<option value="101" >Iran (Islamic Republic of)</option>
<option value="102" >Iraq</option>
<option value="103" >Ireland</option>
<option value="104" >Israel</option>
<option value="105" >Italy</option>
<option value="106" >Jamaica</option>
<option value="107" >Japan</option>
<option value="108" >Jordan</option>
<option value="109" >Kazakhstan</option>
<option value="110" >Kenya</option>
<option value="111" >Kiribati</option>
<option value="112" >Korea, Democratic Peoples Republic of</option>
<option value="113" >Korea, Republic of</option>
<option value="114" >Kuwait</option>
<option value="115" >Kyrgyzstan</option>
<option value="116" >Laos</option>
<option value="117" >Latvia</option>
<option value="118" >Lebanon</option>
<option value="119" >Lesotho</option>
<option value="120" >Liberia</option>
<option value="121" >Libyan Arab Jamahiriya</option>
<option value="122" >Liechtenstein</option>
<option value="123" >Lithuania</option>
<option value="124" >Luxembourg</option>
<option value="125" >Macau</option>
<option value="126" >Macedonia, Republic of</option>
<option value="127" >Madagascar</option>
<option value="128" >Malawi</option>
<option value="129" >Malaysia</option>
<option value="130" >Maldives</option>
<option value="131" >Mali</option>
<option value="132" >Malta</option>
<option value="133" >Marshall Islands</option>
<option value="135" >Mauritania</option>
<option value="136" >Mauritius</option>
<option value="138" >Mexico</option>
<option value="139" >Micronesia, Federated States of</option>
<option value="140" >Moldova, Republic of</option>
<option value="141" >Monaco</option>
<option value="142" >Mongolia</option>
<option value="242" >Montenegro</option>
<option value="143" >Montserrat</option>
<option value="144" >Morocco</option>
<option value="145" >Mozambique</option>
<option value="146" >Myanmar</option>
<option value="147" >Namibia</option>
<option value="148" >Nauru</option>
<option value="149" >Nepal</option>
<option value="150" >Netherlands</option>
<option value="151" >Netherlands Antilles</option>
<option value="153" >New Zealand</option>
<option value="154" >Nicaragua</option>
<option value="155" >Niger</option>
<option value="156" >Nigeria</option>
<option value="157" >Niue</option>
<option value="158" >Norfolk Island</option>
<option value="159" >Northern Mariana Islands</option>
<option value="160" >Norway</option>
<option value="161" >Oman</option>
<option value="162" >Pakistan</option>
<option value="163" >Palau</option>
<option value="164" >Panama</option>
<option value="165" >Papua New Guinea</option>
<option value="166" >Paraguay</option>
<option value="167" >Peru</option>
<option value="168" >Philippines</option>
<option value="169" >Pitcairn</option>
<option value="170" >Poland</option>
<option value="171" >Portugal</option>
<option value="172" >Puerto Rico</option>
<option value="173" >Qatar</option>
<option value="175" >Romania</option>
<option value="176" >Russian Federation</option>
<option value="177" >Rwanda</option>
<option value="178" >Saint Kitts and Nevis</option>
<option value="179" >Saint Lucia</option>
<option value="180" >Saint Vincent and the Grenadines</option>
<option value="181" >Samoa</option>
<option value="182" >San Marino</option>
<option value="183" >Sao Tome and Principe</option>
<option value="184" >Saudi Arabia</option>
<option value="185" >Senegal</option>
<option value="241" >Serbia</option>
<option value="186" >Seychelles</option>
<option value="187" >Sierra Leone</option>
<option value="188" >Singapore</option>
<option value="189" >Slovakia (Slovak Republic)</option>
<option value="190" >Slovenia</option>
<option value="191" >Solomon Islands</option>
<option value="192" >Somalia</option>
<option value="193" >South Africa</option>
<option value="194" >South Georgia and the South Sandwich Islands</option>
<option value="195" >Spain</option>
<option value="196" >Sri Lanka</option>
<option value="197" >St. Helena</option>
<option value="199" >Sudan</option>
<option value="200" >Suriname</option>
<option value="201" >Svalbard and Jan Mayen Islands</option>
<option value="202" >Swaziland</option>
<option value="203" >Sweden</option>
<option value="204" >Switzerland</option>
<option value="205" >Syrian ArabRepublic</option>
<option value="206" >Taiwan</option>
<option value="207" >Tajikistan</option>
<option value="208">Tanzania, United Republic of</option>
<option value="209" >Thailand</option>
<option value="210" >Togo</option>
<option value="211" >Tokelau</option>
<option value="212" >Tonga</option>
<option value="213" >Trinidad and Tobago</option>
<option value="214" >Tunisia</option>
<option value="215" >Turkey</option>
<option value="216" >Turkmenistan</option>
<option value="217" >Turks and Caicos Islands</option>
<option value="218" >Tuvalu</option>
<option value="219" >Uganda</option>
<option value="220" >Ukraine</option>
<option value="221" >United ArabEmirates</option>
<option value="222" >United Kingdom</option>
<option value="223">United States</option>
<option value="224" >United States Minor Outlying Islands</option>
<option value="225" >Uruguay</option>
<option value="226" >Uzbekistan</option>
<option value="227" >Vanuatu</option>
<option value="228" >Vatican City State(Holy See)</option>
<option value="229" >Venezuela</option>
<option value="230" >Viet Nam</option>
<option value="231" >Virgin Islands (British)</option>
<option value="232" >Virgin Islands (U.S.)</option>
<option value="234" >Western Sahara</option>
<option value="235" >Yemen</option>
<option value="237" >Zaire</option>
<option value="238" >Zambia</option>
<option value="239" >Zimbabwe</option>
</select></td>
</tr>
<tr>
<td><div align="right">State/Region:<span class="redColor">*</span></div></td>
<td><input name="mem_state" type="text" value="<?php print "$state"; ?>" /></td>
</tr>
<tr>
<td><div align="right">City/Town:<span class="redColor">*</span></div></td>
<td>
<input name="mem_city" type="text" value="<?php print "$city"; ?>" />
</td>
</tr>
<tr>
<td><div align="right">Zip:<span class="redColor">*</span></div></td>
<td><input name="mem_zip" type="text" value="<?php print "$zip"; ?>" /></td>
</tr>
<tr>
<td><div align="right">Email:<span class="redColor">*</span></div></td>
<td><input name="mem_email" type="text" value="<?php print "$email"; ?>" /></td>
</tr>
<tr>
<td><div align="right"> Password:<span class="redColor">*</span></div></td>
<td><input name="mem_password" type="password" /></td>
</tr>
<tr>
<td><div align="right"></div></td>
<td><input type="submit" name="Submit" value="Submit Form" /></td>
</tr>
</form>
</table>
</body>
</html>Code: Select all
<?php
// First we check to see if the form has been submitted
if (isset($_POST['mem_firstname'])){
//Connect to the database through our include
include_once "../scripts/connect_to_mysql.php";
// Create local varibles from the info the user supplied in the form
$firstname = $_POST['mem_firstname'];
$lastname = $_POST['mem_lastname'];
$state = $_POST['mem_state'];
$city = $_POST['mem_city'];
$zip = $_POST['mem_zip'];
$email = $_POST['mem_email'];
$password = $_POST['mem_password'];
$gender = $_POST['gender'];
// Strip slashes on the vars for security reasons
$firstname = stripslashes($firstname);
$lastname = stripslashes($lastname);
$state = stripslashes($state);
$city = stripslashes($city);
$zip = stripslashes($zip);
$email = stripslashes($email);
$password = stripslashes($password);
// Check to see if the user filled all fields with
// the "Required"(*) symbol next to them in the join form
// and print out to them what they have forgotten to put in
if((!$firstname) || (!$lastname) || (!$state) || (!$city) || (!$zip) || (!$email) || (!$password)){
$errorMsg = "You did not submit the following required information!<br /><br />";
if(!$firstname){
$errorMsg .= "*First Name<br/>";
}
if(!$lastname){
$errorMsg .= "*Last Name<br/>";
}
if(!$state){
$errorMsg .= "*State<br/>";
}
if(!$city){
$errorMsg .= "*City<br/>";
}
if(!$zip){
$errorMsg .= "*Zip Code<br/>";
}
if(!$email){
$errorMsg .= "*Email Address<br/>";
}
if(!$password){
$errorMsg .= "*Password<br/>";
}
//Here we include our join form fiel in its entirety
//and place our error message to display in it this time too
include_once "join_form.php";
//stops this script from executing any more further down
exit();
}
//validate radio boxes
var_dump( $_POST ) ;
// test to see gender has been chosen
if( !isset( $_POST['gender'] ) ){
$errorMsg = 'you must pick a gender' ;
include "join_form.php";
}
// Database Email duplication Check
$sql_email_check = mysql_query("SELECT email FROM myMembers WHERE email='$email'");
$email_check = mysql_num_rows($sql_email_check);
if ($email_check > 0){
$errorMsg = "<u>ERROR:</u><br />
Your Email address is already in use inside our system. Please use another.";
//ERROR handling is ended. process the data and add member to database
////////////////////////////////////////////////////////////////////////////
// Here we include our join form file in its entirety and
// place our error message to display in it this time too
include_once "join_form.php";
// Then stop this script from executing any more further down
exit();
} else {
$firstname = mysql_real_escape_string($firstname);
$lastname = mysql_real_escape_string($lastname);
$state = mysql_real_escape_string($state);
$city = mysql_real_escape_string($city);
$zip = mysql_real_escape_string($zip);
$email = mysql_real_escape_string($email);
$password = mysql_real_escape_string($password);
$password1 = mysql_real_escape_string($password1);
$firstname = eregi_replace("`","",$firstname);
$lastname = eregi_replace("`","",$lastname);
$state = eregi_replace("`","",$state);
$city = eregi_replace("`","",$city);
$zip = eregi_replace("`","",$zip);
$email = eregi_replace("`","",$email);
$password = eregi_replace("`","",$password);
$password1 = eregi_replace("`","",$password1);
//add MD5 Hash to the password variable
$db_password = md5($password);
// Add user info into the database table, claim your fields then values
$sql = mysql_query("INSERT INTO myMembers (firstname, lastname, state, city, zip, email, password, sign_up_date)
VALUES('$firstname','$lastname','$state','$city','$zip','$email','$password', now())")
or die (mysql_error());
// Get the inserted ID here to use in the activation email
$id = mysql_insert_id();
// Create directory(folder) to hold each user files(pics, MP3s, etc.)
mkdir("memberFiles/$email", 0755, true);
// Start assembly of Email Member the activation link
$to = "$email";
// Change this to your site admin email
$from = "hecubie26@aol.com";
$subject = "Complete your registration";
//Begin HTML Email Message where you need to change the activation URL inside
$message = "HI $firstname,
Complete this step to activate your login identity at website
Click the link below to activate when ready.
(link) ?id=$id&sequence=$db_password
if the URL above is not an active link, Please copy and paste it into your broser address bar
Login after successful activation using your.
E-mail Address: $email
Password: $password";
//end message
$headers = "From: $from\r\n";
$headers .= "Content-type: text/html\r\n";
$to = "$to";
// Finally send the activation email to the member
mail($to, $subject, $message, $headers);
// Then print a message to the browser for the joiner
$msgToUser = "<h2>OK $firstname, one last step to verify your email identity:</h2>
<br />
We just sent an Activation link to your email address.<br />
<br />
<strong><font color=\"#990000\">Please check your email inbox in a moment</font></strong> to click on the Activation <br />
Link inside the message. After email activation you can log in.<br />";
print $msgToUser;
}// Close else after email duplication check
}else{
//if the form is not posted with variable, place default empty variables
$errorMsg = "Fields marked with an [*] are required";
$firstname = "";
$lastname = "";
$state = "";
$city = "";
$zip = "";
$email = "";
$password = "";
$password1 ="";
}
?>