how to retain the values in the sub process?

tayys · December 27, 2011

hi there,

I have a chained combo boxes. I manage to get the values for the sub process using onchange event.My problem here is how can I retain the values in the sub process combo box after the page is loaded?

main.php

<?php
require_once 'connectDB.php';

$sub_id = $_GET['sub_id'];
$id = $_SESSION['process_id'];

$sql = " SELECT * FROM tb_process ORDER BY pro_id ASC";
$result = mysql_query($sql) or die(mysql_error());

$sql = "SELECT tb_record.rec_tpcd, tb_record.rec_part, tb_record.rec_code, tb_record.rec_vendor, tb_record.rec_location, tb_record.rec_remark,
tb_sub_process.sub_name, tb_process.pro_name
FROM tb_record
LEFT JOIN tb_sub_process
ON tb_record.sub_id=tb_sub_process.sub_id
LEFT JOIN tb_process
ON tb_sub_process.pro_id=tb_process.pro_id
WHERE tb_sub_process.sub_id = '$sub_id'";
$result2 = mysql_query($sql);
$row = mysql_fetch_assoc($result2);
$pro_name = $row['pro_name'];
$sub_name = $row['sub_name'];
?>
<html>
<head>
<script type="text/javascript" src="js/ajax.js"></script>
<script type="text/javascript" src="js/jquery-1.2.3.min.js"></script>
<script type="text/javascript">	

$(document).ready(function() {
$("#selectProcess").change(function() { 
	var processID = $(this).val();
	if(processID > 0)
	{
		$("#txtID").val(processID);
		$("#selectSubProcess").load('getSub.php?processID='+processID);
	}
});

$("#selectSubProcess").change(function() { 
	var subProcessID = $(this).val();
	if(subProcessID > 0)
	{
		window.location = 'main.php?sub_id='+subProcessID;
	}
});
});
</script>

</head>
<body>
<form action="" method="post">
<table>
	<tr>
		<td>Process: </td>
		<td>
		<select id="selectProcess" name="selectProcess">
		     	<option value="0" selected="selected">---SELECT PROCESS---</option>
		     	<?php 
			while ($row = mysql_fetch_array($result)) 
			{
			$process_id = $row['pro_id'];
			$process_name = $row['pro_name'];	
			$select = ($id == $process_id) ? 'selected="selected"' : NULL;  
			echo "<option value='$process_id' $select>$process_name</option>";
		        }
		        ?>
		</select>
		</td>
	</tr>
	<tr>
		<td>Sub Process: </td>
		<td>
			<select id="selectSubProcess" name="selectSubProcess" >
				<option>SELECT PROCESS FIRST</option> 
			</select>
		</td>
	</tr>
</table>
</form>
<table border=1>
<?php 
while($row = mysql_fetch_assoc($result2))
{
	extract($row);
	$imageDir1="images/".$rec_tpcd.".jpg";
	$info = @getimagesize($imageDir1);

	if((bool)$info)
	{
		$imageDir="images/".$rec_tpcd.".jpg";
	}
	else
	{
		$imageDir="images/NoPhoto.jpg";
	} 

	if ($col == 0)
	{
		$display .= "<tr>";
	}		

	$col++;
	if ($col == 1)
	{
		$col = 0;
		$display .= "</td>";
	}

	echo "<tr>
			<td>										
			<img src=$imageDir width='220' height='170' onClick=\"window.open('$imageDir', 'popup','height=500,width=800,scrollbars=yes,resizeable=yes status=yes'); return false\" target=\"_blank\"> 
			</td>
			<td>
				<table style='overflow:auto; width:325px;'>	
					<tr>
						<td width='80' valign='top'>Name</td>
						<td valign='top'>:</td>
						<td valign='top' colspan='2'>$rec_part</td>
					</tr>
					<tr>
						<td valign='top'>Code</td>
						<td valign='top'>:</td>
						<td valign='top' colspan='2'>$rec_code</td>
					</tr>													
					<tr>
						<td>TPCD</td>
						<td>:</td>
						<td colspan='2'>$rec_tpcd</td>
					</tr>
					<tr class='style15'>
						<td>Vendor</td>
						<td>:</td>
						<td colspan='2'>$rec_vendor</td>
					</tr>  
					<tr>
						<td>Location</td>
						<td>:</td>
						<td colspan='2'>$rec_location</td>
					</tr>
					<tr>
						<td>Remarks</td>
						<td>:</td>
						<td>$rec_remark</td>
						<td align='right'>
						<input type='image' name='change[$rec_tpcd]' src='library/cart add.png' width='20' height='20' value='Add To Order List >'/>
						</td>
					</tr> 
				</table>
			</td>
		  </tr>";
	}
	?>
</table>
</body>
</html>

getSub.php

<?php
require_once 'connectDB.php';

if(isset($_GET['processID']))
{
$process_id = $_GET['processID'];
$sql = " SELECT * FROM tb_sub_process WHERE pro_id = '$process_id' ORDER BY sub_id ASC";
$result = mysql_query($sql) or die(mysql_error());
$_SESSION['process_id'] = $process_id;
echo "<option>---------------------SELECTION--------------------</option>"; 
while($row = mysql_fetch_assoc($result))
{
	$sub_process_id = strtoupper($row['sub_id']);
	$sub_process_name = strtoupper($row['sub_name']); 
	echo "<option value='$sub_process_id'>$sub_process_name</option>";
}
}
?>

AGuyWithAthing · December 27, 2011

Either, you could make php print out a set of javascript variables representing the nested values or on each creation of the form elements kick off an ajax request to check if it should be set.

tayys · December 28, 2011

tq AGuyWithAthing

but where should I print out the set of javascript variables?

is there any relevant example I can refer to?

Sign In

how to retain the values in the sub process?

Recommended Posts

tayys

Link to comment

Share on other sites

AGuyWithAthing

Link to comment

Share on other sites

tayys

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information