[SOLVED] Form Problem

Mystixs · October 13, 2007

Ok, so I have this code:

				<tr>
					<td>*Birthdate:</td>
					<td> Month:
					<select name='BirthMonth'>
					<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='12'>11</option>
					<option value='12'>12</option>
					</select>
					Day:
					<select name='BirthDay'>
					<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='12'>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>
					Year:
					<select name='BirthYear'>
					<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='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>
					<option value='1908'>1908</option>
					<option value='1907'>1907</option>
					<option value='1906'>1906</option>
					<option value='1905'>1905</option>
					<option value='1904'>1904</option>
					<option value='1903'>1903</option>
					<option value='1902'>1902</option>
					<option value='1901'>1901</option>
					<option value='1900'>1900</option>
					</select>
					</td>
				</tr>

I have the form stuff already in place.

Just when I run the mySQL query, it doesn't submit the values. What am I missing?

kratsg · October 13, 2007

I need to see more of the code (and that option list could be simplified with a php-loop statement).

Can you show me the mysql_queries you're using (not the database connection information) and the php code that takes the form data as well as the form?

marcus · October 13, 2007

$month = $_POST['BirthMonth'];
$day = $_POST['BirthDay'];
$year = $_POST['BirthYear'];

echo "Your birthday is: " . $day "/" . $month . "/" . $year;

You can save time writing all those options by using for statements.

Mystixs · October 13, 2007

		if($page == "Register2")
		{
			echo "<center><b>.:Register:.</b></center> <hr /> Fields annotated with a * are required.
			<form action='index.php?page=Register3' method='post'>
			<table>
				<tr>
					<td>*First Name:</td>
					<td><input type='text' name='FirstName' /></td>
				</tr>
				<tr>
					<td>Last Name:</td>
					<td><input type='text' name='LastName' /></td>
				</tr>
				<tr>
					<td>*Gender:</td>
					<td>Male:<input type='radio' name='Gender' value='Male'>Female:<input type='radio' name='Gender' value='Female'></td>
				</tr>
				<tr>
					<td>*Birthdate:</td>
					<td> Month:
					<select name='BirthMonth'>
					<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='12'>11</option>
					<option value='12'>12</option>
					</select>
					Day:
					<select name='BirthDay'>
					<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='12'>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>
					Year:
					<select name='BirthYear'>
					<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='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>
					<option value='1908'>1908</option>
					<option value='1907'>1907</option>
					<option value='1906'>1906</option>
					<option value='1905'>1905</option>
					<option value='1904'>1904</option>
					<option value='1903'>1903</option>
					<option value='1902'>1902</option>
					<option value='1901'>1901</option>
					<option value='1900'>1900</option>
					</select>
					</td>
				</tr>
				<tr>
					<td>*Username:</td><td><input type='text' name='Username' /></td>
				</tr>
				<tr>
					<td>*Password:</td><td><input type='password' name='Password' /></td>
				</tr>
				<tr>
					<td>*Password Verify:</td><td><input type='password' name='PasswordVerify' /></td>
				</tr>
				<tr>
					<td>*Email:</td><td><input type='text' name='Email' /></td>
				</tr>
				<tr>
					<td>*Country:</td><td><input type='text' name='Country' /></td>
				</tr>
			</table>
				<input type='submit' value='Register' />
				</form>";
		}

Here it all is.

marcus · October 13, 2007

How bout when you submit the form, where's that code.

kratsg · October 13, 2007

Reformatting your code (I like your indenting btw, very nice :-D) I changed from echoing to ending the <?php ?> variable.

	<?php
		if($page == "Register2")
		{
	?>
		<center><b>.:Register:.</b></center> <hr /> Fields annotated with a * are required.
			<form action='index.php?page=Register3' method='post'>
			<table>
				<tr>
					<td>*First Name:</td>
					<td><input type='text' name='FirstName' /></td>
				</tr>
				<tr>
					<td>Last Name:</td>
					<td><input type='text' name='LastName' /></td>
				</tr>
				<tr>
					<td>*Gender:</td>
					<td>Male:<input type='radio' name='Gender' value='Male'>Female:<input type='radio' name='Gender' value='Female'></td>
				</tr>
				<tr>
					<td>*Birthdate:</td>
					<td> Month:
					<select name='BirthMonth'>
				<?php
					for($i=1;$i<=12;$i++){
					echo "<option value='$i'>$i</option>";
					}
				?>		
					</select>
					Day:
					<select name='BirthDay'>
				<?php
					for($i=1;$i<=31;$i++){
					echo "<option value='$i'>$i</option>";
					}
				?>	
					</select>
					Year:
					<select name='BirthYear'>
				<?php
					for($i=1998;$i>=1900;$i--){
					echo "<option value='$i'>$i</option>";
					}
				?>	
					</select>
					</td>
				</tr>
				<tr>
					<td>*Username:</td><td><input type='text' name='Username' /></td>
				</tr>
				<tr>
					<td>*Password:</td><td><input type='password' name='Password' /></td>
				</tr>
				<tr>
					<td>*Password Verify:</td><td><input type='password' name='PasswordVerify' /></td>
				</tr>
				<tr>
					<td>*Email:</td><td><input type='text' name='Email' /></td>
				</tr>
				<tr>
					<td>*Country:</td><td><input type='text' name='Country' /></td>
				</tr>
			</table>
				<input type='submit' value='Register' />
				</form>
<?php
		}
?>

Mystixs · October 13, 2007

Thanks Kratsg !

Works like a charm. I have never used the for statement before

Sign In

[SOLVED] Form Problem

Recommended Posts

Mystixs

Link to comment

Share on other sites

kratsg

Link to comment

Share on other sites

marcus

Link to comment

Share on other sites

Mystixs

Link to comment

Share on other sites

marcus

Link to comment

Share on other sites

kratsg

Link to comment

Share on other sites

Mystixs

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information