PHP Delete Record Issue

#1 (**permalink**) 08-13-2008, 03:14 AM

I've set up a simple database for adding event news to a site. I'm pretty new
to PHP, but I have the Insert, Update, and Display pages working properly.
However the Delete Record page is being a big pain. I have it set up just as it
explains in Dreamweaver Help, as well as a tutorial i am using as a backbone
for this project. Its a form with a hidden filed that is dynamically pulling my
ID. I have the Delete behavior pointing at the same ID and record set.

My Delete link is properly setting up a dynamic page with the title of record
to be deleted showing up just fine. Also, the redirect page is correct after
hitting the Delete button. Which makes me believe the issue is happening in
somewhere in the behavior. None of my records are being deleted when I go back
to the Display page. They are still there. Im pointing the behavior at my
Primary record so im not sure what's going on. I'm a first-timer to this. Any
help would be much appreciated.

Here is my code:

<?php require_once('Connections/connPRHevents.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "",
$theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

$theValue = function_exists("mysql_real_escape_string") ?
mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" :
"NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}

if ((isset($_POST['DateID'])) && ($_POST['DateID'] != "")) {
$deleteSQL = sprintf("DELETE FROM events WHERE DateID=%s",
GetSQLValueString($_POST['DateID'], "int"));

mysql_select_db($database_connPRHevents, $connPRHevents);
$Result1 = mysql_query($deleteSQL, $connPRHevents) or die(mysql_error());

$deleteGoTo = "events.php";
if (isset($_SERVER['QUERY_STRING'])) {
$deleteGoTo .= (strpos($deleteGoTo, '?')) ? "&" : "?";
$deleteGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $deleteGoTo));
}

$colname_Events = "-1";
if (isset($_GET['DateID'])) {
$colname_Events = $_GET['DateID'];
}
mysql_select_db($database_connPRHevents, $connPRHevents);
$query_Events = sprintf("SELECT * FROM events WHERE DateID = %s",
GetSQLValueString($colname_Events, "date"));
$Events = mysql_query($query_Events, $connPRHevents) or die(mysql_error());
$row_Events = mysql_fetch_assoc($Events);
$totalRows_Events = mysql_num_rows($Events);
?><html>
<head>

<title>Pretty Hurt</title>

<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<style type="text/css">

</style>
<script type="text/javascript">

</script>

</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"
onLoad="MM_preloadImages('images/medicgear_over.gif','images/apparel_over.gif','
images/accessories_over.gif','images/newproducts_over.gif','images/home_over.gif
','images/crutches_over.gif','images/events_over.gif','images/contact_over.gif')
">

<table width="900" height="920" border="0" align="center" cellpadding="0"
cellspacing="0" id="Table_01">
<tr>
<td width="187" height="239" background="images/PHR_Site_01.jpg"><img
src="images/PHR_Site_01.jpg" width="187" height="239" border="0"
usemap="#Map"></td>
<td width="616" height="239" background="images/PHR_Site_02.jpg"> </td>
<td width="97" height="239" background="images/PHR_Site_03.jpg"> </td>
</tr>
<tr>
<td>
<img src="images/PHR_Site_04.jpg" width="187" height="25" alt=""></td>
<td>
<img src="images/PHR_Site_05.jpg" width="616" height="25" alt=""></td>
<td>
<img src="images/PHR_Site_06.jpg" width="97" height="25" alt=""></td>
</tr>
<tr>
<td height="229" background="images/PHR_Site_07.jpg"> </td>
<td>
<img src="images/banner.jpg" width="616" height="229" alt=""></td>
<td width="97" height="229" background="images/PHR_Site_09.jpg"> </td>
</tr>
<tr>
<td valign="top" background="images/PHR_Site_10.jpg"
class="norepeat"> </td>
<td height="370" align="center" valign="top" bgcolor="#FFFFFF"><table
width="616" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="33" align="center" bgcolor="#01BAEF"><a href="index.html"
onMouseOut="MM_swapImgRestore()"
onMouseOver="MM_swapImage('Home','','images/home_over.gif',1)"><img
src="images/home.gif" alt="Home" name="Home" width="72" height="30"
border="0"></a><a href="crutches.html" onMouseOut="MM_swapImgRestore()"
onMouseOver="MM_swapImage('Crutches','','images/crutches_over.gif',1)"><img
src="images/crutches.gif" alt="Crutches" name="Crutches" width="101"
height="30" border="0"></a><a href="apparel.html"
onMouseOut="MM_swapImgRestore()"
onMouseOver="MM_swapImage('Apparel','','images/apparel_over.gif',1)"><img
src="images/apparel.gif" alt="Apparel" name="Apparel" width="101" height="30"
border="0"></a><a href="accessories.html" onMouseOut="MM_swapImgRestore()"
onMouseOver="MM_swapImage('Accessories','','images /accessories_over.gif',1)"><im
g src="images/accessories.gif" alt="Accessories" name="Accessories" width="140"
height="30" border="0"></a>  <a href="events.php"
onMouseOut="MM_swapImgRestore()"
onMouseOver="MM_swapImage('Events','','images/events_over.gif',1)"><img
src="images/events.gif" alt="Events" name="Events" width="86" height="30"
border="0"></a><a href="forms/contact.php" onMouseOut="MM_swapImgRestore()"
onMouseOver="MM_swapImage('Contact','','images/contact_over.gif',1)"><img
src="images/contact.gif" alt="Contact" name="Contact" width="87" height="30"
border="0"></a>  </td>
</tr>
</table>
<br>
<br>

<table width="550" height="86" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top"><p><?php echo $row_Events['Title']; ?></p>
<form name="form1" method="post" action="events_delete.php">
<p>
<input type="submit" name="button" id="button" value="Delete">
<input name="DateID" type="hidden" id="DateID" value="<?php echo
$row_Events['DateID']; ?>">
</p>
</form> <p> </p></td>
</tr>
</table>
<br>
<table width="600" height="18" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="18"> </td>
</tr>
</table>
</td>
<td> </td>
</tr>
<tr>
<td>
<img src="images/PHR_Site_13.gif" width="187" height="25" alt=""></td>
<td width="616" align="center" valign="top"
background="images/PHR_Site_14.gif" class="style6">Pretty Hurt.
Northern/Southern California. 949-355-4607. <a href="policy.html">Privacy
Policy</a> | <a href="forms/support.php">Support</a></td>
<td>
<img src="images/PHR_Sit

#2 (**permalink**) 08-23-2008, 08:06 PM

Hi

I was reading your post and realized that I had the same troubles the first
time I tried to setup a record deletion page.

I hope the following helps.

What I ended up doing was to set up 3 pages..
1) a user list page of all users in the users table
2) a confirmation page to show user info
3) a delete page which does the actual deletion

This first page was a simple repeat region table showing the entire list of
users in the database table. I linked the username to the conformation page
with a simple URL Parameter to isolate the user I want to delete

Here is the code

<a href="admin_users_delconfirm.php?id=<?php echo $row_rsUsers['id']; ?>

The on the confirmation page I have a delete button graphic which is linked to
the delete page in the same way.

Code:
<a href="admin_users_delete.php?id=<?php echo $row_rsUsers['id']; ?>

Finally on the delete page I applied the" delete record" server behaiviour so
that the deletion is done when the page loads. You can also have it redirect
back to the master list of users when the deletion is done.

It may seem a little redundant to have 3 pages, but the purpose of the 2nd
page is to give the user an opportunity to change their mind and also to remind
them that the delete action cannot be undone.

I hope this helps you.

Good Luck and Good Coding!

#3 (**permalink**) 08-31-2008, 04:43 AM

On Aug 23, 3:06 pm, "SaigonJeff" <webforumsu...@macromedia.com> wrote:
> Hi
>
> I was reading your post and realized that I had the same troubles the first
> time I tried to setup a record deletion page.
>
> I hope the following helps.
>
> What I ended up doing was to set up 3 pages..
> 1) a user list page of all users in the users table
> 2) a confirmation page to show user info
> 3) a delete page which does the actual deletion
>
> This first page was a simple repeat region table showing the entire list of
> users in the database table. I linked the username to the conformation page
> with a simple URL Parameter to isolate the user I want to delete
>
> Here is the code
>
> <a href="admin_users_delconfirm.php?id=<?php echo $row_rsUsers['id']; ?>
>
> The on the confirmation page I have a delete button graphic which is linked to
> the delete page in the same way.
>
> Code:
> <a href="admin_users_delete.php?id=<?php echo $row_rsUsers['id']; ?>
>
> Finally on the delete page I applied the" delete record" server behaiviour so
> that the deletion is done when the page loads. You can also have it redirect
> back to the master list of users when the deletion is done.
>
> It may seem a little redundant to have 3 pages, but the purpose of the 2nd
> page is to give the user an opportunity to change their mind and also to remind
> them that the delete action cannot be undone.
>
> I hope this helps you.
>
> Good Luck and Good Coding!

Hi,

Sorry to just barge in here but I am having a bit of an issue with
this same scenario. I have it all working but have run in to an issue
where the page will not re-direct to the userlist.php (original list
of users) because the header info has already been sent by the time
the delete page is reached. The code that is causing this issue is the
redirect code i.e. header(sprintf("Location: %s", $deleteGoTo)); Just
wondering if youu have experienced this type of problem and if so,
perhaps you can share your experience with it in how you solved it. It
seems trivial but it is very frustrating.

Here is the php error I am getting:

[30-Aug-2008 20:51:20] PHP Warning: Cannot modify header information
- headers already sent in /usr/web/home/fsmgroup.zuka.net/docs/site/
admin/delete.php on line 44

thanks for any help.

Dave

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode