PHP_SELF form submission

[programmer79]

I have search page that dynamically generates the contents of a second dropdown box by what the user selects from the first combo dropdown box. This is achieved by submitting the form using PHP_SELF. The issue is when the user presses the submit button at the bottom of the page, I want the form to go to another page, but I cannot get this to work.

Thank you in advance for your help!

[planetsim]

Try this

if(!isset($_POST['submit'])){
//Form code here
}else{
//your next page
}

[programmer79]

if(!isset($_POST['submit'])){
//Form code here
}else{
//your next page
}

This would be placing the code for the second page within the first page correct? I really want to keep the two separate.

Thank you,

Tony

[planetsim]

In that case then

Dont use $PHP_SELF

have it

<form action="blah.php" method="post"> instead of

<form action="<?php echo $PHP_SELF; ?>" method="post">

Or whatever you have.

[DeltaRho2K]

Using this:

if(!isset($_POST['submit'])){ 
//Form code here 
}else{ 
//your next page 
}

Instead of putting the code for your next page in the else portion, you could maybe try put a redirect to the other page... To do this though, I believe you would have to make sure the headers aren't sent yet, and you would have to pass the variables in a GET method... (not 100% on this though)

[programmer79]

This is for a car dealer site.

I have two combo boxes. The first queries the db and displays all of the manufacturers. When the user selects a manufacturer it uses the onChange and submits a php_self call, which requeries the db to display all of the makes for a particular manufacturer. Once the user has selected the make that they want they will click the go button to submit the form to the next page, so I need some way to have both php_self and an action to submit to the next page. I have tried

if (isSet($POST['submit'])){
form name=search action=next_page.php method=POST>;
}
else{
form name=search action=$SERVER['PHP_SELF'] method=POST>;
}

This will not work because you must click submit twice before it actually submits to the next page.

Thanks!

[programmer79]

Here is the working code that I currently have. I hope this helps.

Thanks,

Tony

<?php  

/////////////////////////////////////////////////////////////////////////////////////////////
//  7/1/03 -- Search code..
//  The following queries the database and only lists the valid make/model combinations that
//  are currently listed in inventory.  This way the user is not searching for a vehicle that 
//  the dealer does not have.
//////////////////////////////////////////////////////////////////////////////////////////////

echo "<form name=search action='".$_SERVER['PHP_SELF']."' method=POST>";

//db connections 
include ('config.php');

// Test if the form has been submitted yet
if(!isSet($_POST['mfg'])){  

	// Query db for make/model combinations only for vehicles in stock
    $result = mysql_query("select distinct a.mfg_id, a.mfg_name
							from manufacturer a, model b, vehicle c
							where a.mfg_id = b.mfg_id
							and b.model_id = c.model_id
							order by a.mfg_name"); 

	// Submit for when user select a different make 
    echo "<select name=mfg onChange=\"document.search.submit();\">";  

	// Any Make will default upon form load
	echo "<option value = \"any_make\">Any Make</option>";

		// Loop through manufacturers in db
		while ($row = mysql_fetch_array($result)){  
			echo "<option value=".$row['mfg_id'];  
    		echo ">".$row['mfg_name']."</option>";  
		}  
    echo "</select>";    
	echo "<select>";

	// List any model as a default when the form is first loaded. (Mainly for looks)
	echo "<option value = \"any_model\">Any Model</option>";
	echo "</select>";  
}

// If the form has been submitted this section will be executed
else { 
	$mfg = $_POST['mfg']; 

	// Query db for make/model combinations only for vehicles in stock
    $result = mysql_query("select distinct a.mfg_id, a.mfg_name
							from manufacturer a, model b, vehicle c
							where a.mfg_id = b.mfg_id
							and b.model_id = c.model_id
							order by a.mfg_name");

	// Submit for when user select a different make
    echo "<select name=mfg onChange=\"document.search.submit();\">"; 

	// Put any make as an option along with the other manufacturers
	echo "<option value = \"any_make\">Any Make</option>";

		// Loop through the manufacturers and display in a combo box
		while ($row = mysql_fetch_array($result)){  
			echo "<option value=".$row['mfg_id'];  

        		// This keeps the users previous selection highlighted so the make/model are in sync.		
				if($mfg == $row['mfg_id'])  {
            		echo " SELECTED";  
					$mfg = $row['mfg_id'];
				}
     		echo ">".$row['mfg_name']."</option>";  
	   }  
    echo "</select>";  

		// Check if user selects Any Make option give any model as the other option if so
		if($mfg == 'any_make'){ 
			echo "<select name=model>";
			echo "<option value=any_model>Any Model</option>";
			echo "</select>";
		}

		// If the user selects a manufacturer find the corresponding models in inventory
		else{
			$resultn = mysql_query("Select a.model_id, a.model
									from model a, vehicle b
									where mfg_id = '$mfg'
									and a.model_id = b.model_id");  
    				echo "<select name=model>";  		
					echo "<option value=\"any_model\">Any Model</option>";
				while ($rown = mysql_fetch_array($resultn)){  
					echo "<option value=".$rown['model_id']; 
					echo ">".$rown['model']."</option>";  
				}  
    		echo "</select>";
		}   
}
echo "<input type=submit name=Submit value=Submit>";
}
?>
</form> 

[HalfaBee]

I think what you need to do is move this line
echo "<form name=search action='".$_SERVER['PHP_SELF']."' method=POST>";
inside the IF() and the ELSE and then you know whether to use PHP_SELF or the next filename.

HalfaBee