Delete Message

[Dysan]

The first block of code displays information from a database.

Upon selecting a record using the check boxes, and after the delete button is clicked, the delete code is ran (second code block).

How do I display a "Deleted Successfully" message within the first block of code, upon records deleting successfully?

<?php
$con = mysql_connect("localhost","peter","abc123");
if(!$con) {
  die(mysql_error());
}

mysql_select_db("db", $con);

$result = mysql_query("SELECT * FROM person");

while($row = mysql_fetch_array($result)) {
    echo '<input type="checkbox" name="deletePerson[]" value="' . $row['id'] . '">';
    echo $row['FirstName'];
    echo $row['LastName'] . '<br /><br />';
}

mysql_close($con);
?>

<?php

$delete_person = $_POST['deletePerson'];

foreach($delete_person as $id) {
    mysql_query("DELETE FROM person WHERE id='$id'");
}

?> 

[roscor]

$delete_person = $_POST['deletePerson'];

foreach($delete_person as $id) {
    $query= "DELETE FROM person WHERE id='$id'";
}
$result=mysql_query($query);

if($result)
{
//do something
echo "Record successfully deleted";
} 
else
 {
//do something else, redirect back to page etc
echo "Record Not deleted try again";
}

[Dysan]

How do I display the message in the first block of code, not the second? 🙂

[roscor]

I would use the results from the Select and display them in a form which the user then selects using the checkboxes. On select the form would be directed to the next page where the second block of code is executed. I use this method with a third page, "Are you sure you want to delete this record". It all depends on who is deleting if its a moderator fine if its members who can delete records you need the correct permissions(mysql) etc.

[daredevil14]

Try this...

<?php 
$con = mysql_connect("localhost","peter","abc123"); 
if(!$con) { 
  die(mysql_error()); 
} 

mysql_select_db("db", $con); 

$result = mysql_query("SELECT * FROM person"); 

while($row = mysql_fetch_array($result)) { 
    echo '<input type="checkbox" name="deletePerson[]" value="' . $row['id'] . '">'; 
    echo $row['FirstName']; 
    echo $row['LastName'] . '<br /><br />'; 
} 

mysql_close($con); 

// ADD THIS

if ( isset($_GET["msg"]) )
  {
  echo $_GET["msg"];
  }
?> 

and in the second block :

<?php 

$delete_person = $_POST["deletePerson"]; 

foreach ( $delete_person as $id ) 
  { 
  $result = mysql_query("DELETE FROM person WHERE id='$id'"); 
  } 

// ADD THIS

if ( $result && $conn )
  {
  header("location: yourpage.php?msg=Deleted Successfully!!");
  }
  else
  {
  echo "Could Not Delete!!";
  }

?>