calling function from href

[jonathen]

Hi all,

If I am being incredibly dense, apologies - I am shattered, and just trying to get this script finished.

I have created a function that when called (via a href) will delete a particular record from the db.
This is the function:

function deleterec($id)
{
$link = mysql_connect("$db_host","$db_user","$db_pass");
mysql_select_db("$db_name",$link);
$query="DELETE from mytable WHERE id = '$id'";
echo "Record no. $id has been deleted!";
return $query;
}

Then to call it, I have a link (part of the loop that displays all records, and this link is below each record, specifying that record's ID)

echo "<a href=\"{$_SERVER['PHP_SELF']}" ."?action=deleterec&id=$id\">Delete record no. $id</a>"

I think I am missing something in the syntax, but my brain is too tired to comprehend what it is. Any ideas?

TIA

Jonathen

[keith73]

you posted code, but didn't say what the problem was. Where are you calling the function? keep in mind that you need an if or switch statement to read the value of action and then call the appropriate function. Tecnically, you can not call a function "via href".

• keith

[jonathen]

Ah sorry - the problem is that the page simply refreshes and doesn't delete that entry from the db.

So prehaps I need an "if action=deleterec do blah"?

Too tired... time for bed soon, methinks!

[Pig]

Yes,

something like

...com?delete=3

if( isset($delete)
{
deleterec($delete);
}

[jonathen]

Thanks for that 🙂

[Pig]

I forgot a ), but you get the idea.