display the value from xml file when user click the drop down menu

[dkyadav80]

Hi sir,

I'm new about xml, javascript. I have two selection field(html) first is city and second is state. the city and state values should be store in xml file. when user select city then all city values should display in city selection field and when user select any one city value then this state of this city should be display auto in state
selection field without user selection. please solve my prolem.

Thank you.

[acoder]

What have you managed so far? This is the classical dependent drop-down problem. Post your code.

[dkyadav80]

Hi Sir,
I'm new in XML , I 'm displaying the cities values in drop-down menu box from cities.xml file for city: field, through smarty and php code , on html form and I have next field is State which is also drop-down menu list box. I want when i select city name from city drop-down then state name of this city will become automatic in state drop-down menu box. currently i'm using saparate xml file for city and state. both xml file are below:

file: cities.xml

<cities>
    <city><![CDATA[Abohar]]></city>
    <city><![CDATA[Abu Road]]></city>
    <city><![CDATA[Adilabad]]></city>
    <city><![CDATA[Ariyalur]]></city>
    <city><![CDATA[Agartala]]></city>
    <city><![CDATA[Agra]]></city>
    <city><![CDATA[Ahmedabad]]></city>
    <city><![CDATA[Ahmednagar]]></city>
    <city><![CDATA[Aizwal]]></city>
    <city><![CDATA[Ajmer]]></city>
    <city><![CDATA[Ajjampura]]></city>
    <city><![CDATA[Akola]]></city>
    <city><![CDATA[Aligarh]]></city>
</cities>

[php]

function getCities() {
$filename = "cities.xml";
if (file_exists($filename)) {
$cities_obj = simplexml_load_file($filename);
$cities = $cities_obj->xpath('/cities/city');
return $cities;
} else {
echo "File does not exist";
}
}
$cities = getCities();
$main_smarty->assign("cities", $cities);[/php]


file: states.xml

 
<states>
    <state><![CDATA[Andaman and Nicobar Islands]]></state>
    <state><![CDATA[Andhra Pradesh]]></state>
    <state><![CDATA[Arunachal Pradesh]]></state>
    <state><![CDATA[Assam]]></state>
    <state><![CDATA[Bihar]]></state>
    <state><![CDATA[Chandigarh]]></state>
    <state><![CDATA[Chhattisgarh]]></state>
    <state><![CDATA[Dadra and Nagar Haveli]]></state>
    <state><![CDATA[Daman and Diu]]></state>
    <state><![CDATA[Delhi]]></state>
    <state><![CDATA[Goa]]></state>
    <state><![CDATA[Gujarat]]></state>
    <state><![CDATA[Haryana]]></state>
    <state><![CDATA[Himachal Pradesh]]></state>
    <state><![CDATA[Jammu and Kashmir]]></state>
    <state><![CDATA[Jharkhand]]></state>
    <state><![CDATA[Karnataka]]></state>
    <state><![CDATA[Kerala]]></state>
</states>

Php:

 
function getStates(){
    $filename="states.xml";
    if (file_exists($filename)) {
        $states_obj = simplexml_load_file($filename);
        $states = $states_obj->xpath('/states/state');
        return $states;
    } else {
        echo "File does not exist";
    }
}
$states = getStates();    
$main_smarty->assign("states", $states);

[HTML]

<tr>
<td align="right"><label for="cons_indi_prof_city">City<span class="req">*</span></label></td>
<td align="left">
<select name="cons_indi_prof_city" id="cons_indi_prof_city" style="width:180px" onChange="display(this,'ot');">
<option value="Select" selected="selected">Select</option>
{html_options values=$cities output=$cities}
<option value="other">other</option>
</select></td>
<td align="left">
<input name="ocity" id="ot" type="text" style="display:none;width:170px" maxlength="50"/>
</td>
</tr>
<tr>
<td align="right"><label for="cons_indi_prof_state">State<span class="req">*</span></label></td>
<td align="left">
<select name="cons_indi_prof_state" id="cons_indi_prof_state" style="width:180px" onChange="display2(this,'oth');">
<option value="Select" selected="selected">Select</option>
{html_options values=$states output=$states}
<option value="other">other</option>
</select></td>
<td align="left">
<input name="ostate" id="oth" type="text" style="display:none;width:170px" maxlength="50" />
</td>
</tr>[/html]

//////////

All codes are working good , cities and states are displaying good in drow-down menu box. Proble is that if user select the city then particular state of that's city will should be display in state drop down menu box.
Pls solve my problem I'm sufffering from 2 weeks.

Thanks

[dkyadav80]

Hi guys,

I 'm developing a site using javascript lib file with prototype, Iframe, smarty , php html, css.. I have read the xml file( city and state ) using CDATASECTION through php and display by smarty in drop down menu . I have one text filed after drop down. i wanna when user select the city from drop down then auto display the state of this city which one user is selecting in the text field.
pls give programe example.

Pls help me.

[newlearner]

Can u give the structure of the XML that has the city and state combination.

Are u parsing the XML using javascript or PHP?

[dkyadav80]

Can u give the structure of the XML that has the city and state combination.

Are u parsing the XML using javascript or PHP?

Yes sir, I'm giving below in detail:
-> I'm parsing through PHP

I 'm displaying the cities values in drop-down menu box from cities.xml file for city: field, through smarty and php code , on html form and I have next field is State which is also drop-down menu list box. I want when i select city name from city drop-down then state name of this city will become automatic in state drop-down menu box. currently i'm using saparate xml file for city and state. both xml file are below:

file: cities.xml

: goes here
<cities>
<city><![CDATA[Abohar]]></city>
<city><![CDATA[Abu Road]]></city>
<city><![CDATA[Adilabad]]></city>
<city><![CDATA[Ariyalur]]></city>
<city><![CDATA[Agartala]]></city>
<city><![CDATA[Agra]]></city>
<city><![CDATA[Ahmedabad]]></city>
<city><![CDATA[Ahmednagar]]></city>
<city><![CDATA[Aizwal]]></city>
<city><![CDATA[Ajmer]]></city>
<city><![CDATA[Ajjampura]]></city>
<city><![CDATA[Akola]]></city>
<city><![CDATA[Aligarh]]></city>
</cities>

[: code goes here for cities]

function getCities() {
$filename = "cities.xml";
if (file_exists($filename)) {
$cities_obj = simplexml_load_file($filename);
$cities = $cities_obj->xpath('/cities/city');
return $cities;
} else {
echo "File does not exist";
}
}
$cities = getCities();
$main_smarty->assign("cities", $cities);

file: states.xml

: goes here
 
<states>
<state><![CDATA[Andaman and Nicobar Islands]]></state>
<state><![CDATA[Andhra Pradesh]]></state>
<state><![CDATA[Arunachal Pradesh]]></state>
<state><![CDATA[Assam]]></state>
<state><![CDATA[Bihar]]></state>
<state><![CDATA[Chandigarh]]></state>
<state><![CDATA[Chhattisgarh]]></state>
<state><![CDATA[Dadra and Nagar Haveli]]></state>
<state><![CDATA[Daman and Diu]]></state>
<state><![CDATA[Delhi]]></state>
<state><![CDATA[Goa]]></state>
<state><![CDATA[Gujarat]]></state>
<state><![CDATA[Haryana]]></state>
<state><![CDATA[Himachal Pradesh]]></state>
<state><![CDATA[Jammu and Kashmir]]></state>
<state><![CDATA[Jharkhand]]></state>
<state><![CDATA[Karnataka]]></state>
<state><![CDATA[Kerala]]></state>
</states>

Php:
[Code: ghes here]

function getStates(){
$filename="states.xml";
if (file_exists($filename)) {
$states_obj = simplexml_load_file($filename);
$states = $states_obj->xpath('/states/state');
return $states;
} else {
echo "File does not exist";
}
}
$states = getStates(); 
$main_smarty->assign("states", $states);

[and HTML CODE GOES HERE] : for city and state ;
[html]
<tr>
<td align="right"><label for="cons_indi_prof_city">City<span class="req">*</span></label></td>
<td align="left">
<select name="cons_indi_prof_city" id="cons_indi_prof_city" style="width:180px" onChange="display(this,'ot');">
<option value="Select" selected="selected">Select</option>
{html_options values=$cities output=$cities}
<option value="other">other</option>
</select></td>
<td align="left">
<input name="ocity" id="ot" type="text" style="display:none;width:170px" maxlength="50"/>
</td>
</tr>
<tr>
<td align="right"><label for="cons_indi_prof_state">State<span class="req">*</span></label></td>
<td align="left">
<select name="cons_indi_prof_state" id="cons_indi_prof_state" style="width:180px" onChange="display2(this,'oth');">
<option value="Select" selected="selected">Select</option>
{html_options values=$states output=$states}
<option value="other">other</option>
</select></td>
<td align="left">
<input name="ostate" id="oth" type="text" style="display:none;width:170px" maxlength="50" />
</td>
</tr>[/html]

//////////

All codes are working good , cities and states are displaying good in drow-down menu box. Proble is that if user select the city then particular state of that's city will should be display in state drop down menu box.
Pls solve my problem I'm sufffering from 2 weeks.

Thanks

[acoder]

dkyadav80, learn to use code tags properly. I'll show you how:
[CODE=javascript]var test = "test";[/code]

Replace "javascript" with something else for other languages. You can even omit the language, but at the very least use the code tags properly.

I've merged this thread with one you asked earlier since it relates to the same problem.