[RESOLVED] Problem with updating image uploads

[n_baswa]

Hello frends,

I've written a code which uploads images and works fine. The problem is when i update other fields of that record, the image which i uploaded earlier for that record is deleted automatically. Can anyone plz help me regarding this...

here's my update code...

<?php

//$date = date('F j, Y');

//This is the directory where images will be saved
$target = "specials/";
$target = $target . $_FILES['photo']['name'];
//print($_FILES['photo']['name']);
//echo "<br>";

include('../TT_inc.php');

$sql = "UPDATE specials SET tagline='". $tagline ."', summary='". $summary ."', category='". $category ."', date='". $date ."', details='". $details ."', email='". $email ."', photo='". $_FILES['photo']['name'] ."', frontpage='". $_POST[frontpage] ."' WHERE specialID='".$specialID."'";

	//exit(print($sql));

//Writes the photo to the server
if(move_uploaded_file($_FILES['photo']['tmp_name'], $target))
{

//Tells you if its all ok
echo "The file ". $_FILES['photo']['name'] . " has been uploaded, and your information has been added to the directory";
}
else {

//Gives and error if its not
echo "Sorry, there was a problem uploading your file.";
} 

if (!mysql_query($sql,$mysql_link))
		{
			 die('Error: ' . mysql_error());
		}
else
        {
			header("Location: travel_specials.php");
		}
?>

[mikell]

When you submit whatever form you are using to update a special, if you don't specify an image, then $_FILES['photo']['name'] is just an empty string.

So make sure $_FILES['photo']['name'] is set to something before you update the photo field with it, or don't update it at all. Otherwise you'll overwrite it with ''.

[n_baswa]

ok. i got u, but pls tell me how do i set $_FILES['photo']['name'] to the image i already uploaded for that record.

If i don't update it, then thr will be a problem with the other records which do not have any image. Later on, when we need to add image to those records it will be a problem.

Plz give me some solution for this...

thanks

[mikell]

<?php
include('../TT_inc.php');

//if they are trying to set the photo then do this stuff, otherwise do other stuff
if (strlen($_FILES['photo']['name']) > 0)
{
	$target = "specials/";
	$target = $target . $_FILES['photo']['name'];

//upload the photo
if(move_uploaded_file($_FILES['photo']['tmp_name'], $target))
{
	echo "The file ". $_FILES['photo']['name'] . " has been uploaded.";
}
else 
{
	echo "Sorry, there was a problem uploading your file.";
}

//set query that updates the photo field
$sql = "UPDATE specials SET tagline='". $tagline ."', summary='". $summary ."', category='". $category ."', date='". $date ."', details='". $details ."', email='". $email ."', photo='". $_FILES['photo']['name'] ."', frontpage='". $_POST[frontpage] ."' WHERE specialID='".$specialID."'";	
}
else
{
	//set query that DOES NOT update the photo field
	$sql = "UPDATE specials SET tagline='". $tagline ."', summary='". $summary ."', category='". $category ."', date='". $date ."', details='". $details ."', email='". $email ."', frontpage='". $_POST[frontpage] ."' WHERE specialID='".$specialID."'";
}

//execute query that may or may not update the photo field
if (!mysql_query($sql,$mysql_link))
{
	die('Error: ' . mysql_error());
}
else
{
header("Location: travel_specials.php");
}
?> 

Does that help? Figured it would be easier to just give u the code than try to explain it.

[n_baswa]

that wrks gr8. Thank you so much.

[n_baswa]

hi mikell,

i would like to ask u something else regarding this.

can u pls tell me how do i write a code for deleting only the image/photo keeping all the other fields of that RECORD as they are.

also if u can tell how do i delete that image also frm the dir/folder.

thanks again

[mikell]

can u pls tell me how do i write a code for deleting only the image/photo keeping all the other fields of that RECORD as they are.

$sql = "UPDATE specials SET photo='' WHERE specialID='$specialID'";

also if u can tell how do i delete that image also frm the dir/folder.

First get the name of the photo you want to delete.
$sql = "SELECT photo FROM specials WHERE specialID='$specialID.'";

And to delete a file, use the unlink command. http://us3.php.net/unlink
unlink ($target);

[n_baswa]

thanks Mikell, but the first one doesn't work.

can u explain more...

[mikell]

I'm not really sure what else to say...thats how you would do it, using an update
query...of course you need to run the query. You didn't expect
$sql = "UPDATE specials SET photo='' WHERE specialID='$specialID'";
to do it by itself did you? You said you wrote the original code that you posted, so I have to assume you know how to run a query in PHP.

If you're completely unfamiliar with PHP then let me know, otherwise I"m gonna assume you know the basics. On the other hand, if you did actually run that query,
let me know something about why it didn't work. Did it give you an error? If so, what was it? What was the code you used?...etc

[n_baswa]

here is the code that i used...

<?php
include('../TT_inc.php');

//set query that updates the photo field
$sql = "UPDATE specials SET photo='' WHERE specialID='".$specialID."'";    

//execute query that may or may not update the photo field
if (!mysql_query($sql,$mysql_link))
{
    die('Error: ' . mysql_error());
}
else
{
header("Location: travel_specials.php");
}
?> 

It didn't give any error but it didn't delete the image either.

[n_baswa]

here is the code which i use for image deleting...

		<?php 
		if($photo!='') 
		{ 
			echo '<img src="../specials/' . $photo . '" align="left" class="paragraph_photo" /><br />';
			echo "<a href=\"delete_image.php?specialID=$specialID\">delete image</a>";
		}
		else 
		{ ?>
			<input type="file" name="photo" id="file_font" />
		<?php } ?>

This code shows up the image with a link to delete the image if it is present, otherwise it shows the input file to add an image.

I didn't find any errors in my code as far as i know.

Can u plz tell me if i'm missing something?

Thanks

[mikell]

Ok this code is in delete_image.php right? If so, lets see exactly what query is
being executed. Replace your code with this:

<?php
include('../TT_inc.php');

//set query that updates the photo field
$sql = "UPDATE specials SET photo='' WHERE specialID='".$specialID."'";    
   die($sql);

//execute query that may or may not update the photo field
if (!mysql_query($sql,$mysql_link))
{
    die('Error: ' . mysql_error());
}
else
{
header("Location: travel_specials.php");
}
?> 

Try to delete a photo now. Tell me what $sql is getting set to. If $specialID is not being set, remember it would be in the $GET array, not $POST.

[n_baswa]

u r right...

i got it... it was the $_GET....

i changed the query to this...

    $sql = "UPDATE specials SET photo='' WHERE pecialID='".$_GET["specialID"]."'";   

and it worked.

Thank u for keeping the patience with me.

i really appreciate ur help.

[mikell]

Don't mention it. Good luck with your site.

[livelineuk]

@
I have trouble in this code which you gave for update image.

Pls help me

My CODE:

mysql_connect("localhost", "root", "") or die(mysql_error()) ;
mysql_select_db("escorts") or die(mysql_error()) ;

$name = mysql_real_escape_string(stripslashes($POST['name']));
$age = mysql_real_escape_string(stripslashes($POST['age']));
$fee = mysql_real_escape_string(stripslashes($POST['fee']));
$des = mysql_real_escape_string(stripslashes($POST['des']));
$id = mysql_real_escape_string(stripslashes($POST['id']));
$photo = mysql_real_escape_string(stripslashes($FILES['photo']['name']));
//if they are trying to set the photo then do this stuff, otherwise do other stuff
if (strlen($FILES['photo']['name']) > 0)
{
$target = "images/";
$target = $target . $FILES['photo']['name'];

//upload the photo 
if(move_uploaded_file($_FILES['photo']['tmp_name'], $target)) 
{ 
    echo "The file ". $_FILES['photo']['name'] . " has been uploaded."; 
} 
else 
{ 
    echo "Sorry, there was a problem uploading your file."; 
} 

//set query that updates the photo field 
$sql = "UPDATE `es` SET name='". $name ."', age='". $age ."', fee='". $fee ."', des='". $des ."',  photo='". $photo ."' WHERE id='".$id."'";     

}
else
{
//set query that DOES NOT update the photo field
$sql = "UPDATE es SET name='". $name ."', age='". $age ."', fee='". $fee ."', des='". $des ."' WHERE id='".$id."'";
}

//execute query that may or may not update the photo field
if (!mysql_query($sql))
{
die('Error: ' . mysql_error());
}
else
{
header("Location: file_constants.php");
}
?>

Pls give me some solution for this...