Hi
I have a mysql database table, for which I wish to allow my users to add, edit and delete their record.
Add and edit are ok, but when the user tries to delete their record, they should be prompted by a confirmation box. If they press OK, then it should go ahead and delete, however, if they press cancel, it should not delete, but return them to the home page.
Currently, the OK button works fine, but if the user presses cancel, they are re-directed to the home page, but the record is still deleted.
Here is the code:
<?php
$database = "Istanbul";
$host="localhost";
$link = mysql_connect($host)or die ("Couldn't connect");
mysql_select_db($database,
?>
<html>
<head>
<title>Unsubscribe</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<head>
<style type="text/css">
<!--
-->
</style>
<link href="Tan.css" rel="stylesheet" type="text/css">
</head>
</head>
<body bgcolor="#FFFF66">
<?
if (!$_POST['unsubscribe']) {
?>
<center>
<form method="post" action="" name="theForm">
<table border=1 cellpadding=10 cellspacing=0 bgcolor = white>
<tr>
<td>
<font size=+1><b>Unsubscribe</b>
</td>
</tr>
<tr>
<td>
Enter email: <input name="email" type="text" value="">
</td>
</tr>
<tr>
<td colspan=2 align=center>
<input type="submit" name="unsubscribe" value="Unsubscribe" >
</td>
</tr>
</table>
</form>
</center>
<?php
}
if ($_POST['unsubscribe'])
{
$email1 = trim($_POST['email']);
if ( empty($email1))
{
$error = true; // input validation failed
echo "<span style=\"color:red\">Error!
?>
<p>Click <a href="javascript:history.g
<?
}
else if (!empty($email1))
{
$sql = "SELECT email FROM mailinglist WHERE email = '$email1'";
$result = mysql_query($sql, $link) or die ("Couldn't execute query");
while($a_row=mysql_fetch_r
{
foreach($a_row as $field)
$user = "$field";
}
if ($user)
{
?>
<script type="text/javascript">
var answer = confirm ("Are you sure you want to unsubscribe?")
if (answer==false)
window.location="mainFrame
else
</script>
<?php
$query = "DELETE FROM mailinglist WHERE email LIKE '".$email1."' LIMIT 1";
$result = mysql_query($query, $link) or die ("Couldn't add the data");
if ($result)
{
echo "Success";
}
else
{
echo "<span style=\"color:red\">Error!
?>
<p>Click <a href="javascript:history.g
<?
}
}
else if (!$user)
{
echo "<span style=\"color:red\">Error!
?>
<p>Click <a href="javascript:history.g
<?
}
}
} // End if post ok conditional
?>
</body>
</html>
Thank you for looking!
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
when you ask the user to confirm using javascript, if they press cancel and so the returned value is false, you can then set a hidden field in your form to a value, then you can submit the form.
you then check for this hidden value and if its set to "1" for example which means its ok to delete then you can allow your delete statement to execute.
here are some snippets to explain what i said
.....
var answer = confirm ("Are you sure you want to unsubscribe?")
if (answer==false)
document.theForm.delFlag = 0
document.theForm.submit()
.....
<input type="hidden" name="delFlag" value="1" />
.....
this would have to go before any HTML output
if ($_POST["delFlag"] == 1) {
.. delete statement
} else {
Header('Location: mainFrame.htm')
}
Business Accounts
Answer for Membership
by: swingerPosted on 2004-03-18 at 20:53:15ID: 10630469
well, i think you have an misunderstanding about what PHP does.
ALL PHP CODE IS EXECUTED WHEN THE PAGE SENDS TO YOU.
that is when you see the javascript to ask for confirmation. The record is already deleted!
For your question, I suggest you ask the confirmation in the page that people choose unsubsribe.
(ie, the page which submitted the form to this page).