[Resolved] Deleting data from a database using php

hsob

I need to have a delete section for my database. I’m not exactly sure what to do ( I’m fairly new to php). Well I know I need to pick up the id of the item selected and store that id and then I can delete the row corresponding to that id. The problem is I’m not sure how I get to store the id and how I know the delete link is clicked on. I know this is very basic questions, I have looked around the net and I’m rather confused. Please help, thank you.

Norman_Graham

Hi Hsob

The MySQL for deletion is:

DELETE FROM mytable WHERE id='$id';

You need to pick up the ID from whatever the user clicks on. Is it a link? The id can either be hard-coded in the link:

<a href="delete.php?id=1">Delete item 1<a>

Or can be part of a form input. Either way, you pick up the variable using:

$id = $_GET["id"];

Or probably $_POST[] if you are using form input.

Does that answer your question?

Norm

hsob

Thank you for replying , ive posted some of my code below. The problem is when I click on the link for delete the id isnt carried on to that page at all. Do you know why?

<?php

$db = mysql_connect("", "", "");
mysql_select_db("",$db);

/ Performing SQL query /
$query = "SELECT * FROM CurrentlyShowing order by screen_number";
$result = mysql_query($query) or die("Query failed : " . mysql_error());

/ Printing results in HTML /
while ($myrow = mysql_fetch_row($result))
{

$filmid="$myrow[7]";
$film="$myrow[0]";
$rate="$myrow[5]";
$time="$myrow[1]";
$screen="$myrow[2]";
$link="$myrow[3]";
$image="$myrow[4]";

<table width="685">
<tr>
<td width="284">
<?php
echo("<br><b>$film</b></font>");
echo("  ($rate) <br>");
echo("Time of Showing: $time  <br>");
echo("In Screen: $screen <br>");
?>

  <b><font color="#FF0000">
  <a href="file:///Z:/public_html/cinema/owner/reviews.php"><font color="#FF0000">
  Review</font></a>&nbsp;&nbsp;&nbsp;&nbsp;
  <a href="file:///Z:/public_html/cinema/owner/reviews.php"><font color="#FF0000">
  Official Website</font></a></font></b>

</td>

<td align=center width="263">
<?php

echo("<br>&nbsp;&nbsp;<B>Image:</b> $image <br>");

?>
</td>

 <?php
	 echo("Filmid: $filmid <br>");
  ?>

	<a href="delete.php?filmID=$filmid">Click to delete</a>

</td>

</tr>
</table>

mikeatrpi

Change this:

<a href="delete.php?filmID=$filmid">Click to delete</a>

To this:

<a href="delete.php?filmID=<?=$filmid?>">Click to delete</a>

When you generate that link you're outside of the PHP tags so $filmid isn't getting replaced with the ID.

You can also do this:

<?php
echo '<a href="delete.php?filmID='.$filmid.'">Click to delete</a>';
?>

hsob

That is great, thank you very much for all yer help, Norman and Mikeatrpi