delete checkbox

cmpennington

I am trying to find a way to dynamically generate a delete checkbox beside each condolence message that I receive for a deceased person. Here is the codee that I have been using, but it only deletes all the condolences for the person selected. I am trying to individually delete each record, or multiple delete them.

Any help with this will be most greatly appreciated.

// display individual record

if ($id) {

$result = mysql_query("SELECT * FROM condolenceone WHERE id=$id",$db);

printf("<center><i><font size=3>Online Condolences</I></center><font size=5><center><b>%s\n</center></b></font><center><hr size=4 width=300 color=black></center><br>", $Fullname);

If($myrow = mysql_fetch_array($result)){
do{

printf("<table width=500 align=center><tr><td>%s</td></tr><tr><td> </td></tr><tr><td><font size=2><i>From</i> <b>%s</b><i> at</i> (%s)</td></tr><tr><td><font size=2><i>Location:</i> %s<br></font></td></tr><tr><td><input type=checkbox name=delete value=$delete>Delete This Condolence<hr></hr></td></tr></table>\n", nl2br($myrow["cond_message"]), $myrow["cond_name"], $myrow["cond_email"], $myrow["cond_city"]);

if ($delete="YES") { echo "CHECKED"; }
}

   while ($myrow = mysql_fetch_array($result));

echo "<form action=deletetwo.php?id=$id& method=post>";
echo "<center><input type=submit value=\"Remove Condolences\"><center></form><br>";

} else {

// no records to display

  echo "<center><font size=4 color=red><b>No Condolences Are Currently Available.</center></b></font>";	

}

} else {
echo "<p align=center><font size=6 color=green><b>Condolence System</b></font></p>";
// show employee list

$result = mysql_query("SELECT * FROM employees ORDER BY date DESC LIMIT 7",$db);

if ($myrow = mysql_fetch_array($result)) {

  // display list if there are records to display

echo "<CENTER><TABLE CELLPADDING=5 CELLSPACING=0 WIDTH=500><TR BGCOLOR=#000000><TD ALIGN=left WIDTH=150><B><FONT FACE=Garamond SIZE=3 COLOR=#FFFFFF>Last Name</FONT></B></TD><TD ALIGN=CENTER WIDTH=150><B><FONT FACE=Garamond SIZE=3 COLOR=#FFFFFF>Full Name</FONT></B></TD><TD ALIGN=center WIDTH=150><B><FONT FACE=Garamond SIZE=3 COLOR=#FFFFFF>Date</FONT></B></TD></TR><br>";
do {

    printf("<tr><td align=left>%s</td><td align=center><a href=\"%s?id=%s&Fullname=%s\">%s</a></td><td align=center>%s</td></tr>\n", $myrow["last"], $PHP_SELF, $myrow["id"], $myrow["Fullname"], $myrow["Fullname"], $myrow['date']);

  } while ($myrow = mysql_fetch_array($result));
} else {




// no records to display

  echo "Sorry, no records were found!";	

}

}

barand

You could try something like this, maybe.

Give each message its own id
name each checkbox with the message id instead of calling all of them 'delete'.
[/list=1]

hth

cmpennington

what would the code look like to give each condolence an id?
I mean how does the code look to dynamically do this?

printf("<table width=500 align=center><tr><td>%s</td></tr><tr><td> </td></tr><tr><td><font size=2><i>From</i> <b>%s</b><i> at</i> (%s)</td></tr><tr><td><font size=2><i>Location:</i> %s<br></font></td></tr><tr><td>%s <hr></hr></td></tr></table>\n", nl2br($myrow["cond_message"]), $myrow["cond_name"], $myrow["cond_email"], $myrow["cond_city"],

$myrow["cond_message_id"]);

I am having trouble putting your idea onto paper, but you are surely on a better track than I.
Thanks again!

cmpennington

one other thing?
is there a way to still encorporate the checkbox delete into your idea?

barand

You would add an auto-increment field to your condolance table so that as each new message is added it gets a unique id. When you query the table to list messages, select this id too.

I f you have, say, two messages with checked check boxes named 123 and 124, clicking a submit button with name=action and value=delete should send

mypage.php?action=delete&123=Yes&124=Yes

Now you know which individual messages to delete.

hth

cmpennington

I am trying to figure out how to dynamically create these checkboxes, I am guessing that I have to have some sort of counter within my loop to increase the value portion of the checkbox statement, or some sort of array?
{
<input type=checkbox name=$delete[] value= ?????>
}

Any code or ideas would be a huge help. my brain is fried and my feet are planted in concrete??
thanx, cmpenington

barand

Assuming you have added the extra field, say cond_id, to give each condolence message a unique id, then where you have this

<input type=checkbox name=delete value=$delete>Delete This Condolence

put

<input type=checkbox name=$myrow["cond_id"] value=$delete>Delete This Condolence

(As you've used prinf it'll actually be name=%s with $myrow["cond_id"] as another arg., but you get the idea)

cmpennington

How will I get the stuff out with my delete.php program?
I am not able to get the data into the [url]http://....header.[/url]

It shows:
http://www.bpafuneralhome.com/gate/deletetwo.php?id=144&cond_id=

144 is the case number of the deceased person, cond_id is the actual condolence, each has a unique id?

Heeeelpppp!😕

barand

Do you have to have multiple deletes or would you be happy to delete, replenish list, delete ..etc

cmpennington

barand,
I think that multiple deletes would be the most efficient and the best way to do this. The page is set up like this:

Condolences for Jon Doe

Dear, john blah blah blah..
from peggy (Peggy@net.com)
[] Delete This Condolence

John,
I really am sorry about your brother.....
from Al (Al@somewhere.com)
[] Delete This Condolence

Mr. Doe,
Sorry............
from Ben (Ben@here.net)
[] Delete This Condolence

[Submit Button]

And by the way, I really do appreciate your taking the time to help with this problem.

barand

Back to your idea of check boxes named delete[].

Heres a sample script to test out what you want to do

<?php
if (isset($delete)) foreach($delete as $k=>$v) {
	echo "DEL $k = $v<br>";
	// $sql = "delete from condolence where cond_id=$v";
	}
?>
<html>
<!-- Creation date: 04/11/02 -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Test check boxes</title>
<meta name="Description" content="">
<meta name="Keywords" content="">
<meta name="Author" content="Barand">
<meta name="Generator" content="AceHTML 4 Pro">
</head>
<body>
<FORM ACTION="<?=$PHP_SELF?>" METHOD="get">
	<!-- your check box would be :
	<input type="checkbox" name="delete[]" value="<?=$myrow["cond_message_id"]?>"> Delete this condolence<br> 
	-->
	<input type="checkbox" name="delete[]" value="123"> 123<br>
	<input type="checkbox" name="delete[]" value="124"> 124<br>
	<input type="checkbox" name="delete[]" value="125"> 125<br>

<INPUT TYPE="submit" value="go"> 
</FORM> 
</body>
</html>