[RESOLVED] Checkbox and input box form

scuzzo84

I have a form where you select a room from a building then you get a list of software. You then check off which software titles will be added to that room. The checkboxes have the software id as its value. I then take the array and expode it and add it to the table "softroom" which is:

softroom [rid, sid, added] , room id, software id, and date that it was added

I now want to add a feature where you enter how many software copies will be used on that classroom. So again the same process, select building, then pick the room, then get the list of software to add to that room but now there will be an input on each software title row for inputting how many copies will be used.

Im stuck as far as how to do this. So far I have added a field to "softroom" , which is "used" which will tell how many copies of the software will used in that class.

softroom [rid, sid, used, added]

My problem is how to process the input box part as far as how its linked to the checkbox, because the checkbox has the software id and I need that in order to INSERT the 2 main values checked/inputted into the "softroom" table

softroom [5, 2, 36, 20060327]
softroom [rid, sid, used, added]

Houdini

If it is a form problem then post the form.

scuzzo84

here is my code

 


/////////STEP 3//////////////////////
if ($_POST['sub2']){
$rid = $_POST['room'];
$query = "SELECT * FROM software ORDER BY title";
$result = pg_query($query);
$numrows = pg_num_rows($result);
if ($numrows < 1){
echo "<p id=editbad>No records!</p>";
}else{
echo "<p id=edithead>Step 3. Pick software to add to room</p>";
echo "<FORM action=$self method=post>";
echo "<table>";
echo "<tr><input type=hidden name=rid value=$rid>
<td $cell><p id=edithead>Add</p></td><td $cell><p id=edithead>Title</p></td><td $cell><p id=edithead>Version</p></td>
<td $cell><p id=edithead>License</p></td><td $cell><p id=edithead>Copies</p></td><td $cell><p id=edithead>Using</p></td></tr>";
while ($row = pg_fetch_assoc($result)){
$id = $row['id'];
$title = $row['title'];
$uname = $row['uname'];
$version = $row['version'];
$ltype = $row['ltype'];
$lnum = $row['lnum'];
echo "<tr><td $cell><input type=checkbox name=software[] value=$id></td><td $cell><p id=hsub>$title</p></td>
<td $cell><p id=hsub>$version</p></td><td $cell><p id=hsub>$ltype</p></td><td $cell><p id=hsub>$lnum</p></td>
<td $cell><p id=hsub><input type=text name=used></p></td></tr>";
}
echo "<tr><td colspan=3 $cell><input type=submit name=sub3></td></tr>";
echo "</table></FORM>";
}
}

if ($_POST['sub3']){
$softwares = implode(",",$_POST['software']);
//$softwares = $_POST['software'];
$rid = $_POST['rid'];

echo "<p id=editbad>Are you sure you want to add this/these?</p>";
// Testing passing values for arrays....yay
echo "<br><br>$rid $softwares<br><br>";
echo "<a name=sub1>";
echo "<form action=$self method=post><input type=hidden name=rid value=$rid><input type=hidden name=software value=$softwares><input type=submit name=sub4 value=Yes></form>";
echo "<META HTTP-EQUIV=Refresh CONTENT=\"0; URL=$self#sub1\">";
}

if ($_POST['sub4']){
$softwares = explode(',', $_POST['software']);
$rid = $_POST['rid'];
foreach($softwares as $sw){
$date = date("Ymd");
$query = "INSERT INTO softroom (rid,sid,added) VALUES ('$rid','$sw','$date')";
$result = pg_query($query);
}
echo "<a name=sub2>";
echo "<p id=editbad>Added! <a href=$self>Click here to refresh page</a></p><br>";
echo "<META HTTP-EQUIV=Refresh CONTENT=\"0; URL=$self#sub2\">";
}

Houdini

First of all your code produces no output evedently because it is dependant on another file somewhere else and the proper way to post a form to it self without failing is

 action="<?php echo $_SERVER['PHP_SELF']; ?>">

if their is other code somewhere that refers to that code then you might want to show it also.