Seraskier Posted November 21, 2006 Share Posted November 21, 2006 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. Link to comment https://forums.phpfreaks.com/topic/27933-gender-into-a-database/ Share on other sites More sharing options...
btherl Posted November 21, 2006 Share Posted November 21, 2006 Please post your current code. Link to comment https://forums.phpfreaks.com/topic/27933-gender-into-a-database/#findComment-127779 Share on other sites More sharing options...
Seraskier Posted November 21, 2006 Author Share Posted November 21, 2006 this is the part of my code: [code]<?phpecho "<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] Link to comment https://forums.phpfreaks.com/topic/27933-gender-into-a-database/#findComment-127780 Share on other sites More sharing options...
btherl Posted November 21, 2006 Share Posted November 21, 2006 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? Link to comment https://forums.phpfreaks.com/topic/27933-gender-into-a-database/#findComment-127784 Share on other sites More sharing options...
Seraskier Posted November 21, 2006 Author Share Posted November 21, 2006 O opps forgot that I re-write it. But can you give me a full code, Thanks. Link to comment https://forums.phpfreaks.com/topic/27933-gender-into-a-database/#findComment-127789 Share on other sites More sharing options...
btherl Posted November 21, 2006 Share Posted November 21, 2006 You re-wrote it? What does your code look like now? Link to comment https://forums.phpfreaks.com/topic/27933-gender-into-a-database/#findComment-127792 Share on other sites More sharing options...
Seraskier Posted November 21, 2006 Author Share Posted November 21, 2006 [code]<?phpinclude("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 <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] Link to comment https://forums.phpfreaks.com/topic/27933-gender-into-a-database/#findComment-127796 Share on other sites More sharing options...
btherl Posted November 21, 2006 Share Posted November 21, 2006 What does [code=php:0]var_dump($_POST);[/code] show when you submit the form? Link to comment https://forums.phpfreaks.com/topic/27933-gender-into-a-database/#findComment-127823 Share on other sites More sharing options...
Seraskier Posted November 21, 2006 Author Share Posted November 21, 2006 [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] Link to comment https://forums.phpfreaks.com/topic/27933-gender-into-a-database/#findComment-127973 Share on other sites More sharing options...
Seraskier Posted November 21, 2006 Author Share Posted November 21, 2006 **bump** Link to comment https://forums.phpfreaks.com/topic/27933-gender-into-a-database/#findComment-128126 Share on other sites More sharing options...
marcus Posted November 21, 2006 Share Posted November 21, 2006 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] Link to comment https://forums.phpfreaks.com/topic/27933-gender-into-a-database/#findComment-128138 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.