Click on link to delete or insert?

[IDontKnow]

Is it possible to delete from or insert into a database, just by clicking on a link?

Thanks for your help.

Mada

[daphreeek]

yes - but it isnt the link doing the work, its php.

make a link like this:

<a href="myfile.php?delete=1&id=3">Delete Entry 3</a>
<a href="myfile.php?edit=1&id=3">Edit Entry 3</a>

The delete=1 means to delete (the script in myfile.php will check if delete=1 or edit=1). the id=3 means it will edit the entry with id=3

Here is some code to do this:

if ($delete == "1") {
    $sql = "DELETE FROM table WHERE id='$id'";
    $result = mysql_query($sql);
}else if ($edit == "1") {
   if ($submit == "1") {
      $sql = "UPDATE table SET text='$text' WHERE id='$id'";
      $result = @mysql_query($sql);
   }else{
      $result = mysql_query("SELECT * FROM table WHERE id='$id'",$db);
      $myrow = mysql_fetch_array($result);

  echo "<form method=\"post\" action=\"myfile.php?edit=1&submit=1&id=$id\">";
  echo "<textarea name=\"text\">". $myrow["text"] ."</textarea>";
  echo "<input type=\"submit\" name=\"Save\">";
  echo "</form>";
   }
}else{
    // myfile body here
}

Edit it a bit - but thats about all you need 🙂

• Matt

[IDontKnow]

Thanks for the quick reply. Will try it.

Thanks again.

Mada