Confirmation upon delete

-Karl-

What I want to do is have a confirmation page between the deletion of the MySQL record, I want to have buttons, one saying "Yes" one saying "No". No will redirect to the previous page and Yes will continue with the deletion of the record, by the ID selected in editskill.php.

But I can't figure out how to do this without JavaScript and without making another 20+ files for each different page I have. Because I have editnews.php as well plus others which I want to be able to delete with a confirmation.

If anyone could help I'd appreciate it.

I have editskill.php

<th width="100%"><left><font color="#FFFFFF" size="1"><b><a href="editskill.php?id={$arr['id']}">{$arr['guidename']}</a></b></font></left>
<th><font color="#FFFFFF" size="1"><b><form action="deleteskill.php" method="post">
<input type="hidden" name="id" value="{$arr['id']}">
<input type="Submit" value="Delete">
</form>

I also have deleteskill.php

<?php
$con = mysql_connect("*");

if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("*", $con);

$sql="DELETE FROM skills WHERE `id` = '$_POST[id]'";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "<font color='#FFFFFF' size='2'>1 record deleted</font>";

mysql_close($con)
?>

rincewind456

I would amend your deleteskill.php it like this

<?php

#If delete button set check for confirmation
if (isset($_POST['delete'])) {

$id = (int) $_POST['id'];
?>
<p>Are you sure you want to delete this record</p>
<form method="post" action="deleteskill.php">
<input type="hidden" name="id" value="<?php echo $id; ?>">
<input type="submit" value="Yes" name="yes">
<input type="submit" value="No" name="no">

</form>
<?php
}
#If no redirect to edit page
if (isset($_POST['no'])) {
	header("Location: editskill.php");
}
#if yes do delete
if (isset($_POST['yes'])) {

$id = mysql_real_escape_string($_POST['id']);

$con = mysql_connect("*");

if (!$con)
{
	die('Could not connect: ' . mysql_error());
}
mysql_select_db("*", $con);

$sql="DELETE FROM skills WHERE `id` = '$id'";

if (!mysql_query($sql,$con))
{
	die('Error: ' . mysql_error());
}
echo "<font color='#FFFFFF' size='2'>1 record deleted</font>";

mysql_close($con);
}
?>

You would need to add a name attribute to your delete button like

<input type="Submit" name="delete" value="Delete">

for it to work

-Karl-

When I click No I get

Warning: Cannot modify header information - headers already sent by (output started at /home/karl/public_html/contentdev/deleteskill.php:8) in /home/karl/public_html/contentdev/deleteskill.php on line 37

and when I click Yes I get

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'nobody'@'localhost' (using password: NO) in /home/karl/public_html/contentdev/deleteskill.php on line 42

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in /home/karl/public_html/contentdev/deleteskill.php on line 42
1 record deleted

It says it was deleted, but doesn't delete it and the database information is all there and correct.

-Karl-

I've fixed the deleting, it's just the redirect, which won't work as I already have one in the file.

-Karl-

Fixed it all, thanks a lot for your help 🙂