Forum Moderators: coopster
<html>
<head></head>
<body>
<div id= "tableSelection" >
<form name = "form1" method="post" >
Select the operation you want to perform <br />
<select name="actionToPerform">
<option value= "1" >Enter Recycling Information for Bottles and Cans</option>
</select><br /><br/><br/>
<input type="submit" value="submitMainPage" name="submit">
<input type="hidden" name="form1" value="1"/>
</form>
</div>
<div id="getRowDetails" style="display:none">
<form name = "form2" method="post">
Select The Month :<br />
<select name="Month">
<option value= "1" >January</option>
<option value= "2" >February</option>
<option value= "3" >March</option>
<option value= "4" >April</option>
<option value= "5" >May</option>
<option value= "6" >June</option>
<option value= "7" >July</option>
<option value= "8" >August</option>
<option value= "9" >September</option>
<option value= "10" >October</option>
<option value= "11" >November</option>
<option value= "12" >December</option>
</select><br /><br/><br/>
Select The Year : <br />
<select name="Year">
<option value= "1" >2010</option>
<option value= "2" >2011</option>
<option value= "3" >2012</option>
<option value= "4" >2013</option>
<option value= "5" >2014</option>
<option value= "6" >2015</option>
<option value= "7" >2016</option>
<option value= "8" >2017</option>
<option value= "9" >2018</option>
<option value= "10" >2019</option>
<option value= "11" >2020</option>
<option value= "12" >2021</option>
</select><br /><br/><br/>
Select The Number of records you want to Enter:<br />
<select name="noOfRecords">
<option value= "1" >1</option>
<option value= "2" >2</option>
<option value= "3" >3</option>
<option value= "4" >4</option>
<option value= "5" >5</option>
<option value= "6" >6</option>
<option value= "7" >7</option>
<option value= "8" >8</option>
<option value= "9" >9</option>
<option value= "10" >10</option>
<option value= "11" >11</option>
<option value= "12" >12</option>
</select><br /><br/><br/>
<input type="submit" value="submitUpperLevelData" name="submitDetails">
<input type="hidden" name="form2" value="1"/>
</form>
</div>
<div id="submitAggregateData" style="display:none">
<form name = "form3" method="post">
<input type='submit' value='submitAgrregateData' name='submitDetails'>";
</form>
</div>
<?php
if (array_key_exists('form1', $_POST))
{
$actionToPerform = $_POST["actionToPerform"];
?>
<script language="javascript">
document.getElementById("getRowDetails").style.display = "block";
</script>
<?php
}
if(array_key_exists('form2', $_POST))
{
$NoOfRec = $_POST["noOfRecords"];
?>
<script language="javascript">
document.getElementById("getRowDetails").style.display = "block";
</script>
<?php
$db="sustain";
$host = "example.edu";
$username = "username";
$password = "password";
$link = mysql_connect('deleted', 'deleted', 'deleted');
if (! $link) die(mysql_error());
mysql_select_db($db , $link) or die("Couldn't open $db: ".mysql_error());
$resultBusinessConnections = mysql_query("select ID,Name from Business_Connections;");
$VendorNameArray = array();
while($nt=mysql_fetch_array($resultBusinessConnections))
{
$VendorNameArray[$nt[ID]] = $nt[Name];
}
echo "</br>";
echo "<table>";
echo"<tr>";
echo"<td>Vendor</td>";
echo"<td>Date</td>";
echo"<td>Net Weight</td>";
echo"</tr>";
for($i=1;$i<=$NoOfRec;$i++)
{
echo "<tr>";
echo"<td>";
echo "<select name = '$i'.'s'>";
foreach($VendorNameArray as $ID => $Name)
{
echo "<option value = '$ID'>$Name</option>";
}
echo "</select>";
echo"</td>";
echo"<td>";
echo "<input type='text' name = '$i'.'d'>";
echo"</td>";
echo"<td>";
echo "<input type='text' name = '$i'.w>";
echo"</td>";
echo "</tr>";
}
echo "<input type='submit' value='submitAgrregateData' name='submitDetails'>";
echo "</table>";
}
?>
</body>
[edited by: coopster at 11:12 am (utc) on Oct 11, 2010]
[edit reason] user/password details changed [/edit]
