asked on

radio Button must have a ID when selecting it and moving to a other Page

Hi

I have a search Page with data on it. If I select a option from the radio button and move to a other page I need the id to be carried over. This is not working even if I place the follow code it in

<input name='changeCheck' type='radio' value='".$row['AssetID']."'/>

<?php
 session_start();
 ?>
<html>
<body>
<?php include "Menu.php"; ?>
	<!--<form action="action.php" method="post">-->
	
<?php
 
	define("DB_HOST","server");
	define("DB_USER","usename");
	define("DB_PASS","password");
	define("DB_NAME","database");
	
	$db_connection = mssql_connect(DB_HOST, DB_USER, DB_PASS) or die ("Could not connect to MSSQL host:<br>".mssql_get_last_message());
	$result = mssql_select_db(DB_NAME, $db_connection);
	if(!$result) exit("Could not select MSSQL DB:<br>".mssql_get_last_message());
	
	$cost_code = $_POST['branch'];
	$query = "SELECT BranchID FROM Branch WHERE  branchcostcode= '$cost_code'";
	$result = mssql_query($query, $db_connection);
	if(!$result) exit("Could not execute query:<br>$query");
	if(mssql_num_rows($result) == 0) exit("Cost code not found:<br>$query<br>Cost code var:$cost_code");
	$_SESSION['cost_code'] = $_POST['branch'];
	
	$row = mssql_fetch_assoc($result);
	$get_assets = "SELECT AssetID FROM Asset_Branch_Link WHERE  BranchID = ".$row['BranchID']."";
	$get_assets_result = mssql_query($get_assets, $db_connection);
	if(!$get_assets_result) exit("Could not execute query:<br>$get_assets<br>".mssql_get_last_message());
	if(mssql_num_rows($get_assets_result) == 0) exit("No assets found for branch");
	
 
	echo "<table border=\"2\" cellspacing=\"1\">";
	echo "<tr>";
	echo "<th>Select</th>";
	echo "<th>DeviceType</th>";
	echo "<th>DeviceMake</th>";
	echo "<th>DeviceModel</th>";	
	echo "<th>Serial</th>";
	echo "<th>Cost Code</th>";
	echo "<th>Domain User</th>";
	echo "<th>Date Modified</th>";
	echo "<th>Date Created</th>";
	echo "<th>Status</th>";
	echo "<th>Change Order</th>";
	//echo "<th>Change Order</th>";
	//echo "<th>Select and Update</th>";
	//echo "<th>Move Asset</th>";
	echo "</tr>";
	while($row = mssql_fetch_assoc($get_assets_result))
	{
		$asset_details = " select 
								c.TypeName,
								d.MakeName,
								e.ModelName,
								a.AssetSerial,
								DomainUser,
								convert(varchar,a.Datemodified,111) As DateModified,
								convert(varchar,a.DateCreated,111) As DateCreated,
								b.Statusname,
								a.AssetID,
								g.branchcostcode,
								g.changeorder
								
							
			from 
								dbo.Asset a left join dbo.Status b
								ON a.statusid = b.statusid
								left join dbo.AssetType c
								ON c.typeid = a.typeid
								left join dbo.AssetMake d
								on d.makeid = a.makeid
								left join dbo.MakeModel e
								on e.modelid = a.modelid
								left join Asset_branch_link f
								on f.assetid = a.assetid
								left join branch g
								on g.branchid = f.branchid
						  WHERE a.AssetID = '".$row['AssetID']."'";
		$asset_details_result = mssql_query($asset_details, $db_connection);
		if(!$asset_details_result) exit("Could not execute query:<br>$asset_details<br>".mssql_get_last_message());
		if(mssql_num_rows($asset_details_result) == 0) exit("Could not find asset ".$row['Asset_id']." in Assets table:<br>$asset_details<br>".mssql_get_last_message());
		
		$row = mssql_fetch_assoc($asset_details_result);
		echo "<tr>";
		echo "<td><input name='changeCheck' type='radio' value='".$row['AssetID']."'/></td>";
		echo "<td>".$row['TypeName']."</td>"; 
		echo "<td>".$row['MakeName']."</td>";
		echo "<td>".$row['ModelName']."</td>";
		echo "<td>".$row['AssetSerial']."</td>";
		echo "<td>".$row['branchcostcode']."</td>";
		echo "<td>".$row['DomainUser']."</td>";
		echo "<td>".$row['DateModified']."</td>";
		echo "<td>".$row['DateCreated']."</td>";
		echo "<td>".$row['Statusname']."</td>";
		echo "<td>".$row['changeorder']."</td>";
		//echo "<td>".$row['Incident']."</td>";
		//echo "<td>".$row['changeorder']."</td>";
		//echo "<td><a href='action.php?id=".$row['AssetID']."'>Action Asset</a></td>";
		//echo "<td><a href='asset_move.php?id=".$row['AssetID']."'>MOVE ASSET</a></td>";
		echo "</tr>";
	} // end while
 
	echo "</table>";
	echo "<br>";
 
?>
 
	<!--<input type="submit" value="Action">
	</form>-->
	        <?php
		if(isset($_POST["submit_action"])){
	            switch ($_POST["submit_action"]) {
	                case "Register a Transfer": header("Location: asset_move.php"); break;
	                case "Place into storage": header("Location: place_into_storage.php"); break;
	                case "Register as Broken": header("Location: register_as_broken.php"); break;
	                case "Decommission": header("Location: decommission.php"); break;
	           }
	       } 
	?>
		<form action="#" method="post">
		<input type="submit" value="Register a Transfer" name="submit_action" />
		<input type="submit" value="Place into storage" name="submit_action"/>
		<input type="submit" value="Register as Broken" name="submit_action"/>
		<input type="submit" value="Decommission" name="submit_action"/>
		</form>
	
 
</body>
</html>

Open in new window

gamebits

If you want to automate the process (so the user doesn't have to select the radio button) do this

<input name='changeCheck' type='radio' value='".$row['AssetID']."' checked/>

agriesser

Checkboxes and radioboxes do only get carried over when they're set. If they're not set, not even the environment variables (e.g. $_REQUEST, $_GET or $_POST) show them.

As gamebits already suggested, you need to set the value of this input element to checked, but what puzzles me more is that you seem to do redirects depending on what action the user has chosen, is that right?

form variables will usually not survive redirects unless you store them into your $_SESSION array...