6 dropdown boxes populated from PHP/MySQL using Ajax

[hdf]

hi
i want to use a dropdown box to populate another dropdownbox and so on but i want to maitain all the data adt was selected from d previoce box and i dnt want to make use of submit button but the dropdown must triger the changes assoon as its value gange

can anyone hlp

[ronverdonk]

Ever thought of using JavaScript for that? Certainly not PHP.

Ronald :cool:

[hdf]

Ever thought of using JavaScript for that? Certainly not PHP.

Ronald :cool:

hi how can i go about doing dat

[ronverdonk]

Where do you want your dropdown box to be populated from?

From data that is stored in your program or from a server database?

That makes a big difference, because in the first case you simply trigger a JS routine that fills another box.

In the second case you let the triggered JS routine make contact with the server to get the data (using Ajax) and then let that populate the next dropdown.

For both options is a solution.

Ronald :cool:

[hdf]

Where do you want your dropdown box to be populated from?

From data that is stored in your program or from a server database?

That makes a big difference, because in the first case you simply trigger a JS routine that fills another box.

In the second case you let the triggered JS routine make contact with the server to get the data (using Ajax) and then let that populate the next dropdown.

For both options is a solution.

Ronald :cool:

i want it to read from the database

[ronverdonk]

In order to understand the process of Ajax, see demo's named Dynamic client lookup and Chained select boxes at site Ajax scripts

The first one uses the server database top get the info. The second fills a drop down.

When you have questions left, come back here.

Ronald :cool:

[hdf]

In order to understand the process of Ajax, see demo's named Dynamic client lookup and Chained select boxes at site Ajax scripts

The first one uses the server database top get the info. The second fills a drop down.

When you have questions left, come back here.

Ronald :cool:

hi how do i link up 5 dropdown boxs to eachother.e.g
dropdown1 i select the value and it populate dropdown2 dan i select from dropdown2 and it poulates dropdown3 ans son

how can it b done and it must contain the selection tru outh the proces

Thank you

[ronverdonk]

I have (very simple) sample scripts for this. Although it is not my habit of making complete code sets available, I will make an exception in this case because it would be a never ending thread to display and comment the code involved.

I have sample code whereby 6 drop-down boxes are filled, each one depending on the choice in the previous one. The data to populate these boxes is coming from a MySQL database.

The code for this contains 3 simple scripts:

1. client script building the screen and executing the JS requests to the server
2. a PHP program that is invoked by the client JS. It performs the required MySQL selects, builds the fileld dropdown box and sends the result back to the client.
3. the Ajax.js include lib (Simple AJAX Code Kit (SACK)), used for handling the httpRequests, which is not developed by me, but by Gregory Wild-Smith, under a modified MIT license.

When you are interested in this code I will send it to the email address of anyone interested. In that case send me your email address.

Ronald :cool:

[acoder]

Why not just include an attachment (in a zip file) instead of having to email everyone who asks for it?

[javaram]

roven. i need the code.



javaram

I have (very simple) sample scripts for this. Although it is not my habit of making complete code sets available, I will make an exception in this case because it would be a never ending thread to display and comment the code involved.

I have sample code whereby 6 drop-down boxes are filled, each one depending on the choice in the previous one. The data to populate these boxes is coming from a MySQL database.

The code for this contains 3 simple scripts:

1. client script building the screen and executing the JS requests to the server
2. a PHP program that is invoked by the client JS. It performs the required MySQL selects, builds the fileld dropdown box and sends the result back to the client.
3. the Ajax.js include lib (Simple AJAX Code Kit (SACK)), used for handling the httpRequests, which is not developed by me, but by Gregory Wild-Smith, under a modified MIT license.

When you are interested in this code I will send it to the email address of anyone interested. In that case send me your email address.

Ronald :cool:

[hdf]

I have (very simple) sample scripts for this. Although it is not my habit of making complete code sets available, I will make an exception in this case because it would be a never ending thread to display and comment the code involved.

I have sample code whereby 6 drop-down boxes are filled, each one depending on the choice in the previous one. The data to populate these boxes is coming from a MySQL database.

The code for this contains 3 simple scripts:

1. client script building the screen and executing the JS requests to the server
2. a PHP program that is invoked by the client JS. It performs the required MySQL selects, builds the fileld dropdown box and sends the result back to the client.
3. the Ajax.js include lib (Simple AJAX Code Kit (SACK)), used for handling the httpRequests, which is not developed by me, but by Gregory Wild-Smith, under a modified MIT license.

When you are interested in this code I will send it to the email address of anyone interested. In that case send me your email address.

Ronald :cool:

hi
is send u the pm n waiting for the code thnx

[aniltc]

hi all

i need the code for 6 drop down list box using AJAX.I have done something similar to this using 3 drop downe.But values are not retaining.please help me out and please show me some examples.

Thanks

[ronverdonk]

then pm your email address.

Ronald :cool:

[aniltc]

then pm your email address.

Ronald :cool:

I have send it.But the code you have given look like jung values.I am not able to read.please send me once more as a Zip file or Rar files

Thanks and Regards
ANIL

[aniltc]

you have send the code twice But i am not able to raed it.which alnguage is this?
please help me.i am in a deep trouble

[ronverdonk]

Once I have send it as a ZIPped file, the second time all separate files (.php, .js and .sql). You must have a problem in your mail client or in your firewall.

All other requestors have received it in the correct format. (ZIP or separate files).

Ronald :cool:

[ronverdonk]

We solved it. I sent the files as attachments using Outlook Express to a gmail account. That screwed it really up. All files were send as binaries. Whatever I did a the OE side, it did not help.

So I send them again from my own gmail account and that worked fine.

So anyone who runs into this sort of problem (screwed up attached files sent from Outlook express to gmail), get a gmail account!

Ronald :cool:

[rossco]

Hi,

I was wondering if it would be possible to get a copy of this code for the 6 linked drop-down boxes. i only need it for 3 where the 2nd and 3rd values are fetched form a MySQL db dependent on the previous option.

Thanks in advance.

[ronverdonk]

Hi,

I was wondering if it would be possible to get a copy of this code for the 6 linked drop-down boxes. i only need it for 3 where the 2nd and 3rd values are fetched form a MySQL db dependent on the previous option.

Thanks in advance.

You can have this code 'as is', i.e. 6 drop downs, each one filling from MySQL select. Send me a pm with your email and I'll send you an Omnidrive link.

Ronald :cool:

[dariimd]

hi! I would like you will send me this script, ajax 6 drop down box.please, at <email_removed>.
Merci man

[etnies99]

Hello, Can you please send me the script for the dropdown chain as well..

my email is removed by admin

Thank Yuo very much,
Adam

[mashafer]

then pm your email address.

Ronald :cool:

Please send me your example. I've been messing around with an example
You select countries, 2nd box fills with cities. The original example code didn't interface with mysql.

If you would share your " 6 dropdown boxes populated from PHP/MySQL" , I could get on with the rest of my project.

Thanks in advance for your help.

[Andrewthomas1977]

Hi there can i get also get a copy of your code

[ffulcher]

i also need that code for the dropdowns at <email_removed> i need it like yesterday does it come with an example on how to use it? Thanks

[ronverdonk]

i also need that code for the dropdowns at [e-mail] i need it like yesterday does it come with an example on how to use it? Thanks

Sent to requestor.

Ronald

[momogi]

I have (very simple) sample scripts for this. Although it is not my habit of making complete code sets available, I will make an exception in this case because it would be a never ending thread to display and comment the code involved.

I have sample code whereby 6 drop-down boxes are filled, each one depending on the choice in the previous one. The data to populate these boxes is coming from a MySQL database.

The code for this contains 3 simple scripts:

1. client script building the screen and executing the JS requests to the server
2. a PHP program that is invoked by the client JS. It performs the required MySQL selects, builds the fileld dropdown box and sends the result back to the client.
3. the Ajax.js include lib (Simple AJAX Code Kit (SACK)), used for handling the httpRequests, which is not developed by me, but by Gregory Wild-Smith, under a modified MIT license.

When you are interested in this code I will send it to the email address of anyone interested. In that case send me your email address.

Ronald :cool:

Hi, ronver..
I really need the code..
would you send me, pls? I'v just sent my email to U (PM)...
-thanks-

[kmithu]

Well if you are familiar with Ajax, then you can use the Update Panel. How many update panels are to be put entirely depends upon your functionality. This will serve your purpose but be careful while placing them. After putting drop downs in update panel, make the UPDATE MODE property of update panel CONDITIONAL and drop down list AUTO POST BACK Property TRUE. Then bind the dropdown with your database.Hope this works out for you!

[ronverdonk]

Well if you are familiar with Ajax, then you can use the Update Panel. How many update panels are to be put entirely depends upon your functionality. This will serve your purpose but be careful while placing them. After putting drop downs in update panel, make the UPDATE MODE property of update panel CONDITIONAL and drop down list AUTO POST BACK Property TRUE. Then bind the dropdown with your database.Hope this works out for you!

Can you give us a hint as to what problem/qeuestion in this forum your post is related? I cannot find any question related to any Update panel or Update mode. Otherwise, could you explain what you are referring to?

Ronald

[momogi]

hi Ron,,,

I've received the code. Thx, thx... :)

But, may I ask u something more? Would u give me a reference to learn about ajax? a site or something else...

I'v try ur code and I'll try it on my project...

[bugboy]

Heya ronverdonk,

I would love to have a look at the 6 dropdown cascade code, if you could email it to me at <email_removed> that would be great. I really appreciate it.

Thanks! BugBoy

[acoder]

But, may I ask u something more? Would u give me a reference to learn about ajax? a site or something else...

Check out the Ajax tutorial links in Offsite Links in the Javascript/Ajax forum. You can also see an example in the Articles section.

[JohnMV]

Hi ,can i too, get a copy of your code.

Could you please mail me the code to <email_removed>

Thanks!!
John.

[ronverdonk]

Hi ,can i too, get a copy of your code.

Could you please mail me the code to <email_removed>

Thanks!!
John.

Sent it to you.

Ronald

[sgk12345]

I have (very simple) sample scripts for this. Although it is not my habit of making complete code sets available, I will make an exception in this case because it would be a never ending thread to display and comment the code involved.

I have sample code whereby 6 drop-down boxes are filled, each one depending on the choice in the previous one. The data to populate these boxes is coming from a MySQL database.

The code for this contains 3 simple scripts:

1. client script building the screen and executing the JS requests to the server
2. a PHP program that is invoked by the client JS. It performs the required MySQL selects, builds the fileld dropdown box and sends the result back to the client.
3. the Ajax.js include lib (Simple AJAX Code Kit (SACK)), used for handling the httpRequests, which is not developed by me, but by Gregory Wild-Smith, under a modified MIT license.

When you are interested in this code I will send it to the email address of anyone interested. In that case send me your email address.

Ronald :cool:

i stumbled upon this thread, and read about your 6 select boxes.

i too need your help on the codes. i've pmed you already :)

thank you~

[lizaa]

I aslo need this code badly
i sent you a pm ..

Thnaks

[amystephenson]

Please send me the code also. I am working on a three drop down. <email_removed>

[desmukh]

hai,

send me the code tooo.... <email_removed> ... Thnx Thnx

[amcoldspy]

Hi,

I would appreciate if u could send the code. My id is <email_removed>
Thanks

[xander85]

Hi,

Can you please send me to the code as well. I'd be very appreciated!

<email_removed>

[wan7073]

Hi,

My name is wan. Can you please send me to the code as well. I'd be very appreciated! Here's my email: <email_removed>

[denzil]

Hi there,

Please could you send me the code as well, it would be most appreciated.

My email address is: <email_removed>

Many thanks,
Denzil

[mainul05]

can anyone please send me the code also. my email is <email_removed>