Gender into a database

[Seraskier]

Ok dont laugh at me please, but ive been having trouble with this one thing, yet so simple. How do I get radio buttons to insert into a database. As in it asks for a gender, 1 male and 1 female. I do that but what it says in my database is "gender" and i've tried everything. Please help me. Thanks.

[btherl]

Please post your current code.

[Seraskier]

this is the part of my code:

[code]
<?php
echo "<form method='post' action='register.php?do=do'>";
echo "<input type='radio' name='gender' value='Male'>Male<input type='radio' name='gender' value='Female'>Female";
echo "</form>";

if($_GET['do'] == 'do')
{
$_gender = $_POST['gender'];
mysql_query("INSERT INTO users (gender) VALUES ('$_gender')");
}
?>
[/code]

[btherl]

The first things I would try are to print out the value of $_gender to the screen, as well as [code=php:0]var_dump($_POST);[/code]

I would also add [code=php:0] or die(mysql_error());[/code] to your mysql_query() line, to check if it fails.

I'm also puzzled as to how you submit your form without a submit button.  Are you using javascript?

[Seraskier]

O opps forgot that I re-write it. But can you give me a full code, Thanks.

[btherl]

You re-wrote it?  What does your code look like now?

[Seraskier]

[code]
<?php
include("connect.php");

echo "<form method='post' action='register.php?do=do'>";
echo "<table cellspacing='5' cellpadding='0'>";
echo "<td><font color='#FF0000'>All Fields Required</font></td>";
echo "<tr><td>Email:</td><td><input type='text' name='email' value='$_email' size='29'></td></tr>";
echo "<tr><td>Password:</td><td><input type='password' name='password' value='$_password' size='29'></td></tr>";
echo "<tr><td>Confirm Password:</td><td><input type='password' name='confirmpassword' size='29'></td></tr>";
echo "<tr><td>First Name:</td><td><input type='text' name='first' value='$_first' size='29'></td></tr>";
echo "<tr><td>Last Name:</td><td><input type='text' name='last' value='$_last' size='29'></td></tr>";
echo "<tr><td>Gender:</td><td><input type='radio' name='gender' value='Male'>Male&nbsp;&nbsp;<input type='radio' name='gender' value='Female'>Female";
echo "<tr><td>Birthday:</td><td>";
echo "<select name='birthmonth'><option value='Month'>Month</option><option value='January'>January</option><option value='February'>February</option><option value='March'>March</option><option value='April'>April</option><option value='May'>May</option><option value='June'>June</option><option value='July'>July</option><option value='August'>August</option><option value='September'>September</option><option value='October'>October</option><option value='November'>November</option><option value='December'>December</option></select>";
echo "<select name='birthday'><option value='Day'>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>";
echo "<select name='birthyear'><option value='Year'>Year</option><option value='1906'>1906</option><option value='1907'>1907</option><option value='1908'>1908</option><option value='1909'>1909</option><option value='1910'>1910</option><option value='1911'>1911</option><option value='1912'>1912</option><option value='1913'>1913</option><option value='1914'>1914</option><option value='1915'>1915</option><option value='1916'>1916</option><option value='1917'>1917</option><option value='1918'>1918</option><option value='1919'>1919</option><option value='1920'>1920</option><option value='1921'>1921</option><option value='1922'>1922</option><option value='1923'>1923</option><option value='1924'>1924</option><option value='1925'>1925</option><option value='1926'>1926</option><option value='1927'>1927</option><option value='1928'>1928</option><option value='1929'>1929</option><option value='1930'>1930</option><option value='1931'>1931</option><option value='1932'>1932</option><option value='1933'>1933</option><option value='1934'>1934</option><option value='1935'>1935</option><option value='1936'>1936</option><option value='1937'>1937</option><option value='1938'>1938</option><option value='1939'>1939</option><option value='1940'>1940</option><option value='1941'>1941</option><option value='1942'>1942</option><option value='1943'>1943</option><option value='1944'>1944</option><option value='1945'>1945</option><option value='1946'>1946</option><option value='1947'>1947</option><option value='1948'>1949</option><option value='1950'>1950</option><option value='1951'>1951</option><option value='1952'>1952</option><option value='1953'>1953</option><option value='1954'>1954</option><option value='1955'>1955</option><option value='1956'>1956</option><option value='1957'>1957</option><option value='1958'>1958</option><option value='1959'>1959</option><option value='1960'>1960</option><option value='1961'>1961</option><option value='1962'>1962</option><option value='1963'>1963</option><option value='1964'>1964</option>1964<option value='1965'>1965</option><option value='1966'>1966</option><option value='1967'>1967</option><option value='1968'>1968</option><option value='1969'>1969</option><option value='1970'>1970</option><option value='1971'>1971</option><option value='1972'>1972</option><option value='1973'>1973</option><option value='1974'>1974</option><option value='1975'>1975</option><option value='1976'>1976</option><option value='1977'>1977</option><option value='1978'>1978</option><option value='1979'>1979</option><option value='1980'>1981</option><option value='1982'>1982</option><option value='1983'>1983</option><option value='1984'>1984</option><option value='1985'>1985</option><option value='1986'>1986</option><option value='1986'>1986</option><option value='1987'>1987</option><option value='1988'>1988</option><option value='1989'>1989</option><option value='1990'>1990</option><option value='1991'>1991</option><option value='1992'>1992</option><option value='1993'>1993</option><option value='1994'>1994</option><option value='1995'>1995</option><option value='1996'>1996</option><option value='1997'>1997</option><option value='1998'>1998</option><option value='1999'>1999</option><option value='2000'>2000</option><option value='2001'>2001</option><option value='2002'>2002</option><option value='2003'>2003</option><option value='2004'>2004</option><option value='2005'>2005</option><option value='2006'>2006</option></select></td></tr>";
echo "<tr><td></td><td><div align='right'><input type='submit' value='Sign Up'></div></td></tr>";
echo "</table></form>";

if($_GET['do'] == 'do')
{
$_email = $_POST['email'];
$_password = $_POST['password'];
$_confirmpassword = $_POST['confirmpassword'];
$_first = $_POST['first'];
$_last = $_POST['last'];
$_gender = $_POST['gender'];
$_birthmonth = $_POST['birthmonth'];
$_birthday = $_POST['birthday'];
$_birthyear = $_POST['birthyear'];
$_regdate = date("M d, Y");
$_regtime = date("g:i a");
srand((double)microtime()*99999999); 
$_id = rand(100000,99999999);
$_ip = $_SERVER['REMOTE_ADDR'];


$result = mysql_query("SELECT * FROM users WHERE email='" . $_email . "'") or die(mysql_error());
$row = mysql_fetch_array( $result );
if(($row['email'] != '') || ($_email == '') || (file_exists($_id . "/")))
{
$_email_required = '1';
echo "<font color='#BF0000'>This Email Address is Already Registered.</font><br />";
}
else
{
mysql_query ("insert into users (email, password, first, last, gender, birthmonth, birthday, birthyear, regdate, regtime, ip, id) values ('$_email', '$_password', '$_first', '$_last', '$_gender', '$_birthmonth', '$_birthday', '$_birthyear', '$_regdate', '$_regtime', '$_ip', '$_id')");
mkdir($_id . "/", 0777);
mkdir("images/users/" . $_id, 0777);
mkdir("source/users/" . $_id, 0777);
$file = 'source/profile.php';
$newfile = $_id . '/index.php';
rename($_id . "/profile.php", $_id . "/index.php");
if (!copy($file, $newfile)) {
  echo "failed to copy $file, please try again later.\n";
}
header("location:login.php");
}
?>
[/code]

[btherl]

What does [code=php:0]var_dump($_POST);[/code] show when you submit the form?

[Seraskier]

[quote author=btherl link=topic=115714.msg471283#msg471283 date=1164090845]
What does [code=php:0]var_dump($_POST);[/code] show when you submit the form?
[/quote]

what do you mean? There is no [code=php:0]var_dump($_POST);[/code]

[Seraskier]

**bump**

[marcus]

you can try this:

[code]
$sex = $_POST[gender];
if($sex == male){
$gender = male;
}else{
$gender = female;
};
mysql_query("INSERT INTO `users` (`gender`) VALUES ('$gender')");
[/code]