[RESOLVED] Having Trouble with passing variables from forms

steve_m2

Hi everyone,

I hope I can explain clearly, but I am having trouble with trying to figure out how to pass variables from a dynamic form. I have this form where I select everything from MySQL database. I have the form display every row with a check box, and the value in the check box I have it echo a column from the database. What I want it to do is when the check box is checked (how ever many I have checked) and I submit the form, I want to be able to pass all of the information from the database row to another page. So let’s say that I have 5 items checked, I want to pass those 5 checked items and all of information in those rows and be able to call that information on the next page. I just can't seem to figure out on how to do this. I'm not very good with loops and I think I need to use one, but I don't know which one and how. Would somebody be able to point me in the right direction?

bpat1434

----> Some like to go this way ---->
<---- Others like to go this way <----
<---- Or you could always go both ways ---->
(Sorry, Wizard of Oz moment....)

Okay, so if the checkboxes are given a name like: row[] in the form, then in your code you'd loop through the sub-array of POSTed data and query the database for each result. So your check-boxes look like:

<input type="checkbox" name="row[]" value="_row_id_from_mySQL_row_">

So, in the next form when it's submitted, row will be an array of all the mySQL row IDs of the selected items. So, if you selected 5 items, you'd loop through the POST['row'] array:

$query = 'SELECT * FROM `table` WHERE ';
foreach($_POST['row'] as $rowid)
{
    $query .= "id='".$rowid."' OR";
}
// Nifty trick... the last "OR" becomes "ORDER"...
$query .= "DER BY id ASC";

And then you'd go on from there....

Houdini

$query = ("SELECT bud,ice,mgd,lite FROM beer WHERE first_name='$first' AND last_name='$last'");
$result = mysql_query($query)
	or die("Could not execute query".mysql_error());	
while($row=mysql_fetch_array($result)){
  extract($row);
  if($bud=="1"){
  echo"I like Budweiser. <input type='checkbox' name='beer[bud]' value='bud' checked='checked'><br />"; 
}
  else{
  echo"I like Budweiser. <input type='checkbox' name='beer[bud]' value='bud'><br />";   

	}

The above extract a boolean 0 or 1 and depending on the result will either output a checked check box or and un checked one, you should be able to modify it for your purposes. The if else statements for the other values would be similar.

bpat1434

while($row=mysql_fetch_array($result)){
  extract($row);
  if($bud=="1"){
  echo"I like Budweiser. <input type='checkbox' name='beer[bud]' value='bud' checked='checked'><br />";
}
  else{
  echo"I like Budweiser. <input type='checkbox' name='beer[bud]' value='bud'><br />";   

    }
} // <-- Oopsy...

can be reduced to:

while($row=mysql_fetch_array($result)){
  extract($row);
  if($bud=="1"){ $checked = 'checked'; }
  else{ $checked = ''; }

  echo"I like Budweiser. <input type='checkbox' name='beer[bud]' value='bud' ".$checked."><br />";   

}

steve_m2

Thanks a lot guys. That did the trick. You have helped me out a bunch.