[SOLVED] Link question

[pedrobcabral]

<a href="<?php $query_apagar = mysql_query("DELETE FROM contacto WHERE id = '1'");?>">Say hello</a>

 

Why does this code deletes the row when the page loads? It is supposed to only do it then I click on the link. Besides that if I have an echo "something.php" as the link, it will only go to the URL "something.php" after clicking, so I don't know why this different type of behaviour.

Any help? Thanks in advance.

[jscix]

place the code inside of a external file. whatever.php... then simply link to the file instead of using the code imbedded in the a href

[ivalmian]

Lol, all php code is executed at page load. If you want a row deleted only when you click the link you must have something along the lines of

 

main.html

<a href="delterow.php">Delete Row FTW!</a>

 

delterow.php

<?php $query_apagar = mysql_query("DELETE FROM contacto WHERE id = '1'");?>

[jscix]

and it's because the php processor isnt reading the HTML. the php processor begins when it sees <?php.....

 

 

it performs the action reguardless of what the html surrounding it does..

[pocobueno1388]

You can't do that with PHP....Do something like this:

 

<?php

if (isset($_GET['id'])){

    $id = $_GET['id'];
    mysql_query("DELETE FROM contacto WHERE id = '$id'")or die(mysql_error());

}
?>


<a href="<?php echo $_SERVER['PHP_SELF']; ?>?id=1">Say hello</a>

[pedrobcabral]

All the replies were pretty explanatory, pocobueno1388 nice way to deal with it.

Going also to follow your signature suggestion.