HTML data depending on "combo box"

Question

1.00/5 (1 vote)

See more:

Hello. I'm stuck here with a problem.

I have a "combo box" in HTML and I want to display another page that contains information from a MySQL database depending on the value selected from the combo box.

E.g.: the combo box contains the months of the year and depending on what month is selected, I want to display the corresponding information from the database for that month.

additional information copied from comment below
Here is the code:

HTML

<body>

  		<p>Get informations for month:
    
      <select id="month" name="month">
      
        <option value = "January">January</option>
        <option value = "February">February</option>
        <option value = "March">March</option> 
        <option value = "April">April</option>
        <option value = "Mai">Mai</option>
        <option value = "June">June</option>
        <option value = "July">July</option>
        <option value = "August">August</option>
        <option value = "September">September</option>
        <option value = "October">October</option>
        <option value = "November">November</option>
        <option value = "December">December</option>
        
      </select>
      
     </p>
       
  <form action="popup2.php" method="post" >
    <input type="submit" value="Display" name="   Display">
  </form>
  
	  
</body>

Posted 26-Dec-13 4:20am

Catalin Tudoroiu

Updated 26-Dec-13 6:12am

Nelek

v3

Add a Solution

Comments

ZurdoDev 26-Dec-13 10:22am

Pass the value through the querystring.

Catalin Tudoroiu 26-Dec-13 10:28am

how can I do that?

ZurdoDev 26-Dec-13 10:44am

Where's your code that takes you to the next page?

ZurdoDev 26-Dec-13 10:44am

Where's your code that takes you to the next page?

Catalin Tudoroiu 26-Dec-13 10:50am

Here is the code:

<body>

<p>Get informations for month:

<select id="month" name="month">

<option value = "January">January</option>
<option value = "February">February</option>
<option value = "March">March</option>
<option value = "April">April</option>
<option value = "Mai">Mai</option>
<option value = "June">June</option>
<option value = "July">July</option>
<option value = "August">August</option>
<option value = "September">September</option>
<option value = "October">October</option>
<option value = "November">November</option>
<option value = "December">December</option>

</select>

</p>

<form action="popup2.php" method="post" >
<input type="submit" value="Display" name=" Display">
</form>

</body>

Peter Leow 26-Dec-13 10:55am

It goes to show that you have no idea what the code is all about. Please take my advice in solution 1.

1 solution

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)

Peter Leow · Answer 1 · 2013-12-26T04:50:00

Solution 1

It is easy to ask a question like this, but to accomplish this seemingly simple task, you will need to have some minimal knowledge of the following areas:
1. HTML
2. PHP
3. MySQL
In order not to stuck with the similar problems in the future, why not help yourself by starting your learning journey right away. The following links should give you a good head start:
Learn HTML[^]
Learn PHP+MySQL[^]
If you encounter any problems with your learning or coding, then come here to post your question again and preferably show some code.

Posted 26-Dec-13 4:50am

Peter Leow

Updated 26-Dec-13 4:53am

v3

Comments

Sergey Alexandrovich Kryukov 26-Dec-13 13:57pm

This is fair enough, but you should have added two important items:
4. Javascript
5. Ajax.

This is because the HTTP request could be send from the UI (client-side, HTML page) only by a Web form, which would be quite impractical in this case, or Ajax. Isn't it logical?
I voted 4.

—SA

Peter Leow 26-Dec-13 21:56pm

Thank you. + virtual 5.