php drop down box categorycall list

Question

5.00/5 (1 vote)

See more:

Hi,

I want to create 2 select boxes. The option of the first box chosen will decide the options visible in the second select box. For example:

Select box A contains options 2010, 2011, 2012

Select box B contains movies names according their release year.

Now when say option 2012 is selected in box A, only those movies which have their release year on 2012 are displayed.

Please help coding in PHP/MySQL.

Thanks in advance.

Posted 17-Sep-12 5:37am

indranic

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Answer 1 · 2012-09-17T10:13:00

Solution 1

You need a simple query with a WHERE clause!

Example:

SQL

SELECT  
  movieNames
FROM
  Movies
WHERE
  movieYear = '2012'

You will have to pass movieYear as a parameter to query where its value will be equal to boxA option selected. Set query result as a datasource of this boxB.

Posted 17-Sep-12 10:13am

Sandeep Mewara

Er. Tushar Srivastava · Answer 2 · 2012-09-17T10:15:00

Hi Friend,
These tips may help you. I am sorry that I will not be providing you with codes since I have not one ready, and it really takes time to create one. But I will be giving you hints toward which you can move your way to reach the success.

1. First of all create a MySQL database and possibly create two tables, the one for the year and the another for film name or something like that, you are able to create one that seems more logical to you.

2. The second step is using AJAX (Yes, Javascripting) unless you have planned to reload the page everytime the user select an Year from the first select box.

3. The third step will be if you are going with creating an AJAX script. Create a function that will submit the Value of first selectbox on a onchange() event.

4. Create a page in php without any html inside it. This page will receive this data (the value of Selectbox1) and process it using MYSQL query to get a list of the array that will be storing the name of the Movies. Echo this data using this kind of code as example:

PHP

foreach($dataarray as $moviename)
{
 echo '<option>'.$moviename.'</option>';
}

5. In the ajax script, simply put this code in a block defined with ID name like this:

JavaScript

if(xmlhttp.readyState == 4 && xmlhttp.status == 200)
{
 document.getElementById("movieid").innerHTML = xmlhttp.responseText;
}

and, in the html part define something like this:

HTML

<select>
<div id="movieid"><option>Wait...</option></div>
</select>

6. Now you have your very own professional looking Select Box System, in which the Items displayed in one box will depend on the item selected in another box.

Hope it has helped you. I will possibly post the code if I get time to write one very soon.

Regards
Tushar Srivastava