how to delete image from directory

[fifin04]

Hi there..

Okay I just make update page and it works okay and my problems is how to delete the old image from directory if I just upload/update a new image into my site...here''s the code I'm using

 $intro_txt    = mysql_escape_string($_POST['intro_txt']);

$id = $_GET["id"];

/////////img upload portion//////////////////

$uploadDir = "img/"; 
$uploadfile = $uploadDir . $_FILES['filename']['name'];  

if (move_uploaded_file($_FILES['filename']['tmp_name'], $uploadfile)) 
{ 
     $imagename = $_FILES['filename']['name'];	      
} 


/////////////////////////////////////////////

 $dbhostname = "localhost";
 $dbusername = "root";
 $dbpassword = "";
 $dbname = "somedtbase";

 $db = mysql_connect($dbhostname, $dbusername, $dbpassword);
 mysql_select_db($dbname, $db) or die("ERROR: Cannot connect to the database");

 //////////////////////////////////////////////
 //if imagename is none
 if( $imagename == "" or $imagename == 'none'){
     $query = "UPDATE introduction SET textintro='$intro_txt',timedate = NOW()
	           WHERE id = '$id'";

     $result = mysql_query($query);
 }else{
//it'll replace the oldimage with new image in dtbase but how to delete the old image in directory
	 	 $query = "UPDATE introduction SET textintro='$intro_txt',imgname ='$imagename',
		           timedate = NOW() WHERE id = '$id'";

     $result = mysql_query($query);
 } 

Hope some shed on light on this will be appreciate...

Thank you

[ifty]

use unlink to delete an image, I use it alot in my software program.

Example:

$image_path = "../images/";
$rs_image = "what ever your image filename is"
if(file_exists($image_path . $rs_image)){
unlink($image_path . $rs_image);
}

[cahva]

First search for that old image from database and remove it. Simple eh?

$query = "SELECT imgname FROM introduction WHERE id='$id'";
$result = mysql_query($query);
if (mysql_num_rows($result)==1) {
	$pic = mysql_result($result,0);
	if (file_exists($uploadDir.$pic)) {
		unlink($uploadDir.$pic);
	}
}

EDIT: too slow 🙂

[ifty]

More reference to unlink:
http://us2.php.net/manual/en/function.unlink.php