Member Avatar for rics

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.

  • 5 Contributors
  • 6 Replies
  • 136 Views
  • 22 Hours Discussion Span
  • Latest Post Latest Post by urtrivedi

Recommended Answers

All 6 Replies

Member Avatar for fobos

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.

Member Avatar for MVied

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?

Member Avatar for 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.

Member Avatar for rics

Thanks, Rajan.

Member Avatar for rajarajan2017

Please Mark as solved!

Member Avatar for urtrivedi

You may also use javascript datepicker library. In that case you need not to use seperate selection boxes

Edited by urtrivedi because: n/a
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.