I have placed three comboboxes on PHP form. One for Year, one for month, one for year. How do i pick values from these three combos and concatenate them & transfer them to Dateofbirth field in Mysql table. Please give code.
rics 0 Newbie Poster
fobos 19 Posting Whiz in Training
You must understand something when posting a forum. We are here to help, but you must show some code to let us know that you are trying. There are no freebies here, so expect handouts.
MVied 11 Junior Poster
Also, there are at least 50 ways to do any one thing, so without something to start with, it's nearly impossible to give you something that would work for you.
Also, why comboboxes?
rajarajan2017
Combo box:
<!doctype html public "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title> Day Month Year </title>
<meta name="Generator" content="EditPlus">
<meta name="Author" content="">
<meta name="Keywords" content="">
<meta name="Description" content="">
</head>
<body>
<form name="frm1" action="update.php" method="post">
<td style="padding-top: 3px;">
<select name="dy">
<option value="">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="mth">
<option value="">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="yr">
<option value="">Year</option>
<option value="1900" >1900</option><option value="1901" >1901</option><option value="1902" >1902</option><option value="1903" >1903</option><option value="1904" >1904</option><option value="1905" >1905</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" >1948</option><option value="1949" >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><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" >1980</option><option value="1981" >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="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><option value="2007" >2007</option><option value="2008" >2008</option><option value="2009" >2009</option><option value="2010" >2010</option> </select>
</td>
<input type="submit" name="commit" value="Submit"/>
</form>
</body>
</html>PHP:
<?php
$dy = $_POST['dy'];
$mth=$_POST['mth'];
$yr = $_POST['yr'];
$phpdate = $yr."-".$mth."-".$dy;
$id = "1";
$phpdate=date($phpdate);
$host = "localhost";
$user = "root";
$pass = "";
$db = "testdb";
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
mysql_select_db($db) or die ("Unable to select database!");
$query = "INSERT INTO birthday VALUES ('$id','$phpdate')";
$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());
mysql_close($connection);
?>This is the code which exactly works.
Please put some efforts on writing codes. Please mark as solved. if you got it.
rics 0 Newbie Poster
Thanks, Rajan.
rajarajan2017
Please Mark as solved!
urtrivedi 276 Nearly a Posting Virtuoso
You may also use javascript datepicker library. In that case you need not to use seperate selection boxes
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.