Simple PHP problem with checkboxes

[davestacey]

Hi,

I would be very grateful for anyone's help on this!
I have a php script that displays data from a SQL database in rows

E.G:

Name - Address - Age - Height - Weight - etc - [ ] (& a checkbox)

it successfully displays the data in rows, with a checkbox on the end.

I would like to be able to tick some checkboxes and then post only 'that' data to a new page

this is the code that i have on that page:

<form name="form" method="post" action="print.php">

$query = "SELECT * FROM database where field = '$value' ORDER BY id desc";
$result = mysql_query($query) or die("Query failed");
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
foreach ($line as $col_value) {
$x++;

if ($x == 1) { $id = $col_value; }
if ($x == 2) { $name = $col_value; }
if ($x == 3) { $age = $col_value; }
etc...

}

print "<table><tr>";
print "<td>$name</td>";
print "<td>$age</td>";
print "<td valign=top><input type=text name=id[] multiple value=$id>";
print "<input type=checkbox name=print[] multiple></td>";
print "</tr>\n";

$x = 0;
}

<input type="submit" value="Print" name="form">
</form>

I understand that it builds the data into an array, but im stuck, as to how you then display the array on the new page.

i did try this and it worked:

$POST['id'][0],$POST['print'][0]
$POST['id'][1],$POST['print'][1]
$POST['id'][2],$POST['print'][2]
$POST['id'][3],$POST['print'][3]

but what if i have a 100 rows and i select 100 rows, that would mean i would have to repeat the above code 100 times.

so really what i require is, if 30 rows are posted to the new page, then the ID of the 30 rows is grabbed and then put through a new loop, to display the new data.

any help very much appricated!!!
Thanks
Dave!

[TF_TheMoon]

You need to use a loop. Depending on how you want the results to appear depedns how i'd do it but this will loop printing the ID of the ones where the print value was ticked

for ( $i = 0; $i <= count($_POST['id']); $i++ ) {
  if( $_POST['print'][$i] ) {
     echo $_POST['id'][$i]."<br />";
  }
}

[devinemke]

<?php
// connect to db here

if (!isset($_POST['submit']))
{
	$result = mysql_query("SELECT * FROM database WHERE field = '$value' ORDER BY id DESC") or exit(mysql_error());
	echo '
	<form action="" name="form" method="post">
	<table>
	';
	while ($row = mysql_fetch_assoc($result))
	{
		echo '
		<tr>
		<td>' . $row['name'] . '</td>
		<td>' . $row['age'] . '</td>
		<td>' . $row['id'] . '</td>
		<td><input type="checkbox" name="print[]" value="' . $row['id'] . '"></td>
		</tr>
		';
	}
	echo '
	</table>
	<input type="submit" name="submit" value="Print">
	</form>
	';
}
else
{
	if (isset($_POST['print']))
	{
		echo 'you checked the following rows:<br><br>';
		foreach ($_POST['print'] as $value) {echo $value . '<br>';}
	}
	else
	{
		echo 'you did not check any rows';
	}
}
?>

[davestacey]

thanks to both of you, but especially devinemke!

Your solution worked!

   if (isset($_POST['print']))
    {
        echo 'you checked the following rows:<br><br>';
        foreach ($_POST['print'] as $value) {echo $value . '<br>';}
    }
    else
    {
        echo 'you did not check any rows';
    }

this now outputs the id's onto the new page.

Now my last problem is putting the id's from the result into a new loop to pull the name and address and output them on the new page.

any samples of code please?

[davestacey]

HOLD THE PHONE !!

i just sussed it......

        if (isset($_POST['print']))
    {
        echo 'you checked the following rows:<br><br>';
        foreach ($_POST['print'] as $value) {
echo "<table>";

$query = "SELECT * FROM flyers where `id` = '".$value."' ORDER BY id desc";
$result = mysql_query($query) or die("Query failed");
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
foreach ($line as $col_value) {
$x++;

if ($x == 1) { $id = $col_value; }
if ($x == 2) { $name = $col_value; }
if ($x == 3) { $age = $col_value; }
if ($x == 4) { $mobile = $col_value; }
if ($x == 5) { $email = $col_value; }
if ($x == 6) { $school = $col_value; }
if ($x == 7) { $address = $col_value; }
if ($x == 8) { $comments = $col_value; }
if ($x == 9) { $powerhouse = $col_value; }
if ($x == 10) { $assigned = $col_value; }
if ($x == 11) { $emailed = $col_value; }
if ($x == 12) { $posted = $col_value; }

}
if($emailed=="0") { $emailImage = "../images/email.gif"; } else { $emailImage = "../images/email_sent.gif"; }

print "<tr onMouseOver=\"this.style.backgroundColor='#EFEFEF';\" onMouseOut=this.style.backgroundColor=\"#FFFFFF\">\n";
print "<td valign=top>$name</td>\n";
print "<td valign=top class=f10>$address</td>\n";
print "</tr>\n";
print "<tr><td height=1 bgcolor=#DDDDDD colspan=13></td></tr>\n";


$x = 0;
}

echo "</table>";
        }
    }
    else
    {
        echo 'you did not check any rows';
    }

my very last question is......

how do you display 3 results in 3 rows across and then the rest down?

e.g:

name1..................................name2..........................name3
address1..............................address2.......................address3

name 4.................................name5..........................name6
address4..............................address5......................address6

Thanks again!!!

[devinemke]

davestacey wrote:

Now my last problem is putting the id's from the result into a new loop to pull the name and address and output them on the new page.

on the second page you have all of the ID's ready to go. you don't need another loop to do the queries. in fact you really shouldn't. why do 30 queries when you can just do 1 like this:

$sql = 'SELECT * FROM flyers WHERE id IN(' . implode(',', $_POST['print']) . ') ORDER BY id DESC');

quite honestly, i wouldn't even bother requerying the db at all. just store the privious results in a session.

[davestacey]

Thanks i'll take your advice on that!

any ideas on how to make results display in 3 rows across and the rest down?

name1..................................name2..........................name3
address1..............................address2.......................address3

name 4.................................name5..........................name6
address4..............................address5......................address6

Thanks again!!!!!!!!!