4 Replies - 248 Views - Last Post: 11 March 2013 - 10:21 AM Rate Topic: -----

#1 nazirul_137  Icon User is offline

  • New D.I.C Head

Reputation: -1
  • View blog
  • Posts: 15
  • Joined: 06-February 13

How to retrieve from listmenu or drop menu and checkbox?

Posted 10 March 2013 - 09:21 PM

How to retrieve from this three list menu and two check box?

        <table width="257" border="0" align="center">
        <tr>
            <td width="32"> Date: </td>
            <td width="215">
                <select name="DateOfBirth_Day">
                <option> 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="DateOfBirth_Month">
                <option> Month </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>
                </select>

                <select name="DateOfBirth_Year">
                <option> Year </option>
                <option value="2040">2040</option>
                <option value="2039">2039</option>
                <option value="2038">2038</option>
                <option value="2037">2037</option>
                <option value="2036">2036</option>
                <option value="2035">2035</option>
                <option value="2034">2034</option>
                <option value="2033">2033</option>
                <option value="2032">2032</option>
                <option value="2031">2031</option>
                <option value="2030">2030</option>
                <option value="2029">2029</option>
                <option value="2028">2028</option>
                <option value="2027">2027</option>
                <option value="2026">2026</option>
                <option value="2025">2025</option>
                <option value="2024">2024</option>
                <option value="2023">2023</option>
                <option value="2022">2022</option>
                <option value="2021">2021</option>
                <option value="2020">2020</option>
                <option value="2019">2019</option>
                <option value="2018">2018</option>
                <option value="2017">2017</option>
                <option value="2016">2016</option>
                <option value="2015">2015</option>
                <option value="2014">2014</option>
                <option value="2013">2013</option>
                <option value="2012">2012</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>
                <option value="1904">1904</option>
                <option value="1903">1903</option>
                <option value="1902">1902</option>
                <option value="1901">1901</option>
                <option value="1900">1900</option>
                </select>
            </td>
        </tr>
        </table>
        
        <table width="255" border="0" align="center">
        <tr>
            <td width="33"><div align="center">Time:</div></td>
            <td width="212"><div align="left">
                <input type="checkbox" name="checkbox6" id="checkbox6" />Day
                <input type="checkbox" name="checkbox6" id="checkbox7" />Night</div>
            </td>
        </tr>
        </table>
        
        <table width="50" border="0" align="center">
        <tr>
            <td><input type="submit" name="button2" id="button2" value="Retrieve" /></td>
        </tr>
        </table>



Is This A Good Question/Topic? 0
  • +

Replies To: How to retrieve from listmenu or drop menu and checkbox?

#2 macosxnerd101  Icon User is offline

  • Self-Trained Economist
  • member icon




Reputation: 10194
  • View blog
  • Posts: 37,646
  • Joined: 27-December 08

Re: How to retrieve from listmenu or drop menu and checkbox?

Posted 10 March 2013 - 09:23 PM

You can access the values from $_GET or $_POST, appropriately, depending on the method you use to submit your form.
Was This Post Helpful? 0
  • +
  • -

#3 nazirul_137  Icon User is offline

  • New D.I.C Head

Reputation: -1
  • View blog
  • Posts: 15
  • Joined: 06-February 13

Re: How to retrieve from listmenu or drop menu and checkbox?

Posted 10 March 2013 - 09:37 PM

what should i change for use this get method and using list menu and checkbox?

if($_GET["txtKeyword"] != "")
{	
	$strSQL = "SELECT  * FROM database  WHERE (col1 LIKE '%".$_GET["txtKeyword"]."%' 
	or col2 LIKE '%".$_GET["txtKeyword"]."%' )  ";
	$objParse = oci_parse ($conn, $strSQL);
	oci_execute ($objParse);
	?>
	<table width="1000" height="70" border="1">
	  <tr>
		<th width="147" height="33"> <div align="center">show col1</div></th>
		<th width="148"> <div align="center">show col2</div></th>
	  </tr>
	<?php
	while($objResult = oci_fetch_array($objParse,OCI_BOTH))
	{
	?>
	  <tr>
		<td><div align="center"><?php echo $objResult["col1"];?></div></td>
		<td><div align="center"><?php echo $objResult["col2"];?></div></td>
	  </tr>
	<?php
	}
	?>
    </table>
<?php
oci_close($conn);
}
?>


Was This Post Helpful? 0
  • +
  • -

#4 macosxnerd101  Icon User is offline

  • Self-Trained Economist
  • member icon




Reputation: 10194
  • View blog
  • Posts: 37,646
  • Joined: 27-December 08

Re: How to retrieve from listmenu or drop menu and checkbox?

Posted 10 March 2013 - 09:40 PM

Use how so? The way this works is that the HTML form is displayed. When you hit submit, the data is sent to the server and processed by the server-side language (PHP). The results are then sent back to the browser to be displayed.
Was This Post Helpful? 0
  • +
  • -

#5 laytonsdad  Icon User is online

  • Cheese and Sprinkles
  • member icon

Reputation: 409
  • View blog
  • Posts: 1,729
  • Joined: 30-April 10

Re: How to retrieve from listmenu or drop menu and checkbox?

Posted 11 March 2013 - 10:21 AM

Do you have form tags?

<form method='get' action='process.php'>
This is a form with a method of 'get' and it is sent to a page called 'process.php'.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1