You need a dynamic dependent select box. We will explain how to create a dynamic dependent select box in PHP, jquery and ajax.
index.php
<?php
include_once 'dbconfig.php';
?>
<html>
<head>
<title>Dynamic Dependent Select Box using Ajax</title>
<script type="text/javascript" src="jquery-1.4.1.min.js"></script>
<script type="text/javascript">
$(document).ready(function()
{
$("#loding1").hide();
$("#loding2").hide();
$(".country").change(function()
{
$("#loding1").show();
var id=$(this).val();
var dataString = 'id='+ id;
$(".state").find('option').remove();
$(".city").find('option').remove();
$.ajax
({
type: "POST",
url: "get_state.php",
data: dataString,
cache: false,
success: function(html)
{
$("#loding1").hide();
$(".state").html(html);
}
});
});
$(".state").change(function()
{
$("#loding2").show();
var id=$(this).val();
var dataString = 'id='+ id;
$.ajax
({
type: "POST",
url: "get_city.php",
data: dataString,
cache: false,
success: function(html)
{
$("#loding2").hide();
$(".city").html(html);
}
});
});
});
</script>
<style>
label
{
font-weight:bold;
padding:10px;
}
div
{
margin-top:100px;
}
select
{
width:200px;
height:35px;
border:2px solid #456879;
border-radius:10px;
}
.color {
color:green;
}
.link {
color:red;
}
</style>
</head>
<body>
<h1 align="center" class="color"> Daynamic Dropdown in PHP &MySql Ajax And jQuery</h1>
<center>
<div>
<label>Country :</label>
<select name="country" class="country">
<option selected="selected">--Select Country--</option>
<?php
$stmt = $DB_con->prepare("SELECT * FROM country");
$stmt->execute();
while($row=$stmt->fetch(PDO::FETCH_ASSOC))
{
?>
<option value="<?php echo $row['country_id']; ?>"><?php echo $row['country_name']; ?></option>
<?php
}
?>
</select>
<br><br><br>
<label>State :</label>
<select name="state" class="state">
<option selected="selected">--Select State--</option>
</select>
<img src="ajax-loader.gif" id="loding1"></img>
<br><br><br>
<label>City :</label>
<select name="city" class="city">
<option selected="selected">--Select City--</option>
</select>
<img src="ajax-loader.gif" id="loding2"></img>
<br><br><br>
</div>
<br />
</center>
</body>
</html>
dbconfig.php
<?php
$DB_host = "localhost";
$DB_user = "root";
$DB_pass = "";
$DB_name = "database";
try
{
$DB_con = new PDO("mysql:host={$DB_host};dbname={$DB_name}",$DB_user,$DB_pass);
$DB_con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch(PDOException $e)
{
$e->getMessage();
}get_city.php
<?php
include('dbconfig.php');
if($_POST['id'])
{
$id=$_POST['id'];
$stmt = $DB_con->prepare("SELECT * FROM city WHERE state_id=:id");
$stmt->execute(array(':id' => $id));
?><option selected="selected">Select City :</option>
<?php while($row=$stmt->fetch(PDO::FETCH_ASSOC))
{
?>
<option value="<?php echo $row['city_id']; ?>"><?php echo $row['city_name']; ?></option>
<?php
}
}
?>get_state.php
<?php
include('dbconfig.php');
if($_POST['id'])
{
$id=$_POST['id'];
$stmt = $DB_con->prepare("SELECT * FROM state WHERE country_id=:id");
$stmt->execute(array(':id' => $id));
?><option selected="selected">Select State :</option><?php
while($row=$stmt->fetch(PDO::FETCH_ASSOC))
{
?>
<option value="<?php echo $row['state_id']; ?>"><?php echo $row['state_name']; ?></option>
<?php
}
}
?>
Check on FacebookComments are closed.
Terrific post but I was wanting to know if you could write a
litte more on this topic? I’d be very grateful if you could elaborate a little
bit further. Bless you!
Hi,
You can check the captcha plugin from here
Hello everybody, here every one is sharing these kinds of know-how,
therefore it’s pleasant to read this webpage, and I used to pay a quick
visit this web site daily. https://npseniorliving.com/communities/howard/
continuously i used to read smaller articles or reviews
that also clear their motive, and that is also happening with this article which I am
reading at this time.
Can you tell us more about this? I’d want to find out more details.
Hello There. I found your blog using msn. This is a really well written article.
I’ll make sure to bookmark it and return to read more of your useful info.
Thanks for the post. I will certainly return.
There is definately a lot to find out about this topic.
I really like all the points you’ve made.
The other day, while I was at work, my cousin stole my iphone and tested to see if it
can survive a twenty five foot drop, just so she can be a youtube sensation. My apple ipad
is now broken and she has 83 views. I know this is completely off topic but I had to share it with someone!
Piece of writing writing is also a excitement, if you be acquainted with after that you can write if not it is difficult to write.
My partner and I stumbled over here different page and thought
I might as well check things out. I like what I see so
now i’m following you. Look forward to exploring your
web page repeatedly.
Had no idea there was more money in the safe
Thank you for sharing your thoughts. I really appreciate your efforts and I will be waiting for your next write ups thank you once again.
Massage therapy promotes tissue regeneration and is also a terrific way to
cure acne, or even acne scars as well. When you visit a spa, the decisions about how you will spend your time
and energy are often left for you but you could be wise to
make a choice of these packages that incorporate numerous
services from facials to mineral baths. Again, this process
isn’t for anyone but should you prefer to wash your own personal sheets, this is the way
you can keep them who is fit for a time.
Its like you learn my thoughts! You appear to grasp so
much approximately this, such as you wrote the guide in it or something.
I feel that you can do with a few p.c. to drive the message house a little
bit, but other than that, this is great blog. A great read.
I’ll definitely be back.
Touche. Sound arguments. Keep up the good spirit.
Thank you for the auspicious writeup. It in fact was a amusement account it.
Look advanced to far added agreeable from you! By the way, how can we communicate?
Undeniably believe that which you stated. Your favorite justification appeared to be on the internet the easiest thing to be aware of.
I say to you, I certainly get irked while people think about worries that they just don’t know about.
You managed to hit the nail upon the top and defined out
the whole thing without having side-effects ,
people can take a signal. Will probably be back to get more.
Thanks
Yes! Finally someone writes about
hu, You can use the Yoast SEO Plugin You can Download from here
I know this if off topic but I’m looking into starting my own weblog
and was wondering what all is needed to get set up?
I’m assuming having a blog like yours would cost a pretty penny?
I’m not very web savvy so I’m not 100% positive. Any
recommendations or advice would be greatly
appreciated. Many thanks
Hurrah! In the end I got a weblog from where I be able to genuinely obtain useful
data regarding my study and knowledge.
Here is my blog post: https://tuolumnecountyprofile.org
Hi there, everything is going well here and ofcourse every one is sharing information,
that’s actually fine, keep up writing.
This is a topi which is coose to my heart… Take care! Exactly where are your
contact details though?
my site :: perfect beauty anti wrinkle eye cream
I always emailed this weblog post page to all my contacts, since if like to read it next my contacts will too.
Inspiring story there. What happened after? Good luck!
Paragraph writing is also a excitement, if you be acquainted with after that you can write or else it is complex to write.
Hello there, just became aware of your blog through Google, and
found that it’s truly informative. I’m going
to watch out for brussels. I’ll be grateful if you continue this in future.
Many people will be benefited from your writing.
Cheers!
Howdy very nice blog!! Guy .. Excellent .. Wonderful .. I will bookmark your site
and take the feeds additionally? I am satisfied to find numerous useful info right here in the put up, we’d like work out extra strategies on this regard, thank you
for sharing. . . . . .
It’s perfect time to make some plans for the
future and it is time to be happy. I’ve read this post and if I could I wish to suggest you few interesting things or advice.
Perhaps you can write next articles referring to this
article. I desire to read even more things about it!
I am sure this article has touched all the internet people,
its really really nice post on building up new weblog.
Howdy just wanted to give you a quick heads up. The text in your article seem to be running off the screen in Safari.
I’m not sure if this is a formatting issue or something to do with internet browser compatibility but I thought I’d post
to let you know. The layout look great though! Hope you get the
problem fixed soon. Cheers
It’s a shame you don’t have a donate button! I’d definitely
donate to this brilliant blog! I guess for
now i’ll settle for book-marking and adding your RSS feed to my Google account.
I look forward to new updates and will share this site with my Facebook group.
Chat soon!
Hi Agen, you can use WordPress. Its good CMS for Blogging.
Attractive element of content. I just stumbled upon your blog and in accession capital to claim that I get actually loved account your weblog posts.
Any way I’ll be subscribing for your feeds or even I fulfillment you get right of entry to constantly quickly.