Jump to content


Photo

[SOLVED] deleting from sql and dir


  • Please log in to reply
4 replies to this topic

#1 corillo181

corillo181
  • Members
  • PipPipPip
  • Advanced Member
  • 896 posts

Posted 11 May 2006 - 12:02 AM

now this is something i'm clueless about.. i got to delete records from mysql with the get method, but how i do to delete from a dir anything a user has uploaded to a temp folder for the user..

#2 trq

trq
  • Staff Alumni
  • Advanced Member
  • 31,041 posts

Posted 11 May 2006 - 12:04 AM

Is there anything that difines which user owns whch files? Does each user have there own directory? You need to be more specific.

#3 Caesar

Caesar
  • Members
  • PipPipPip
  • Advanced Member
  • 1,025 posts

Posted 11 May 2006 - 12:24 AM

You need to be more specific...and at least show some sample code to give us an idea of what you're doing. It's not polite to expect the code to be written for you.

I suppose something like this, is what you have in mind:

<?php

 $query_file = mysql_query("SELECT * FROM files WHERE id = '$fileid' && userid = '$user_id'");

 $fileinfo = mysql_fetch_array($query_file);

 $name = $fileinfo[filename];

 $path = 'users/temp';

 $thefile = $path.$name;

 unlink($thefile);

 mysql_query("DELETE FROM files WHERE id = '$fileid' && userid = '$user_id'");

?>

I'm at work so...not tested, and not sure what method you are using to identify which file you are trying to delete....and so on.
PHP Ninja

#4 corillo181

corillo181
  • Members
  • PipPipPip
  • Advanced Member
  • 896 posts

Posted 11 May 2006 - 03:18 AM

sorry bout that guys...

but i try usng that code and it don't work.. this is how i did it..

<?php
include'../includes/db.php';
$dir='/userpic/';
$pic=$_GET['delpic'];
$delpath=$dir.$pic;
unlink($delpath);
$co="DELETE FROM userpic WHERE name='$pic'";
$cod=mysql_query($co);
$ed=mysql_fetch_array($cod);
header('Location: index.php');
?>


#5 corillo181

corillo181
  • Members
  • PipPipPip
  • Advanced Member
  • 896 posts

Posted 11 May 2006 - 05:03 AM

sorry the code i just showed does work.. [img src=\"style_emoticons/[#EMO_DIR#]/wink.gif\" style=\"vertical-align:middle\" emoid=\":wink:\" border=\"0\" alt=\"wink.gif\" /]




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users