Thanking you for your constant help, may God bless us. Please, i want my form to auto generate local government if a state is selected. For example, if lagos state is selected, i want my form to list all the local government in lagos state. Please help.

first crate a table and polulate with state names.now create tables of each state local government while the state name is used as the foreign key for respective local government table .you will understand better if you understad how to create a relational database.
not confortable here cos am typing from my phone

I am facing same issue, hope suneepet1 solution will solve it

You need basic knowledge of Ajax.

talk2hb1: You need basic knowledge of Ajax.

i have basic knowledge of it. What should i do?

For every soul that is bailing me out of this problem, problems and difficulties will be far from your household. Please help.

U ve to create a table in ur database with all the states. Each state must have a unique key. Create a table for local govt and link each local govt with the unique key of its state.
U are going to use ajax and php to complete this task. It is necessary you have a knowledge of jquery also. Am using my phone to comment so its not really easy to comment well.
U will need 2 files. The php file where the change will be made on the select button and a php file where u will query db for local govt. It will be beta if u load the states from database straight and include the state uniqueu need to write a jquery function to perform an ajax anytime an action is performed to load d local govts (eg when a user changes d select button). u can now send the state to the php file as post or get to the php file to query the database for lga with the state. On completion echo the display way u want it to work.

Please i am using my mobile now and cant type well but once i get to my system i will upload codes on how it works. Sorry for poor write up and incomplete explanation. In lagos traffic......

Pls is javascript or java applet is good choice for the task?

What you need is javascript or jquery

Hw abt CSS?

U dont need css to achieve this result. CSS is for design.

First thing your table structure should be

State Table
CREATE TABLE State
(
name VARCHAR(30) PRIMARY KEY
);

CREATE TABLE LGA
(
LGAName VARCHAR(30),
state VARCHAR(30) REFERENCES State (name)
)

I expect you to know how to interact with database using php(Load or Query data).

You need Ajax just because you don't want your page to refresh but i will advice you get the logic of how to implement your problem.

1) Create form that have <select> or drop down list for state and local govt.
2) Populate the state dropdown list with what you have in your database (Let me know if you have no idea how to query database and populate in dropdown list)

3) Without Ajax, you can use onchange of the state drop down list to populate Local govt by getting the selected item. (Without Ajax ur page will refresh but your problem will be solve.) The base practice is to use Ajax (though it's socially constructed) because most sites still use traditional method that refresh the entire page.


Let us know if you are a newbie in php meaning that you can't query database table and populate a combo or dropdown box for more assistance.

Nekon J: First thing your table structure should be

State Table
CREATE TABLE State
(
name VARCHAR(30) PRIMARY KEY
);

CREATE TABLE LGA
(
LGAName VARCHAR(30),
state VARCHAR(30) REFERENCES State (name)
)

I expect you to know how to interact with database using php(Load or Query data).

You need Ajax just because you don't want your page to refresh but i will advice you get the logic of how to implement your problem.

1) Create form that have <select> or drop down list for state and local govt.
2) Populate the state dropdown list with what you have in your database (Let me know if you have no idea how to query database and populate in dropdown list)

3) Without Ajax, you can use onchange of the state drop down list to populate Local govt by getting the selected item. (Without Ajax ur page will refresh but your problem will be solve.) The base practice is to use Ajax (though it's socially constructed) because most sites still use traditional method that refresh the entire page.


Let us know if you are a newbie in php meaning that you can't query database table and populate a combo or dropdown box for more assistance.

Lemme just continue from here. This should be on the page you want to display the states and lga
Your jquery should look like this

<script>
$(document).ready(function() {
	$('#state').change(function(){
		var state= $(this).val();
		$("#lga".load("ajax.php",{state:state, ajax: 'true'});
	});
});
</script>

Am assuming you are using select <select></select>
This is how your select should look like

<select name="state" id="state">
{list of all states here is an example <option value="Lagos">Lagos</option> }
</select>

//leave the lga empty
<select name="lga" id="lga">
</select>

On the ajax.php file you should have this:

if(isset($_POST['state'])){
		//am assuming you have a function which connects with the db to get the lgas for a random state
                $lgas = get_lgas_from_state($_POST['state']);
                $options = "";
                     if($lgas){
		          for($i = 0; $i< count($lgas); $i++){
			        $options .="<option value='".$lga[$i]."'>".$lga[$i]."</option>";
		          }
                      }
                //if you want to have others in the option. Include the below code else skip
		$options .="<option value='Others'>Others</option>";
		echo $options;	
}

This will change the LGA on the page anytime there is a change on the states.

I hope i have been able to explain myself well. Find attached a list of the countries in the world, states and LGAs in Nigeria. (I hope it attaches)

Nekon J: First thing your table structure should be

State Table
CREATE TABLE State
(
name VARCHAR(30) PRIMARY KEY
);

CREATE TABLE LGA
(
LGAName VARCHAR(30),
state VARCHAR(30) REFERENCES State (name)
)

I expect you to know how to interact with database using php(Load or Query data).

You need Ajax just because you don't want your page to refresh but i will advice you get the logic of how to implement your problem.

1) Create form that have <select> or drop down list for state and local govt.
2) Populate the state dropdown list with what you have in your database (Let me know if you have no idea how to query database and populate in dropdown list)

3) Without Ajax, you can use onchange of the state drop down list to populate Local govt by getting the selected item. (Without Ajax ur page will refresh but your problem will be solve.) The base practice is to use Ajax (though it's socially constructed) because most sites still use traditional method that refresh the entire page.


Let us know if you are a newbie in php meaning that you can't query database table and populate a combo or dropdown box for more assistance.

great having you. I query db but combo box, list and drop down often give me issue.

robzyone:

Lemme just continue from here. This should be on the page you want to display the states and lga
Your jquery should look like this

<script>
$(document).ready(function() {
	$('#state').change(function(){
		var state= $(this).val();
		$("#lga".load("ajax.php",{state:state, ajax: 'true'});
	});
});
</script>

Am assuming you are using select <select></select>
This is how your select should look like

<select name="state" id="state">
{list of all states here is an example <option value="Lagos">Lagos</option> }
</select>

//leave the lga empty
<select name="lga" id="lga">
</select>

On the ajax.php file you should have this:

if(isset($_POST['state'])){
		//am assuming you have a function which connects with the db to get the lgas for a random state
                $lgas = get_lgas_from_state($_POST['state']);
                $options = "";
                     if($lgas){
		          for($i = 0; $i< count($lgas); $i++){
			        $options .="<option value='$lga->LGA'>".$lga->LGA."</option>";
		          }
                      }
                //if you want to have others in the option. Include the below code else skip
		$options .="<option value='Others'>Others</option>";
		echo $options;	
}

This will change the LGA on the page anytime there is a change on the states.

I hope i have been able to explain myself well. Find attached a list of the countries in the world, states and LGAs in Nigeria. (I hope it attaches)

i will be wright back, let me put it in practice. Please don't mind my ignorance

robzyone:

Lemme just continue from here. This should be on the page you want to display the states and lga
Your jquery should look like this

<script>
$(document).ready(function() {
	$('#state').change(function(){
		var state= $(this).val();
		$("#lga".load("ajax.php",{state:state, ajax: 'true'});
	});
});
</script>

Am assuming you are using select <select></select>
This is how your select should look like

<select name="state" id="state">
{list of all states here is an example <option value="Lagos">Lagos</option> }
</select>

//leave the lga empty
<select name="lga" id="lga">
</select>

On the ajax.php file you should have this:

if(isset($_POST['state'])){
		//am assuming you have a function which connects with the db to get the lgas for a random state
                $lgas = get_lgas_from_state($_POST['state']);
                $options = "";
                     if($lgas){
		          for($i = 0; $i< count($lgas); $i++){
			        $options .="<option value='$lga->LGA'>".$lga->LGA."</option>";
		          }
                      }
                //if you want to have others in the option. Include the below code else skip
		$options .="<option value='Others'>Others</option>";
		echo $options;	
}

This will change the LGA on the page anytime there is a change on the states.

I hope i have been able to explain myself well. Find attached a list of the countries in the world, states and LGAs in Nigeria. (I hope it attaches)

i will be wright back, let me put it in practice. Please don't mind my ignorance

robzyone:

Lemme just continue from here. This should be on the page you want to display the states and lga
Your jquery should look like this

<script>
$(document).ready(function() {
	$('#state').change(function(){
		var state= $(this).val();
		$("#lga".load("ajax.php",{state:state, ajax: 'true'});
	});
});
</script>

Am assuming you are using select <select></select>
This is how your select should look like

<select name="state" id="state">
{list of all states here is an example <option value="Lagos">Lagos</option> }
</select>

//leave the lga empty
<select name="lga" id="lga">
</select>

On the ajax.php file you should have this:

if(isset($_POST['state'])){
		//am assuming you have a function which connects with the db to get the lgas for a random state
                $lgas = get_lgas_from_state($_POST['state']);
                $options = "";
                     if($lgas){
		          for($i = 0; $i< count($lgas); $i++){
			        $options .="<option value='$lga->LGA'>".$lga->LGA."</option>";
		          }
                      }
                //if you want to have others in the option. Include the below code else skip
		$options .="<option value='Others'>Others</option>";
		echo $options;	
}

This will change the LGA on the page anytime there is a change on the states.

I hope i have been able to explain myself well. Find attached a list of the countries in the world, states and LGAs in Nigeria. (I hope it attaches)

i will be wright back, let me put it in practice. Please don't mind my ignorance

robzyone:

Lemme just continue from here. This should be on the page you want to display the states and lga
Your jquery should look like this

<script>
$(document).ready(function() {
	$('#state').change(function(){
		var state= $(this).val();
		$("#lga".load("ajax.php",{state:state, ajax: 'true'});
	});
});
</script>

Am assuming you are using select <select></select>
This is how your select should look like

<select name="state" id="state">
{list of all states here is an example <option value="Lagos">Lagos</option> }
</select>

//leave the lga empty
<select name="lga" id="lga">
</select>

On the ajax.php file you should have this:

if(isset($_POST['state'])){
		//am assuming you have a function which connects with the db to get the lgas for a random state
                $lgas = get_lgas_from_state($_POST['state']);
                $options = "";
                     if($lgas){
		          for($i = 0; $i< count($lgas); $i++){
			        $options .="<option value='$lga->LGA'>".$lga->LGA."</option>";
		          }
                      }
                //if you want to have others in the option. Include the below code else skip
		$options .="<option value='Others'>Others</option>";
		echo $options;	
}

This will change the LGA on the page anytime there is a change on the states.

I hope i have been able to explain myself well. Find attached a list of the countries in the world, states and LGAs in Nigeria. (I hope it attaches)

i will be wright back, let me put it in practice. Please don't mind my ignorance

@ op, I think you need to go and sleep and come back some other time. You are quoting and posting the same words for more than three times. lol .
Back to my own parole, I think i need to be spoon fed, lol. I am totally lost.
@robzyone and Nekon J, please use Lagos State (Ikeja & Ikoyi for LG) and Ogun State (Otta & Abeokuta for LG) in place of State. I am a slow learner that need practical examples.

Back to bed and check back during the day

ire4me: @ op, I think you need to go and sleep and come back some other time. You are quoting and posting the same words for more than three times. lol .
Back to my own parole, I think i need to be spoon fed, lol. I am totally lost.
@robzyone and Nekon J, please use Lagos State (Ikeja & Ikoyi for LG) and Ogun State (Otta & Abeokuta for LG) in place of State. I am a slow learner that need practical examples.

you are on your own

read this ajax tutorial

http://www.quackit.com/ajax/tutorial/

You keep spoon feeding him code, without asking him what he has done?
What are the challenges is facing and how do you be of help?
Knowing is half the battle
@OP what have you done?
What are the challenges you are encountering and how do we be of help?

robzyone:

Lemme just continue from here. This should be on the page you want to display the states and lga
Your jquery should look like this

<script>
$(document).ready(function() {
	$('#state').change(function(){
		var state= $(this).val();
		$("#lga".load("ajax.php",{state:state, ajax: 'true'});
	});
});
</script>

Am assuming you are using select <select></select>
This is how your select should look like

<select name="state" id="state">
{list of all states here is an example <option value="Lagos">Lagos</option> }
</select>

//leave the lga empty
<select name="lga" id="lga">
</select>

On the ajax.php file you should have this:

if(isset($_POST['state'])){
		//am assuming you have a function which connects with the db to get the lgas for a random state
                $lgas = get_lgas_from_state($_POST['state']);
                $options = "";
                     if($lgas){
		          for($i = 0; $i< count($lgas); $i++){
			        $options .="<option value='".$lga[$i]."'>".$lga[$i]."</option>";
		          }
                      }
                //if you want to have others in the option. Include the below code else skip
		$options .="<option value='Others'>Others</option>";
		echo $options;	
}

This will change the LGA on the page anytime there is a change on the states.

I hope i have been able to explain myself well. Find attached a list of the countries in the world, states and LGAs in Nigeria. (I hope it attaches)

Delegation is the best for your change event. So based on your code it will be
$("#mainbodydiv').on("change", "#stateselect" function(e) {
e.preventDefault();
Rest of the code

});

This is also good if you are dynamically adding the state select form to your mainbodydiv on the page.

oluagness: i have basic knowledge of it. What should i do?

Basic knowledge of what!!!! @op like me, u are still a learner Oooo!!!. There is no such thing as auto generate in programming, u have to type all d states and local govt in it, unless u download them and paste them in your code, do u even know what a programming language is!!!

Well, I'm still a learner what do I know