[RESOLVED] Radio Button Selection and DB Array

[Cynthia_Blue]

I need to build a little page that quieries a Sybase Dabase, displays all the entries for the user, then allows the user to choose to either approve or deny each entry. Then click the button on the bottom. That'll trip a flag in the DB to say if each record is approved or denied.

So.. I'm using a while ($row = sybase_fetch_array($result)) in order to get all the entries and display them nicely in an HTML table for the user. Next to each entry I've put a radio button, one option to approve one option to deny. Then at the bottom there is a button to submit the information.

However when I submit, only the very last radio button value is passing.

How can I do this so it works? Any examples out there I could follow?

Of course I will not know how many entries are in the database at any given time, so it has to be a dynamic sort of display.

Thanks!

[bpat1434]

Well, how about this:

while($row = sybase_fetch_array($result))
{
  echo '<tr><td>'.$row['information'].'</td>
    <td>
      <input type="radio" name="decisions['.$row['id'].']" value="approve">Approve
    </td>
    <td>
      <input type="radio" name="decisions['.$row['id'].']" value="deny">Deny
    </td>';
}

Then, when you're processing you can do this (assuming $row['id'] will always be unique):

$decisions = $_POST['decisions'];

foreach($decisions as $id => $dec)
{
  $query = "UPDATE table SET ";
  $query .= ($dec == 'deny')?"status = 'deny'":"status='approve'";
  $query .= "WHERE id='$id'";
  $result = @mysql_query($result);
  if(@mysql_affected_rows($result)<1)
  {
    echo 'Error updating record id '.$id.'.  Moving to next record.<br><br>';
  }
  else
  {
    echo 'Record ID '.$id.' updated successfully.';
  }
}

Would something like that work?

Basically, you would name your radiobutton decisions[ROW_ID_NUMBER] which would make each radio set unique. Then, loop through each of the decisions to create the queries and execute them.

~Brett

[Cynthia_Blue]

That looks great thank you.. I will get my fingers into it deeper after lunch. 🙂

[Cynthia_Blue]

I probably just don't understand... but as long as I have the foreach statement inside the while loop, I get the data okay. But if I pull the foreach loop outside the while loop (such as on the 2nd page which does the processing) then it gives me the error:

Warning: Invalid argument supplied for foreach() in /vendor/approve.php on line 161

[bpat1434]

Well, this works:

<?php

if(isset($_POST['submit']))
{
	$decisions = $_POST['decisions'];
	foreach($decisions as $id=>$val)
	{
		echo 'ID: <strong>'.$id.'</strong> => Value: <em>'.$val.'</em><br>';
	}
}

?>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<?php
for($i=0; $i<11; $i++)
{
	echo $i.'<input type="radio" name="decisions['.$i.']" value="approve">Approve<br>'.
			 $i.'<input type="radio" name="decisions['.$i.']" value="deny">Deny<hr>';
}
?>
<input type="submit" name="submit" value="Submit">
</form>

It's a crude example, but it works.

~Brett