- Code: Select all
<html>
<body>
<script type="text/javascript">
function lnth_fwd()
{
//alert(document.getElementById('lnthdet').value);
var lnth=document.getElementById('lnthdet').value;
window.location="psit_dpdw15-9-2012.php?lnth="+lnth;
}
function wdth_fwd()
{
var lnthkk=document.getElementById('lnth2').value;
var wdth=document.getElementById('wdth').value;
window.location="psit_dpdw15-9-2012.php?lnth="+lnthkk+"&wdth="+wdth;
}
function thkn_fwd()
{
var lnth4=document.getElementById('lnth4').value;
var wdth4=document.getElementById('wdth4').value;
var thkn=document.getElementById('thkn').value;
window.location="psit_dpdw15-9-2012.php?lnth="+lnth4+"&wdth="+wdth4+"&thkn="+thkn;
}
</script>
<?php
error_reporting(0);
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("store", $con);
$filter_length = mysql_query("select distinct(length) from vibrating_feeder_details ");
while($row = mysql_fetch_array($filter_length))
{
$lnth_det[] = $row['length'];
}
echo '<select name="lnthdet" id="lnthdet" onchange="return lnth_fwd();">
<option >select</option>';
for($ln=0 ; $ln < sizeof($lnth_det) ; $ln++){
echo '<option value='.$lnth_det[$ln].' >'.$lnth_det[$ln].'</option> '; }
echo '</select>';
if($_REQUEST[lnth])
{
$lnth2 = $_REQUEST[lnth];
//$qry2 = "select distinct width from vibrating_feeder_details where length = '$lnth2'";
$filter_thick2=mysql_query("select distinct width from vibrating_feeder_details where length = '$lnth2' ");
while($rowk2 = mysql_fetch_array($filter_thick2))
{
$width_thk3[] = $rowk2['width'];
}
echo '<input type="hidden" name="lnth2" id="lnth2" value="'.$lnth2.'">';
echo '<select name="wdth" id="wdth" onchange="return wdth_fwd();">
<option >select</option>';
for($thk3=0 ; $thk3 < sizeof($width_thk3) ; $thk3++){
echo '<option value='.$width_thk3[$thk3].'>'.$width_thk3[$thk3].'</option> '; }
echo '</select>';
}
//thkdet=400&wdth2=1500
//lnth=1500&wdth=300
if($_REQUEST[wdth])
{
$lnth4 = $_REQUEST[lnth];
$wdth4 = $_REQUEST[wdth];
$qry2 = "select distinct width from vibrating_feeder_details where length = '$lnth2'";
$filter_thick4=mysql_query("select distinct thickness from vibrating_feeder_details where length = '$lnth4' AND width = '$wdth4' ");
while($rowk4 = mysql_fetch_array($filter_thick4))
{
$thk_thk4[] = $rowk4['thickness'];
}
echo '<input type="hidden" name="lnth4" id="lnth4" value="'.$lnth4.'">';
echo '<input type="hidden" name="wdth4" id="wdth4" value="'.$wdth4.'">';
echo '<select name="thkn" id="thkn" onchange="return thkn_fwd();">
<option >select</option>';
for($thk5=0 ; $thk5 < sizeof($thk_thk4) ; $thk5++){
echo '<option value='.$thk_thk4[$thk5].'>'.$thk_thk4[$thk5].'</option> '; }
echo '</select>';
}
if($_REQUEST[thkn])
{
$lnth6 = $_REQUEST[lnth];
$wdth6 = $_REQUEST[wdth];
$thkn6 = $_REQUEST[thkn];
$sql = "select * vibrating_feeder_details where thickness=$_POST[select]";
//$res = mysql_query($sql);
//$row = mysql_fetch_array($res);
?>
<table width="90%" border="5">
<tr>
<td>length</td>
<td>width</td>
<td>thickness</td>
<td>Backsheetthickness</td>
<td>SpringRibsthickness</td>
<td>Sidepanelsthickness</td>
<td>BaseRibthickness</td>
<td>AllotherRibsthickness</td>
<td>SPthickness</td>
<td>SpringAnglesSathickness</td>
<td>TroughAngle</td>
<td>Troughheight</td>
<td>B1</td>
<td>Lw</td>
<td>Hbr</td>
<td>BxW</td>
<td>Fw</td>
<td>BxL</td>
<td>L</td>
<td>C</td>
<td>Nos</td>
<td>P</td>
<td>Q</td>
<td>R</td>
</tr>
<tr>
<td><?php echo $row['length'];?></td>
<td><?php echo $row['width'];?></td>
<td><?php echo $row['thickness'];?></td>
<td><?php echo $row['Backsheetthickness'];?></td>
<td><?php echo $row['SpringRibsthickness'];?></td>
<td><?php echo $row['Sidepanelsthickness'];?></td>
<td><?php echo $row['BaseRibthickness'];?></td>
<td><?php echo $row['AllotherRibsthickness'];?></td>
<td><?php echo $row['SPthickness'];?></td>
<td><?php echo $row['SpringAnglesSathickness'];?></td>
<td><?php echo $row['TroughAngle'];?></td>
<td><?php echo $row['Troughheight'];?></td>
<td><?php echo $row['B1'];?></td>
<td><?php echo $row['Lw'];?></td>
<td><?php echo $row['Hbr'];?></td>
<td><?php echo $row['BxW'];?></td>
<td><?php echo $row['Fw'];?></td>
<td><?php echo $row['BxL'];?></td>
<td><?php echo $row['L'];?></td>
<td><?php echo $row['C'];?></td>
<td><?php echo $row['Nos'];?></td>
<td><?php echo $row['P'];?></td>
<td><?php echo $row['Q'];?></td>
<td><?php echo $row['R'];?></td>
</tr>
</table>
<?php
}
?>
</body>
</html>
when selecting the 3rd drop down that row will retrieve and display in UI. I cant get the values.Please help me. Regards.
