[Resolved] Delete image from db

kekke

Hi!

You guys have helped me a lot earlier with my posting-script and I really appreciate all the help I´ve got so far!

Now I really need help on my next problem. I have searched on the net and gone through tutorials and I have tried really hard by myself...but I can´t get it to work! 🙁

I want to be able to remove uploaded images from my "puffs".
Like a checkbox or a link!

The tablestructure is:

id = auto_increment id for the "puff"
title = as it says
text = content text
imagelocation = where the path to the image is stored
sortorder = here I can put an sortorder-number.

I have tried with code like this:

mysql_query("DELETE FROM mytable WHERE id='".$_GET['id']."'",$db);
?>

This didn´t work!

The page is an Update-page with a form and it works like when an image is browsed and I hit "Update" (submit) the image is uploaded to a folder on my server called "images". The path to the image is stored in the tablefield "imagelocation". I want to clear the path to the image in the specified id.

Would be very gratful if you could help me! Tell me if you need to see the whole code!

Thanks!

bubblenut

Well, debugging an sql query in a script whould always start with outputting the sql and the error so you can see exactly what's going on.

Change your code to this and post back with the results if it's no help.

<?php
$sql="DELETE FROM mytable WHERE id='".$_GET['id']."'";
mysql_query($sql, $db) or die($sql."<br />\n".mysql_error());
?>

Cheers
Bubble

kekke

Thanks Bubble!

But doesn´t i need some sort of link or something? I to remove the image when a link is clicked! I want to know how to do that!

Davy

I don't understand.

At first you say you want to designate an image for deletion using a checkbox, now you want to delete it using a link?

Well you can't use a POST variable for links - only GET variables. First of all check if the GET variable has anything in it. Id it does then take that ID number, plug into the SQL query then voila!

echo "<a href='delete.php?id=";
echo $id;
echo "'>Delete</a>";

This has the url of the page with the below code for deletion. The id number is dynamically creates for each file displays (there might be a list. If there is then you probably will want help with all of those. It probably includes a foreach loop or something.)

Now the deletion code on delete.php:

if (isset($_GET['id']))
 {
$id = $_GET['id'];
$sql="DELETE FROM mytable WHERE id=$id";
mysql_query($sql, $db) or die($sql."<br />\n".mysql_error());
 }

You can, however, have the above code on the same page you are using to select the file for deletion - just make sure the first code nippet points to the same page.

Basically - if a variable is in the URL upon loading, then something happens. If not then nothing happens.

If the ID is there, it deletes it. If not then it displays the list of deletable images.

However, me personally I try to never delete things. I prefer to have a column called 'show' and instead of deleting I set 'show' == '0' so that it would appear deleted.

Call it backup if you like!

kekke

Thanks for the reply Davy!

I´ll try your code. It really doesn´t matter if it is a checkbox or a link, as long as it works!

I let you all know the result soon..

kekke

It deleted the complete puff, I just want it to delete/clear the tablefield "Imagelocation".

In "Imagelocation" the path to the uploaded image is stored, is it possible to clear only that? Is there a way to assign an other id to it?

Worth mentioning could be that the "finnished" page I post to is built almost like a newspage, the content that I post becomes like news items and every item gets an ID.

Davy

Oh bugger ok...

Use an INSERT to change just the column you want to change and set it to be '' which is nothing surrounded by single quotes.

Is that what you wanted to do? Delete the image path?

Or did you want to delete the image path as well as the image?

Oooh this is gettin more complicated with each reply :?

EDIT: made changes to sql and post them below:

if (isset($GET['id']))
{
$id = $GET['id'];
$sql="UPDATE mytable SET imagelocation='' WHERE id=".$id."';
mysql_query($sql, $db) or die($sql."<br />\n".mysql_error());
}

kekke

Hi!

Got an error message:

"Parse error: parse error, unexpected '>' in /my/path/delete.php on line 9"

And here is the code:

<HTML> 

<?php 
$db = mysql_connect("localhost", "username", "password"); mysql_select_db("my_db"); 
if (isset($_GET['id'])) 
{ 
$id = $_GET['id']; 
$sql="UPDATE mytable SET imagelocation='' WHERE id=".$id."'; 
mysql_query($sql, $db) or die($sql."<br />\n".mysql_error());
}
?>
</HTML>

Sound like a great idea doing it this way! I just need the path to be cleared, the image itself does not need to be deleted from the server!

bubblenut

Missed your closing double quote on the query.

$sql="UPDATE mytable SET imagelocation='' WHERE id=".$id."'";

I think you could have got that one yourself really. Anyway, have a look at [man]unset()[/man] for deleting the image from the filesystem as well.

cahva

$sql="UPDATE mytable SET imagelocation='' WHERE id=".$id."'";

Heh.. Still wrong 🙂 Add simplequote or remove it..:

$sql="UPDATE mytable SET imagelocation='' WHERE id='".$id."'";

kekke

HOLY COW!!! IT WORKED!

Thanks guys... reeeaallyy appreciated!

Bubblenut, sorry, I did really missed to look there. I was just looking for a ">". I´ll looke more closer next time!

Thanks again guys! You´re the best! 🙂