Dependent drop down list

Ads
 

Dependent drop down list

hi,i am trying to design a form on which 2 dependent drop down list is used my code is successful but when i select class from first drop down list all the data get lossed means the value entered in fields before drop down list get blank.what can i do for this?

This is the code

<script language="JavaScript">
    function reload(form){
    var val=form.vc.options[form.vc.options.selectedIndex].value;
    self.location='vehicleRegister1.php?vc=' + val ;
    }
    </script>

    <?php
    $con=mysql_connect("localhost","root");
    if (!$con)
      {
      die('Could not connect: ' . mysql_error());
      }
     mysql_select_db("rtodb",$con); 
     ?>

    <?php
                @$cat=$_GET['vc']; 
            if(strlen($cat) > 0 and !is_numeric($cat))
            { 
            echo "Data Error";
            exit;
            }
                $sql=mysql<em>query("SELECT clsid,veh</em>class FROM vehiclass");
                if(isset($cat) and strlen($cat) > 0)
                {
                $quer=mysql<em>query("SELECT sbcid,veh</em>subclass FROM vehisubcls WHERE clsid = $cat");
                }
                echo "<select name='vc' onchange=\"reload(this.form)\">";
                echo "<option value=''>Select One</option>";
                while ($data=mysql<em>fetch</em>assoc($sql)){
                if($data['clsid']==$cat)
                {
                    echo "<option selected value='$data[clsid]'>$data[veh_class]</option>"."&lt;BR>";
                }
                else
                {
                    echo  "<option value='$data[clsid]'>$data[veh_class]</option>";}
                } <br />
                echo "</select>";

     echo "&lt;/td&gt;";        
          echo "&lt;/tr&gt;";
          echo "&lt;tr&gt;";
            echo "&lt;td height='31' id='t3'&gt;"; echo "Vehicle Sub-Class"; echo "&lt;/td&gt;";
            echo "&lt;td&gt;";
            echo "&lt;select name='vsb'&gt;&lt;option value=''&gt;Select one&lt;/option&gt;";
            while($data1 = mysql_fetch_array($quer)) { 
            echo  "&lt;option value='$data1[veh_subclass]'&gt;$data1[veh_subclass]&lt;/option&gt;";
            }
            echo "&lt;/select&gt;";

            ?&gt;
      &lt;/td&gt;
          &lt;/tr&gt;


            &lt;td height="36" id="t3"&gt;Dealer Name &lt;/td&gt;
            &lt;td&gt;&lt;select name="dnm"&gt;
            &lt;?php 
            $sql="SELECT dealer_id,dealer_nm FROM dealer ORDER BY dealer_nm";
            $result =mysql_query($sql);
            while ($data=mysql_fetch_assoc($result)){
            ?&gt;
            &lt;option value ="&lt;?php echo $data['dealer_id'] ?&gt;" &gt;&lt;?php echo $data['dealer_nm'] ?&gt;&lt;/option&gt;
            &lt;?php } ?&gt;

            &lt;/select&gt;
View Answers

January 25, 2011 at 11:28 AM

Hi Friend,

Try this:

1)country.jsp:

 <%@page import="java.sql.*"%>
 <html>
      <head>  
      <script language="javascript" type="text/javascript">  
      var xmlHttp  
      var xmlHttp
      function showState(str){
      if (typeof XMLHttpRequest != "undefined"){
      xmlHttp= new XMLHttpRequest();
      }
      else if (window.ActiveXObject){
      xmlHttp= new ActiveXObject("Microsoft.XMLHTTP");
      }
      if (xmlHttp==null){
      alert("Browser does not support XMLHTTP Request")
      return;
      } 
      var url="state.jsp";
      url +="?count=" +str;
      xmlHttp.onreadystatechange = stateChange;
      xmlHttp.open("GET", url, true);
      xmlHttp.send(null);
      }

      function stateChange(){   
      if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete"){   
      document.getElementById("state").innerHTML=xmlHttp.responseText   
      }   
      }
      </script>  
      </head>  
      <body>  
      <select name='country' onchange="showState(this.value)">  
       <option value="none">Select</option>  
    <%
 Class.forName("com.mysql.jdbc.Driver").newInstance();  
 Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");  
 Statement stmt = con.createStatement();  
 ResultSet rs = stmt.executeQuery("Select * from country");
 while(rs.next()){
     %>
      <option value="<%=rs.getString(1)%>"><%=rs.getString(2)%></option>  
      <%
 }
     %>
      </select>  
      <br>  
      <div id='state'>  
      <select name='state' >  
      <option value='-1'></option>  
      </select>  
      </div>  
      </body> 
      </html>

2)state.jsp:

 <%@page import="java.sql.*"%>
<%
String country=request.getParameter("count");  
 String buffer="<select name='state' ><option value='-1'>Select</option>";  
 try{
 Class.forName("com.mysql.jdbc.Driver").newInstance();  
 Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");  
 Statement stmt = con.createStatement();  
 ResultSet rs = stmt.executeQuery("Select * from state where countryid='"+country+"' ");  
   while(rs.next()){
   buffer=buffer+"<option value='"+rs.getString(1)+"'>"+rs.getString(3)+"</option>";  
   }  
 buffer=buffer+"</select>";  
 response.getWriter().println(buffer); 
 }
 catch(Exception e){
     System.out.println(e);
 }

 %>

For the above code, we have created two database tables:

 CREATE TABLE `country` (                                 
           `countryid` bigint(255) NOT NULL auto_increment,       
           `countryname` varchar(255) default NULL,               
           PRIMARY KEY  (`countryid`));                             


CREATE TABLE `state` (                                   
          `stateid` bigint(255) NOT NULL auto_increment,         
          `countryid` int(255) default NULL,                     
          `state` varchar(255) default NULL,                     
          PRIMARY KEY  (`stateid`));

Thanks


January 25, 2011 at 7:55 PM

Thank You Very much Please send me code in php


September 8, 2011 at 6:52 PM

Hi everybody! The posted code was been very useful for me, but I have a question: how is possible to manage four dropdown dependnt list?

Thanks a lot. regards

Nico

Ads









Related Tutorials/Questions & Answers:
Dependent drop down list
Dependent drop down list  hi,i am trying to design a form on which 2 dependent drop down list is used my code is successful but when i select class from first drop down list all the data get lossed means the value entered
How to create a dependent drop down list using [Apache POI]
How to create a dependent drop down list using [Apache POI]  Here I..., and "rice, curd, milk" items will appear in the dependent drop down list in cell.... In that two drop down list are there. Want to create a drop down list that depends
Advertisements
How to create a dependent drop down list using [Apache POI]
How to create a dependent drop down list using [Apache POI]  Here I..., and "rice, curd, milk" items will appear in the dependent drop down list in cell.... In that two drop down list are there. Want to create a drop down list that depends
JSP Dependent Drop Down Menu
JSP Dependent Drop Down Menu  Hey Guy/Gals! I need someone help to guide me in creating a drop down menu, where the first menu affects the second...; The given code will help you to create a dependent dropdown box. 1
dynamic drop down list
dynamic drop down list  I want to create 2 drop down list, where it takes value from database and the two list are dependent..means if I select a particular value from one the other list is developed accordingly..depending
Get values in drop down list
Get values in drop down list  Pls provide me jsp code to get values in drop down list from another table's field. my project has customer... in drop down box in front end..... pls provide me code.. thanx
store values of drop down list box in database
store values of drop down list box in database  how to store values of drop down list box in oracle database in jsp?I have information inserting form where i have date of birth as drop down list box
Dependant & dynamic drop down list
Dependant & dynamic drop down list  I don't know this should be in this or AJAX forum. I have one dynamic drop down list from data base (working... on the values selected by user in first drop down list. How to achieve this ?   
Drop down list from database
Drop down list from database  Hi, Can I know how do we get the drop down list from database? Eg: select country--select state--select district--so on.   1)country.jsp: <%@page import="java.sql.*"%> <html>
Display related data in other drop down list on selecting one data in one drop down list
Display related data in other drop down list on selecting one data in one drop down list  How to display related datas in dropdown list from database on selecting one data in previous dropdownlist in Java Server Page
view data from database using drop down list
view data from database using drop down list  hi i want to view the data from database by selecting a value in a drop down list. for an example drop down list have picture element.when click it select pictures from the database
Dependant & dynamic drop down list - Follow up
Dependant & dynamic drop down list - Follow up  Thanks for your answer. As per your answer This will select only ONE row (country) from first drop down. In my case user can choose more than one row , which is then sent to next
Excel Cell Drop Down List
Excel Cell Drop Down List In this section, you will learn how to validate data entered in a cell and provide a drop down list of possible values to the user... in a excel sheet's cell and also can provide drop list of possible value
how to retreive data dynamically from mysql to drop down list
how to retreive data dynamically from mysql to drop down list   sir, i created a table in mysql and i inserted some values into the table through... the data of a particular column in a table into drop down list dynamically
retrive the data from access database to drop down list box in jsp
retrive the data from access database to drop down list box in jsp  hai, im new to jsp now im using the jsp along with access database.in table i load all the data's i need to retrive the data from database to dropdown list box
to update drop down list value when selected from website
to update drop down list value when selected from website  hi help me, i want to insert value into db when i select from a drop down list...)&& ($select!="")){ $select=$_POST['NEW']; } ?> <?php $list
to update drop down list value when selected from website
to update drop down list value when selected from website  hi help me, i want to insert value into db when i select from a drop down list...)&& ($select!="")){ $select=$_POST['NEW']; } ?> <?php $list
to update drop down list value when selected from website
to update drop down list value when selected from website  hi help me, i want to insert value into db when i select from a drop down list...)&& ($select!="")){ $select=$_POST['NEW']; } ?> <?php $list
drop down menu
drop down menu  drop down menu using html
How to pass parameter through drop down list using session management in jsp??
How to pass parameter through drop down list using session management in jsp??  How to pass parameter through drop down list in the URL and access it on same jsp page using session management
how to make drop down list in JSF & fetch data Item from database
how to make drop down list in JSF & fetch data Item from database  how to make drop down list in JSF & fetch data Item from database
The code for retrieving data from database into Drop Down List.
The code for retrieving data from database into Drop Down List.  <% DataSource data = new MysqlDataSource(); Connection con...; Book List : - select - <% while
drop down
drop down  how can i add data from choice/dropdown component of java awt to myaql table
Drop Down
Drop Down  How to insert date into database using dropdown like facebook
Drop down menu
Drop down menu  I have drop down list of some 14 links which links to the table,If i click each link the table should display below the link and again if i click the link the table should not appear. please help me
Drop down menu
Drop down menu  I have created a drop down list of links which links to a table but if i click the link the table display in the other page i want to display it in the same page.Please tell me the solution
How to insert multiple drop down list data in single column in sql database using servlet
How to insert multiple drop down list data in single column in sql database using servlet  i want to insert date of birth of user by using separate drop down list box for year,month and day into dateofbirth column in sql server
Drop Down reload in IE
Drop Down reload in IE  Hi i was using two drop down box..One for Displaying date followed by another for Dispalying Month..If i Select/Change Month from the 2nd drop down then the 1st drop down ( which is date) automatically
Pls provide me jsp code to get values in drop down list from another table's field....
Pls provide me jsp code to get values in drop down list from another table's field....  my project has customer registration and company registration... in customer registration page and should be shown in drop down box in front end
Drop Down Box
Drop Down Box  In a Drop Down box I want to show the user All the Country In the World. And when he type A-z,then each of the type Show those country which start with those word. Like I For-India
Login With Drop Down
a drop down list consisting of Customs and Accounts. I have user accounts of both... box and then login to the page. I have a drop down list box with Customs...Login With Drop Down   Hi all, I am doing a project using JSP. My

Ads