PHP dynamic dropdown-change form action based on user selection

phpnewbie2007

Hello,

I have a dropdown which populates from a database.
When user selects option 1 from the dropdown, he should be directed to sample.php, if he selects option 2, then to sampleb.php and so on.

The code is as follows:

Expand|Select|Wrap|Line Numbers

 <html>

<head>

<script language="JavaScript">
 
function go(formname,url){
 
      document.getElementById(myteam).action = url;
 
      document.getElementById(myteam).submit();
 
}
 
</script>

</head>

<title>Homepage</title>

<?php

//dbconnect is a file which has the connection paramaters

//to the server and the database.

require ("dbconnect.php");
 
$sqlquery="SELECT teamqueuename FROM teamqueue;";

$results= mssql_query($sqlquery);

?>

<body>

<table> 

<tr><td><center>Welcome to the homepage!</center><td></tr>

<tr><td><br></td></tr>

<tr><td>Please select a team queue</td></tr>

<form name="myteam" method="get" target="_blank">
 
<tr><td><select name="myteam1" onChange="call()"> 
 
<?php

while ($row=mssql_fetch_array($results)){
 
        $teamqueuename=$row["teamqueuename"];
 
echo "<option>$teamqueuename</option>";
 
}

mssql_close($sqlconnect);

?>

</select></td></tr>

<tr><td><input type="submit" value="submit"></td></tr>
 
</form>

<?php

function call(){

$myteam=$_get['myteam'];

if ($myteam=="Build Team")

{

    go(myteam, "http://sample.php");

}    

if ($myteam=="PPG Team")

{    

    go(myteam, "http://sampleb.php");
 
}

}

    ?>    

</table>

</body>

</html>

[Please use CODE tags when posting source code. Thanks! --pbmods]

Thank you..

Jun 29 '07 #1

Subscribe Post Reply

7000

kovik

1,044

Expert 1GB

Firstly, you can't call a JavaScript function using PHP. Secondly, you don't really need JavaScript for this at all.

Post to the same page and, before anything is displayed, check the posted variable. If it meets the condition for the first page, use header() redirection to send them to the first page, or the second, or third, etc...

Jun 29 '07 #2

phpnewbie2007

Thanks for your reply.
I tried the header redirect..but it doesnt work.
Where am i going wrong??

Code:
<?php

$myteam1=$_post['myteam1'];
if ($myteam1=="Build Team")
{
header("location: newdata.html");
}
if ($myteam1=="PPG Team")

{
header("location: test/newdata.php");
}
?>
<html>
<head>
</head>
<title>Homepage</title>

<?php
//dbconnect is a file which has the connection paramaters
//to the server and the database.

require ("dbconnect.php");

$sqlquery="SELECT teamqueuename FROM teamqueue;";

$results= mssql_query($sqlquery);
$myteam1=$_get['myteam1'];
?>
<body>
<table>
<tr><td><center>Welcome to the homepage!</center><td></tr>
<tr><td><br></td></tr>
<tr><td>Please select a team queue</td></tr>
<form name= "myteam" method="post" target="_blank" action="test1.php">
<tr><td><select name="myteam1">
<?php
while ($row=mssql_fetch_array($results)){
$teamqueuename=$row["teamqueuename"];
echo "<option>$teamqueuename</option>";

}
mssql_close($sqlconnect);
?>
</selec></td></tr>

<tr><td><input type="submit" value="submit"></td></tr>

</form>

</table>
</body>
</html>

Jun 29 '07 #3

kovik

1,044

Expert 1GB

A lot of things. :-p

Firstly, never assume that a variable has been posted. Secondly, the header() function takes absolute paths. I believe it is either a browser issue or a server issue, but not everything recognizes relative paths correctly.

But I can't really help you until you tell me what error messages you are getting.

Jun 30 '07 #4

Similar topics

dynamic dropdown box

by: adam | last post by:

Hi - im looking to have two drop down boxs one with makes of car and the second drop down box to automatically populate with all the model of that particular make of car. there are about 50 makes...

PHP

Limiting duplicates in a dynamic dropdown? - Code included

by: Kingdom | last post by:

I'm using this script to dynamicaly populate 2 dropdowns and dispaly the results. Choose a component type from the first drop down, lets say 'car' and the second box will list all the car...

ASP / Active Server Pages

Need some help with dynamic dropdown in For Loop

by: Drew | last post by:

I am trying to build a small app that shows a Course Title from the database, then displays a dropdown full of categories for the user to choose one... I thought a loop would be the best way to...

ASP / Active Server Pages

Dynamic Dropdown in DataGrid

by: Niks | last post by:

Hi, I have to create a DataGrid which has 5 columns (only for display not for Edit). Problem is with one column, which displays the database value if present else it has to display DropDownlist in...

ASP.NET

ASP.NET 2.0 Menu Dynamic DropDown

by: Just Me | last post by:

My Dynamic dropdown menus are appearing above the text below. How can I prevent this, I have tried setting the zorder high for them, but it makes not difference. Cheers

Visual Basic .NET

<div align=center> also affects align of dynamic dropdown item text

by: Steve Richter | last post by:

I am using <div align=centerto center a horizontal menu on the page. Problem is the center align of the div is rippling down to the menu items and causing the text of the dynamic popup sub menu...

ASP.NET

Dynamic dropdown suggestion list on key press, 1 million possible results.

by: Javilen | last post by:

Hello, Maybe one of you can offer a possible solution to the problem I have below. The request to me is to build a dynamically populating dropdown list from a text box.(something similar to...

ASP / Active Server Pages

Dynamic Dropdown Boxes

by: chowdary | last post by:

hi, Iam new to javascript. I'm wondering how to go about creating two dropdown boxes such that when you select a value from the first one, the second is populated with values that depend on the...

Javascript

Refresh individual Dynamic dropdown

by: d1156676 | last post by:

Hi I have a Dynamic dropdown reading in data from a MySql database, I need to refresh the dropdown when the database is updated without refreshing the whole page. I have had a go at trying to...

PHP

Dynamic DropDown Menu in PHP

by: sydd | last post by:

Hi, I was wondering if it's possible to create a dynamic dropdown menu from this code. if($rs->getNumRows() > 0){ $intProjectCount = 1; $htmlOut ="<table width='100%' border='0'...

PHP

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General