Sending a certain cell from the database to another PHP page

Question

I am trying to send a specific cell to a PHP page and deleting that row which contains this specific cell. But it appears I am doing something wrong.

This is how I sending the information:

echo "<td><a href='delete.php?id= '$row['pid']''>Delete</a>< /td>";

and using it like this:

$del = "DELETE FROM sca WHERE pid =  $_GET['id']";

My database connections are working well but I couldn't manage to send the 'pid' integer to a PHP page.

Thanks

score 0 · Accepted Answer · edited May 23 '17 at 10:24

0

Probably you misstiped some character. Try with this :

        echo "<td><a href='delete.php?id=".$row['pid']."'>Delete</a></td>"; 
        echo '<td><a href="delete.php?id='.$row['pid'].'">Delete</a></td>'; 
        echo "<td><a href='delete.php?id={$row['pid']}'>Delete</a></td>";

Try to keep this code mixture (html and php) readable or improve it for future changes and revisions.

Make sure to receive correct value in $row['pid'].

Also as advice you should protect your data and clean it before any db interaction.

edited May 23 '17 at 10:24

Community

1
1

answered Nov 05 '13 at 00:46

Alejandro Quiroz

2,604
1
15
17

Thanks, the first one you write is working and sending the value correctly. Do you have a solution for the delete operation that I made? – Poyraz Sagtekin Nov 05 '13 at 01:07
Typo again, the answer should be : $del = "DELETE FROM sca WHERE pid='{$_GET['id']}'"; – Poyraz Sagtekin Nov 05 '13 at 01:43

Sending a certain cell from the database to another PHP page

1 Answers1