Using checkboxes instead of a link

[Paul Morrison]

Hi,

On my site I give users to option to subscribe to certain articles. When
they choose to subscribe the necessary addition is made to the database.
When they go to the Unsubscribe section it lists the articles that they are
subscribed to and gives a link next to it letting them unsubscribe. However,
rather than having the text, I want to have a checkbox instead. Then I want
to have a button at the bottom that when clicked unsubscribes them from any
articles whose checkbox is ticked. This is similar to the way that My eBay
works, if you are still unclear.

Is there an easy way of doing this? I know that it can be done, but dont
know how, so any help would be much appreciated!

Cheers,

Paul

[Paul Morrison]

Sorry, meant to put in the code that I am using:

<?php
// Make table if member has specific injustice subscriptions
$sql = "SELECT i.type, i.title , s.inj_id FROM inj_subscription s,
injustices i WHERE s.member_id = '$user' AND i.inj_id = s.inj_id AND
s.inj_id IS NOT null" ;
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result) ;
if ($row) {
echo "<div><span>Specific Injustice Subsriptions:</span><br/>" ;
$table_start ='<table width="90%" align="center" cellspacing="0"
border="0">
<tr>
<th width="20%">Type</th>
<th width="70%">Title</th>
<th width="10%"></th>
</tr>';
echo $table_start;
$rownum = 0;
while($row) {
$rownum++;
$style = rowcolor($rownum);
$table_rows = "<td id=\"td\" align=\"center\" style=\" $style
;padding:5px\" >" .$row['type'] . "</td>";
$table_rows .= "<td id=\"td\" align=\"center\" style=\" $style
;padding:5px\" >" . $row['title']. "</td> \n\t";
$table_rows .= "<td id=\"td\" align=\"center\" style=\" $style
;padding:5px\" ><a href=\"stop_subscription.php?id=" . $row['inj_id'] .
"\">Unsubscribe</a> </td>\n\t";
echo "<tr>" . $table_rows . "</tr>";
$row = mysql_fetch_assoc($result) ;
}
echo '</table><Br/></div><br/>';
}
?>

[noone]

Paul Morrison wrote:

Sorry, meant to put in the code that I am using: <?php
// Make table if member has specific injustice subscriptions
$sql = "SELECT i.type, i.title , s.inj_id FROM inj_subscription s,
injustices i WHERE s.member_id = '$user' AND i.inj_id = s.inj_id AND
s.inj_id IS NOT null" ;
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result) ;
if ($row) {
echo "<div><span>Specific Injustice Subsriptions:</span><br/>" ;
$table_start ='<table width="90%" align="center" cellspacing="0"
border="0">
<tr>
<th width="20%">Type</th>
<th width="70%">Title</th>
<th width="10%"></th>
</tr>';
echo $table_start;
$rownum = 0;
while($row) {
$rownum++;
$style = rowcolor($rownum);
$table_rows = "<td id=\"td\" align=\"center\" style=\" $style
;padding:5px\" >" .$row['type'] . "</td>";
$table_rows .= "<td id=\"td\" align=\"center\" style=\" $style
;padding:5px\" >" . $row['title']. "</td> \n\t";
$table_rows .= "<td id=\"td\" align=\"center\" style=\" $style
;padding:5px\" ><a href=\"stop_subscription.php?id=" . $row['inj_id'] .
"\">Unsubscribe</a> </td>\n\t";
echo "<tr>" . $table_rows . "</tr>";
$row = mysql_fetch_assoc($result) ;
}
echo '</table><Br/></div><br/>';
}
?>
instead of using<a href=\"stop_subscription.php?id=" . $row['inj_id'] .

"\">Unsubscribe</a>

use
<input type="checkbox" name=deletethis[] value=" . $row['inj_id'] .

where deletethis[] is an array of row id's that you pass to
stop_subscription and delete all of the id's in the array for multiple
id's if you only want them to do one at time then remove the [] from
deletethis.

[Paul Morrison]

> instead of using

<a href=\"stop_subscription.php?id=" . $row['inj_id'] .

"\">Unsubscribe</a>

use <input type="checkbox" name=deletethis[] value=" . $row['inj_id'] .

where deletethis[] is an array of row id's that you pass to
stop_subscription and delete all of the id's in the array for multiple
id's if you only want them to do one at time then remove the [] from
deletethis.

Hi,

I have now changed it to be

$table_rows .= "<td id=\"td\" align=\"center\" style=\" $style
;padding:5px\" ><input type="checkbox" name=deletethis[] value=" .
$row['inj_id'] . "\"></td>\n\t";

but it will not accept this, the page doesnt load. Is there something that I
am missing, or am I doing it the wrong way?

Cheers,

Paul

[noone]

Paul Morrison wrote:

instead of using

<a href=\"stop_subscription.php?id=" . $row['inj_id'] . "\">Unsubscribe</a>

use <input type="checkbox" name=deletethis[] value=" . $row['inj_id'] .

where deletethis[] is an array of row id's that you pass to
stop_subscription and delete all of the id's in the array for multiple
id's if you only want them to do one at time then remove the [] from
deletethis.

Hi, I have now changed it to be $table_rows .= "<td id=\"td\" align=\"center\" style=\" $style
;padding:5px\" ><input type="checkbox" name=deletethis[] value=" .
$row['inj_id'] . "\"></td>\n\t"; but it will not accept this, the page doesnt load. Is there something that I
am missing, or am I doing it the wrong way? Cheers, Paul

reformated for readability

$table_rows .= "<td id=\"td\" align=\"center\" style=\"". $style;
$table_rows .= "padding:5px\" ><input type=\"checkbox\" name=deletethis[]";
$table_rows .= " value=\"" . $row['inj_id'] . "\"></td>\n\t";
hopefully I got all of the missing quotes and dots.

[Ryan Lange]

noone wrote:

reformated for readability

$table_rows .= "<td id=\"td\" align=\"center\" style=\"". $style;
$table_rows .= "padding:5px\" ><input type=\"checkbox\" name=deletethis[]";
$table_rows .= " value=\"" . $row['inj_id'] . "\"></td>\n\t";

hopefully I got all of the missing quotes and dots.

You missed a few quotes in there (that's why I refuse to use
double-quotes for outputting HTML):

$table_rows .=
'<td id="td" align="center" style="' . $style . 'padding:5px">' .
'<input type="checkbox" name="deletethis[]"' .
' value="' . $row['inj_id'] . '"></td>' . "\n\t";

This will only return the boxes that are checked, so once you get
the array from the unsubscribe page, you'll need to get the original
list from the database, compare the two, then delete the ones that
appear in the original list, but not in the new list.

- Ryan