Thursday, July 19, 2007

Ajax Triple Dropdown with States Cities Database

Ajax Dropdown Menu it's make easy for user to use interface. When you choose first dropdown menu data in second dropdown will be filter and data related in first dropdown will be show automatic

For This Example Code is PHP and Database is MySQL

Example : Stated and Cities

1. Create Dropdown Menu (state_dropdown.php)


<?
echo "<form name=sel>\n";
echo "States : <font id=states><select>\n";
echo "<option value='0'>============</option> \n" ;
echo "</select></font>\n";

echo "Cities : <font id=cities><select>\n";
echo "<option value='0'>=== none ===</option> \n" ;
echo "</select></font>\n";
?>

<script language=Javascript>
function Inint_AJAX() {
try { return new ActiveXObject("Msxml2.XMLHTTP"); } catch(e) {} //IE
try { return new ActiveXObject("Microsoft.XMLHTTP"); } catch(e) {} //IE
try { return new XMLHttpRequest(); } catch(e) {} //Native Javascript
alert("XMLHttpRequest not supported");
return null;
};

function dochange(src, val) {
var req = Inint_AJAX();
req.onreadystatechange = function () {
if (req.readyState==4) {
if (req.status==200) {
document.getElementById(src).innerHTML=req.responseText; //retuen value
}
}
};
req.open("GET", "state.php?data="+src+"&val="+val); //make connection
req.setRequestHeader("Content-Type", "application/x-www-form-urlencoded;charset=iso-8859-1"); // set Header
req.send(null); //send value
}

window.onLoad=dochange('states', -1); // value in first dropdown
</script>



2. Select States and Cities to Show in Dropdown (state.php)


<?
//set IE read from page only not read from cache
header ("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header ("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header ("Cache-Control: no-cache, must-revalidate");
header ("Pragma: no-cache");

header("content-type: application/x-javascript; charset=tis-620");

$data=$_GET['data'];
$val=$_GET['val'];

//set database
$dbhost = "localhost";
$dbuser = "";
$dbpass = "";
$dbname = "test";
mysql_pconnect($dbhost,$dbuser,$dbpass) or die ("Unable to connect to MySQL server");

if ($data=='states') { // first dropdown
echo "<select name='states' onChange=\"dochange('cities', this.value)\">\n";
echo "<option value='0'>==== choose state ====</option>\n";
$result=mysql_db_query($dbname,"select `id`, `state` from states order by `state`");
while(list($id, $name)=mysql_fetch_array($result)){
echo "<option value=\"$id\" >$name</option> \n" ;
}
} else if ($data=='cities') { // second dropdown
echo "<select name='cities' >\n";
echo "<option value='0'>====choose cities ====</option>\n";
$result=mysql_db_query($dbname,"SELECT `id`, `city` FROM cities WHERE `state_id` = '$val' ORDER BY `city` ");
while(list($id, $name)=mysql_fetch_array($result)){
echo "<option value=\"$id\" >$name</option> \n" ;
}
}
echo "</select>\n";
?>




See Example : States and Cities DropDown
Download Source code : ajax_dropdown.rar
mirror : ajax_dropdown.rar

( Please don’t directly link to the file… thank you )

Example 2 : This is Triple Ajax Dropdown Menu - Province - Ampher - Tumbon in Thailand

1. Create Dropdown Menu (locale_dropdown.php)

<? echo "<form name=sel>\n"; echo "จังหวัด : <font id=province><select>\n"; echo "<option value='0'>============</option> \n" ; echo "</select></font>\n";
echo "อำเภอ : <font id=amper><select>\n"; echo "<option value='0'>==== ไม่มี ====</option> \n" ; echo "</select></font>\n"; echo "ตำบล : <font id=tumbon><select>\n"; echo "<option value='0'>==== ไม่มี ====</option> \n" ; echo "</select></font>\n"; ?>

<script language=Javascript>
function Inint_AJAX() {
try { return new ActiveXObject("Msxml2.XMLHTTP"); } catch(e) {} //IE
try { return new ActiveXObject("Microsoft.XMLHTTP"); } catch(e) {} //IE
try { return new XMLHttpRequest(); } catch(e) {} //Native Javascript
alert("XMLHttpRequest not supported");
return null;
};

function dochange(src, val) {
var req = Inint_AJAX();
req.onreadystatechange = function () {
if (req.readyState==4) {
if (req.status==200) {
document.getElementById(src).innerHTML=req.responseText; //รับค่ากลับมา
}
}
};
req.open("GET", "locale.php?data="+src+"&val="+val); //สร้าง connection
req.setRequestHeader("Content-Type", "application/x-www-form-urlencoded;charset=tis-620"); // set Header
req.send(null); //ส่งค่า
}

window.onLoad=dochange('province', -1);
</script>


2. Select Province Ampher Tumbon to Show in Dropdown (locale.php)

<?
//กำหนดให้ IE อ่าน page นี้ทุกครั้ง ไม่ไปเอาจาก cache
header ("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header ("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header ("Cache-Control: no-cache, must-revalidate");
header ("Pragma: no-cache");

header("content-type: application/x-javascript; charset=tis-620");

$data=$_GET['data'];
$val=$_GET['val'];

//ค่ากำหนดของ ฐานข้อมูล
$dbhost = "localhost";
$dbuser = "";
$dbpass = "";
$dbname = "test";
mysql_pconnect($dbhost,$dbuser,$dbpass) or die ("Unable to connect to MySQL server");

if ($data=='province') {
echo "<select name='province' onChange=\"dochange('amper', this.value)\">\n";
echo "<option value='0'>==== เลือก สังกัด ====</option>\n";
$result=mysql_db_query($dbname,"select loc_code,loc_abbr from location where loc_name = location_name and loc_code != '000000' and flag_disaster is null order by loc_abbr");
while(list($id, $name)=mysql_fetch_array($result)){
echo "<option value=\"$id\" >$name</option> \n" ;
}
} else if ($data=='amper') {
echo "<select name='amper' onChange=\"dochange('tumbon', this.value)\">\n";
echo "<option value='0'>======== เลือก ========</option>\n";
$val2=$val;
$val = substr($val,0,2);
$result=mysql_db_query($dbname,"SELECT loc_code, loc_abbr FROM location WHERE loc_code != '000000' and loc_code != '$val2' AND loc_code LIKE '$val%' AND flag_disaster IS NULL ORDER BY loc_code, loc_abbr ");
while(list($id, $name)=mysql_fetch_array($result)){
echo "<option value=\"$id\" >$name</option> \n" ;
}
} else if ($data=='tumbon') {
echo "<select name='tumbon' >\n";
echo "<option value='0'>======== เลือก ========</option>\n";
$val2=$val;
$val = substr($val,0,4);
$result=mysql_db_query($dbname,"SELECT loc_code, loc_abbr, loc_name, location_name FROM location WHERE loc_code != '000000' and loc_code != '$val2' AND loc_code LIKE '$val%' AND flag_disaster IS NULL ORDER BY loc_code, loc_abbr");
while(list($id, $name)=mysql_fetch_array($result)){
echo "<option value=\"$id\" >$name</option> \n" ;
}
}
echo "</select>\n";
?>




Download Source code :
ajax_dropdown.rar
mirror : ajax_dropdown.rar

( Please don’t directly link to the file… thank you )

PS. In ajax-dropdown.rar file Include
for states and cities (america)
state.php
state_dropdown.php
state.sql (MySQL)

for province ampher tumon (thailand)
locale.php
locale_dropdown.php
location.sql
(MySQL)

185 comments:

Peter said...

พี่ครับ

Peter said...

พี่ครับ ช่วยอธิบายเป็น Step By Step เป็นไทยด้วยได้ไหมอ่าครับ

คือแบบ งงมากๆอ่าครับ

ขอบคุณครับ

m2fu said...

Hi, I like this script a lot, but I am having trouble with doing my own variation of a drop down box system.

Basically I'm making a simple tire search system. You search what tires would be compatible with your car by selecting three linked drop down boxes which populate from a mysql database.

Can anyone help me out ?

superkeng said...

m2fu : you can see example tree linked drop down at "2. Select Province Ampher Tumbon to Show in Dropdown"

first box is " if ($data=='province')"
second box is " else if ($data=='amper') "
and last box is "else if ($data=='tumbon') "

$val is value send to sql query box2 and box3

peter : อยากให้อธิบายตรงไหน ถามมาเลยครับ

m2fu said...

Hi superkeng Can I email you because I need to explain a lot...
I can't get my third drop down box to populate

superkeng said...

mail to superkeng at gmail.com ^__^

bloodymental said...

hi.. great code... i jus have one problem.. i can get all the 3 drops down menus to populate however when i submist a form with a POST action it does not capture the value in the drop down.... any ideas?

Sheriff26 said...

Hi. This ajax dropdown is amazing!!
but I have a little problem with.
I use a phplib a templating system and if i use GET " req.open("GET", "?page=state&data="+src+"&val="+val);"
it include in the td the whole page :(
and if I specify it like this: " req.open("GET", "/state.php&data="+src+"&val="+val);"
don't work.

Any idea ?
Thanks

kaew said...

ถ้าเราต้องการ แสดงข้อมูลจากฐานเพื่อทำการแก้ไข
และใช้ ajax จังหวัด อำเภอ ตำบล เวลาโยนค่าทำอย่างไรช่วยอธิบายให้หน่อยนะคะ ตาม เมล์คะขอบคุณมา
boy1999@hotmail.com

kmustafa said...
This comment has been removed by the author.
twin said...

สุดยอดมากเลยครับ เอาไปลองใช้แล้ว แต่เวลาเลือก อำเภอแล้วมีปัญหาครับ เพราะออกมาทั้งอำเภอและตำบล เมื่อเลือกจังหวัดหรือตำบลไม่มีปัญหาครับ ไม่รู้ว่าเป็นที่ ตารางหรือเปล่าครับ

อ้อ มี Email ไหมครับเพราะจะมีรายละเอียดที่จะเขียนถามยาวครับ (คือต้องอธิบายละเอียด)ครับ
ขอบคุณล่วงหน้า
inteltwin@gmail.com

Tooxic.com said...

Thank you for this... got it working in a few mins and was what I have been looking for for weeks.

matt said...

nice works, I will use that...

Phatrapol said...

รวมๆ แล้ว ก็ มาถูกทางแล้ว

อาจจะต้องแก้ไขอีกนิดหน่อย
ตรงส่วนโปรแกรม และส่วน database ที่ยังไม่สมบูรณ์ นัก

ตอนนี้ กำลังเรียงจังหวัดตามตัวอักษรอยู่
และ เพิ่มบางจังหวัดที่ตกหล่น
เช่น กระบี่ (ตอนนี้ กำลัง แก้ไขอยู่)

ยังไงก็ ขอบคุณ สำหรับ ตัวอย่างอันนี้

ก็ช่วยประหยัดเวลา ไม่ต้องทำเองไปเยอะมากเลย

ykpinar said...

Thanks for this. It is very useful but I having trouble also. I can not get the values when press submit button. I will be glad if anyone show the solution?

ykpinar said...
This comment has been removed by the author.
Jason said...

Great tutorial and script - only problem I am having is when viewing the dropdown lists in IE - they slide all the way to the top of the screen - any suggestions?

g-O-r--a-g-o-d said...

โค้ดเต็มๆต้นฉบับ ตอนนี้เป็นแบบสมบูรณ์แล้ว ที่ http://www.goragod.com

ITyleR said...
This comment has been removed by the author.
ITyleR said...

How is it possible to save selected the chosen value in a list (at the change of information of form)?

Wolverine said...

can you please explain how to implement this on blogger

glen said...

Tks for this. Been chasing around google for ages to find something that is simple and that works. Slick. Well done. Got it working with both dropdowns coming out of an Ingres database.

Heinz Wittenbecher said...

Thank you very much for this sampling of using dropdown with ajax. I've expanded it to 7, gathering information about a vehicle so that ultimately I can show a list of parts.

Where I'm a bit stuck is how to break out and go to a new page. I.e. I've collected all the info I need and now I want to go to a page where the resulting parts are displayed.

Thanks again and if anyone has some hints re breaking to a new page, thanks in advance.

jk said...

Hi,

This is a nice tutorial. But I have a problem.

When you select the category1 (firstdropdown) then the category2 list shows. But when you keep change in the category1 little faster for a while and stops, the sub category stops show the result and later it stops works totally. Why ajax gets stuck when this kind of events occurs?

Fes x said...

Hi,

Excellent script!

Can you show me how i can have the dropdowns pre loaded and options selected?

nikon said...

Thank you very much!
Great script!

Mike said...

Looks nice, but you can't download it. Anyone have it uploaded somewhere real people can download it? (I.E.: NOT those stupid, lame-assed, 'free' upload sites?)

omni said...

Hi, great script, but I'm trying to create a page where both dropdowns are defaulted on page loading from a mysql database.
Any hints on how to do this would be great. I can get the values from the database, just can't get the dropdowns to take on these values when page loads.

balicenter said...

Waw. its cool thank for sharing, and keep posting

regard'

Bali Villas

akos said...

Nice tutorial!

Pêle-Mêle said...

Hi Superkeng this is great. But I am having trouble understanding the difference between the first and second script...

Pêle-Mêle said...

I mean, do I have to use both codes ? or does one replace the other? the reason I an saying this is that when I run the first code, I get two drop downs and when I run the second one, I get another drop down.

akos said...

Hi!As you see, the first code creates two dropdown list, the second section dropdown will changes depending from the first list.(See the images.
----------------)
The second dropdons creates 3 dropdown lists. But the 2 codes in my opinion is a bit different. Hello,
akos

Pêle-Mêle said...

Akos, sounds like in the first code, there is no use of mysql database...am I correct?
I have a database that has state and city, I want the user to first select a state and then the list of corresponding cities will show up in the second drop down. which code am I suppose to use?

akos said...

on the dropdown image you will see:
mirror : ajax_dropdown.rar

You will find state_dropdown.php the Javascript(inside), and the original empty dropdowns.

But in state.php you have to change the database connection, that will make the changing dropdowns...

Run state.sql in phpmyadmin (run the SQL command.)

Hello!

paulo said...

hi, this doesnt work with me, it only appears this:

"; echo ""; $result=mysql_db_query($dbname,"select loc_code,loc_abbr from location where loc_name = location_name and loc_code != '000000' and flag_disaster is null order by loc_abbr"); while(list($id, $name)=mysql_fetch_array($result)){ echo "$name \n" ; } } else if ($data=='amper') { echo "

akos said...

This coderesult might comes if your server doesn't allow the short open php tags.

how to solve it? replace all < ? into < ? php

hello, jjozsi.

paulo said...

yes i have found some minutes ago, i was just reply when you reply. one stuff how the triple example database works? i know that the 2 dropdown works with 2 table, the triple example is working with one table and since he doesnt appear the data because its in Thai i cannot figured it out. Can you explain it please? Best Regards

akos said...

I did not tried the triple dropdown yet :) Becouse i modified it to pupolate a textarea using two dropdown list, for a project/table/ --> fieldnames lister.

I would help to comment the triple dropdown, but not today.

paulo said...

i found one problem. Its not working on Internet Explorer, do you know why? its working just fine on firefox.

the IE give this error: "document.getElementById(...) is null and its not an object"

regards

akos said...

i use this code snippet on Opera, Firefox, Internet explorer. go to http://www.phpbuilder.com/board/ and post that problem. i'm a member of that forum with lots of experts. They can help to you. i can only suggest this. Hello, akos

george said...

something similar for those AJAX inclined

http://imagecowboy.com/articles/create_ajax_menu_asp_part1.asp

phpcode.hu said...

Hy all :) i've chenged a little this code, to update database tables:

you can generate it here:
http://phpcode.hu/ajax_updater/

Brian said...

Hi,

The code works great! It's the 3rd script I try and it finally works.

I have 2 drop downs (country and region) and a button that when pressed is suppose to add a marker on my google map centered to the region. It worked before but now it does nothing.

I call this with my button: onClick="showAddress();"

And this is my function:

function showAddress() {
var countryID = document.getElementById("countries");
var country = countryID.options[countryID.selectedIndex].text;

......... (the rest of the code that creates the marker on the map)
}

When I use this in the function
alert(countryID);

I get this: [object HTMLFontElement]


What can use to access the region and country from the drop downs?

Thanks,
Brian

phpcode.hu said...

Hello there, i've made an ajax generator for table update, but now you can design sub dropdowns and textfields. Test it here:
http://phpcode.hu/teszt/ajax/

Video tutorial:
http://www.youtube.com/watch?v=h7AMMb4bVgY

Demo is here:
http://phpcode.hu/teszt/ajax/ajax_teszt_update.php

kit said...

May i know to predefine the state and city as selected? Example, when register user using your script is work fine. But when want to update account, i need to retrieve the stored value and set the state & city as selected. How do i do this? Please help. Thanks.

kit said...
This comment has been removed by the author.
phpcode.hu said...

if you're using php, you can change the clint side output to re-call the dropdowns with the selected state and city numbers.

http://phpcode.hu/one_click_repo/?h=331bd2a1_99

kit said...

Thanks for quick reply. But the code not work for me and i've figure it out. Below is my code:

function dochange(src, val, selected) {
.
.
req.open("GET", "state.php?data="+src+"&val="+val+"&selected="+selected);
.
}

dochange('State', state_value, 0);
dochange('Area', state_value, area_value);

dochange should pass in state_value instead of area_value and need to pass selected value to php then only can set the selected area. :) Thank you.

phpcode.hu said...

Yes, the two values needed to embed into the javascript calls. In the original code body.onload reload the first dropdown with a value: -1

this is what you can make if you want to reload all the dropdowns.

disa said...

Hello all. This ajax dropdown will be very usefull for me,
but I have a little problem with it.
If I use GET "req.open("GET", "?act=state&data="+src+"&val="+val);"
it include in my table cell the whole page,
and if I specify it like this: " req.open("GET", "?act=some_page&state.php&data="+src+"&val="+val);"
don't work.

inetsolution said...

Its highly informative. I would be visiting your blog hereafter regularly to gather valuable information.



professional logo designer india

Chris said...

You need to update that poller, the best php editor is not on the list! Since the debuggers are all bad anyway, just use a good text editor that has nice printing and indenting and color coding: ie USE KATE! (comes with Ubuntu and is available free for most/all Linux distro's..)

AbdulBasit said...

nice work

http://www.abdulbasitnawab.com

AbdulBasit said...

nice work

http://www.abdulbasitnawab.com

pbsl said...

thanks for sharing this site. there are various kinds of ebooks available from here

http://feboook.blogspot.com

anshul said...

I used the above state.php and state_dropdown.php ..... It is only displayin a dropdoen menu but no states and cities are coming in it....

phpcode.hu said...

Then try to set up the server side script correctly first. The mysql connection, the tables created ,ect.

Anti NBK Babu said...

alert("Testing");

kristinawils said...

Great post and very well written, that will really help you to learn Web Design, web development and SEO Strategies to help businesses web design company . You can find out many useful information about web design, seo and his work by visiting his blog and I Just wanna say thanks you for the information you have shared. Web Design Company India

marry said...

Blogs are so informative where we get lots of information on any topic. Nice job keep it up!!
_____________________________

Teaching Dissertation

Jase said...

Anyone have an up to date version of this?

Cheers

phpcode.hu said...

@Jase : What do you mean by: "up to date"?

If you need you can change the code to prevent MYSQL injection. Or search a newest database from countries.

phpcode.hu said...

I've made a JQUERY select generator for two or three dropdowns.
Here

Jase said...

php.hu

I just mean i find this hard to understand, im trying to impliment this myself and im having no luck. I was wondering if there was a tutorial for this instead of just source code.

It would be great if you could email me actually if you are quite good with this.

phpcode.hu said...

i can make a video how to install it, but you have to decide which dropdown you need.

It takes time to 'insetall' the SQL tables, maybe you have trouble around that?

quickheed said...

oh.. nice article. I had learned something interesting with your post. thanks a lot. keep on updating.
seo tutorial

Golden Sparrow said...

Great coding..seen others but this was the easiest to work with..took me a while to get it to work but main issues where connection to database stuff not the coding....

The only problem I have is that the third dropdown doesn't change when the first drop has changed. Anyone have any suggestions?

phpcode.hu said...

The third dropdown and the first aren't in connection. Just the first to the second, and the second to the third. You need to pass the value based on its value.

Golden Sparrow said...

Gee that was a quick reply. Thanks.

Dissertation Writing service said...

This kind of information is very limited on internet. Nice to find the post related to my searching criteria. Your updated and informative post will be appreciated by blog loving people.

Project Management Dissertation

web said...

Thanks for sharing the great information.



web Design Company

Chris said...

How can I make the third dropdown change when the first drop has changed.

pls give me some code.

nice works!

Golden Sparrow said...

Hi Chris

How I did it was to create 3 functions. One like the one here, one that resets the third dropdown and one that is like the one here and also calls the third dropdown reset. Have a play and try and figure it out. Let us know if you've cracked it.

I'm sorry this is probably not the answer you want. Took me ages to figure it but have learnt from it.

Tamandani said...

I have a problem. My second dropdown values are returning empty values when sent for saving. what must be the problem

phpcode.hu said...

The second dropdown based on the first dropdown value, so you can troubleshoot if you save the passed value and save that into a file in PHP. I usually save the whole SQL query string i have when the dropdowns are changing, you can save into a file, and can test in PHPMYADMIN.
All the returning values in JS could displayed for test, use the alert function on the returning results.

sunny said...
This comment has been removed by the author.
Matt Robinson said...

Tum mai tueng, Tum gub chun dai

rajeev pal said...

it is a great post but when i use post method then the value is show the id not value pls help me if any solution for this problem on my mail id.

rajeev.kumar6663@gmail.com

phpcode.hu said...

Basically this script uses HTML codes when you call the JS functions. So in the PHP file you can modify the the field names which inserted into the < option value ="$id" > $value < /option >

برامج said...

oh my god finally i found some one who can understand what are he talking about ..you helped me so so much thanksفيس بوك

Web Developers Chennai said...

We are also one of the Leading Web Design Company in Chennai,our services are web design,web hosting,seo chennai,email marketing,website design,logo design,maintenance etc.please add my website to your blogger.it is very useful for us.

pandorasell said...

Silver pandora jewelry store comprises replacement atomic number 79 equally the metal by choice in that pandora jewelry website flavors manners. .925 alright superlative Ag Jewelry checks 92.5% complete silver pandora jewelry online and comprises assorted with extra debases to beef up them and abbreviate maculating pandora style jewelry coming through a hard-nosed alloy as pandora bracelet beads . The rise in metal prices, especially gold, have begun to alter pandora leather bracelet dashes. Designers are applying sterling pandora style bracelet a lot of today because of its gold pandora bracelet appeal and affordability. Designers care Jacques Louis pandora charm necklace David Yurman and those from pandora’s cause changed their focus and are making A-list assembles by .925 Fine Sterling pandora necklace charms Although Silver is affordable its price has quietly risen 300% inch the last 5 years and is astir across 50% pandora silver beads these class entirely. Many investment advisers* recommend a portion of your wealth be inward Ag and amber. Trend setters who comprised the first to begin wearing pandora necklace leather metal to match tatto last word and additional electric current styles as well do good along accepting pandora bracelet charms worth more than they paid for it.

arkuda2 said...

With the ULTRA Power led flashlight you will never remain in the dark

arkuda2 said...

Buying phentermine and taking it in combination with a special nutrition and diet and you will see how quickly you will lose weight

jasp-v-w said...

phpcode.hu,

you made this code to set the php variable:

function recall()
{
dochange('states',);
dochange('cities', );
}
window.onLoad=recall();

Could you tell me where to place it? Because as soon as i try to place it i lose my values in the 1st dropdown

thank you!

jasp-v-w said...

PS iam using the version with 2 dropboxes and i need the value of the second dropbox to be posted to the next page.

Thank you!

VÕ ĐÌNH said...

How to get values from selected dropdowns for insert into database ?

Jerald said...

Great thoughts you got there, believe I may possibly try just some of it throughout my daily life.


SEO Company Chennai

phpcode.hu said...

VÕ ĐÌNH said...

How to get values from selected dropdowns for insert into database ?

Add a form to the dropdowns, and post to a process.php file.
The code is right here:
http://phpcode.hu/one_click_repo/?h=89ce2810_135

phpcode.hu said...

Hello friends, you can find a code maker here with tutorial video:
http://phpcode.hu/teszt/ajax_helper/?lang=eng

With it you can easily generate unlimited linked listboxes.

h4ns said...

Thank you for another essential article. Where else could anyone get that kind of information in such a complete way of writing? I have a presentation incoming week, and I am on the lookout for such information.
UEFA Live Stream | Live Stream Today | Live Streaming Free TV Channels Online | Technology News | EPL Live Stream

phpcode.hu said...

What are your questions?

Anand said...

this is work very nice.this save my one day

Tory Burch Shoes said...

Dsquared I like to spend my free time by scaning various internet recourses. Today I came across your blog and I located it is as one of the best free resources available! Well done! Keep on this quality! · sfjoxiaujld Dsquared *

asdwe said...

A set of cool Carrera Sunglasses can completely transform any man's look and appearance. However, selecting the right pair of men's carrera sunglass is very important or even the efforts at looking stylish might backfire. For those who have questions such as obtaining excellent customer service in
carrera eyeglasses
, and whether you
carrera champion sunglasses
should choose expensive designer glasses or inexpensive discount carrera sunglasses regular ones, here is nmkgasdfwqwe some information that will be useful to you.

Jeanna said...

Could you explain the following two query strings?
$data=$_GET['data'];
$val=$_GET['val'];

I don't see where the data is stored or being pulled from for the 'data' and 'val'

Thanks!

jasp-v-w said...

it isnt, it stores it in the link so you can withdraw it from the url after the user selected and posted

Andrei Mincov said...
This comment has been removed by the author.
Andrei Mincov said...

When I was looking for a decent database of world cities for my web project, I tried using all of the free city databases out there. I even paid for a couple of them.

But none of them satisfied me. They either had too much useless information (like longitudes, administrative subdivisions for tiny countries, or thousands and thousands of entries for small countries) or too little.

This is why I decided to create my own database.

After that was done I decided to share the results of my work with the world.

I offer my database both in Excel and SQL formats. It has over 40,000 of U.S. cities and a total of over 70,000 cities. To me it is the perfect balance between completeness and usefulness.

If you are interested, visit http://worldcitiesdatabase.info and see if my database is right for you.

ครูวรวิทย์ ไชยวงศ์คต said...

ขอบคุณครับ สุดยอดจริงๆ

John Ortiz said...

The example at: http://superkeng.freehyperspace.com/state_dropdown.php does not work.

phpcode.hu said...

we are not wizards, so share the source code intead of a broken url, please. There are a couple of good programming forums to get help. phpbuilder.com 4 example.

Trọng said...

so share the source code intead of a broken url, please. There are a couple of good programming forums to get help. phpbuilder.com 4 example.
Sightline Payments Bally TechnologiesDeal or No Deal

Web Development | Software Development said...

Thanks for sharing the article.

Web Development India

Ragav said...

i get ur coding for drop down menu thank u

Stoker said...

nice tutorial, i have only one question. I would like to select multiple values in the first selectbox, and show from all those values the results in the second dropdown. Does someone know how i can do this??

many thanx in advance

nihaa said...

Nice drop down, just I'm going to add my project. thanks
-------
Unlimited Web Hosting

sunitha said...

I'm happy when reading through your site with up-to-date information! thanks alot and hope that you'll publish more site that are based on this website. joomla development | joomla developers

Kelly Jones said...

Perfect post. Here’s a tool that lets your build your online database without programming. There is no need to hand code PHP. Cut your development time by 90% http://www.caspio.com/

mumtaz said...

This is a good post and nice point of view..really interesting and amazing here.Thanks for this brilliant information.
web designing company

qinbincai123 said...

The afternoon grows light because at kirefg88 last,Abruptly a minutely shredded rain
Is falling, or it fell. For once again,Rain is something happening in the past.
Wholesale New Era Hats
Cheap 59fifty Hats
Cheap New Era Hats
New Era Snapback Hats
New Era Fitted Hats

Kenneth said...

You have given wonderful information. It was useful. I will bookmark this site.
Search Engine Marketing

Interesting facts said...

Thanks for sharing your info. I really appreciate your efforts and I will be waiting for your further write ups thanks once again.
html5 converter

SANDY said...

very useful post.................
THANK YOU SO MUCH.........

amhash said...

Thanks for sharing such a useful information. The information provided is very very niche. Custom Logo Designs, I was just surfing on internet and found your blog after reading this i realize that i should come here often.

sandeep said...

Thanks for code.. This code is in PHP but I am going to use in DNN Development. I hope it will work.

Nick Damron said...

That is some alarming and advantageous advice appropriate there. I cannot delay until the little humans go to beddy-bye so that I can apply and plan some of this being out.Thanks!
Advertisement

Nick Damron said...

"I absolutely acknowledge the affectionate of capacity you column here. Thanks for administration advice that is in fact helpful. Good day!"
Advertising agencies in pakistan

devindennis said...

I just adulation how you write. Reading your blog for me is like sitting down and accepting a chat with you. You consistently accomplish me smile and you accept a way with words. Just anticipation I'd acquaint you in case you didn't know. :-)
Advertising agency

Nick Damron said...

Brilliant blog posting. I begin your column actual interesting; I anticipate you are a ablaze writer. I added your blog to my bookmarks and will acknowledgment in the future...
Website designing

Nick Damron said...

"I accept been account your posts regularly. I charge to say that you are accomplishing a absurd job. Please accumulate up the abundant work."
Website development

Kunal Wani said...
This comment has been removed by the author.
Kunal Wani said...

hey i am appreciate your code its very good for developer. can u help how to download this code?

Website development bangalore said...

we had a lot of fun to browse through all the links although there which don't work anymore.
web design company

seo eds said...

Nice post,it is very use ful blog .We are one of the leading Web designers in Chennai.Our services are Website design , development , mobile apps development , internet marketing etc.

ashu12 said...

hello I got the following error while I opening the next file

Notice: Undefined index: data in C:\xampp\htdocs\series\index3.php on line
Notice: Undefined index: val in C:\xampp\htdocs\series\index3.php on line

pls help me...

ashu12 said...

hello I got the following error while I opening the next file

Notice: Undefined index: data in C:\xampp\htdocs\series\index3.php on line
Notice: Undefined index: val in C:\xampp\htdocs\series\index3.php on line

pls help me...

devindennis said...

Hi… that was great stuff.. I really like this subject. Could you tell me more … I would love to explore.
advertising agencies

devindennis said...

Actually have a very nice blog, I wish I could see everything you have all the time, I'm really entertained by your comments, and best wishes for your blog...
advertising agencies in islamabad

Nick Damron said...

Excellent read, I just passed this onto a colleague who was doing a little research on this topic.
advertising agencies in karachi

Nick Damron said...

Usually I do not post comments on blogs, but I would like to say that this blog really forced me to do so! Thanks, for a really nice read...
Best advertising agency in Pakistan

devindennis said...

Hi, acknowledge you for administration this abundant info. Was just browsing through the net in my appointment and happened aloft your blog. It is absolutely actual able-bodied accounting and abdicate absolute in answer with a actual simple language...
Cheap office furniture | Best office furniture

blaircraig said...

Hey, acceptable post! Here is nice vibram 5 feel administration with you, just enjoy! I affiance it will not let you down! So don't absence it!..
Customized office furniture

jena grey said...

This is a great blog, I like this content it is very great and enlightening, 70-487, 70-496, MB5-700, I am sure that this content will be very much useful for individuals. Please visit my personal website and let me know if you want to suggest anything

zaro said...
This comment has been removed by the author.
zaro said...

While Reading this post me i have got some diplomatic ideas related to programming languages they are the only way to find the best in Web design services and industrial services thanks for the share.

SEO Company Bangalore said...

Thanks for sharing this great Post dude
Web design company in bangalore

SEO Company Bangalore said...

Thanks for sharing this great Post dude
SEO Company bangalore

colaveri d said...

It is a very informative and useful post thanks it is good material to read this post increases my knowledge..
Pakistani wedding stage | pakistani wedding planner | event management companies in pakistan

colaveri d said...

While reading your blog it seems that you research on this topic very much. I must tell you that your blog is very informative and it helps others also.
maqbool mirza | mirza maqbool

colaveri d said...

There’s visibly a new bundle in order to identify relates to this. I just believe you’ve made various good points inside elements likewise.
pakistani matrimony | pakistani matrimonial | pakistani matrimonial sites | pakistani rishtay

colaveri d said...

Really nice blog, very informative. Thanks dude for the wonderful posting. Keep it up in the future as well.
urdu newspaper | english newspaper | news from pakistan

Marie Jones said...

Your article helped me to understand the topic well and I would love to share this to my friends. I also love to
Get Likes for your website
Free Twitter Followers
Free Website Traffic
Free Facebook Likes
Get free likes for your website
Get visitors for your website
Get tweets for your website
Get backlinks for your website
Get traffic for your website
Thank you for this and all the best.

web design company said...

This excellent website truly has all the information and facts I wanted concerning this subject and didn't know who to ask.Web Designing Companies in Bangalore

zersys cmpy said...

Really good one.

website design company bangalore

dolinna said...

Congratulations for this wonderful reading article. I found it very informative and interesting too, I think you are a brilliant writer. I have bookmarked your blog and will return in the future. I want to encourage you to continue that marvelous work, have a great daytime!I am a china tour lover,You can learn more: China travel service | China travel packages | China Asia travel

web design company said...

Thanks for discussing useful publish regarding actions for database. I appreciate for that. I study you blog and understand new factors.Web Development Company Bangalore

hedley lamor said...

Thanks Dude!!! You had shared a very good information.Here after i will be a regular follower for your blog.

Hosting Reviews

Manoranjan Sahoo said...

Its really a very good tutorial, thanks to share this with us.I hope its very helpful for the beginner to make their site more attractive and better functionality.
Website Development Company in India

Sevgisiir said...

a simple tire search system

sohbet odaları

Sevgisiir said...

p By Step เป็นไทยด้วยได้ไหมอ่าครับ

sohbet odaları

Oktay TEK said...


Nişantaşı Çilingir
Beykoz Çilingir
Bayrampaşa Çilingir
Bahçelievler Çilingir

Oktay TEK said...


Nişantaşı Çilingir
Beykoz Çilingir
Bayrampaşa Çilingir
Bahçelievler Çilingir

devindennis said...

I enjoyed your entries on Toxic Words - such great thoughts and a wonderful reminder to watch the words I use - to be positive and kind and use words to build up rather than tear down. :)

cosmetic surgery in pakistan | cosmetic surgery in lahore | cosmetic surgery for skin

ahmed abd elrazek said...

تقنية

دنيا التقنية

جوجل ناو ستقوم بتذكيرك بمكان سيارتك

كت كات نسخة أندرويد تعمل على 8.5% من الاجهزة الأندرويد

كيف تتصفح الأنترنت من هاتفك الذكى بشكل أسرع

شرح: طريقة إطفاء آيفون وآيباد عند تلف زر الطاقة

ahmed abd elrazek said...

Really good one.
AESTHETICS

ahmed abd elrazek said...

Hi, I like this script a lot, but I am having trouble with doing my own variation of a drop down box system.
free chat online

ahmed abd elrazek said...

oh my god finally i found some one who can understand what are he talking about ..you helped me so so much thanks أندرويد 4.4.2 كيت كات

ahmed abd elrazek said...

online games for kids

play online games for kids

fun online games for kids

ahmed abd elrazek said...

العاب فلاش

ahmed abd elrazek said...

تحويل التاريخ

التاريخ الهجرى

التاريخ الميلادى

ahmed abd elrazek said...

تحويل العملات

تجارة العملات

ahmed abd elrazek said...

جوال الخليج

واتساب بلس

شرح اعادة رقمك المحذوف في واتسب

نشر اي صوره تضيفها في الانستجرام تلقائيا على تويتر

افضل برامج و تطبيقات الاندرويد الجديدة

جميع طرق فورمات الجلكسي

طريقة تحديث جلكسي اس 1 بلس

عرض شاشة جهاز الأندرويد على شاشة الحاسوب

ahmed abd elrazek said...

free games

Zulus Zoo

Youre The Boss

Zombie Girl Dress Up

Aboxer said...

Zeribet El Oued| زريبة الوادي

ahmed abd elrazek said...

باب الحارة 6

ahmed abd elrazek said...

فتح الواتساب وفايبر والفيس بوك فى العراق بعد الحجب

طريقة فتح الفيس بوك واليوتيوب فى العراق بعد الحجب

تشغيل أندرويد على الكمبيوتر ويندوز وماك

أسرار الربح من أدسنس

طريقة لتسريع جهاز S4

تغيير الـ IP في 5 دقائق بدون برامج ولامواقع

خاتم إلكتروني يقوم بمهمة نقل كلمة السر عبر لمس الشاشة

بث مباشر لمباريات كأس العالم البرازيل 2014

واتساب بلس

الفيس بوك

Chergui Khaled said...

تعليم اللغة العربية
الارقام باللغة العربية
تعليم الارقام باللغة العربية
تعليم الارقام للاطفال

ahmed abd elrazek said...

سمانا نت

ahmed abd elrazek said...

طريق الاحتراف

ahmed abd elrazek said...

موقع زواج

بحث تفصيلى

اجابات

ahmed abd elrazek said...

حراج بن قاسم

ahmed abd elrazek said...

عالم الداتا

ahmed abd elrazek said...

حصريا: طريقة إسترجاع حساب فيسبوك تم حذفه نهائيا

طريقة فك حظر حساب جوجل أدسنس في اقل من 8 ساعات

فديوهات بدون حقوق، فرصة الربح من اليوتوب وبدون أي جهد

جديد: "نصائح من ذهب لكسر حاجز الركود وبيع أولى خدماتك في خمسات"

وفر حماية قوية لجهازك ضد البرامج الخبيثة

ahmed abd elrazek said...

كوالكوم تعلن عن معالجات Snapdragon 810 و Snapdragon 808

شرح طريقة التخلص من تغريدات تويتر القديمة

الأن الفيس بوك ماسنجر يدعم أجهزة الأيباد

تحذير من الرسائل المزيفة لتوثيق صفحاتك على الفيس بوك

Macromedia Flash Player

منبه الذاكرين للكمبيوتر zekr alarm

متصفحات للاندرويد

سباق الطيور الغاضبة Angry Birds Go

Need For Speed Most Wanted

Asphalt 8:Airborne لعبة السيارت للاندرويد

لعبة كابتن أمريكا Captain America

Cut the Rope او لعبة قطع الحبل الجزء 2

moto racing لاجهزة الاندرويد مجانا

السمكة نيمو لاجهزة الاندرويد

لعبة القناص للاندرويد

تطبيق تشغيل اكثر من حساب فيسبوك في الاندرويد

تطبيق Xposed و الذي سيجعل هاتفك اندرويد رائع

طريقة لانشاء تطبيقات الموبايل على الاندرويد والآيفون

تحميل برنامج نيمبز Nimbuzz للمكالمات والرسائل المجانية للأندرويد

تحميل لعبة الكلب الناطق للأندرويد

تحميل لعبة صب واى Subway Surfers للأيفون

ابل تكشف عن الايبود بسعة 16GB

جوجل تكشف عن أندرويد للتلفاز والسيارات

أندرويد

دنيا التقنية

اسعار ومواصفات

ahmed abd elrazek said...

خلطة بياض الثلج

خلطة تبييض

تبييض الجسم

تبييض الوجه

خلطة تبييض الوجه

حبوب الجلوتاثيون

ivory caps

ahmed abd elrazek said...
This comment has been removed by the author.
ahmed abd elrazek said...

ألعاب فلاش موضوع

flash games

ahmed abd elrazek said...

Cadeaux au Maroc

site spécialisé dans les cadeaux personnalisés

idées cadeaux personnalisés

idée cadeau pour femme

cadeau pour homme

cadeaux pour enfant

cadeaux anniversaire

cadeaux saint Valentin

aminos lahragui said...


صور مشبات
ديكورات مشبات
مشبات
مدافئ
شوايات
غرف تراثية

aminos lahragui said...

hey nthanks for that great and awesome article



تحميل برنامج فوتوشوب



شوايات

مدافئ

مشبات
غرف تراثيةم

Aymane Elg said...
This comment has been removed by the author.
amine lahragui said...

hey great article i just want to tell you thanks for that great article bro

workout schedule for men

amine lahragui said...


السيارات المستعملة



hi i just want to telll uou thanks for that great article