Ad:

PHP Discussion Thread
Unsolved
Views: 1851

Nov 18th, 2008

[HELP] Regarding on select Box

Expand Post »

I want to build a simple search system.
I have this one page call search.php which I had a multiple select box that i retrieve from the database..

some of the code are like this:

PHP Syntax (Toggle Plain Text)
<form method="post" action="modulartabulated.php">
  <table width="75%" border="0" align="center">
    <tr>
      <td>Date:</td>
      <td><input type="text" name="date" /></td>
    </tr>
    <tr>
      <td>Examiner:</td>
      <td><input type="text" name="examiner"  />      </td>
    </tr>
    <tr>
      <td>Program:</td>
      <td><select name="program" id="prog">
        <?
			$db=mysql_connect($hostname,$username,$password);
			mysql_select_db($dbname,$db);
 
			$query = "SELECT * from execdipprog";
			$record = mysql_query($query);
			$numrows = mysql_num_rows($record);
 
			if($numrows > 0 )
			{
				while($row = mysql_fetch_array($record))
				{
					$prog_id = $row['K_Name'];
					$prog_name = $row['K_Desc'];
					echo("<option value='$prog_name'>".$prog_name."</option>");
				}
			}
		?>
      </select></td>
    </tr>
    <tr>
      <td>Class</td>
      <td><select name="class" id="kelas">
          <?
			$db=mysql_connect($hostname,$username,$password);
			mysql_select_db($dbname,$db);
 
			$query = "SELECT * from execdipclass";
			$record = mysql_query($query);
			$numrows = mysql_num_rows($record);
 
			if($numrows > 0)
			{
				while($row = mysql_fetch_array($record))
				{
					$class_id = $row['C_Id'];
					$class_name = $row['C_Name'];
					echo("<option value='$class_name'>".$class_name."</option>");
				}
			}
		?>
        </select></td>
    </tr>
    <tr>
      <td>Module:</td>
      <td><select name="subject" id="subjek">
        <?
			$db=mysql_connect($hostname,$username,$password);
			mysql_select_db($dbname,$db);
 
			$query = "SELECT * from modul";
			$record = mysql_query($query);
			$numrows = mysql_num_rows($record);
 
			if($numrows>0)
			{
				while($row = mysql_fetch_array($record))
				{
					$sub_id = $row['M_ID'];
					$sub_name = $row['M_Desc'];
					echo("<option value='$sub_name'>".$sub_id."</option>");
				}
			}
		?>
      </select></td>
    </tr>
    <tr>
      <td colspan="2"><div align="center">
        <input type="submit" name="generate" value="Display" />
      </div></td>
    </tr>
 
  </table>
</form>
<form method="post" action="modulartabulated.php">
  <table width="75%" border="0" align="center">
    <tr>
      <td>Date:</td>
      <td><input type="text" name="date" /></td>
    </tr>
    <tr>
      <td>Examiner:</td>
      <td><input type="text" name="examiner"  />      </td>
    </tr>
    <tr>
      <td>Program:</td>
      <td><select name="program" id="prog">
        <?
			$db=mysql_connect($hostname,$username,$password);
			mysql_select_db($dbname,$db);
			
			$query = "SELECT * from execdipprog";
			$record = mysql_query($query);
			$numrows = mysql_num_rows($record);
			
			if($numrows > 0 )
			{
				while($row = mysql_fetch_array($record))
				{
					$prog_id = $row['K_Name'];
					$prog_name = $row['K_Desc'];
					echo("<option value='$prog_name'>".$prog_name."</option>");
				}
			}
		?>
      </select></td>
    </tr>
    <tr>
      <td>Class</td>
      <td><select name="class" id="kelas">
          <?
			$db=mysql_connect($hostname,$username,$password);
			mysql_select_db($dbname,$db);
			
			$query = "SELECT * from execdipclass";
			$record = mysql_query($query);
			$numrows = mysql_num_rows($record);
			
			if($numrows > 0)
			{
				while($row = mysql_fetch_array($record))
				{
					$class_id = $row['C_Id'];
					$class_name = $row['C_Name'];
					echo("<option value='$class_name'>".$class_name."</option>");
				}
			}
		?>
        </select></td>
    </tr>
    <tr>
      <td>Module:</td>
      <td><select name="subject" id="subjek">
        <?
			$db=mysql_connect($hostname,$username,$password);
			mysql_select_db($dbname,$db);
			
			$query = "SELECT * from modul";
			$record = mysql_query($query);
			$numrows = mysql_num_rows($record);
			
			if($numrows>0)
			{
				while($row = mysql_fetch_array($record))
				{
					$sub_id = $row['M_ID'];
					$sub_name = $row['M_Desc'];
					echo("<option value='$sub_name'>".$sub_id."</option>");
				}
			}
		?>
      </select></td>
    </tr>
    <tr>
      <td colspan="2"><div align="center">
        <input type="submit" name="generate" value="Display" />
      </div></td>
    </tr>
   
  </table>
</form>

On the next page..I want to retrieve data from database according to the selected data from search.php. Can anyone tell me how to code it? I've use the regular POST method but it didn't work

Please Help

Similar Threads

Select box that changes textbox value in JavaScript / DHTML / AJAX
passing values of Select box from JSP to Action class thru form Bean in JSP
Populating Select Box w/ Passed In Value? in JavaScript / DHTML / AJAX
onClick html select box help, passing selected value and populating select box in JavaScript / DHTML / AJAX
Select Box populates text field in JavaScript / DHTML / AJAX

syazuchan

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Nov 2008

Permalink

Nov 18th, 2008

Re: [HELP] Regarding on select Box

why not to store your search results on sessions....

Shanti C

Reputation Points: 137

Solved Threads: 162

Posting Virtuoso

Offline

1,641 posts
since Jul 2008

Permalink

Nov 18th, 2008

Re: [HELP] Regarding on select Box

You can grab the values from the global $_REQUEST array or $_POST array. The selected values are avaialble in the variable which has the same name as the form tag. e.g. the selected value for subject can be retrieved as $_REQUEST['subject']

jack239

Reputation Points: 13

Solved Threads: 1

Newbie Poster

Offline

14 posts
since Aug 2008

Permalink

Nov 19th, 2008

Re: [HELP] Regarding on select Box

use the $_POST data to do it. not $_REQUEST, in which is not very secure.

kkeith29

Reputation Points: 235

Solved Threads: 193

Nearly a Posting Virtuoso

Offline

1,315 posts
since Jun 2007

Permalink

Jan 4th, 2009

Re: [HELP] Regarding on select Box

thank you for all the reply.
however i ad somethign else to my code.
I add onChange statement at the dropdown menu.

so code become like this,

(Toggle Plain Text)

<form name="modulartabulate" method="post" action="modulartabulated.php">
  <table width="75%" border="0" align="center">
    <tr>
      <td>Date:</td>
      <td><input type="text" name="date" /></td>
    </tr>
    <tr>
      <td>Examiner:</td>
      <td><input type="text" name="examiner"  />      </td>
    </tr>
    <tr>
      <td>Program:</td>
      <td><select oncahnge="modulartabulted.submit()" name="program" id="prog">
        <?
			$db=mysql_connect($hostname,$username,$password);
			mysql_select_db($dbname,$db);
			
			$query = "SELECT * from execdipprog";
			$record = mysql_query($query);
			$numrows = mysql_num_rows($record);
			
			if($numrows > 0 )
			{
				while($row = mysql_fetch_array($record))
				{
					$prog_id = $row['K_Name'];
					$prog_name = $row['K_Desc'];
					echo("<option value='$prog_name'>".$prog_name."</option>");
				}
			}
		?>
      </select></td>
    </tr>
    <tr>
      <td>Class</td>
      <td><select modulartabulted.submit() name="class" id="kelas">
          <?
			$db=mysql_connect($hostname,$username,$password);
			mysql_select_db($dbname,$db);
			
			$query = "SELECT * from execdipclass where K_Name='program'";
			$record = mysql_query($query);
			$numrows = mysql_num_rows($record);
			
			if($numrows > 0)
			{
				while($row = mysql_fetch_array($record))
				{
					$class_id = $row['C_Id'];
					$class_name = $row['C_Name'];
					echo("<option value='$class_name'>".$class_name."</option>");
				}
			}
		?>
        </select></td>

My problem is, I want the 2nd select option (drop down menu) to list the data from database according to the 1st select option (drop down menu). Using the coding above, after I selected the 1st select option (drop down menu), it redirect to the "modulartabulted.php" which suppose to happend after I click the submit button after I finish select from all the drop down list menu.

to clear it all out I'll show from example

according to the image that i've attach, i want to list out data from the database. Here a the step by step.
1. First I select Program (A)
2. Then Class (B) will list its data according to Program (A)
3. After I select Class (B), Student Name (C) will list it data according to the Class (B) that I choose.
4. Module (D) will list its data according to the Program (A) that I choose earlier.
5. After finish selecting, I click display button and it will be directed to "modulartabulated.php" page where all the date been sort according to the data I selected in previous page.

All of above happen to be in the same form.

Please help.
Thank you in advanced.

Attached Thumbnails

Click image for larger version

Name: serach1wt8.jpg
Views: 153
Size: 28.5 KB
ID: 8765

Last edited by syazuchan; Jan 4th, 2009 at 10:20 pm.

syazuchan

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Nov 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Multilanguage with PHP-MySQL

Next Thread in PHP Forum Timeline: what is php stands for

DaniWeb Message

Cancel Changes

User Name
Password