Deleting files with php and removing the reference from mysql - Graphic Design Forum and Web Design Forum

jontywagener · #1 (**permalink**) 02-10-2007, 11:49 AM

Hi guys,

I have built a little gallery manager in PHP / MySQL. I have created it so that you upload files to the server using PHP and then you leave a reference to the image inside the MySQL database. That all works fine.

The fun comes when I want to delete the images, I would need to unset them from the folder on the server and would also need to remove the reference from the database.

Does anyone know how that could be done?? I sorta know what the script should contain but I do not really have an idea how it would be done.

thanks, bye bye

jontywagener · #2 (**permalink**) 02-10-2007, 02:13 PM

come on guys, please help...

James Jones · #3 (**permalink**) 02-10-2007, 02:15 PM

Haven't got a clue have you had a search on google

Kelly Creative · #4 (**permalink**) 02-10-2007, 02:17 PM

try a programming forum, mostly designers here

jontywagener · #5 (**permalink**) 02-10-2007, 02:18 PM

cool, cool...

Kimran · #6 (**permalink**) 02-10-2007, 02:23 PM

I had a quick scout around on google and couldn't find anything, sorry.

tepe · #7 (**permalink**) 02-10-2007, 07:21 PM

I know some SQL but I don't think I don't know how to help you..sorry =/

flick · #8 (**permalink**) 02-10-2007, 07:25 PM

these are the best links i've found for SQL yet, I use them all the time:
SQL Tutorial
SQL Topics
I think that specifically you should look at the DELETE statement (be careful though!)

jontywagener · #9 (**permalink**) 02-10-2007, 07:26 PM

cool, dont worry i figured it out all by myself... thanks for all the suggestions anyway

tepe · #10 (**permalink**) 02-10-2007, 07:28 PM

databases are quite fun and interesting actually..but it s*cks when there's a problem =)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Deleting backlink?	Acuity	Search Engines	3	27-02-2008 10:59 AM
Old WordPress plugins (removing)	PolarBear	General Web Design Forum	7	09-01-2008 03:20 PM
Clipping Path, Photoshop Masking, Removing Backgrounds from your Pictures!	ritchelclips	Advertising Forum	5	25-09-2007 06:14 AM
“Simpsons” Scenes and their Reference Movies	pablo795	Off Topic	0	23-09-2007 06:50 PM
Saving .MAX files with baked textures as .X files (or .3DS)	lalex48	Graphic Design and Web Design Help	0	28-06-2007 09:40 AM