[RESOLVED] How to get results from this?

MitchEvans

How do I get the results for these radio buttons, when they are passed to a new page:

dotbob

try this:

if($_POST) {
  foreach($_POST as $key=>$value) {
    echo $key." : ".$value."<br>";
  }
}

MitchEvans

Unfortunately that doesn't work however this does:

foreach($_POST['myradio'] as $radio){
$try="<br>" . $radio . "\n";
echo $try;

But I want to be able to check the values of the checkboxes singly, so I can see what is in each one. How would I do this?

dotbob

Ahh sorry Mitch, failed to see that you were using arrays as the field names.

First off, if you move the {$productRow1['id']} outside of the encompassing brackets then that will label your field names correctly. So for example (if $productRow1['id'] is equal to 123):

name='myradio{$productRow1['id']}[]' will give a form field with the name of 'myradio123'

then within php you can use this code to retrieve the selected value of the radio:

foreach($_POST as $fieldname=>$resultarray) {
	echo $fieldname." - ".$resultarray[0]."<br>";
}

If i'm still on the wrong track then I do apologise, the first cup of coffee hasn't yet hit the system 🙂

acey

i think ive said this before , i think the reason why you are only getting one result is because radio buttons are named the same , maybe you could use an array?

MitchEvans

I think we're on the right lines now.
I need an "X" to appear in the correct box on the results page depending on which one has been chosen from the 3 options.

Code:

echo"<tr><td><strong>1 - Operational</strong></td></tr>";
$productsql1 = "SELECT * FROM survey WHERE rtid=1";
$productResults1 = mysql_query($productsql1);
while ($productRow1 = mysql_fetch_array ($productResults1)){
$ProductName1 = $productRow1["requirement_txt"];

echo"
<tr>
<td>$ProductName1</td>
<td><center><strong>$s</strong></center></td>
<td><center><strong>$t</strong></center></td>
<td><center><strong>$u</strong></center></td>
<td>Module 1</td>
</tr>";}

Where $s, $t and $u are an "X" should appear depending on which one has been chosen.

I had this code ofr it before but it won't work:

if ($radio == "Currently In Place") {
$s= "X";
}
elseif ($radio == "Required Essential") {
$t = "X";
}
else {
$u= "X";
}

MitchEvans

Tried this:

if ($resultarray[0] == "Currently In Place") {
$s= "X";
}
elseif ($resultarray[0] == "Required Essential") {
$t = "X";
}
elseif ($resultarray[0] == "Required-Recommended") {
$u= "X";
}}

This just puts an "X" in every cell of the table under the one specified instead of just one cell.
Eg.
When "Currently in Place" is chosen all the cells under the heading "currently in place" have an X in them.

dotbob

try unsetting the vars at the beginning of every loop i.e.

while($blah = $blah) {
unset($s,$t,$u);
if ($resultarray[0] == "Currently In Place") {
$s= "X";
}
elseif ($resultarray[0] == "Required Essential") {
$t = "X";
}
elseif ($resultarray[0] == "Required-Recommended") {
$u= "X";
}
}

MitchEvans

The cells just show blank with this code.

foreach($_POST as $fieldname=>$resultarray) {
echo $fieldname." - ".$resultarray[0]."<br>";

while($blah = $blah) {
unset($s,$t,$u);
if ($resultarray[0] == "Currently In Place") {
$s= "X";
}
elseif ($resultarray[0] == "Required Essential") {
$t = "X";
}
elseif ($resultarray[0] == "Required-Recommended") {
$u= "X";
}}}

Where should this code be in here, at the moment it all goes before it?

echo"
<tr>
<td>$ProductName1</td>
<td><center><strong>$s</strong></center></td>
<td><center><strong>$t</strong></center></td>
<td><center><strong>$u</strong></center></td>
<td>Module 1</td>
</tr>";}
echo"<tr><td><strong>2 - Financial</strong></td></tr>";
$productsql = "SELECT * FROM survey WHERE rtid=2";
$productResults = mysql_query($productsql);
while ($productRow = mysql_fetch_array ($productResults)){
$ProductName = $productRow["requirement_txt"];

echo "

<tr>
<td>$ProductName</td>
<td><center><strong>$s</strong></center></td>
<td><center><strong>$t</strong></center></td>
<td><center><strong>$u</strong></center></td>
<td>Module 2</td>
</tr>";}
echo"<tr><td><strong>3 - Health And Safety</strong></td></tr>";
$productsql2 = "SELECT * FROM survey WHERE rtid=3";
$productResults2 = mysql_query($productsql2);
while ($productRow2 = mysql_fetch_array ($productResults2)){
$ProductName2 = $productRow2["requirement_txt"];

echo"
<tr>
<td>$ProductName2</td>
<td><center><strong>$s</strong></center></td>
<td><center><strong>$t</strong></center></td>
<td><center><strong>$u</strong></center></td>
<td>Module 3</td>
</tr>";}

void_function

Unlike checkboxes, radio button names are not arrays, but instead the name becomes variable containing the value of selected radio button in PHP:

<input type="radio" name="samename" value="1"> Select for 1
<input type="radio" name="samename" value="2"> Select for 2
<input type="radio" name="samename" value="3"> Select for 3
<input type="radio" name="samename" value="4"> Select for 4

Then, if method was post, $_POST['samename'] will contain the value of selected button, or null if nothing selected. So in order to assing dynamic values to radio buttons:



$res= mysql_query ("SELECT id, category_name FROM table_with_categories");
$num= mysql_num_rows($res);

for ($i=0; $i<$num; $i++) {
  $row= mysql_fetch_array ($res);

  // Set first radio as selected by default
  if ($i==0) $sel=' selected ';
  else $sel= '';

  echo "<input {$sel}type=\"radio\" name=\"somename\" value=\"{$row['id']}\"> {$row['category_title']}<br>";
}

Of course substitute the query to reflect actual table structure, and substitue the name of radio group for some meaningful name. Use that same name in $_POST[''] when you retrieve selected radio button. Enclose the loop in apropriate form.

MitchEvans

I'm actually using check boxes but users will not be able to choose more than one box or it won't work (that's fine though).

Just want to get the "X" in the correct cell on the second page. The results echo fine I just need to put them into an if statement and make it work:

foreach($_POST as $fieldname=>$resultarray) {
echo $fieldname." - ".$resultarray[0]."<br>";

This doesn't work unfortunately, maybe there has to be a separate statement for each heading in my table?

void_function

Why on earth do you use checkboxes if you want only one value selected?! There are radio buttons for that, and the selected value is nicely available in $_POST['somename']:


// building upon example given above with radio buttons

$s= $t= $u= '';

if ($_POST['somename']==1) $s= 'X';
else if ($_POST['somename']==2) $t= 'X';
else if ($_POST['somename']==3) $u= 'X';

// Echo $s, $t and $u in appropriate table cells here

MitchEvans

I don't think that would work unfortunately as I have an array on my POST. It doesn't bring back all the details, I did try that way yesterday.

void_function

If users can only select one item, use radio buttons and you won't have to use any arrays.

MitchEvans

I think I have to have an array as this is some of my code, it loops round and gets a different $ProductName each time:

echo"
<FORM method='POST' action='friday1.php'><table border=1><tr>
<td>Requirement Type</td><td>Currently In Place</td><td>Required-Essential</td><td>Required-Recommended</td></tr>";
echo"<tr><td><strong>1 - Operational</strong></td></tr>";
$productsql1 = "SELECT * FROM survey WHERE rtid=1";
$productResults1 = mysql_query($productsql1);
while ($productRow1 = mysql_fetch_array ($productResults1)){
$ProductName1 = $productRow1["requirement_txt"];

echo"
<tr>
<td>$ProductName1</td>
<td><INPUT type='checkbox' name='myradio{$productRow1['id']}[]' value='Currently In Place'></td>
<td><INPUT type='checkbox' name='myradio{$productRow1['id']}[]' value='Required Essential'></td>
<td><INPUT type='checkbox' name='myradio{$productRow1['id']}[]' value='Required-Recommended'></td></tr>
</tr>";}
echo"<tr><td><center><img src='add.jpg'><a href='addnew.php'>Add New Item</a></center></td></tr><tr><td><strong>

MitchEvans

This echoes what results have been posted perfectly:

foreach($_POST as $fieldname=>$resultarray) {
echo $fieldname." - ".$resultarray[0]."<br>";}

So what would be the if and elseif statement for the above results, i have:

while($blah = $blah) {
$s='';
$t='';
$u='';
if ($resultarray[0] == "Currently In Place") {
$s= "X";
}
elseif ($resultarray[0] == "Required Essential") {
$t = "X";
}
elseif ($resultarray[0] == "Required-Recommended") {
$u= "X";
}}

The code below puts an "X" in everysingle cell.

Visit the problem here www.ecsonline.co.uk/friday.php

void_function

What you're trying to do is FAR more easier to do with radio buttons, plus you have native control that only ONE item is selected, otherwise you need Javascript.
If you so stubbornly insist to use checkboxes, then the checkboxes need to have, like radio buttons, SAME NAME, but with added brackets:

Only the SELECTED checkboxes will appear in the resulting somename[] array. They will become elements of that array containing their VALUE.
To see which were selected you need to loop through EACH of the array elements and see their respective values:

$s= $t= $u= '';

foreach ($_POST[somename] as $key => $val) {
  if ($val=='Currently in Place') $s='X';
  else if ($val=='Required Essential') $t='X';
  else if ($val=='Required-Recommended') $u='X';
}

MitchEvans

I'm afraid the above doesn't work. If you visit the site maybe you can appreciate what i'm trying to do. It seems strange that I can echo the values so why can't I just put them in an if statement.

MitchEvans

If you have time i would appreciate if you could look at my entire code for this page. Maybe i'm just putting things in the wrong place:

foreach($_POST as $fieldname=>$resultarray) {
echo $fieldname." - ".$resultarray[0]."<br>";

if ($resultarray[0] == "Currently In Place") {
$s= "X";
}
elseif ($resultarray[0] == "Required Essential") {
$t = "X";
}
elseif ($resultarray[0] == "Required-Recommended") {
$u= "X";
}}

echo"
<table border='1'><tr>
<td>Requirement Type</td><td>Currently In Place</td><td>Required-Essential</td><td>Required-Recommended</td><td>i-Clean Solution</td></tr>";
echo"<tr><td><strong>1 - Operational</strong></td></tr>";
$productsql1 = "SELECT * FROM survey WHERE rtid=1";
$productResults1 = mysql_query($productsql1);
while ($productRow1 = mysql_fetch_array ($productResults1)){
$ProductName1 = $productRow1["requirement_txt"];

echo "

echo"
<tr>
<td>$ProductName2</td>
<td><center><strong>$s</strong></center></td>
<td><center><strong>$t</strong></center></td>
<td><center><strong>$u</strong></center></td>
<td>Module 3</td>
</tr>";}
echo"<tr><td><strong>4 - Human Resources</strong></td></tr>";
$productsql3 = "SELECT * FROM survey WHERE rtid=4";
$productResults3 = mysql_query($productsql3);
while ($productRow3 = mysql_fetch_array ($productResults3)){
$ProductName3 = $productRow3["requirement_txt"];

echo"
<tr>
<td>$ProductName3</td>
<td><center><strong>$s</strong></center></td>
<td><center><strong>$t</strong></center></td>
<td><center><strong>$u</strong></center></td>
<td>Module 4</td>
</tr>";}
echo"<tr><td><strong>5 - General</strong></td></tr>";
$productsql4 = "SELECT * FROM survey WHERE rtid=5";
$productResults4 = mysql_query($productsql4);
while ($productRow4 = mysql_fetch_array ($productResults4)){
$ProductName4 = $productRow4["requirement_txt"];

echo"
<tr>
<td>$ProductName4</td>
<td><center><strong>$s</strong></center></td>
<td><center><strong>$t</strong></center></td>
<td><center><strong>$u</strong></center></td>
<td>Module 4</td>
</tr>";}

?>
</BODY>
</HTML>

void_function

I'm afraid the above doesn't work.

No, it works perfectly. I've selected first three checkboxes, from first three rows, distinctly, and got this:

myradio1 - Currently In Place
myradio2 - Required Essential
myradio3 - Required-Recommended

Which is correct, given that the checkbox groups for those three rows were myradio1, myradio2 and myradio3 respectively. And since you have dynamic NAMES of the arrays, you need to put that too into the loop, so you need a loop inside the loop.