ecabrera Posted August 15, 2011 Share Posted August 15, 2011 hey im createing a registration form and i create this birthday section but i dont know how to save the data on my mysql should i create a table name birthday or what i have no clue how to store it <tr> <td>Birthday</td> <td><select name='month' onchange='removeSpace(this); ValidateDate();' name='monthdropdown' style='width: 75px; margin-bottom: 5px; padding: 2px; font-size: 12px;'> <option value='--' selected='selected'>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 name='day' name='daydropdown' onchange='removeSpace(this);' class='dropdday'> <option value='--' selected='selected'>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 name='year' onchange='removeSpace(this); ValidateDate();' name='yeardropdown' class='dropdyear'> <option value='--' selected='selected'>Year</option> <option value='2011' >2011</option> <option value='2010' >2010</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> <option value='1908' >1908</option> <option value='1907' >1907</option> <option value='1906' >1906</option> <option value='1905' >1905</option> </select><font color='red'>*</font></td> </tr> Link to comment https://forums.phpfreaks.com/topic/244866-birthday-help/ Share on other sites More sharing options...
jcbones Posted August 15, 2011 Share Posted August 15, 2011 I would save it in the user table in a timestamp or datetime column. Changing it to the database timestamp format is easy with the strtotime function. Link to comment https://forums.phpfreaks.com/topic/244866-birthday-help/#findComment-1257876 Share on other sites More sharing options...
ecabrera Posted August 15, 2011 Author Share Posted August 15, 2011 ok but how should i name it because there is a select names which is month , day and year Link to comment https://forums.phpfreaks.com/topic/244866-birthday-help/#findComment-1257880 Share on other sites More sharing options...
jcbones Posted August 15, 2011 Share Posted August 15, 2011 <?php $month = intval($_POST['month']); $day = intval($_POST['day']); $year = intval($_POST['year']); $store_in_database_as = $year . '-' . $month . '-' . $day; ?> On second thought, there is no need to store as a timestamp or datetime, using a date column would be just fine. Link to comment https://forums.phpfreaks.com/topic/244866-birthday-help/#findComment-1257885 Share on other sites More sharing options...
ecabrera Posted August 15, 2011 Author Share Posted August 15, 2011 ok thanks Link to comment https://forums.phpfreaks.com/topic/244866-birthday-help/#findComment-1257886 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.